How to relate the event action and event category from Matomo database?

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.
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