# Reports and working with data **URL:** https://community.piwik.pro/c/reports/16.md?page=2 [Latest](https://community.piwik.pro/latest.md) · [Categories](https://community.piwik.pro/categories.md) **Page:** 3 --- ## [Cannot show average session time in custom table](https://community.piwik.pro/t/cannot-show-average-session-time-in-custom-table/4737)
**Author:** [@j\_ask](https://community.piwik.pro/u/j_ask)\ **Replies:** 1\ **Last updated:** [December 18, 2024, 12:46pm UTC](https://community.piwik.pro/t/cannot-show-average-session-time-in-custom-table/4737 "2024-12-18T12:46:30Z")
Hi there, I have a table in a dashboard that is grouped by date (in quarter), country, and channel. I tried showing ‘average session duration’ for each group by changing session time to average session time as suggested… --- ## [Custom Report - create Table report](https://community.piwik.pro/t/custom-report-create-table-report/4705)
**Author:** [@KU-Marketing-team](https://community.piwik.pro/u/KU-Marketing-team)\ **Replies:** 1\ **Last updated:** [December 10, 2024, 3:19pm UTC](https://community.piwik.pro/t/custom-report-create-table-report/4705 "2024-12-10T15:19:50Z")
I need this reports. how Can I set in Custom report (as Table report) area? Thank you for your help. --- ## [Why the variance % shows green if a goal has decreased](https://community.piwik.pro/t/why-the-variance-shows-green-if-a-goal-has-decreased/4654)
**Author:** [@Elena\_Benito\_Ruiz](https://community.piwik.pro/u/Elena_Benito_Ruiz)\ **Replies:** 1\ **Last updated:** [November 28, 2024, 11:20am UTC](https://community.piwik.pro/t/why-the-variance-shows-green-if-a-goal-has-decreased/4654 "2024-11-28T11:20:17Z")
Hello everyone, Kind of dumbfounded, but… let’s compare conversions last October 2023 and October 2024 (fewer than Oct 2023)…the difference shows green (positive)…when should read red negative, no? :smiley: --- ## ["Search exits" and "search refinements"](https://community.piwik.pro/t/search-exits-and-search-refinements/1791)
**Author:** [@martho](https://community.piwik.pro/u/martho)\ **Replies:** 4\ **Last updated:** [November 25, 2024, 1:31pm UTC](https://community.piwik.pro/t/search-exits-and-search-refinements/1791 "2024-11-25T13:31:44Z")
Hi Just wondering. Is there anyone who’s integrated additional internal search metrics to your Piwik-account on top of the standard-metrics? Fx. “Search Exits” and “Search Refinements” as a calculated metric? I know ho… --- ## [Dashboards and Reports showing different data for same time period](https://community.piwik.pro/t/dashboards-and-reports-showing-different-data-for-same-time-period/4650)
**Author:** [@ClareSKC](https://community.piwik.pro/u/ClareSKC)\ **Replies:** 3\ **Last updated:** [November 21, 2024, 9:44am UTC](https://community.piwik.pro/t/dashboards-and-reports-showing-different-data-for-same-time-period/4650 "2024-11-21T09:44:28Z")
I’m seeing different numbers in my dashboard versus my reports for the same time period. I’m viewing: Dashboard \> User Engagement \> Most Visited Pages and Reports \> Pages \> Page Views Page view numbers and bounce rat… --- ## [Google / cpc not showing in sources](https://community.piwik.pro/t/google-cpc-not-showing-in-sources/4616)
**Author:** [@MAGGyver](https://community.piwik.pro/u/MAGGyver)\ **Replies:** 6\ **Last updated:** [November 13, 2024, 1:35pm UTC](https://community.piwik.pro/t/google-cpc-not-showing-in-sources/4616 "2024-11-13T13:35:22Z")
Hi everyone, (I’m new to Piwik) I’ve been running into an issue with Piwik Pro Core’s channel attribution that I’d like to get your thoughts on. Setup status: Piwik Pro Core has been running for several days Google … --- ## [Sum of Product Revenue and quantity not the same in Looker Studio](https://community.piwik.pro/t/sum-of-product-revenue-and-quantity-not-the-same-in-looker-studio/2290)
**Author:** [@Jeff](https://community.piwik.pro/u/Jeff)\ **Replies:** 8\ **Last updated:** [October 31, 2024, 9:39am UTC](https://community.piwik.pro/t/sum-of-product-revenue-and-quantity-not-the-same-in-looker-studio/2290 "2024-10-31T09:39:02Z")
Hi, with the new update I can now display the products sold in Google Looker Studio. But the data is not correct: Piwik: Looker: The orders are right, but the rest is wrong. There is no filter in Looker and the … --- ## [Looker Studio Connector Issue](https://community.piwik.pro/t/looker-studio-connector-issue/4579)
**Author:** [@Optizent](https://community.piwik.pro/u/Optizent)\ **Replies:** 1\ **Last updated:** [October 25, 2024, 8:03am UTC](https://community.piwik.pro/t/looker-studio-connector-issue/4579 "2024-10-25T08:03:15Z")
Looker Studio Piwik PRO connector is giving an error that credentials are invalid. Is anybody else having similar issue? --- ## [(Kind of) Dumb Question: what is the "-" in this report?](https://community.piwik.pro/t/kind-of-dumb-question-what-is-the-in-this-report/4557)
**Author:** [@Elena\_Benito\_Ruiz](https://community.piwik.pro/u/Elena_Benito_Ruiz)\ **Replies:** 5\ **Last updated:** [October 23, 2024, 12:24pm UTC](https://community.piwik.pro/t/kind-of-dumb-question-what-is-the-in-this-report/4557 "2024-10-23T12:24:24Z")
Hi there Kind of embarrassing question, my brainfog doesn’t let me think where this could be coming…but in an explorer table where I want to rank top performing posts regarding 2 given goals and filtered by dimension Pa… --- ## [Channel Report rows sum doesn't add up](https://community.piwik.pro/t/channel-report-rows-sum-doesnt-add-up/4540)
**Author:** [@BT\_nista](https://community.piwik.pro/u/BT_nista)\ **Replies:** 2\ **Last updated:** [October 21, 2024, 8:43am UTC](https://community.piwik.pro/t/channel-report-rows-sum-doesnt-add-up/4540 "2024-10-21T08:43:01Z")
Hi, when looking at the Channel Report (Reports → Acquisition → Channels), I can see the individual entries for the channels. When I sum up each channel, I’ll get a different summary than the one displayed at the top. T… --- ## [Total for widgets in dashboard missing](https://community.piwik.pro/t/total-for-widgets-in-dashboard-missing/4555)
**Author:** [@V\_E](https://community.piwik.pro/u/V_E)\ **Replies:** 1\ **Last updated:** [October 21, 2024, 8:26am UTC](https://community.piwik.pro/t/total-for-widgets-in-dashboard-missing/4555 "2024-10-21T08:26:14Z")
Hello, I work a lot with creating dashboards and exporting them for others to see. Unfortunately, for an example when doing a bar chart, it seems as “data points”, which shows the total for each bar is not possible to a… --- ## [Scope reports Piwik](https://community.piwik.pro/t/scope-reports-piwik/4565)
**Author:** [@Arthur](https://community.piwik.pro/u/Arthur)\ **Replies:** 1\ **Last updated:** [October 21, 2024, 7:47am UTC](https://community.piwik.pro/t/scope-reports-piwik/4565 "2024-10-21T07:47:55Z")
Hi, My customer would like to know if the Q&A pages on their site generate conversions even during a different session. To answer this, I simply created a funnel with step 1: the Q&A page URL and step 2: the event ‘purc… --- ## [How to add Filters to custom attribution report (model comparison tool)?](https://community.piwik.pro/t/how-to-add-filters-to-custom-attribution-report-model-comparison-tool/4509)
**Author:** [@James\_Garnier](https://community.piwik.pro/u/James_Garnier)\ **Replies:** 2\ **Last updated:** [October 17, 2024, 9:14am UTC](https://community.piwik.pro/t/how-to-add-filters-to-custom-attribution-report-model-comparison-tool/4509 "2024-10-17T09:14:56Z")
I’ve created a custom attribution report in the Model Comparison Tool view to see Goal conversions against the Dimension “Session Entry URL”. How do I add a Filter to this report to filter Goal conversions for a specifi… --- ## [Public dashboards - want them always show data up to todays date](https://community.piwik.pro/t/public-dashboards-want-them-always-show-data-up-to-todays-date/4524)
**Author:** [@David\_Butler](https://community.piwik.pro/u/David_Butler)\ **Replies:** 1\ **Last updated:** [October 15, 2024, 11:55am UTC](https://community.piwik.pro/t/public-dashboards-want-them-always-show-data-up-to-todays-date/4524 "2024-10-15T11:55:49Z")
I am creating some public dashboards. The date range is always the one I set when setting it up, instead, I want to pick a start date (that remains constant) but then the end date to always be todays date. Not the date … --- ## [Looker data not same](https://community.piwik.pro/t/looker-data-not-same/4518)
**Author:** [@dave](https://community.piwik.pro/u/dave)\ **Replies:** 0\ **Last updated:** [October 10, 2024, 11:34am UTC](https://community.piwik.pro/t/looker-data-not-same/4518 "2024-10-10T11:34:15Z")
Piwik is showing us this for last month While the connector in Looker is showing very different? Thxs --- ## [Why consent report shows numbers in "No decisions" even though collecting anonymous data is disabled?](https://community.piwik.pro/t/why-consent-report-shows-numbers-in-no-decisions-even-though-collecting-anonymous-data-is-disabled/4479)
**Author:** [@Mika](https://community.piwik.pro/u/Mika)\ **Replies:** 1\ **Last updated:** [October 4, 2024, 9:10am UTC](https://community.piwik.pro/t/why-consent-report-shows-numbers-in-no-decisions-even-though-collecting-anonymous-data-is-disabled/4479 "2024-10-04T09:10:47Z")
I have two sites using Piwik PRO. The first one is set to not collect anonymous data from non-consenting visitors and the second one is collecting data from non-consenting visitors. The consent report shows zero in “No … --- ## [Missing Products in PowerBI](https://community.piwik.pro/t/missing-products-in-powerbi/4465)
**Author:** [@Martin](https://community.piwik.pro/u/Martin)\ **Replies:** 2\ **Last updated:** [October 4, 2024, 5:44am UTC](https://community.piwik.pro/t/missing-products-in-powerbi/4465 "2024-10-04T05:44:05Z")
Hi, I have to switch from Lookerstudio to PowerBI. I followed the instructions Microsoft Power BI Desktop integration | Piwik PRO help center and connected Piwik with PowerBI. Not all is running smoothly but thats for… --- ## [Dashboard (resut for each website in one look)](https://community.piwik.pro/t/dashboard-resut-for-each-website-in-one-look/4463)
**Author:** [@KU-Marketing-team](https://community.piwik.pro/u/KU-Marketing-team)\ **Replies:** 1\ **Last updated:** [October 1, 2024, 11:28am UTC](https://community.piwik.pro/t/dashboard-resut-for-each-website-in-one-look/4463 "2024-10-01T11:28:05Z")
Hi! we have several website per every country. like “.de”, “.com”, “.it”, “.fr”., or “.dk”. how can I set each Basic info (Visitor, Session and PV) on one Dashboard(.com page)? --- ## [Visitors difference between date range and monthly datas](https://community.piwik.pro/t/visitors-difference-between-date-range-and-monthly-datas/4442)
**Author:** [@Alexia](https://community.piwik.pro/u/Alexia)\ **Replies:** 1\ **Last updated:** [September 26, 2024, 9:51am UTC](https://community.piwik.pro/t/visitors-difference-between-date-range-and-monthly-datas/4442 "2024-09-26T09:51:24Z")
Hello, I am a bit confused because we’ve noticed a slight difference when analysing datas. For example when we took datas months by months and comparing these datas to the same month range the values differs. Is that … --- ## [Track specific session time as a custom event](https://community.piwik.pro/t/track-specific-session-time-as-a-custom-event/4416)
**Author:** [@Online\_M-A](https://community.piwik.pro/u/Online_M-A)\ **Replies:** 3\ **Last updated:** [September 23, 2024, 12:44pm UTC](https://community.piwik.pro/t/track-specific-session-time-as-a-custom-event/4416 "2024-09-23T12:44:01Z")
Hi, I want to track a specific session time e.g. 2m or 120 sec as a custom event. However the stg.timer event is activated and working, it seems impossible to use this data as a trigger and thus fire a custom event. I t… --- ## [Fishing out referrer/parameter](https://community.piwik.pro/t/fishing-out-referrer-parameter/4387)
**Author:** [@bwill](https://community.piwik.pro/u/bwill)\ **Replies:** 2\ **Last updated:** [September 11, 2024, 1:37pm UTC](https://community.piwik.pro/t/fishing-out-referrer-parameter/4387 "2024-09-11T13:37:35Z")
I want to make my goal tracking a bit more accurate. The goal is a webpage for the download of my software. I want to fish out when I send an email about a software update which also sends traffic to the download page. T… --- ## [All reports are throwing errors](https://community.piwik.pro/t/all-reports-are-throwing-errors/4348)
**Author:** [@cgoasduff](https://community.piwik.pro/u/cgoasduff)\ **Replies:** 1\ **Last updated:** [August 28, 2024, 8:48am UTC](https://community.piwik.pro/t/all-reports-are-throwing-errors/4348 "2024-08-28T08:48:22Z")
Hello Is there something wrong at the moment?, all reports are showing the following error. Thanks Christophe --- ## [Master Filter applied to Dashboard](https://community.piwik.pro/t/master-filter-applied-to-dashboard/4311)
**Author:** [@gocarrera](https://community.piwik.pro/u/gocarrera)\ **Replies:** 0\ **Last updated:** [August 20, 2024, 8:14am UTC](https://community.piwik.pro/t/master-filter-applied-to-dashboard/4311 "2024-08-20T08:14:35Z")
Dear developer, is there a way to apply a filter (user role (session), for example) into a dashboard without applying individually to each widget? If not, could please add to the roadmap? Kind regards, --- ## [Google Ads campaign name filter missing CONTAIN operator](https://community.piwik.pro/t/google-ads-campaign-name-filter-missing-contain-operator/4298)
**Author:** [@gocarrera](https://community.piwik.pro/u/gocarrera)\ **Replies:** 2\ **Last updated:** [August 19, 2024, 11:27am UTC](https://community.piwik.pro/t/google-ads-campaign-name-filter-missing-contain-operator/4298 "2024-08-19T11:27:21Z")
Dear developers, I am trying to create a counter widget on a Piwik PRO dashboard filtering Google Ads campaign name but filter seems to support only IS or IS NOT operators for this dimension. Is there a way to add CONTA… --- ## [Measure time between two specific pageviews in a session](https://community.piwik.pro/t/measure-time-between-two-specific-pageviews-in-a-session/4290)
**Author:** [@martho](https://community.piwik.pro/u/martho)\ **Replies:** 2\ **Last updated:** [August 19, 2024, 9:54am UTC](https://community.piwik.pro/t/measure-time-between-two-specific-pageviews-in-a-session/4290 "2024-08-19T09:54:25Z")
Hi there Say a user visits a part of your website. Is it possible to somehow measure the time between the first and last pageview of that part of the site? Example: A user enters the website via the frontpage and navig… --- ## [Scheduled Reports ALL 404ing](https://community.piwik.pro/t/scheduled-reports-all-404ing/4291)
**Author:** [@David\_Culbertson](https://community.piwik.pro/u/David_Culbertson)\ **Replies:** 1\ **Last updated:** [August 19, 2024, 8:32am UTC](https://community.piwik.pro/t/scheduled-reports-all-404ing/4291 "2024-08-19T08:32:14Z")
Hello, I’ve set-up scheduled reports (tables in CSV) formats for more than 10 websites. For ALL ofg them, clicking on the report names in the automated emails doesn’t result in the report being displayed or downloaded. … --- ## [Ad Segment - Country -\> Netherlands](https://community.piwik.pro/t/ad-segment-country-netherlands/4300)
**Author:** [@Daan\_Geers](https://community.piwik.pro/u/Daan_Geers)\ **Replies:** 2\ **Last updated:** [August 19, 2024, 8:28am UTC](https://community.piwik.pro/t/ad-segment-country-netherlands/4300 "2024-08-19T08:28:17Z")
Goodmorning, I would like to filter only the visitors from the Netherland. But i can not select Netherlands as an value in ‘Country’. Greetings Daan --- ## [Failed looker connection](https://community.piwik.pro/t/failed-looker-connection/4299)
**Author:** [@dave](https://community.piwik.pro/u/dave)\ **Replies:** 3\ **Last updated:** [August 16, 2024, 3:19pm UTC](https://community.piwik.pro/t/failed-looker-connection/4299 "2024-08-16T15:19:26Z")
Noticed that there is a new way to connect looker with piwik (?) but it’s not working for me. While credentials are correct, keep getting the “We sent your information, but it appears to be invalid” message --- ## [Custom Repport & KPis not available](https://community.piwik.pro/t/custom-repport-kpis-not-available/4279)
**Author:** [@DavidZ](https://community.piwik.pro/u/DavidZ)\ **Replies:** 2\ **Last updated:** [August 14, 2024, 9:16am UTC](https://community.piwik.pro/t/custom-repport-kpis-not-available/4279 "2024-08-14T09:16:48Z")
Hi, I have some issues to deal with custom reports (regards GA4) to arrive at the same dashboard. Impossible to obtain for division by month and at the same time sessions / visitors and session time because it will put… --- ## [Linked Google ads showing "google ads unknown'](https://community.piwik.pro/t/linked-google-ads-showing-google-ads-unknown/546)
**Author:** [@Tom](https://community.piwik.pro/u/Tom)\ **Replies:** 8\ **Last updated:** [August 13, 2024, 10:02am UTC](https://community.piwik.pro/t/linked-google-ads-showing-google-ads-unknown/546 "2024-08-13T10:02:40Z")
I have recently linked up my Google Ads account into piwik pro and it successfully displays all the current ad campaign names that are running under the Google Ads section in reports. However, when clicking on one of my… [Previous page](https://community.piwik.pro/c/reports/16.md?page=1) [Next page](https://community.piwik.pro/c/reports/16.md?page=3)