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.
Querying data for one day for this Page URLs works, getting data for a larger period, however, can be very slow.
This is due to the following reasons:
Looker Studio has no concept of hierarchical reports, so we flatten the reports. For some Matomos with many different page URLs, this can take some time, and the process is repeated for every paginated request to get the data.
The cost of loading one day of reports is multiplied by the number of days requested. If an entire month is requested, that's (potentially) 30x the processing.
To resolve this completely, this will likely need fixes either in the core product (or Matomo Cloud's infrastructure) and changes to the way the connector requests data.
Querying data for one day for this Page URLs works, getting data for a larger period, however, can be very slow.
This is due to the following reasons:
To resolve this completely, this will likely need fixes either in the core product (or Matomo Cloud's infrastructure) and changes to the way the connector requests data.