Forum Discussion
Problems with Google Analytics connector - Retrieving different figures adding a coloumn
I need the tables you are pulling from, sorry if I missed them but I don't see the tables and the columns in those tables. listed. When I connect to Google Analytics, I see tables such as:
- Ad Exchange
- Adsense
- Adwords
- App Tracking
- Audience
- Channel Grouping
- Content Experiments
- Content Grouping
etc.
Sorry. I am pulling the following columns from left to right:
- TABLE --> (SUBTABLE) --> COLUMN
First case where it all works (Table 1):
- Time --> Month of Year
- Session --> Sessions
- Goal Conversions --> (Goal Completions) --> Goal 2 Completions
- Goal Conversions --> (Goal Completions) --> Goal 3 Completions
- Goal Conversions --> (Goal Completions) --> Goal 4 Completions
- Traffic Sources --> Source / Medium (filtered to one source / medium afterwards)
Second case with incorrect figures:
- Time --> Month of Year
- Session --> Sessions
- Goal Conversions --> (Goal Completions) --> Goal 2 Completions
- Goal Conversions --> (Goal Completions) --> Goal 3 Completions
- Goal Conversions --> (Goal Completions) --> Goal 4 Completions
- Traffic Sources --> Source / Medium (filtered to one source / medium afterwards)
- User --> Users
Thanks a lot
The behaviour can be even observed without the goal conversion metrics.
Using only Date, Sessions, Source / Medium will alter the figures returned with and without pulling "Users"
Beaviour could not be observed without the dimension "Source / Medium", Thats is, pulling only "Date" and "Sessions" will return the same amount of sessions per day with and without the dimension "Users".
Sorry for my inability to express myself in a proper way. :)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.
