Matomo API, extractions, User Guide


I would like to ask whether I could export somehow the whole Matomo’s DB? I need to import the data in Excel in order to do some statistical calculations, organize the data and find patterns inside the numbers.

I tried already with Live API requests but it is very unorganized, also with the buttons which are inside Matomo interface but its extracting the data for each and every metric in different tables w/o any connection between them. E.g. I have differ tables for Browsers & Devices and could not connect them to find out those people who are on PC which browser they are particularly using.

Do you have any downloadable Manual/Guide for Matomo?

Thank you in advance for the help!
Kind regards,