Forum Discussion

Timbo's avatar
Timbo
New Member
10 years ago

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

 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 no...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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's avatar
    Timbo
    New Member
    10 years ago

    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's avatar
      Timbo
      New Member
      10 years ago

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

       

      Correct figuresIncorrect figures

  • Timbo's avatar
    Timbo
    New Member
    10 years ago

    Dear smoupre,

     

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

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      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's avatar
        Timbo
        New Member
        10 years ago

        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