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...
Need Help
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.

       

       

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi cowork16,

       

      I agree with CahabaData. In addition, as mentioned this article, the Google Analytics connector relies on a third-party service. As such, features and availability may vary over time and no guarantee for the results of your queries when using this connector. So I would suggest you to try the content pack to see if it works in this scenario.:smileyhappy:

       

      Regards

      • cowork16's avatar
        cowork16
        Frequent Visitor
        9 years ago

        Thank you for the replies CahabaData and v-ljerr-msft :) I need data from 2013 forward, and the content pack only seems to go back 6 months, so that didn't work for me, unfortunately. Using the PQGoogleAnalytics third party connector (suggested to me in another post), I got the same, incorrect numbers, but when I queried directly in the Query Editor, I got the correct numbers. So it seems like something is going wrong when I try to put the dimensions/metrics in a report, but I'm not sure what it is.