# Data differences in datastudio vs Piwik

**URL:** <https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256>\
**Category:** Reports and working with data\
**Created:** [November 14, 2022, 10:36am UTC](https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256 "2022-11-14T10:36:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeff](https://avatars.discourse-cdn.com/v4/letter/j/e19b73/32.png) [@Jeff](https://community.piwik.pro/u/Jeff)\
**Post date:** [November 14, 2022, 10:36am UTC](https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256/1 "2022-11-14T10:36:01Z")

</div>

Hi,

With the sames filters, the data in google datastudio is different Piwik. I try to replicate the Campaigns view and all but the bounce rate are off.

If create a table and filter for only one campaign name, I get several lines for the same campaign name with different values.

Thank you  
Jeff

---

<div class="post-metadata">

**Author:** ![Piotrek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotrek/32/160_2.png) [@Piotrek](https://community.piwik.pro/u/Piotrek)\
**Post date:** [November 15, 2022, 10:33am UTC](https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256/2 "2022-11-15T10:33:36Z")

</div>

Hey @Jeff,

Support for filters was improved in one of our recent updates, are you using the same version as the one that we have listed in our Help Center article [here](https://help.piwik.pro/support/integrations/looker-studio-integration/)?

The issue was a result of Data Studio applying processing when using filters, we solved it by adding filters directly to queries for our Analytics.

With regards to the second point - duplicates - we’re releasing an update later this week that will address this issue of dimensions not being aggregated in a table (campaign names showing up twice in results and so on).

---

<div class="post-metadata">

**Author:** ![Jeff](https://avatars.discourse-cdn.com/v4/letter/j/e19b73/32.png) [@Jeff](https://community.piwik.pro/u/Jeff)\
**Post date:** [November 15, 2022, 2:42pm UTC](https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256/3 "2022-11-15T14:42:55Z")

</div>

Hi @Piotrek,

I created a new connection yesterday from the link in the Help Center.

Even if I use explore on the connection and only apply a date filter on “Goal name” and “Goal revenue”, the values are wrong [Screenshot by Lightshot](https://prnt.sc/ntEXoung_sx6)

Thank you  
Jeff

---

<div class="post-metadata">

**Author:** ![Piotrek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotrek/32/160_2.png) [@Piotrek](https://community.piwik.pro/u/Piotrek)\
**Post date:** [November 15, 2022, 2:48pm UTC](https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256/4 "2022-11-15T14:48:28Z")

</div>

Thanks @Jeff,

We’ll try to reproduce your issue. We are aware of an issue when using Goal name (it will also be fixed later this week), we’ll verify if it’s exactly what’s causing this discrepancy.

---

<div class="post-metadata">

**Author:** ![Jeff](https://avatars.discourse-cdn.com/v4/letter/j/e19b73/32.png) [@Jeff](https://community.piwik.pro/u/Jeff)\
**Post date:** [November 28, 2022, 2:14pm UTC](https://community.piwik.pro/t/data-differences-in-datastudio-vs-piwik/1256/5 "2022-11-28T14:14:29Z")

</div>

Hi @Piotrek,

Witht the newest connector (16.32.0), the metric “Sum of goal revenue” displays the correct data.

Thank you  
Jeff
