Forum Discussion
user measure google analytics
Hi Team,
Please help me out here, even I am facing the same issue with count of users not matching with actual GA users.
Thanks,
Ram
Hi there,
Same issue for me. This is what happens:
When I load 'Pageviews', 'Session', 'Bounce rate', etc. it looks all good. The values are identical to what is measured in Google Analytics.
But when I combine these data with the metric 'Users' or 'Number of sessions per user' all data is wrong.
This tells me that all data is up-to-date, except the 'Users' metrics, which affects other metrics when loaded in the same sheet.
Hope this extra info helps.
Thank you Roland! Let's see if we get any attention from BI Dev team.
-Ram
- You have to remember that the Google Analytics is a cube. So when you are using measures across different dimensions this will appear to make the numbers incorrect.
But if you get them individually they will be correct. So one way around this is to bring in the common ones together. And then merge them in Power BI Desktop in the Query editor.Thanks for your answer.
I'm aware of combining metrics can cause numbers to appear different than in GA. However, combining Users with Pageviews, never caused any problem before and still doesn't for other domains I am reporting for.
It seems to me now that the particular problem I'm facing lies within GA. When I report Users over a longer timespan this affects the number of Users within GA as well. This problem appears at some point in the past.
So, as a result of that, a follow up question: is there a way to import data from GA from a certain moment in time? Now it imports all lifetime data, but I don't need all of this, and in this case this causes numbers to appear wrong.
