Linking Matomo Cloud to Data Studio

Hi,

I’m very new to Matomo so apologies if this is a really stupid question.

We have Matomo cloud and I would like to be able to link up to Data Studio to build reports. I have found instructions that tell me to create a MySQL connector in Data Studio but this is where I get stuck. The connector asks for the following but I have no idea where I would find the hostname, IP or database.

Hostname or IP
Port (optional)
Database
Username
Password

Any help with this (even if it’s as simple as this isn’t possible with Matamo cloud) would be much appreciated.

Thanks

Christine

Hi Christine,

It is not possible to connect to you SQL database on the cloud. We do have a reporting API Reporting API Reference: API Reference - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3 but there is currently no connector in data studio.

Thanks,

Hi Jason,

Bother, I had a feeling that was the case. Thanks for your help.

Christine

You could import the data into a google sheet, then connect using this