注意： 为方便直观比较，特令单元格空表示字段存在于相应版本，N/A表示字段在相应版本不存在
| Table Name | Column Name | Matomo 3.14.1 | Matomo 4.16.1 | Matomo 5.1.2 |
| mtm_access | idaccess | |||
| mtm_access | login | |||
| mtm_access | idsite | |||
| mtm_access | access | |||
| mtm_archive_invalidations | idinvalidation | N/A | ||
| mtm_archive_invalidations | idarchive | N/A | ||
| mtm_archive_invalidations | name | N/A | ||
| mtm_archive_invalidations | idsite | N/A | ||
| mtm_archive_invalidations | date1 | N/A | ||
| mtm_archive_invalidations | date2 | N/A | ||
| mtm_archive_invalidations | period | N/A | ||
| mtm_archive_invalidations | ts_invalidated | N/A | ||
| mtm_archive_invalidations | ts_started | N/A | ||
| mtm_archive_invalidations | status | N/A | ||
| mtm_archive_invalidations | report | N/A | ||
| mtm_brute_force_log | id_brute_force_log | |||
| mtm_brute_force_log | ip_address | |||
| mtm_brute_force_log | attempted_at | |||
| mtm_brute_force_log | login | N/A | ||
| mtm_changes | idchange | N/A | ||
| mtm_changes | created_time | N/A | ||
| mtm_changes | plugin_name | N/A | ||
| mtm_changes | version | N/A | ||
| mtm_changes | title | N/A | ||
| mtm_changes | description | N/A | ||
| mtm_changes | link_name | N/A | ||
| mtm_changes | link | N/A | ||
| mtm_custom_dimensions | idcustomdimension | N/A | ||
| mtm_custom_dimensions | idsite | N/A | ||
| mtm_custom_dimensions | name | N/A | ||
| mtm_custom_dimensions | index | N/A | ||
| mtm_custom_dimensions | scope | N/A | ||
| mtm_custom_dimensions | active | N/A | ||
| mtm_custom_dimensions | extractions | N/A | ||
| mtm_custom_dimensions | case_sensitive | N/A | ||
| mtm_goal | idsite | |||
| mtm_goal | idgoal | |||
| mtm_goal | name | |||
| mtm_goal | description | |||
| mtm_goal | match_attribute | |||
| mtm_goal | pattern | |||
| mtm_goal | pattern_type | |||
| mtm_goal | case_sensitive | |||
| mtm_goal | allow_multiple | |||
| mtm_goal | revenue | |||
| mtm_goal | deleted | |||
| mtm_goal | event_value_as_revenue | |||
| mtm_locks | key | |||
| mtm_locks | value | |||
| mtm_locks | expiry_time | |||
| mtm_log_action | idaction | |||
| mtm_log_action | name | |||
| mtm_log_action | hash | |||
| mtm_log_action | type | |||
| mtm_log_action | url_prefix | |||
| mtm_log_conversion | idvisit | |||
| mtm_log_conversion | idsite | |||
| mtm_log_conversion | idvisitor | |||
| mtm_log_conversion | server_time | |||
| mtm_log_conversion | idaction_url | |||
| mtm_log_conversion | idlink_va | |||
| mtm_log_conversion | idgoal | |||
| mtm_log_conversion | buster | |||
| mtm_log_conversion | idorder | |||
| mtm_log_conversion | items | |||
| mtm_log_conversion | url | |||
| mtm_log_conversion | visitor_days_since_first | N/A | N/A | |
| mtm_log_conversion | visitor_days_since_order | N/A | N/A | |
| mtm_log_conversion | visitor_returning | |||
| mtm_log_conversion | visitor_count_visits | |||
| mtm_log_conversion | referer_keyword | |||
| mtm_log_conversion | referer_name | |||
| mtm_log_conversion | referer_type | |||
| mtm_log_conversion | config_device_brand | |||
| mtm_log_conversion | config_device_model | |||
| mtm_log_conversion | config_device_type | |||
| mtm_log_conversion | location_city | |||
| mtm_log_conversion | location_country | |||
| mtm_log_conversion | location_latitude | |||
| mtm_log_conversion | location_longitude | |||
| mtm_log_conversion | location_region | |||
| mtm_log_conversion | revenue | |||
| mtm_log_conversion | revenue_discount | |||
| mtm_log_conversion | revenue_shipping | |||
| mtm_log_conversion | revenue_subtotal | |||
| mtm_log_conversion | revenue_tax | |||
| mtm_log_conversion | custom_var_k1 | N/A | N/A | |
| mtm_log_conversion | custom_var_v1 | N/A | N/A | |
| mtm_log_conversion | custom_var_k2 | N/A | N/A | |
| mtm_log_conversion | custom_var_v2 | N/A | N/A | |
| mtm_log_conversion | custom_var_k3 | N/A | N/A | |
| mtm_log_conversion | custom_var_v3 | N/A | N/A | |
| mtm_log_conversion | custom_var_k4 | N/A | N/A | |
| mtm_log_conversion | custom_var_v4 | N/A | N/A | |
| mtm_log_conversion | custom_var_k5 | N/A | N/A | |
| mtm_log_conversion | custom_var_v5 | N/A | N/A | |
| mtm_log_conversion | pageviews_before | N/A | ||
| mtm_log_conversion | visitor_seconds_since_first | N/A | ||
| mtm_log_conversion | visitor_seconds_since_order | N/A | ||
| mtm_log_conversion | config_browser_name | N/A | ||
| mtm_log_conversion | config_client_type | N/A | ||
| mtm_log_conversion | custom_dimension_1 | N/A | ||
| mtm_log_conversion | custom_dimension_2 | N/A | ||
| mtm_log_conversion | custom_dimension_3 | N/A | ||
| mtm_log_conversion | custom_dimension_4 | N/A | ||
| mtm_log_conversion | custom_dimension_5 | N/A | ||
| mtm_log_conversion_item | idsite | |||
| mtm_log_conversion_item | idvisitor | |||
| mtm_log_conversion_item | server_time | |||
| mtm_log_conversion_item | idvisit | |||
| mtm_log_conversion_item | idorder | |||
| mtm_log_conversion_item | idaction_sku | |||
| mtm_log_conversion_item | idaction_name | |||
| mtm_log_conversion_item | idaction_category | |||
| mtm_log_conversion_item | idaction_category2 | |||
| mtm_log_conversion_item | idaction_category3 | |||
| mtm_log_conversion_item | idaction_category4 | |||
| mtm_log_conversion_item | idaction_category5 | |||
| mtm_log_conversion_item | price | |||
| mtm_log_conversion_item | quantity | |||
| mtm_log_conversion_item | deleted | |||
| mtm_log_link_visit_action | idlink_va | |||
| mtm_log_link_visit_action | idsite | |||
| mtm_log_link_visit_action | idvisitor | |||
| mtm_log_link_visit_action | idvisit | |||
| mtm_log_link_visit_action | idaction_url_ref | |||
| mtm_log_link_visit_action | idaction_name_ref | |||
| mtm_log_link_visit_action | custom_float | |||
| mtm_log_link_visit_action | server_time | |||
| mtm_log_link_visit_action | idpageview | |||
| mtm_log_link_visit_action | interaction_position | N/A | N/A | |
| mtm_log_link_visit_action | idaction_name | |||
| mtm_log_link_visit_action | idaction_url | |||
| mtm_log_link_visit_action | time_spent_ref_action | |||
| mtm_log_link_visit_action | idaction_event_action | |||
| mtm_log_link_visit_action | idaction_event_category | |||
| mtm_log_link_visit_action | idaction_content_interaction | |||
| mtm_log_link_visit_action | idaction_content_name | |||
| mtm_log_link_visit_action | idaction_content_piece | |||
| mtm_log_link_visit_action | idaction_content_target | |||
| mtm_log_link_visit_action | custom_var_k1 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_v1 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_k2 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_v2 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_k3 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_v3 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_k4 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_v4 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_k5 | N/A | N/A | |
| mtm_log_link_visit_action | custom_var_v5 | N/A | N/A | |
| mtm_log_link_visit_action | pageview_position | N/A | ||
| mtm_log_link_visit_action | search_cat | N/A | ||
| mtm_log_link_visit_action | search_count | N/A | ||
| mtm_log_link_visit_action | idaction_product_cat | N/A | ||
| mtm_log_link_visit_action | idaction_product_cat2 | N/A | ||
| mtm_log_link_visit_action | idaction_product_cat3 | N/A | ||
| mtm_log_link_visit_action | idaction_product_cat4 | N/A | ||
| mtm_log_link_visit_action | idaction_product_cat5 | N/A | ||
| mtm_log_link_visit_action | idaction_product_name | N/A | ||
| mtm_log_link_visit_action | product_price | N/A | ||
| mtm_log_link_visit_action | idaction_product_sku | N/A | ||
| mtm_log_link_visit_action | time_dom_completion | N/A | ||
| mtm_log_link_visit_action | time_dom_processing | N/A | ||
| mtm_log_link_visit_action | time_network | N/A | ||
| mtm_log_link_visit_action | time_on_load | N/A | ||
| mtm_log_link_visit_action | time_server | N/A | ||
| mtm_log_link_visit_action | time_transfer | N/A | ||
| mtm_log_link_visit_action | time_spent | N/A | ||
| mtm_log_link_visit_action | custom_dimension_1 | N/A | ||
| mtm_log_link_visit_action | custom_dimension_2 | N/A | ||
| mtm_log_link_visit_action | custom_dimension_3 | N/A | ||
| mtm_log_link_visit_action | custom_dimension_4 | N/A | ||
| mtm_log_link_visit_action | custom_dimension_5 | N/A | ||
| mtm_log_profiling | query | |||
| mtm_log_profiling | count | |||
| mtm_log_profiling | sum_time_ms | |||
| mtm_log_profiling | idprofiling | |||
| mtm_log_visit | idvisit | |||
| mtm_log_visit | idsite | |||
| mtm_log_visit | idvisitor | |||
| mtm_log_visit | visit_last_action_time | |||
| mtm_log_visit | config_id | |||
| mtm_log_visit | location_ip | |||
| mtm_log_visit | user_id | |||
| mtm_log_visit | visit_first_action_time | |||
| mtm_log_visit | visit_goal_buyer | |||
| mtm_log_visit | visit_goal_converted | |||
| mtm_log_visit | visitor_days_since_first | N/A | N/A | |
| mtm_log_visit | visitor_days_since_order | N/A | N/A | |
| mtm_log_visit | visitor_returning | |||
| mtm_log_visit | visitor_count_visits | |||
| mtm_log_visit | visit_entry_idaction_name | |||
| mtm_log_visit | visit_entry_idaction_url | |||
| mtm_log_visit | visit_exit_idaction_name | |||
| mtm_log_visit | visit_exit_idaction_url | |||
| mtm_log_visit | visit_total_actions | |||
| mtm_log_visit | visit_total_interactions | |||
| mtm_log_visit | visit_total_searches | |||
| mtm_log_visit | referer_keyword | |||
| mtm_log_visit | referer_name | |||
| mtm_log_visit | referer_type | |||
| mtm_log_visit | referer_url | |||
| mtm_log_visit | location_browser_lang | |||
| mtm_log_visit | config_browser_engine | |||
| mtm_log_visit | config_browser_name | |||
| mtm_log_visit | config_browser_version | |||
| mtm_log_visit | config_device_brand | |||
| mtm_log_visit | config_device_model | |||
| mtm_log_visit | config_device_type | |||
| mtm_log_visit | config_os | |||
| mtm_log_visit | config_os_version | |||
| mtm_log_visit | visit_total_events | |||
| mtm_log_visit | visitor_localtime | |||
| mtm_log_visit | visitor_days_since_last | N/A | N/A | |
| mtm_log_visit | config_resolution | |||
| mtm_log_visit | config_cookie | |||
| mtm_log_visit | config_director | N/A | N/A | |
| mtm_log_visit | config_flash | |||
| mtm_log_visit | config_gears | N/A | N/A | |
| mtm_log_visit | config_java | |||
| mtm_log_visit | config_pdf | |||
| mtm_log_visit | config_quicktime | |||
| mtm_log_visit | config_realplayer | |||
| mtm_log_visit | config_silverlight | |||
| mtm_log_visit | config_windowsmedia | |||
| mtm_log_visit | visit_total_time | |||
| mtm_log_visit | location_city | |||
| mtm_log_visit | location_country | |||
| mtm_log_visit | location_latitude | |||
| mtm_log_visit | location_longitude | |||
| mtm_log_visit | location_region | |||
| mtm_log_visit | custom_var_k1 | N/A | N/A | |
| mtm_log_visit | custom_var_v1 | N/A | N/A | |
| mtm_log_visit | custom_var_k2 | N/A | N/A | |
| mtm_log_visit | custom_var_v2 | N/A | N/A | |
| mtm_log_visit | custom_var_k3 | N/A | N/A | |
| mtm_log_visit | custom_var_v3 | N/A | N/A | |
| mtm_log_visit | custom_var_k4 | N/A | N/A | |
| mtm_log_visit | custom_var_v4 | N/A | N/A | |
| mtm_log_visit | custom_var_k5 | N/A | N/A | |
| mtm_log_visit | custom_var_v5 | N/A | N/A | |
| mtm_log_visit | profilable | N/A | ||
| mtm_log_visit | visitor_seconds_since_first | N/A | ||
| mtm_log_visit | visitor_seconds_since_order | N/A | ||
| mtm_log_visit | config_client_type | N/A | ||
| mtm_log_visit | visitor_seconds_since_last | N/A | ||
| mtm_log_visit | last_idlink_va | N/A | ||
| mtm_log_visit | custom_dimension_1 | N/A | ||
| mtm_log_visit | custom_dimension_2 | N/A | ||
| mtm_log_visit | custom_dimension_3 | N/A | ||
| mtm_log_visit | custom_dimension_4 | N/A | ||
| mtm_log_visit | custom_dimension_5 | N/A | ||
| mtm_logger_message | idlogger_message | |||
| mtm_logger_message | tag | |||
| mtm_logger_message | timestamp | |||
| mtm_logger_message | level | |||
| mtm_logger_message | message | |||
| mtm_option | option_name | |||
| mtm_option | option_value | |||
| mtm_option | autoload | |||
| mtm_plugin_setting | plugin_name | |||
| mtm_plugin_setting | setting_name | |||
| mtm_plugin_setting | setting_value | |||
| mtm_plugin_setting | json_encoded | |||
| mtm_plugin_setting | user_login | |||
| mtm_plugin_setting | idplugin_setting | |||
| mtm_privacy_logdata_anonymizations | idlogdata_anonymization | |||
| mtm_privacy_logdata_anonymizations | idsites | |||
| mtm_privacy_logdata_anonymizations | date_start | |||
| mtm_privacy_logdata_anonymizations | date_end | |||
| mtm_privacy_logdata_anonymizations | anonymize_ip | |||
| mtm_privacy_logdata_anonymizations | anonymize_location | |||
| mtm_privacy_logdata_anonymizations | anonymize_userid | |||
| mtm_privacy_logdata_anonymizations | unset_visit_columns | |||
| mtm_privacy_logdata_anonymizations | unset_link_visit_action_columns | |||
| mtm_privacy_logdata_anonymizations | output | |||
| mtm_privacy_logdata_anonymizations | scheduled_date | |||
| mtm_privacy_logdata_anonymizations | job_start_date | |||
| mtm_privacy_logdata_anonymizations | job_finish_date | |||
| mtm_privacy_logdata_anonymizations | requester | |||
| mtm_report | idreport | |||
| mtm_report | idsite | |||
| mtm_report | login | |||
| mtm_report | description | |||
| mtm_report | idsegment | |||
| mtm_report | period | |||
| mtm_report | hour | |||
| mtm_report | type | |||
| mtm_report | format | |||
| mtm_report | reports | |||
| mtm_report | parameters | |||
| mtm_report | ts_created | |||
| mtm_report | ts_last_sent | |||
| mtm_report | deleted | |||
| mtm_report | evolution_graph_within_period | |||
| mtm_report | evolution_graph_period_n | |||
| mtm_report | period_param | |||
| mtm_report_subscriptions | idreport | |||
| mtm_report_subscriptions | token | |||
| mtm_report_subscriptions | ||||
| mtm_report_subscriptions | ts_subscribed | |||
| mtm_report_subscriptions | ts_unsubscribed | |||
| mtm_segment | idsegment | |||
| mtm_segment | name | |||
| mtm_segment | definition | |||
| mtm_segment | login | |||
| mtm_segment | enable_all_users | |||
| mtm_segment | enable_only_idsite | |||
| mtm_segment | auto_archive | |||
| mtm_segment | ts_created | |||
| mtm_segment | ts_last_edit | |||
| mtm_segment | deleted | |||
| mtm_segment | hash | N/A | ||
| mtm_sequence | name | |||
| mtm_sequence | value | |||
| mtm_session | id | |||
| mtm_session | modified | |||
| mtm_session | lifetime | |||
| mtm_session | data | |||
| mtm_site | idsite | |||
| mtm_site | name | |||
| mtm_site | main_url | |||
| mtm_site | ts_created | |||
| mtm_site | ecommerce | |||
| mtm_site | sitesearch | |||
| mtm_site | sitesearch_keyword_parameters | |||
| mtm_site | sitesearch_category_parameters | |||
| mtm_site | timezone | |||
| mtm_site | currency | |||
| mtm_site | exclude_unknown_urls | |||
| mtm_site | excluded_ips | |||
| mtm_site | excluded_parameters | |||
| mtm_site | excluded_user_agents | |||
| mtm_site | group | |||
| mtm_site | type | |||
| mtm_site | keep_url_fragment | |||
| mtm_site | creator_login | |||
| mtm_site | excluded_referrers | N/A | ||
| mtm_site_setting | idsite | |||
| mtm_site_setting | plugin_name | |||
| mtm_site_setting | setting_name | |||
| mtm_site_setting | setting_value | |||
| mtm_site_setting | json_encoded | |||
| mtm_site_setting | idsite_setting | |||
| mtm_site_url | idsite | |||
| mtm_site_url | url | |||
| mtm_tracking_failure | idsite | |||
| mtm_tracking_failure | idfailure | |||
| mtm_tracking_failure | date_first_occurred | |||
| mtm_tracking_failure | request_url | |||
| mtm_twofactor_recovery_code | idrecoverycode | |||
| mtm_twofactor_recovery_code | login | |||
| mtm_twofactor_recovery_code | recovery_code | |||
| mtm_user | login | |||
| mtm_user | password | |||
| mtm_user | alias | N/A | N/A | |
| mtm_user | ||||
| mtm_user | twofactor_secret | |||
| mtm_user | token_auth | N/A | N/A | |
| mtm_user | superuser_access | |||
| mtm_user | date_registered | |||
| mtm_user | ts_password_modified | |||
| mtm_user | idchange_last_viewed | N/A | ||
| mtm_user | invited_by | N/A | ||
| mtm_user | invite_token | N/A | ||
| mtm_user | invite_link_token | N/A | ||
| mtm_user | invite_expired_at | N/A | ||
| mtm_user | invite_accept_at | N/A | ||
| mtm_user | ts_changes_shown | N/A | N/A | |
| mtm_user_dashboard | login | |||
| mtm_user_dashboard | iddashboard | |||
| mtm_user_dashboard | name | |||
| mtm_user_dashboard | layout | |||
| mtm_user_language | login | |||
| mtm_user_language | language | |||
| mtm_user_language | use_12_hour_clock | |||
| mtm_user_token_auth | idusertokenauth | N/A | ||
| mtm_user_token_auth | login | N/A | ||
| mtm_user_token_auth | description | N/A | ||
| mtm_user_token_auth | password | N/A | ||
| mtm_user_token_auth | hash_algo | N/A | ||
| mtm_user_token_auth | system_token | N/A | ||
| mtm_user_token_auth | last_used | N/A | ||
| mtm_user_token_auth | date_created | N/A | ||
| mtm_user_token_auth | date_expired | N/A | ||
| mtm_user_token_auth | secure_only | N/A | N/A |