Input - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

The input table, bank_web_url, contains the URL of each page browsed by the customer. The definitions of the browser pages, which can be specified by the ItemDefinition argument, are in the table ref_url (which follows bank_web_url).

FrequentPaths Example 2 Input Table bank_web_url
session_id page_url datestamp
0 www.bank.com/acsum 2004-03-17 16:35:00
0 www.bank.com/faq 2004-03-17 16:38:00
0 www.bank.com/achist 2004-03-17 16:42:00
0 www.bank.com/fundsxfer 2004-03-17 16:45:00
0 www.bank.com/onlinestat 2004-03-17 16:49:00
0 www.bank.com/profile 2004-03-17 16:50:00
0 www.bank.com/acsum 2004-03-17 16:51:00
0 www.bank.com/customer 2004-03-17 16:53:00
0 www.bank.com/deposit 2004-03-17 16:57:00
1 www.bank.com/acsum 2004-03-18 01:16:00
1 www.bank.com/acsum 2004-03-18 01:18:00
1 www.bank.com/faq 2004-03-18 01:20:00
1 www.bank.com/acsum 2004-03-18 01:21:00
1 www.bank.com/fundsxfer 2004-03-18 01:24:00
1 www.bank.com/achist 2004-03-18 01:25:00
1 www.bank.com/deposit 2004-03-18 01:27:00
1 www.bank.com/acsum 2004-03-18 01:27:00
1 www.bank.com/achist 2004-03-18 01:28:00
2 www.bank.com/acsum 2004-03-18 09:22:00
2 www.bank.com/acsum 2004-03-18 09:23:00
2 www.bank.com/acsum 2004-03-18 09:25:00
2 www.bank.com/achist 2004-03-18 09:27:00
2 www.bank.com/fundsxfer 2004-03-18 09:31:00
2 www.bank.com/acsum 2004-03-18 09:31:00
2 www.bank.com/faq 2004-03-18 09:33:00
2 www.bank.com/faq 2004-03-18 09:36:00
3 www.bank.com/acsum 2004-03-18 22:41:00
3 www.bank.com/achist 2004-03-18 22:45:00
3 www.bank.com/acsum 2004-03-18 22:47:00
3 www.bank.com/achist 2004-03-18 22:49:00
3 www.bank.com/faq 2004-03-18 22:50:00
3 www.bank.com/acsum 2004-03-18 22:53:00
3 www.bank.com/acsum 2004-03-18 22:55:00
4 www.bank.com/acsum 2004-03-19 08:33:00
4 www.bank.com/faq 2004-03-19 08:36:00
4 www.bank.com/deposit 2004-03-19 08:38:00
4 www.bank.com/faq 2004-03-19 08:41:00
5 www.bank.com/acsum 2004-03-19 10:06:00
5 www.bank.com/fundsxfer 2004-03-19 10:09:00
5 www.bank.com/deposit 2004-03-19 10:11:00
5 www.bank.com/deposit 2004-03-19 10:13:00
5 www.bank.com/achist 2004-03-19 10:14:00
FrequentPaths Example 2 Definition Table ref_url
page_id pagedef page
1 page_url like '%acsum%' ACCOUNT SUMMARY
2 page_url like '%faq%' FAQ
3 page_url like '%achist%' ACCOUNT HISTORY
4 page_url like '%fundsxfer%' FUNDS TRANSFER
5 page_url like '%onlinestat%' ONLINE STATEMENT ENROLLMENT
6 page_url like '%profile%' PROFILE UPDATE
8 page_url like '%customer%' CUSTOMER SUPPORT
9 page_url like '%deposit%' VIEW DEPOSIT DETAILS