Social Media Report Data Source

(Christopher Bell) #1

Hi hoping someone can help on this

The report for the social profiles report below

does anyone know the SQL for it to extract the data from the MYSQL database ?


(Lukas Winkler) #2


Did you know that Matomo can log all SQL queries into a logfile?

The URL->Social Network mapping is from here:

(Christopher Bell) #3

Hi Lukas that logging would seem the ideal solution , I have a cloud account with matomo

can it be switched on , on the cloud ?