I use Google Data Studio (GDS) to process some data gathered by PiwikPRO, most values are transferred accurately, but some have a considerable mismatch:
As seen from the screenshots, the number of new visitors for the same period is 2,681 while in GDS I get only 2 visitors.
Session time and Time on Page also differ significantly for the same period of time.
Do you have any idea on what can be the cause of these mismatches? And how can it be fixed?
I just checked and unfortunately I cannot reproduce your issue - the numbers seem to match what I see in my Piwik PRO account. I used the same conditions and the same date ranges across both products.
Google Data Studio:
Did you change the control scope for the date range for any of your charts?
Here’s what I mean: Date range control - Data Studio Help
Another important thing to consider - did you build the charts the same way as you would build a widget in Piwik PRO dashboards? For the chart showing “returning visitors”, did you set it up by using the metric “Visitors” and making a scorecard filter like on the screenshots below?
the scorecard filter you proposed solved the problem, thanks a lot! Any ideas how to fix “session time” and “time on page” mismatch?
Is my guess correct that you are comparing stats for a particular location? In the screenshot from Piwik PRO Analytics, I see the following text: “Country › Subdivision › City”, which suggests that you are looking at the Locations report.
If that’s the case, it’s important to make sure that you filter the data the same way in Google Data Studio. By default, Data Studio would return the average session time for all visitors without taking locations into account. If you add locations to the mix (like in Analytics reports), the data may be calculated differently (to split between cities and also to see results where location couldn’t be attributed).
In general, it can be pretty hard to compare a scorecard chart in GDS to a full report where the query for the data is more complex. A useful tip might be checking if the data is accurate by comparing it to a widget in Piwik PRO dashboards.
Let me know if this is a good explanation.
it’s not about the locations, the values differ regardless of geography