Matomo Database: Join log_action and log_link_visit_action

Knowledge base
1

Hey there,

I’m trying to understand more about actions in their respective visit. Precisely, I’m looking for a timestamp related to actions stored in log_action db. As a timestamp is missing in log_action, I was going to join log_action and log_link_visit_action. But I’m not sure about the appropriate join key to log_action.idaction and I’m down to guessing. Any suggestion out there? Help appreciated!

Many thanks in advance,
Steffen

2

There are more possible join keys. That depends on what data you’re searching for. idaction url / action name / url ref / etc. the actions table is just a lookup. I think, in general, you can use all columns starting with “idaction” from the “log_link_visit_action” table to join with the actions table.