Input - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

The input table is web clickstream data recorded as a user navigates through a web site. Events—view, click, and so on—are recorded with a timestamp.

Sessionize Example Input Table adweb_clickstream
userid adid productid event clicktime
1039 2 1001 view 2009-04-21 13:17:59
1039 2 1001 view 2009-04-21 13:17:59
1039 2 1001 view 2009-04-21 13:17:59
1039 3 1001 view 2009-05-23 13:17:59
1039 3 1001 view 2009-05-23 13:17:59
1039 3 1001 view 2009-05-23 13:17:59
1039 4 1001 view 2009-07-16 11:17:59
1039 4 1001 view 2009-07-16 11:17:59
1039 4 1001 view 2009-07-16 11:17:59
1039 4 1001 click 2009-07-16 11:18:16
1039 4 1001 click 2009-07-16 11:18:16
1039 4 1001 click 2009-07-16 11:18:16
1039 4 1001 landing_page 2009-07-16 11:18:18
1039 4 1001 landing_page 2009-07-16 11:18:18
1039 4 1001 landing_page 2009-07-16 11:18:18
... ... ... ... ...