I made a Dashboard in PiwikPRO Analytics and created exactly the same Dashboard with PiwikPRO as a Data Source in Google Data Studio.
I made sure to chose an end date that is -2 days from today (I understand the Data Time Lag)
I did not use any calculated fields or custom dimensions, just KPIs + Filters.
Still, the Data does not match-
My report shows PageViews and Sessions and this is where the differences occur.
(- on event level, the Data matches)
That is a known issue with using filters in Google Data Studio together with our data connector. Fortunately, we have just finished working on an update that fixes the issue and improves using filters.
Hi Piotrek.
Sounds great, thanks.
So, when you have a new Update or Version of the Data Studio Connector ready, I have to actively install it, as it doesn’t “update” automatically?
If yes, how can I be notified about an update?
Will install this one now.
Thanks, Susanne
For now we have to share the connector outside of Google’s Community Connector Gallery, which means that it needs to be installed from direct links like the one I’ve shared previously.
We are planning to get listed in Google’s gallery in the near future and when that happens, you will be immediately notified in case of any update.
Until that happens, you would need to check our changelog from time to time to see if there’s anything new related to Google Data Studio. And if that’s the case, we always share the link to the latest version in our Help Center article about the integration (the one I’ve shared above is coming there later this week): Looker Studio (Google Data Studio) integration | Piwik PRO help center
The version I just shared will show up in our changelog on Monday and we’ll add information about filters to the article above.
So is this the way to go:
I install it, give the source a new name so it can be shared and found by my other editors, then I reconnect each Dashboard with the new source? It is pretty much work like this, as I have to set the filters anew.
Is there any other way?
Thanks, Susanne
Yes, that’s the safest way for now, but personally when using the connector I do a little cleanup and remove the old version first. That’s because Google Data Studio saves the definitions for later (at least in my case) when you reconnect with the data source again. However, I don’t work on any more complex or sensitive data, so I would go with the safer option for that.
If you save it with the same name it will work, but it may be harder to recognize the two different versions. Unfortunately there’s no way for us right now to mark different versions in the connector directly.
The chart definitions should also display the right data source:
In some cases, we saw that it was a matter of setting everything up properly (replacing data sources in chart definitions) and waiting a while (around an hour) for Google Data Studio to process the changes.
In the previous resource of PiwikPRO with the previous connector, I used the field “Ad Group Ad Network Type (Google Ads)” for my custom channel grouping … it is not there in the new connector.
Do you have any hint on how to use it or replace it?
Hi @Piotrek I’m having the same issue about Avg pageviews per session in Looker not matching Piwik. Avg page views in session according to Piwik is 4.43, Vs 25.38 in Looker. I’m using the new connector that you shared in the comments above.
Also using metric ‘pageviews in session’ and then calculating AVG in looker as the Piwik metric called ‘Avg pageviews in session’ breaks the table.
Thanks for reporting this issue, I can confirm that the ‘Average pageviews in session’ metric is currently not working properly. We’ll plan a fix for this bug.
We’ll add more details to this thread about when you can expect a connector update.
