Forum Discussion
Wrong data from Google Analytics
Hi kendash,
if there are several blocks of rows that have the same value as you describe, this is a strong indication that your data is sampled.
(https://support.google.com/analytics/answer/2637192?hl=en)
"If the number of sessions in the property over the given date range exceeds 500k sessions (25M for Premium)1, Analytics will employ a sampling algorithm"
Here's how you can verify if that's the case:
- Check your GA data you have imported in PBI and note down the date range you have imported (earliest and latest date)
- Go to https://ga-dev-tools.appspot.com/query-explorer/- Set up exactly the same query and use the same dates that you have in PBI
- Hit "Run Query" and have a look at the header section of the result
If it says "Contains sampled data:Yes", then you know, that sampling is the root of the issue.
The only way around it is to request smaller date ranges of data, which you cannot do in PBI itself. So you will have to programmaticly do that elsewhere and use the result as a source for PBI.
Hi kendash,
if there are several blocks of rows that have the same value as you describe, this is a strong indication that your data is sampled.
(https://support.google.com/analytics/answer/2637192?hl=en)
"If the number of sessions in the property over the given date range exceeds 500k sessions (25M for Premium)1, Analytics will employ a sampling algorithm"
Here's how you can verify if that's the case:
- Check your GA data you have imported in PBI and note down the date range you have imported (earliest and latest date)
- Go to https://ga-dev-tools.appspot.com/query-explorer/
- Set up exactly the same query and use the same dates that you have in PBI
- Hit "Run Query" and have a look at the header section of the result
If it says "Contains sampled data:Yes", then you know, that sampling is the root of the issue.
The only way around it is to request smaller date ranges of data, which you cannot do in PBI itself. So you will have to programmaticly do that elsewhere and use the result as a source for PBI.
What is the best way to reduce the data sample size before getting it into PBI? All I want to see is dates and channels as the dimensions, but as it's pulling through all dates ever before I even have chance to do any transformation I'm having to work with sampled data. What's the best way to get around this?
Thanks
