Hai, I have installed matomo and I have have tracked the visitors from facebook and campaigns.Where do these datas store in database i.e, datas about where the visitors are from. I have referred the document ( Database schema: API Reference - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3 ) but i couldnt find the exact field and also what for archieve data is used? Thanks in advance
Hi,
I think the matomo_log_conversion table is what you are looking for (if you need the raw referrer data).
But I’d really recommend you to use the reporting API as it allows you to get all data that you see in Matomo in a structured way.
https://developer.matomo.org/api-reference/reporting-api
The Archive tables store the processed data. To be able to show statistics, Matomo needs to aggregate the raw data of all visits and create reports out of them.
Thank you Lukas. But matomo_log_conversion table is empty.