Forum Discussion

cowork16's avatar
cowork16
Frequent Visitor
9 years ago

Google Analytics Help, Please!

I posted this yesterday and got no replies. I've been trying to figure this out for days and desparately need help.

 

I'm trying to figure out why there are such large discrepancies in data between Google Analytics and Power BI. I know sampling can be an issue but that be the cause of such large differences? Here's part of a table from GA and the same data in PBI. Some values are close (e.g. facebook/remarketing) but others are completely off. Any ideas? I have a deadline to meet that won't be possible if I can't figure this out Smiley Sad TIA!

 

 

 

 

 

Need Help

6 Replies

  • kcantor's avatar
    kcantor
    Community Champion
    9 years ago

    cowork16

    I use the Google Content Pack as well and have determined my difference to come from refresh times. To get a better match, I have attempted to match the refresh times within the scheduler. Unfortunately, 6:00 am means different things when leaving the refresh automated.

    If you differences are failing outside of "fresh" data, I would offer that it may be the built in filters within the content pack that we may or may not notice. I am not a fan of the content pack.

    • cowork16's avatar
      cowork16
      Frequent Visitor
      9 years ago

      Thanks for the response! :) I think I'm using the connector, rather than the content pack. Do you think the filter issue would still apply?

      • CahabaData's avatar
        CahabaData
        Memorable Member
        9 years ago

        I have not yet had a project involving GA - but looking at the data - common sense would say that the New User count would always be less than the Session Count because there will always be some repeat users.  This is true on the left with GA but not true on the right with PBI.  So it appears that the definition of what should be counted/categorized is not correct.