Looker Studio Connector - known issues and ETAs

Hello Guys!

I’m a Product Manager at Piwik PRO, now responsible for the maintenance and development of the Looker Studio Connector for Piwik PRO Analytics. In order to meet our client’s needs and expectations, we’ve just launched a project that aims to greatly improve the quality and usability of the Looker Studio data connector. To ensure access to information, transparency and to make our lives easier, I’d like to publicly share a list of known issues connected with Looker Studio, along with their statuses. I’ll be posting updates, adding estimated times of delivery when we set one. Thank you very much for all your patience and understanding!

In progress:

  1. Google Ads - Using Google Ads metrics/dimensions crashes connector (mid-November 2023)
    (Related posts: No Google Ads Campaign ID in Looker Studio / other Google Ads data breaks as soon as it is filtered)
  2. Average page views in session shows wrong numbers (mid-November 2023) (Average page views in session does not work in Looker Studio)
  3. Conversion rates on scorecards show wrong numbers (mid-November 2023) (Conversion rate issue in Looker Studio)
  4. Sum of product quantity, sum of product revenue show different numbers in LS and PPAS (mid-November 2023) (Sum of Product Revenue and quantity not the same in Looker Studio - #6 by joao
  5. IN_LIST filter operator should handle exclusions (mid-November 2023)
  6. Dashboards for Meta Sites show slightly wrong numbers (investigation pending, ETA unknown).

In the queue:

Waiting for changes in the product:

  1. Add the connector to the official Google Gallery and make updates smooth and easy (Q1 2024) (Change of authentication method required)

Known facts that are not bugs:

  • All metrics and dimensions appear as green fields in the Looker Studio connector for Piwik PRO - Google changed the way they treat data sources like Piwik PRO, and now lists both metrics and dimensions as “green” fields, which were previously reserved only for dimensions.
    After dropping any metric listed as a green field into the “Metrics” definitions, it will change the color to blue and become a proper metric.
5 Likes

Thanks. Please keep us updated.

Hello Guys! I know there’s a lot of you waiting for an update here. We were working hard to meet the deadline and your expectations, and we’re finally ready to announce that a new version of the connector is ready. It will be published publicly on Monday, November 27th.

Here’s the list of changes that we managed to deliver:

  • Fixed Google Ads metrics/dimensions
  • Improved date/timestamp handling, added support for all date groups in reports like hour of day, day of week, week, month etc.
  • Fixed ‚Average page views in session’ metric
  • Fixed exclusion filters for is null/empty/equals to 0 conditions
  • Added support for exclusions with IN_LIST filters
  • Added handling complex conditions with IN_LIST filters (Example: Exclude Country in Denmark,Germany unless Device Type in Smartphone,Tablet)
  • Added support for all transformations for eCommerce metrics (Like Sum of product revenue (Orders), Average Revenue, Sum of product quantity, Median product quantity etc.)
  • Removed the product scope dimensions which are not available in Queries API and were breaking the connector (Like Product revenue (Array))
  • Fixed bounce rate showing wrong numbers.

We’re not stopping here - the next versions will now be released regularly. Stay tuned!

1 Like

Hello! A new version of the Looker Studio connector is already here :sparkles: :tada: :confetti_ball:

The final changelog:

  • Fixed Google Ads metrics&dimensions
  • Improved date/timestamp handling, added support for all date groups in reports like hour of day, day of week, week, month etc.
  • Fixed ‚Average page views in session’ metric
  • Added filters for ‘is null’/empty/‘equals to 0’ conditions (for both metrics and dimensions)
  • Added support for exclusions with IN_LIST filters
  • Added handling complex conditions with IN_LIST filters (Example: Exclude Country in Denmark,Germany unless Device Type in Smartphone,Tablet)
  • Added support for all transformations for eCommerce metrics (Like ‘Sum of product revenue (Orders)’, ‘Average Revenue’, ‘Sum of product quantity’, ‘Median product quantity’ etc.)
  • Removed the product scope dimensions which are not available in Queries API and were breaking the connector (Like ‘Product revenue (Array)’)
  • Fixed bounce rate showing wrong numbers.

Enjoy! :blush:

2 Likes