Matomo data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: VISITOR_COUNTRY

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
visitor_locations__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
visitor_locations__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
visitor_locations__conversions
Display name Conversions
Description Number of goal conversions
Field type metric
Data type int.number.value
visitor_locations__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
visitor_locations__country
Display name Country
Description Country where the visits originate from
Field type dimension
Data type string.geo.country
visitor_locations__date
Display name Date
Field type dimension
Data type string.time.date
visitor_locations__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
visitor_locations__revenue
Display name Revenue
Description Total revenue of goal conversions
Field type metric
Data type float.currency.value
visitor_locations__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
visitor_locations__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
visitor_locations__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
visitor_locations__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
visitor_locations__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: VISITOR_LANGUAGE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
visitor_language__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
visitor_language__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
visitor_language__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
visitor_language__date
Display name Date
Field type dimension
Data type string.time.date
visitor_language__language
Display name Web-browser language
Description Language of the web-browser
Field type dimension
Data type string.text.value
visitor_language__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
visitor_language__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
visitor_language__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
visitor_language__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
visitor_language__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
visitor_language__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: VISITOR_DEVICE_TYPE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
visitor_devices__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
visitor_devices__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
visitor_devices__conversions
Display name Conversions
Description Number of goal conversions
Field type metric
Data type int.number.value
visitor_devices__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
visitor_devices__date
Display name Date
Field type dimension
Data type string.time.date
visitor_devices__device_type
Display name Device type
Description Type of the device
Field type dimension
Data type string.text.value
visitor_devices__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
visitor_devices__revenue
Display name Revenue
Description Total revenue of goal conversions
Field type metric
Data type float.currency.value
visitor_devices__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
visitor_devices__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
visitor_devices__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
visitor_devices__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
visitor_devices__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: BEHAVIOUR_PAGE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
pages__date
Display name Date
Field type dimension
Data type string.time.date
pages__entrances
Display name Entrances
Description Number of visits that started on this page
Field type metric
Data type int.number.value
pages__entry_actions
Display name Entry actions
Description Number of page views for visits that started on this page
Field type metric
Data type int.number.value
pages__entry_bounces
Display name Entry bounces
Description Number of visits that started on this page, and bounced (viewed only one page)
Field type metric
Data type int.number.value
pages__entry_visit_length
Display name Entry visit length (sec)
Description Time spent (in seconds) by visits that started on this page
Field type metric
Data type int.duration.seconds
pages__exits
Display name Exits
Description Number of visits that ended on this page
Field type metric
Data type int.number.value
pages__page_title
Display name Page
Description Path of the page. Corresponds to the Page URL field in the Matomo user interface
Field type dimension
Data type string.text.value
pages__page_url
Display name Page URL
Description Full URL of the page. Does not return data for pages grouped by Matomo under the Other category
Field type dimension
Data type string.text.url
pages__pageviews
Display name Pageviews
Description The number of times this page was visited
Field type metric
Data type int.number.value
pages__total_time_spent
Display name Total time spent (sec)
Description Total time (in seconds) spent on this page
Field type metric
Data type int.duration.seconds
pages__visits_following_search
Display name Visits following search
Description The number of times this page was visited after a visitor did a search on your website, and clicked on this page in the search results
Field type metric
Data type int.number.value
pages__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
pages__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: ACQUISITION_CHANNEL_TYPE

channels__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
channels__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
channels__channel_type
Display name Channel type
Description Type of the channel
Field type dimension
Data type string.text.value
channels__conversions
Display name Conversions
Description Number of goal conversions
Field type metric
Data type int.number.value
channels__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
channels__date
Display name Date
Field type dimension
Data type string.time.date
channels__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
channels__revenue
Display name Revenue
Description Total revenue of goal conversions
Field type metric
Data type float.currency.value
channels__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
channels__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
channels__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
channels__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
channels__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value

Table: ACQUISITION_REFERRER

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
referrers__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
referrers__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
referrers__conversions
Display name Conversions
Description Number of goal conversions
Field type metric
Data type int.number.value
referrers__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
referrers__date
Display name Date
Field type dimension
Data type string.time.date
referrers__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
referrers__referrer
Display name Referrer
Description Name of the referrer
Field type dimension
Data type string.text.value
referrers__referrer_type__referrer_type
Display name Referrer type
Description Type of the referrer
Field type dimension
Data type string.text.value
referrers__referrer_url
Display name Referrer URL
Description A link to the referrer
Field type dimension
Data type string.text.url
referrers__revenue
Display name Revenue
Description Total revenue of goal conversions
Field type metric
Data type float.currency.value
referrers__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
referrers__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
referrers__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
referrers__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
referrers__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: ACQUISITION_CAMPAIGN

campaigns__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
campaigns__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
campaigns__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaigns__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
campaigns__date
Display name Date
Field type dimension
Data type string.time.date
campaigns__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
campaigns__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
campaigns__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
campaigns__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
campaigns__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
campaigns__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value

Table: ACQUISITION_CAMPAIGN_KEYWORD

campaign_keywords__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_keywords__date
Display name Date
Field type dimension
Data type string.time.date
campaign_keywords__keywords_per_campaign__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
campaign_keywords__keywords_per_campaign__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
campaign_keywords__keywords_per_campaign__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
campaign_keywords__keywords_per_campaign__keyword
Display name Keyword
Description Name of the keyword
Field type dimension
Data type string.text.value
campaign_keywords__keywords_per_campaign__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
campaign_keywords__keywords_per_campaign__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
campaign_keywords__keywords_per_campaign__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
campaign_keywords__keywords_per_campaign__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
campaign_keywords__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
campaign_keywords__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value

