Forum Discussion
Problems with Google Analytics connector - Retrieving different figures adding a coloumn
Hmm, OK, I think that I configured this correctly and unfortunately I am not seeing what you are seeing. I guess one question I would have, do you see the correct/incorrect data in the preview? I am also wondering if perhaps the issue is somewhere in the Power Query. Any chance you can post the power query "M" code?
Hi,
This is likely a sampling issue with GA. When you bring in the metric Users with those dimensions, the report (across all metrics) switches from precalculated reports to actually calculating this data. If the total data set is greater than 500k sessions, then the data will be sampled, causing these sorts of issues. Metrics like goal conversion rates and sessions are standard so won't cause this issue.
Try reducing the date range and see if it works then. Maybe do for a single week initially.
- Hi, I'm having the same problem. When pulling out a few metrics, such as transactions, revenue, sessions, week and channel grouping, I get what I see in the Google Analytics interface a 100%, but when I add the Campaign or the Landing page dimension, the transaction and revenue numbers get reduced and inaccurate. Any suggestions on anything to change in the query? KR Marianne
How does one specify the timeframe parameter in this GA connector? In the API there are startdate and enddate parameters.
