# Matomo schema ERD

Table and field reference for the Fivetran Matomo connector.

## 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 |  |

## Relationships

- event_category(id_site) → multi_site(id)
- event_name(id_site) → multi_site(id)
- event_action(id_site) → multi_site(id)
- insight_overview(multi_site_id) → multi_site(id)
- visit_time(multi_site_id) → multi_site(id)
- visitor_interest(multi_site_id) → multi_site(id)