Page Views and Sessions do not match between Reports (PiwikPRO Analytics and Google Data Studio)

Hi!

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)

Why is that?

Data Studio:


The Filter ist always ā€œPage URL contains /angebotā€

Thanks, Susanne

Hello @Susanne,

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.

You can install it with this direct link: Google Data Studio

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.

1 Like

Hi Piotrek.

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.

So you keep the same name for the new data source or do you rename it?

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.

I have reconnected but there is an error now. Is it temporary or did I make a mistake in the connection?
image

A new error and all Data Sets show a configuration error
image

@Susanne do those errors show up in the report? Could you check the Resource > Manage data sources menu? This is what it should show:


The chart definitions should also display the right data source:
image
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.

Working now, yes, I think I had to wait. Thanks

Hi Piotrek.

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?

Thanks, Susanne

@Susanne I will check why itā€™s not being displayed and get back to you later.
If necessary, we will release another update to bring it back.

1 Like

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.

Any one else experiencing the same issue? Thanks

Hi @Veronica,

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.