Fivetran documentation

Search the docs

/

Matomo

Explore the interactive ERD

Table & Field Reference

event_category

Column	Type	Keys
`_fivetran_id`	String	PK
`id_site`	Unknown	FK
`avg_event_value`	Unknown
`date`	Unknown
`id_sub_datatable`	Unknown
`label`	Unknown
`max_event_value`	Unknown
`min_event_value`	Unknown
`nb_events`	Unknown
`nb_events_with_value`	Unknown
`nb_visits`	Unknown
`segment`	Unknown
`sum_daily_nb_uniq_visitors`	Unknown
`sum_event_value`	Unknown

event_name

Column	Type	Keys
`_fivetran_id`	String	PK
`id_site`	Unknown	FK
`avg_event_value`	Unknown
`date`	Unknown
`id_subdata_table`	Unknown
`label`	Unknown
`max_event_value`	Unknown
`nb_events`	Unknown
`nb_events_with_value`	Unknown
`nb_visits`	Unknown
`segment`	Unknown
`sum_daily_nb_uniq_visitors`	Unknown
`sum_event_value`	Unknown

multi_site

Column	Type	Keys
`id`	Unknown	PK
`actions_evolution`	Unknown
`actions_evolution_trend`	Unknown
`currency_symbol`	Unknown
`groups`	Unknown
`label`	Unknown
`main_url`	Unknown
`nb_actions`	Unknown
`nb_page_views`	Unknown
`nb_visits`	Unknown
`page_views_evolution`	Unknown
`page_views_evolution_trend`	Unknown
`period_name`	Unknown
`previous_actions_nb_page_views`	Unknown
`previous_goal_revenue`	Unknown
`previous_nb_actions`	Unknown
`previous_nb_visits`	Unknown
`previous_range`	Unknown
`ratio`	Unknown
`revenue`	Unknown
`revenue_evolution`	Unknown
`revenue_evolution_trend`	Unknown
`visits_evolution`	Unknown
`visits_evolution_trend`	Unknown

event_action

Column	Type	Keys
`_fivetran_id`	String	PK
`id_site`	Unknown	FK
`avg_event_value`	Unknown
`date`	Unknown
`id_sub_datatable`	Unknown
`label`	Unknown
`max_event_value`	Unknown
`min_event_value`	Unknown
`nb_events`	Unknown
`nb_events_with_value`	Unknown
`nb_visits`	Unknown
`segment`	Unknown
`sum_daily_nb_uniq_visitors`	Unknown
`sum_event_value`	Unknown

insight_overview

Column	Type	Keys
`_fivetran_id`	String	PK
`multi_site_id`	Unknown	FK
`date`	Unknown
`difference`	Unknown
`grown`	Unknown
`growth_percent`	Unknown
`growth_percent_numeric`	Unknown
`importance`	Unknown
`is_disappeared`	Unknown
`is_mover`	Unknown
`is_mover_and_shaker`	Unknown
`is_new`	Unknown
`label`	Unknown
`nb_visits`	Unknown
`type`	Unknown
`value_new`	Unknown
`value_old`	Unknown

visit_time

Column	Type	Keys
`_fivetran_id`	String	PK
`multi_site_id`	Unknown	FK
`bounce_count`	Unknown
`date`	Unknown
`day_of_week`	Unknown
`label`	Unknown
`nb_actions`	Unknown
`nb_uniq_visitors`	Unknown
`nb_users`	Unknown
`nb_visits`	Unknown
`nb_visits_converted`	Unknown
`sum_visit_length`	Unknown

visitor_interest

Column	Type	Keys
`_fivetran_id`	String	PK
`multi_site_id`	Unknown	FK
`date`	Unknown
`label`	Unknown
`nb_visits`	Unknown
`segment`	Unknown