UserReport(2018/12)

Motivation

• Summary the user behavior of different Affiliate_Code
• Tracking the user journey
• Reference document:

1. Base Report Requirement
2. Web Analytic and Testing

DataSource

• OLAP data (CNY)

• GA data (CNY)

• If we can get raw PIWIK data, we will translate data source from GA to PIWIK.

DataVerification

• Although the mapping data from OLAP to GA will lost about 65% users, GA data contains source/media and user url history pages that we needed.
  

• Check the deposit amount of these two data, GA also only have 35% amount against to OlAP data.

• User Case 1: The some deposit in two different datasets.(user_congtao82)

• User Case 2: Some days equel, Some days missing.(user_elie05)

• User Case 3: All missing deposit amount .(user_elie05)