Generating an auth token from the WordPress plugin

WordPress Plugin
1

Hi,

I’ve been trying to generate Google Data Studio reports from Matomo data using this FAQ : https://fr.matomo.org/faq/new-to-piwik/how-to-import-matomo-data-in-to-google-data-studio/

At some point you need an authentication token, which I tried to access by following this FAQ : https://fr.matomo.org/faq/general/faq_114/

However, there is no “Security” tab on the Administration page for me. I’m using the Matomo for Wordpress plugin, and I suspect that this is why I don’t have the same tabs as other Matomo installations. I confirmed this by installing Matomo manually, where I was able to access a token.

The odd part is that I also compared the databases between the Wordpress plugin version and the manually installed version, and the WP version also has the same tables used to store the hashes and other values created when generating a token.

So my question is : how can I generate authentication tokens when I’m only using the Wordpress plugin ? or how can i access the Security tab from this plugin ?

(side note : i do have admin rights on the wordpress installations)

Thanks !

2

Hi Antony,

thanks for joining the Matomo community.
Unfortunately this tutorial cannot be applied for the Matomo for wordpress plugin. We’ll update it soon.
The reason is that we had to disable the native Matomo API to use the wordpress one instead.
The workaround you can use to export your data to google data studio is to use the google data studio MySQL connector to fetch directly the data from the database.

Kind regards

Matthieu

3

Thank you for the reply. I haven’t managed to connecte the database yet, but i’ll mark your answer as solution. Thanks !

4

Hi Matthieu,

I have the same problem like Anthony. But instead of importing the data to google data studio, I want to import them to a simple google sheet. Can you help me with that?

Best regards
Christina

5

Hi @Christina

You can export your data in CSV format. Then open this export with your spreadsheet software.
Kind regards

Mat

6

Hi Mat,

I forgot to say that I want the data to be updated in the google sheet on a daily basis.

I followed this manual: https://matomo.org/faq/new-to-piwik/how-to-import-matomo-data-in-to-google-data-studio/ and created a script and trigger, but it doesn´t work without the auth token.

7

Hi @Christina

the auth tokens do not exist in the wordpress plugin.
If you want them, you must switch to matomo on premise.
Kind regards

Mat

8

Ok, thank you @Matthieu_Mary