search

matomo-org / looker-studio-connector

The officially supported Matomo Connector for Looker Studio enables you to explore your Matomo data in Looker Studio at no cost. You can connect to both Matomo Cloud instances or On-Premise instances using just a Matomo Auth Token.
https://matomo.org/guide/apis/looker-studio/
6 stars 1 forks source link

Grouping Failure in Looker Studio with Matomo Connector #29

Open Lynn-777 opened 8 months ago

Lynn-777 commented 8 months ago

There is a critical issue with the Matomo Connector used in Looker Studio where identical values from calculated fields are not being grouped as intended across all visualizations, including pie charts, tables, and others. This bug disrupts data analysis, as each instance of a value is treated as unique, leading to a fragmented and misleading representation of the data.

Steps to Reproduce:

Expected Behavior: The visualization should consolidate identical values into single groups for clear and accurate data representation, irrespective of the type of visualization used. (see Screenshot: left: Matomo Connector right: GA4 Connector)

Actual Behavior: Despite the use of calculated fields designed to group identical values, the visualizations treat each instance as unique. This results in an inflated number of groups and an erroneous depiction of the dataset. This issue is observable in pie charts, where it generates an excessive number of slices, as well as in tables, where rows that should be combined are instead displayed separately.

Impact: This bug severely affects the usability of Looker Studio with the Matomo Connector for meaningful data analysis and visualization, as it prevents accurate aggregation of data points.

Additional Information:

The problem persists regardless of the visualization format. This is not an isolated issue; it has been replicated with various data dimensions.

image

Lynn-777 commented 8 months ago

Even using dimension fields such as "Search Engine" without filters or calculated fields won't display correctly.

image

diosmosis commented 8 months ago

@njoyhwsm What version of Matomo are you connecting to?

Lynn-777 commented 8 months ago

@diosmosis

We use Matomo Cloud. So I guess it is the latest version.

diosmosis commented 8 months ago

I see, yes, this is a known issue with the connector and Matomo at present. More details on the work needed to add this and details on a workaround are here: https://github.com/matomo-org/looker-studio-connector/issues/3

Lynn-777 commented 8 months ago

Thank you for these links, they have helped me understand that by re-aggregating the appropriate metric, the values will indeed be grouped as desired. :)