Piwik PRO
Explore the interactive ERD
Table & Field Reference
app_site_query_param
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
query_param | Unknown |
app_site_category_param
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
category_param | Unknown |
app_excluded_url_param
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
excluded_url_param | Unknown |
app_excluded_ip
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
excluded_ip | Unknown |
app_excluded_user_agent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
excluded_user_agent | Unknown |
app_url
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
url | Unknown |
app_privacy_coookie_domain
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
app_id | Unknown | PKFK |
privacy_cookie_domain | Unknown |
app
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
added_at | Unknown | |
app_type | Unknown | |
cnil | Unknown | |
currency | Unknown | |
delay | Unknown | |
e_commerce_tracking | Unknown | |
exclude_unknown_url | Unknown | |
gdpr | Unknown | |
gdpr_data_anonymization | Unknown | |
gdpr_data_anonymization_mode | Unknown | |
gdpr_location_recognition | Unknown | |
gdpr_usermode_enabled | Unknown | |
keep_url_fragment | Unknown | |
name | Unknown | |
organization | Unknown | |
privacy_cookie_domains_enabled | Unknown | |
privacy_cookie_expiration_period | Unknown | |
privacy_use_cookies | Unknown | |
privacy_use_finger_printing | Unknown | |
session_id_strict_privacy_mode | Unknown | |
sharepoint_integration | Unknown | |
site_search_tracking | Unknown | |
timezone | Unknown | |
type | Unknown | |
updated_at | Unknown |
event
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
session_id | Unknown | FK |
website_id | Unknown | FK |
content_name | Unknown | |
content_piece | Unknown | |
content_target | Unknown | |
custom_event_name | Unknown | |
download_url | Unknown | |
event_index | Unknown | |
goal_id | Unknown | |
goal_id_label | Unknown | |
goal_revenue | Unknown | |
goal_uuid_id | Unknown | |
goal_uuid_label | Unknown | |
item_count | Unknown | |
lost_revenue | Unknown | |
next_event_title | Unknown | |
next_event_url | Unknown | |
order_id | Unknown | |
outlink_url | Unknown | |
page_generation_time | Unknown | |
page_view_index | Unknown | |
previous_event_title | Unknown | |
previous_event_url | Unknown | |
revenue | Unknown | |
revenue_discount | Unknown | |
revenue_shipping | Unknown | |
revenue_subtotal | Unknown | |
revenue_tax | Unknown | |
search_category | Unknown | |
search_keyword | Unknown | |
search_results_count | Unknown | |
time_on_page | Unknown | |
timestamps | Unknown | |
title | Unknown | |
type_id | Unknown | |
type_label | Unknown | |
url | Unknown | |
visitor_id | Unknown |
session_location
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PK |
website_id | Unknown | FK |
city_name_id | Unknown | |
city_name_label | Unknown | |
continent_iso_code_id | Unknown | |
continent_iso_code_label | Unknown | |
country_name_id | Unknown | |
country_name_label | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
metro_code_id | Unknown | |
metro_code_label | Unknown | |
organization | Unknown | |
provider | Unknown | |
subdivision_1_name_id | Unknown | |
subdivision_1_name_label | Unknown | |
subdivision_2_name_id | Unknown | |
subdivision_2_name_label | Unknown | |
timestamps | Unknown | |
visitor_id | Unknown |
event_custom_variable
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
session_id | Unknown | FK |
website_id | Unknown | FK |
dimension_1 | Unknown | |
dimension_2 | Unknown | |
dimension_3 | Unknown | |
dimension_4 | Unknown | |
dimension_5 | Unknown | |
key_1 | Unknown | |
key_2 | Unknown | |
key_3 | Unknown | |
key_4 | Unknown | |
key_5 | Unknown | |
timestamps | Unknown | |
value_1 | Unknown | |
value_2 | Unknown | |
value_3 | Unknown | |
value_4 | Unknown | |
value_5 | Unknown | |
visitor_id | Unknown |
session_custom_variables
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PK |
website_id | Unknown | FK |
dimension_1 | Unknown | |
dimension_2 | Unknown | |
dimension_3 | Unknown | |
dimension_4 | Unknown | |
dimension_5 | Unknown | |
key_1 | Unknown | |
key_2 | Unknown | |
key_3 | Unknown | |
key_4 | Unknown | |
key_5 | Unknown | |
timestamps | Unknown | |
value_1 | Unknown | |
value_2 | Unknown | |
value_3 | Unknown | |
value_4 | Unknown | |
value_5 | Unknown | |
visitor_id | Unknown |
session_users
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PK |
website_id | Unknown | FK |
cookie_id | Unknown | |
timestamps | Unknown | |
visitor_days_since_first_session | Unknown | |
visitor_days_since_last_session | Unknown | |
visitor_days_since_order | Unknown | |
visitor_id | Unknown | |
visitor_returning_id | Unknown | |
visitor_returning_label | Unknown | |
visitor_session_number | Unknown | |
website_name_id | Unknown | |
website_name_label | Unknown |
event_consent
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
session_id | Unknown | FK |
website_id | Unknown | FK |
action_id | Unknown | |
action_label | Unknown | |
form_button_id | Unknown | |
form_button_label | Unknown | |
scope_id | Unknown | |
scope_label | Unknown | |
source_id | Unknown | |
source_label | Unknown | |
timestamps | Unknown | |
type_ab_testing_personalization | Unknown | |
type_analytics | Unknown | |
type_conversion_tracking | Unknown | |
type_custom_1 | Unknown | |
type_marketing_automation | Unknown | |
type_remarketing | Unknown | |
type_user_feedback | Unknown | |
visitor_id | Unknown |
session_device_and_platform
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PK |
website_id | Unknown | FK |
browser_engine | Unknown | |
browser_fingerprint | Unknown | |
browser_language_iso_639_id | Unknown | |
browser_language_iso_639_label | Unknown | |
browser_name_id | Unknown | |
browser_name_label | Unknown | |
browser_version | Unknown | |
device_brand_id | Unknown | |
device_brand_label | Unknown | |
device_model | Unknown | |
device_type_id | Unknown | |
device_type_label | Unknown | |
ipv_4_address | Unknown | |
ipv_6_address | Unknown | |
operating_system_id | Unknown | |
operating_system_label | Unknown | |
operating_system_version | Unknown | |
plugin_cookie | Unknown | |
plugin_director | Unknown | |
plugin_flash | Unknown | |
plugin_gear | Unknown | |
plugin_java | Unknown | |
plugin_pdf | Unknown | |
plugin_quicktime | Unknown | |
plugin_realplayer | Unknown | |
plugin_silverlight | Unknown | |
plugin_windowsmedia | Unknown | |
resolution | Unknown | |
resolution_height | Unknown | |
resolution_width | Unknown | |
timestamps | Unknown | |
visitor_id | Unknown |
session_traffic
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PK |
website_id | Unknown | FK |
campaign_content | Unknown | |
campaign_id | Unknown | |
campaign_name | Unknown | |
keyword | Unknown | |
medium | Unknown | |
referrer_type_id | Unknown | |
referrer_type_label | Unknown | |
referrer_url | Unknown | |
source | Unknown | |
source_medium | Unknown | |
timestamps | Unknown | |
visitor_id | Unknown |
event_website_performance
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
session_id | Unknown | FK |
website_id | Unknown | FK |
domain_lookup_time | Unknown | |
is_entry | Unknown | |
is_exit | Unknown | |
page_rendering_time | Unknown | |
redirections_time | Unknown | |
server_connection_time | Unknown | |
server_response_time | Unknown | |
timestamps | Unknown | |
timing_dom_interactive | Unknown | |
timing_event_end | Unknown | |
visitor_id | Unknown |
session_goal
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
session_id | Unknown | PKFK |
session_goals | Unknown |
session_goal_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
session_id | Unknown | PKFK |
session_goal_id | Unknown |
session
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PK |
website_id | Unknown | FK |
campaign_gclid | Unknown | |
ecommerce_status_id | Unknown | |
ecommerce_status_label | Unknown | |
entry_title | Unknown | |
entry_url | Unknown | |
exit_title | Unknown | |
exit_url | Unknown | |
is_bounce | Unknown | |
local_hour | Unknown | |
second_title | Unknown | |
second_url | Unknown | |
timestamps | Unknown | |
total_abandoned_cart | Unknown | |
total_cart_addition | Unknown | |
total_cart_removal | Unknown | |
total_content_impression | Unknown | |
total_content_interaction | Unknown | |
total_custom_event | Unknown | |
total_download | Unknown | |
total_ecommerce_conversion | Unknown | |
total_event | Unknown | |
total_goal_conversion | Unknown | |
total_outlink | Unknown | |
total_page_view | Unknown | |
total_product_detail_view | Unknown | |
total_site_search | Unknown | |
total_time | Unknown | |
unique_content_impression | Unknown | |
unique_content_interaction | Unknown | |
unique_custom_event | Unknown | |
unique_download | Unknown | |
unique_outlink | Unknown | |
unique_page_view | Unknown | |
unique_searche | Unknown | |
user_id | Unknown | |
visitor_id | Unknown |
product_name
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_name | Unknown |
product_sku
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_sku | Unknown |
product_brand
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_sku | Unknown |
product_price
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_price | Unknown |
product_quantity
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_quantity | Unknown |
product_revenue
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_revenue | Unknown |
product_variant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_variant | Unknown |
product_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_category | Unknown |
product_category_1
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_category_1 | Unknown |
product_category_2
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_category_2 | Unknown |
product_category_3
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_category_3 | Unknown |
product_category_4
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_category_4 | Unknown |
product_category_5
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_category_5 | Unknown |
product_dimension_1
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_1 | Unknown |
product_dimension_2
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_2 | Unknown |
product_dimension_3
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_3 | Unknown |
product_dimension_4
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_4 | Unknown |
product_dimension_5
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_5 | Unknown |
product_dimension_6
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_6 | Unknown |
product_dimension_7
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_7 | Unknown |
product_dimension_8
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_8 | Unknown |
product_dimension_9
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_9 | Unknown |
product_dimension_10
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_10 | Unknown |
product_dimension_11
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_11 | Unknown |
product_dimension_12
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_12 | Unknown |
product_dimension_13
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_13 | Unknown |
product_dimension_14
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_14 | Unknown |
product_dimension_15
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_15 | Unknown |
product_dimension_16
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_16 | Unknown |
product_dimension_17
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_17 | Unknown |
product_dimension_18
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_18 | Unknown |
product_dimension_19
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_19 | Unknown |
product_dimension_20
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
product_dimension_20 | Unknown |
event_product
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
session_id | Unknown | FK |
website_id | Unknown | FK |
product_count | Unknown | |
timestamps | Unknown | |
visitor_id | Unknown |
event_custom_events
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
session_id | Unknown | FK |
website_id | Unknown | FK |
action | Unknown | |
category | Unknown | |
name | Unknown | |
timestamps | Unknown | |
value | Unknown | |
visitor_id | Unknown |