We are using the MySQL database to getting the report from Matomo database. We can get the event action separately and event category separately. But how to related those events ?
From what I understand, piwik_log_action seems to to be the table storing events and I should expect the details of the event to be in piwik_log_link_visit_action. But I’m not able to find event category/action that would relate to the event in these tables.
Events are stored in the
matomo_log_link_visit_action table coupled with
Have a look at
idaction_event_category columns of
That’s okay @heurteph-ei .
But How to split the event action and event category? You told us as events are stored in two tables. I accept your valuable answer. I can’t able to split the event action and event category from the matomo_log_action table.