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.
When using "All Websites -> All Websites Dashboard" Report, Ecommerce Orders and Conversions are always 0, but correct values are provided by the API response.
Reproducibility:
Create Data Connection
Select "All Websites -> All Websites Dashboard" Report
Create new Table Visualisation with "Websites" as a Dimension and "Ecommerce Orders" and "Conversions" as Metrics.
Correspondingvalues are 0, even though the MultiSites API responds with the correct numbers (and revenue is correct)
When using "All Websites -> All Websites Dashboard" Report, Ecommerce Orders and Conversions are always 0, but correct values are provided by the API response.
Reproducibility:
Tested this with 2 different Matomo instances.