How to get Unique Downloads count from Matomo mysql table

General questions
1

Looking for SQL quire to get the Unique Downloads count from matomo_log_action table
as shown below

image
image1535×347 12.7 KB

please help the way to get Unique Downloads count

2

Hi,

Matomo doesn’t officially support making direct MySQL queries to get reports (as they are potentially not stored in a straightforward format and you end up reinventing a large portion of Matomo yourself). So I strongly recommend you to go with the HTTP API instead (you can find the API URL with the export :export: button below the report).

But if you want to you can enable SQL logging in Matomo (https://matomo.org/faq/troubleshooting/faq_115/) and see if you can find something useful.