Hello.
I have already asked this in a Support Ticket but I was wondering if I find a different answer or creative approach in the Community
I connected Data Studio with Piwik PRO and am currently updating our existing Dashboards with the new Data from Piwik (we used Google Analytics Data before)
Now I have several cases where Data is not shown cumulated:
How it is: August 2022 is shown in several rows
How it should be (Screenshot with Data from GA):
one Row with August 2022, one with July 2022
It is a Blended Data Source where I use "campaign name RegExp Contains .* to define the selection “UTM campaign is set”
Keep in mind that it’s not possible to use the “partial RegExp matches” operator with our data, because we don’t provide an operator like that in our product (only exact matches).
Hi Piotrek,
thanks a lot for your answer. We tried it today but the problem doesn’t seem to be solved. Look here (with the new data connector as source):
Hello!
Adding to Serenas Input (we are in the same team), I have now used the new Connector in an existing Dashboard and encountered the following error:
When I use a global filter for the report (eg Filter by page URL), I get a Data Set Configuration Error
Do you have any Info on how to avoid this?
Thanks, Susanne
Hello @Piotrek.
Is there any news on this? Also, the Connector from 14.9. does not allow any filters.
Do you have News about a possible date for a new one which fixes those issues?
Thanks for letting me know.
Susanne
We’re currently looking into adding better aggregations to months in the connector. We don’t have a release date yet, but in general we are planning two releases this month (one in the first half of November and one in the second half) and we want to include a solution in one of them.
Great, thanks! Could you please let me/us know in this thread, when also the cumulation topic is fixed? So we can come back to it and get the latest connector. Thanks, Susanne
We have just released a new version of our Data Studio connector which includes a fix for the issue with dimension value duplicates. Data that you see in charts and reports should not contain duplicates anymore. You can find the latest version in our Help Center article: Looker Studio (Google Data Studio) integration | Piwik PRO help center
More info about what happened an how we fixed it: the issue was a result of a change introduced by Google to the data model provided by connectors like ours. We have implemented changes to our schema based on feedback from Google and as a result, all metrics and dimensions will now appear as green fields in the connector. They will look like dimensions, but if you drop them into the metrics section in a chart/table definition, they will switch to a blue field (a metric).
Amazing news, thanks! I have already tried it and it works, also I found I could easily fix the dimension/metrics mixup as described. So great you guys fixed this.
Right now I feel the new connector does not work with filters, could this be the case? When I set a filter i receive an error in the widgets.
For everyone that still has the problems with cumulated data in Looker Studio. When using a default metric like unique pageviews and you want to see the views per weekday, you will still get the error shown above:
You have to use the SUM() function in a custom field
So strange since i’m using the same but it doesn’t aggregate.
