# Sessions metric doesn't coincide with the Breakdown

**URL:** <https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670>\
**Category:** Reports and working with data\
**Created:** [May 26, 2022, 12:58pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670 "2022-05-26T12:58:29Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [May 26, 2022, 12:58pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/1 "2022-05-26T12:58:29Z")

</div>

Provided there is a website abc.eu, that contains:  
abc.eu/de  
abc.eu/fr  
abc.eu/nl  
abc.eu  
abc.eu/en

where abc.eu and abc.eu/en is the same content.

I have to split sessions in 4 groups starting with abc.eu/de, abc.eu/fr, abc.eu/nl and abc.eu(abc.eu/en).

When I filter out by Session Entry URL, then the total of all 4 groups won’t result in the total of Sessions displayed in “Analytics” \> “Reports” \> “Audience overview” \> “Sessions”

Could you please help me?

Thank you,  
Dmitry

---

<div class="post-metadata">

**Author:** ![Admin](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@Admin](https://community.piwik.pro/u/Admin)\
**Post date:** [May 27, 2022, 11:53am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/2 "2022-05-27T11:53:39Z")

</div>

Hi 🙂 Can you provide a screenshot? BTW. you can use dimensions value grouping to create a new dimension that fixes the issue with / and /en 🙂 Also, some smart 301 redirect would fix it ultimately.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [May 31, 2022, 3:03pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/3 "2022-05-31T15:03:51Z")

</div>

Hi, I have a simpler example. when I check the total number of sessions in Piwik Pro and Google Data Studio, then I get the same number, but if I add a filter of the same content, then the numbers show up differently. See below:

 ![EU_Dashboard 20:05:22 › Website Traffic 2022-05-31 16-58-35](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/7092992a869b5bd985eb45b7f3b0bde7f0f9d5f7.png)  
 ![DP Sessions - Dashboards - Analytics - VF PROD CMS 2022-05-31 16-51-11](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/16629bc5080ec9ee22ef6697a0c5628ebe29a7f2.png)  
 ![Sessions with Filter dimension (Session entry URL starts with https:::vinfastauto.eu:de) (edit a widget) - Dashboards - Analyti… 2022-05-31 17-01-46](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/2ec3f626179137f6e99a1472a93d49c1d462693c.png)

Please share your thoughts.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [July 19, 2022, 1:09pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/4 "2022-07-19T13:09:54Z")

</div>

@Admin do you have any thoughts about this question?  
it has been a while…

---

<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:** [July 19, 2022, 1:24pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/5 "2022-07-19T13:24:57Z")

</div>

Hello @Dmity,

This is Piotr from the Integrations team, I’ll take the part of the question about Data Studio. Right now filters can’t be applied to scorecard widgets, but we want to fix that in an upcoming update. I’ll get back to you with more details later this week.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [July 29, 2022, 9:38am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/6 "2022-07-29T09:38:24Z")

</div>

Hi @Piotrek , thank you for your reply. I’m being pushed about that my management everyday and I will appreciate if this update comes ASAP.  
However, the same problem is true for other GDS controls using filters, when I interact with Piwik Pro. For example,  
Piwik Pro shows the following:

 ![Sessions and visitors - Custom reports - Analytics](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/f78eb784d0b790902bdd5ee909890a159f087475.png)  
 ![Sessions and visitors (edit report) - Custom repor](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/289a1b25ec838f3afd0a79bfac75a7a3cdfeea74.png)

and Google Data Studio shows the following with the same filter

 ![Dashboard_EU_Marketing Internal POC v1 › Website T](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/5d67f84eb20d440893d60d682f55e66be7be62d0.png)

1. What value is the right one(in Piwik Pro or in GDS)?
2. Could you please let me know if there is any way I can reach the same values in those 2 platforms?

Thank you,  
Dmitry

---

<div class="post-metadata">

**Author:** ![Admin](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@Admin](https://community.piwik.pro/u/Admin)\
**Post date:** [July 29, 2022, 10:19am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/7 "2022-07-29T10:19:49Z")

</div>

Thanks for the valuable input. Piotrek should share more details after his holidays. As far as I know, he already started working on the solution. Sorry for not giving an update earlier.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [July 29, 2022, 1:46pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/8 "2022-07-29T13:46:11Z")

</div>

@Admin , thank you for the feedback. Could you please let me know, when Piotreks’ holiday will be over, as my management is pushing me about that subject and requires definite dates, when it will be addressed?

---

<div class="post-metadata">

**Author:** ![Admin](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@Admin](https://community.piwik.pro/u/Admin)\
**Post date:** [July 29, 2022, 1:59pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/9 "2022-07-29T13:59:48Z")

</div>

One week more, but then I guess he’ll need a week or two to finish things.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [August 1, 2022, 7:03am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/10 "2022-08-01T07:03:21Z")

</div>

Hi @Admin, thank you for the provided clear timeline. It sounds reasonable, but it’s a long timeframe for us, which can result in my management decision to move to a different analytics platform. We will see.  
Thank you,  
Dmitry

---

<div class="post-metadata">

**Author:** ![Admin](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@Admin](https://community.piwik.pro/u/Admin)\
**Post date:** [August 1, 2022, 9:12am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/11 "2022-08-01T09:12:22Z")

</div>

I’ll make sure @Piotrek checks this as the first thing after holidays. Thanks for the patience.

---

<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:** [August 8, 2022, 2:30pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/12 "2022-08-08T14:30:42Z")

</div>

Hello @Dmity,

Sorry that this took a while and especially for not reaching out to you earlier about the update that we are working on.

Basically, we want to provide a better way to use filters with Piwik PRO data. Right now filters are applied to the data in GDS only after the data has been downloaded from our Analytics. That doesn’t work in some cases, like when using the scorecard widgets.

However, in the upcoming version, the filters will be added to all of our data queries, meaning that it will be exactly the same as applying a filter in a Piwik PRO Analytics report or dashboard.

We are working to release the new version of the Google Data Studio connector with improved filters next week.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [August 11, 2022, 12:53pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/13 "2022-08-11T12:53:01Z")

</div>

Hi Piotrek,  
We are looking forward to it very much.  
Thank you,  
Dmitry

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [August 12, 2022, 11:49am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/14 "2022-08-12T11:49:34Z")

</div>

Hi @Piotrek ,  
You mentioned scorecard widgets, which is great, but in this thread I also provided an example of a table. [Sessions metric doesn't coincide with the Breakdown - #6 by Dmity](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/6) . Will the upcoming version fix this case as well?  
Thank you,  
Dmitry

---

<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:** [August 12, 2022, 1:53pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/15 "2022-08-12T13:53:52Z")

</div>

Hey @Dmity,

Yes, it will. We want to address filters in general, so that they always work in GDS reports.

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [August 18, 2022, 4:36pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/16 "2022-08-18T16:36:02Z")

</div>

Hi @Piotrek,  
Is the release with the fixes still taking place this week?  
Thank you,  
Dmitry

---

<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:** [August 19, 2022, 7:51am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/17 "2022-08-19T07:51:32Z")

</div>

Hello @Dmity,

The release is on track for today, I’ll get back to you with a new link to the connector.  
We’ll publish documentation next week.

---

<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:** [August 19, 2022, 10:19am UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/18 "2022-08-19T10:19:11Z")

</div>

@Dmity,

Version 1.0.3 is out and it’s available here: [Google Data Studio](https://datastudio.google.com/datasources/create?connectorId=AKfycbxSMQME0mlT-wGNHozTaXR4pDHqFGSnf_1mMTsnq4qcK3qMyULHQzqPMZivYumIvpFq6w)

It introduces support for Google Data Studio filters on Analytics query level. Filters will now be applied to the requests sent to our product. Previously they were only applied after the data was already downloaded.

Keep in mind that there are some differences between Data Studio filters and our filters, meaning that not every Data Studio filter will work with our data. Notable differences include: list operator, partial regexp matches. We’re still working on the City dimension, which we want to support in filters in a later release.

Let us know if everything works for you now. In case of a filter not working, the connector will use the old method of downloading data (filter will be applied only after data was downloaded).

---

<div class="post-metadata">

**Author:** ![Dmity](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@Dmity](https://community.piwik.pro/u/Dmity)\
**Post date:** [August 19, 2022, 2:56pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/19 "2022-08-19T14:56:21Z")

</div>

Hi @Piotrek , thank you for the update. I can see that “include” filter started to return the numbers in Google Data Studio close to that of Piwik Pro work, however, “exclude” filter still won’t work(it returns exactly the same numbers as “include” filter). See the example:

 ![2022-08-19_17h44_23](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/9a5aab580f56af05bdef4086e8d9e20436020116.png)  
 ![2022-08-19_17h42_37](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/c8cc329e645c155f770f6bb00b6745650e23ed58.png)  
I need this exclude filter to work in GDS. Would you be able to fix it?  
Thank you,  
Dmitry

---

<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:** [August 22, 2022, 2:38pm UTC](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670/20 "2022-08-22T14:38:15Z")

</div>

@Dmity I was able to reproduce your issue with exclude filters. Fortunately, we were able to fix it quickly.

Here’s a new link to the update: [Google Data Studio](https://datastudio.google.com/datasources/create?connectorId=AKfycbzRgPMaXVD3B-ZOoJvwsz3faTmrn5PTOvYPnSDCufXnCs3KXsS2hmW1c_5wUr1k5RGOQw)

Unfortunately, you need to follow the same process to install it. Let me know if you run into any further issues.

[Next page](https://community.piwik.pro/t/sessions-metric-doesnt-coincide-with-the-breakdown/670.md?page=2)