Table: ACQUISITION_SEARCH_ENGINE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
search_engines__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
search_engines__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
search_engines__conversions
Display name Conversions
Description Number of goal conversions
Field type metric
Data type int.number.value
search_engines__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
search_engines__date
Display name Date
Field type dimension
Data type string.time.date
search_engines__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
search_engines__revenue
Display name Revenue
Description Total revenue of goal conversions
Field type metric
Data type float.currency.value
search_engines__search_engine
Display name Search engine
Description The name of the search engine
Field type dimension
Data type string.text.value
search_engines__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
search_engines__url
Display name Search engine URL
Description A link to the search engine
Field type dimension
Data type string.text.url
search_engines__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
search_engines__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
search_engines__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
search_engines__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: ACQUISITION_SEARCH_KEYWORD

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
search_keywords__date
Display name Date
Field type dimension
Data type string.time.date
search_keywords__keywords_per_search_engine__actions
Display name Actions
Description Number of actions (page views, outlinks and downloads)
Field type metric
Data type int.number.value
search_keywords__keywords_per_search_engine__bounces
Display name Bounces
Description Number of visits that bounced (viewed only one page)
Field type metric
Data type int.number.value
search_keywords__keywords_per_search_engine__converted_visits
Display name Converted visits
Description Number of visits that converted a goal
Field type metric
Data type int.number.value
search_keywords__keywords_per_search_engine__keyword
Display name Keyword
Description Name of the keyword
Field type dimension
Data type string.text.value
search_keywords__keywords_per_search_engine__keyword_url
Display name Keyword URL
Description A link to the keyword
Field type dimension
Data type string.text.url
search_keywords__keywords_per_search_engine__max_actions
Display name Max actions
Description Maximum number of actions in a visit
Field type metric
Data type int.number.value
search_keywords__keywords_per_search_engine__total_visit_length
Display name Total visit length (sec)
Description Total time spent (in seconds) on a website
Field type metric
Data type int.duration.seconds
search_keywords__keywords_per_search_engine__users
Display name Users
Description Number of unique active users (visitors with known user ID)
Field type metric
Data type int.number.value
search_keywords__keywords_per_search_engine__visits
Display name Visits
Description Number of visits (30 min of inactivity considered a new visit)
Field type metric
Data type int.number.value
search_keywords__search_engine
Display name Search engine
Description The name of the search engine
Field type dimension
Data type string.text.value
search_keywords__url
Display name Search engine URL
Description A link to the search engine
Field type dimension
Data type string.text.url
search_keywords__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
search_keywords__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value

Table: GOAL_OVERVIEW

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
goal_overview__allow_multiple
Display name Allow multiple
Description Whether this goal can be completed multiple times during a single visit to the website
Field type dimension
Data type bool
goal_overview__case_sensitive
Display name Case sensitive
Description Whether the pattern matching should be case sensitive or not
Field type dimension
Data type bool
goal_overview__date
Display name Date
Field type dimension
Data type string.time.date
goal_overview__deleted
Display name Deleted
Description Whether this goal has been marked as deleted
Field type dimension
Data type bool
goal_overview__description
Display name Description
Description A brief description of the goal, for informational purposes
Field type dimension
Data type string.text.value
goal_overview__goal__nb_conversions
Display name Conversions
Description The total number of conversions on the website, where a conversion is typically defined as a user completing a desired action, such as making a purchase or filling out a form
Field type metric
Data type int.number.value
goal_overview__goal__nb_conversions_new_visit
Display name Conversions (new visit)
Description The number of conversions that occurred during a user's first visit to the website
Field type metric
Data type int.number.value
goal_overview__goal__nb_conversions_returning_visit
Display name Conversions (returning visit)
Description The number of conversions that occurred during a user's return visit to the website
Field type metric
Data type int.number.value
goal_overview__goal__nb_visits_converted
Display name Visits converted
Description The number of visits to the website that resulted in a conversion
Field type metric
Data type int.number.value
goal_overview__goal__nb_visits_converted_new_visit
Display name Visits converted (new visit)
Description The number of visits to the website that resulted in a conversion, where the visit was the user's first visit
Field type metric
Data type int.number.value
goal_overview__goal__nb_visits_converted_returning_visit
Display name Visits converted (returning visit)
Description The number of visits to the website that resulted in a conversion, where the visit was a return visit
Field type metric
Data type int.number.value
goal_overview__goal__revenue
Display name Revenue
Description The total revenue generated by the website, typically calculated by summing the value of all conversions
Field type metric
Data type float.currency.value
goal_overview__goal__revenue_new_visit
Display name Revenue (new visit)
Description The total revenue generated by first-time visitors to the website
Field type metric
Data type float.currency.value
goal_overview__goal__revenue_returning_visit
Display name Revenue (returning visit)
Description The total revenue generated by returning visitors to the website
Field type metric
Data type float.currency.value
goal_overview__goal_id
Display name Goal ID
Description The unique identifier of this goal
Field type dimension
Data type string.text.value
goal_overview__goal_name
Display name Goal name
Description The name or title of this goal
Field type dimension
Data type string.text.value
goal_overview__match_attribute
Display name Match attribute
Description The type of match that should be used to determine if a goal has been completed. This could be a URL, a page title, or some other attribute
Field type dimension
Data type string.text.value
goal_overview__pattern
Display name Pattern
Description The pattern to match against the specified match_attribute
Field type dimension
Data type string.text.value
goal_overview__pattern_type
Display name Pattern type
Description The type of pattern matching to use, such as a regular expression or a simple string match
Field type dimension
Data type string.text.value
goal_overview__website_id
Display name Website ID
Description ID of the website
Field type dimension
Data type string.text.value
goal_overview__website_name
Display name Website name
Description The name of the website
Field type dimension
Data type string.text.value