Forum Discussion
Problems with Google Analytics connector - Retrieving different figures adding a coloumn
Dear smoupre,
could you simulate my scenrario?`I still haven't found a solution for this myself :(
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?