Forum Discussion
Google Analytics Sessions Syncing Issues
Ended up figuring this one out! Finally got it after reading some PBI forums of something completely unrelated.
I realized I was pulling Sessions alongside a bunch of other fields (source, users, hits, etc), which was causing me to lose out on rows that didn't have associated values. For example, if a session had no hits and I was pulling both, then it wouldn't show up as a session.
By pulling only sessions and the date, or users and the date, etc. I was able to link up GA and PBI. I suppose that's a beginner's mistake but very happy to have found the solution!
Zev
Hi zskolnik
From your screenshot, which is the visual of the left one? matrix?
It's better to share some data and expected result according to this data for analysis.
Best Regards
Maggie
Hi Maggie,
The left one is from Google Analytics, the right PBI's data view.
Basically, on the left it says my Sessions for Google / Organic are 50 and 91 (new vs returning). Pulling with PBI, it says my sessions are 50 and 95 (new vs returning) for November 15.
I'm pulling what I believe is the exact same data, and am not sure why they aren't lining up.
Thanks,
Zev
Hi zskolnik
It seems the left one from Google Analytics is a visual instead of original dataset.
Please check if any other filter apply to it.
Best Regards
MaggieEnded up figuring this one out! Finally got it after reading some PBI forums of something completely unrelated.
I realized I was pulling Sessions alongside a bunch of other fields (source, users, hits, etc), which was causing me to lose out on rows that didn't have associated values. For example, if a session had no hits and I was pulling both, then it wouldn't show up as a session.
By pulling only sessions and the date, or users and the date, etc. I was able to link up GA and PBI. I suppose that's a beginner's mistake but very happy to have found the solution!
Zev