I need a list of users with a total count of specific actions they have completed. e.g. Downloaded a book, liked a page etc. These actions have been captured using Event Tracking.
I could, but that would be very inefficient due to I have 4500+ users. So creating 4500 segments would be a killer for Matomo and its database structure.
I merely want to combine the event data from piwik_log_link_visit_action with the userId of piwik_log_visit.
There must be a way to do this simple analytics extraction based on user?
Can you identify a field/column that the two tables share in common, if so, then you could export each table separately and match the data of the two tables by the just-mentioned field/column.
The only other possibility of which I am aware is a custom variable that would assign a visitor ID to each event. Unfortunately, I am confused about the way Matomo assigns visitor IDs in general, and would very much appreciate your reporting back to us should you attempt this route.