Problems with Google Analytics connector - Retrieving different figures adding a coloumn

[Timbo]

 Dear all,

I have tried to find topics that would help me solve my problem but I failed. 🙂

I am pulling data from analytics...basic stuff: Date, Sessions, Conversions, Users...but I noticed some differences in numbers. The table on the right hand side simply pulls sessions and conversion per day, filtered by source / medium "htg / meta". These figures are 100% correct and equal to data displayed in my analytics account. 

If I now add "users" coloumn (table on the left), the numbers change dramatically and even the conversions "E-Mail Anfragen", "Kauf" and "Telefonnumer" change to strange multiples of 7 (and multiples of 7 plus 1). Another thing that happens is that the 27th of November disappears and traffic seems to attributed to other dates...I am lost. I have also tried to add other coloumns such as campaign with the same behaviour.

I have also checked the https://ga-dev-tools.appspot.com/query-explorer/ tool and data is being returned correctly even if I pull Sessions and Users together. 

Thankful for any help...

Tim

[Greg_Deckler]

I have a Google Analytics content pack deployed so I should be able to simulate this, but I can't really see your columns and such in your screen shot. If you can give me the specific table:columns that you are using like:

Overview:Sessions

then I could mock this up in my environment and see if I can figure out what is going on.

[Timbo]

Dear smoupre,

could you simulate my scenrario?`I still haven't found a solution for this myself 😞

[Greg_Deckler]

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.

[Timbo]

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

[Timbo]

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. 🙂

[Greg_Deckler]

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?

[peter_oneill]

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.

[MarianneElver]

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

[intrasight]

How does one specify the timeframe parameter in this GA connector? In the API there are startdate and enddate parameters.

[Timbo]

Dear smoupre,

the columns I am pulling are:

First case: Date, Sessions, Source / Medium (filtered), Conversions (This is the constellation that works)

Second case: Date, Sessions, Source / Medium (filtered), Conversions, Users or Campaign (figures for Sessions and Conversions are incorrect)

Hope this helps. Thanks in advance

[Timbo]

For your convenience I am trying to upload the tables once again:

Correct figuresIncorrect figures