Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Google Analytics wrong data when many columns

Hi all.   When combining several columns, the data is off.   Example:   Table 1: Date, Sessions, Country, Medium Table 2: Date, Sessions, Country Table 3: Date, Sessions, Medium   Number of...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ,

 

As tested here,I found I cant find the column "Country" as you said in the post,

 

 

So how do you get the column" country" from google analytics?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi!

     

    The 4 columns are from:

     

    Time --> Date

    Sessions --> Sessions

    Traffic Sources --> Source / Medium

    Geo Network --> Country

     

    So if I pick just

    • "Date" and "Sessions"
    • "Date" and "Sessions" and "Country"
    • "Date" and "Sessions" and "Medium / Source"

    Then I get the same numbers. But if I mix up "Country" and "Medium / Source", then the number of sessions is higher per period?

    • "Date" and "Sessions" and "Country" and "Medium / Source"

     

    That is weird  to me!

     

    •  
    •