Landing Page Rankings by Conversions

The ranking of landing pages, which brings the most conversions (e.g. purchase, clicks, etc).

Description

This query calculates the most performing landing pages, which brings the conversions (e.g. purchase, clicks, etc). Please check Sessionization to understand the concept of sessionization.

Sample Input

access
time user_id path
1416435585 3 http://docs.treasuredata.com/
1416435586 3 http://www.treasuredata.com/
1416435587 5 http://www.treasuredata.com/products/
1416435588 1 http://www.treasuredata.com/about/
1416435598 1 http://www.treasuredata.com/products/
1416435628 1 http://www.treasuredata.com/team/
... ... ...

Query


to view this query

Sample Output

first_path conversion_count
http://docs.treasuredata.com/ 321
http://www.treasuredata.com/ 231
http://www.treasuredata.com/products/ 104
http://www.treasuredata.com/about/ 98
http://www.treasuredata.com/products/ 78
http://www.treasuredata.com/team/ 64
... ...