Forum Discussion
Data partially matched retrieving blank values
a_yatsenko, looks like that your issue is more related to data which is exported from Google Analytics.
1). You said that the blank values is caused by clicks happen time is different from purchase time. Do you get any other column or table with which you get build up correct relationships between these two tables?
2). For your second issue, please be sure that you're checking data in the same time range. As I saw that the 1st image shows data in 2014 while in 2015 in the 2rd image.
3). Additionally, I think you can also considering consult GA for help. Go here.
a_yatsenko, looks like that your issue is more related to data which is exported from Google Analytics.
1). You said that the blank values is caused by clicks happen time is different from purchase time. Do you get any other column or table with which you get build up correct relationships between these two tables?
2). For your second issue, please be sure that you're checking data in the same time range. As I saw that the 1st image shows data in 2014 while in 2015 in the 2rd image.
3). Additionally, I think you can also considering consult GA for help. Go here.
Vicky_Song thanks for following-up
1) Indeed, click time and purchase time different of course, but I would not foresee such a great dispersion
2) I guess that the problem lies in GA API, as for one of the websites I could extract data only for 2015, not 2016, thus the values could not be matched.
I guess I won't relly on Analytics integration then, as in my case it imposes some limitations. The best option would be to build a custom app that will store traffic data and then cross it with the sales data.
Thanks again!