Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing fields description for table log_link_visit_action in the Database schema reference #674

Open
heurteph-ei opened this issue Oct 21, 2022 · 0 comments

Comments

@heurteph-ei
Copy link

heurteph-ei commented Oct 21, 2022

Page URL

https://developer.matomo.org/guides/database-schema#visit-actions (Chapiter Visit Actions)

What is missing?

Many fields are missing in table log_link_visit_action:

Field Type Nullable Key More info
idvisit bigint unsigned NO MUL Sure this is the left part of the link 😉
custom_float double YES No idea what it can be... Maybe the value in case of events with value?
idpageview char(6) YES Easy to understand, but not described in the doc
search_cat varchar(200) YES Used for search tracking
search_count int unsigned YES Used for search tracking
idaction_event_action int unsigned YES Easy to understand, but not described in the doc
idaction_event_category int unsigned YES Easy to understand, but not described in the doc
idaction_content_interaction int unsigned YES In case of Contents core plugin activation
idaction_content_name int unsigned YES In case of Contents core plugin activation
idaction_content_piece int unsigned YES In case of Contents core plugin activation
idaction_content_target int unsigned YES In case of Contents core plugin activation

Also, custom_var_k* columns are described, whereas it is advised to disable the CustomVariables plugin, but custom_dimension_* columns are described, whereas it is advised to enable the CustomDimensions plugin.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants