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.
Hi @Vijay_karthick
Events are stored in the matomo_log_link_visit_action
table coupled with matomo_log_action
table.
https://developer.matomo.org/guides/database-schema#visit-actions
Have a look at idaction_name
, idaction_event_action
and idaction_event_category
columns of matomo_log_link_visit_action
table.
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.
Hi @Vijay_karthick
Sorry for the delay…
The link between event action and event category is located in the matomo_log_link_visit_action
table.
1 Like