Querying "Actions > Page Urls" for multiple dates can be very slow

[diosmosis]

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.