Piwik PRO data warehouse table groups

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

Table: AUDIENCE

analytics__account
Display name Account name
Field type dimension
Data type string.text.value
analytics__account_id
Display name Account ID
Field type dimension
Data type string.text.value
analytics__bounces
Display name Bounces
Description The number of sessions during which visitors viewed an entry page but didn't continue to another page view, goal conversion, or ecommerce conversion
Field type metric
Data type int.number.value
analytics__browser_name
Display name Browser name
Description The name of the visitor's browser
Field type dimension
Data type string.text.value
analytics__content_impressions
Display name Content impressions
Description The number of times a content block was displayed to visitors
Field type metric
Data type int.number.value
analytics__content_interactions
Display name Content interactions
Description Content interactions
Field type metric
Data type int.number.value
analytics__custom_events
Display name Custom events
Description The number of tracked custom events
Field type metric
Data type int.number.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__device_brand
Display name Device brand
Description The brand of the visitor's device
Field type dimension
Data type string.text.value
analytics__device_model
Display name Device model
Description The model of visitor's device
Field type dimension
Data type string.text.value
analytics__device_type
Display name Device type
Description The type of the visitor's device
Field type dimension
Data type string.text.value
analytics__downloads
Display name Downloads
Description The number of clicks on links to downloadable files
Field type metric
Data type int.number.value
analytics__ecommerce_abandoned_carts
Display name Ecommerce abandoned carts
Description The number of abandoned carts
Field type metric
Data type int.number.value
analytics__ecommerce_conversions
Display name Ecommerce conversions
Description The number of purchases
Field type metric
Data type int.number.value
analytics__entries
Display name Entries
Description The number of page views for a page that was the first during a session
Field type metric
Data type int.number.value
analytics__events
Display name Events
Description The number of events performed by visitors, such as a page view, download, outlinks, searches custom events, and goals
Field type metric
Data type int.number.value
analytics__exits
Display name Exits
Description The number of page views for a page that was the last during a session
Field type metric
Data type int.number.value
analytics__goal_conversions
Display name Goal conversions
Description The total number of completed goals, repeated goals included
Field type metric
Data type int.number.value
analytics__goal_revenue
Display name Goal revenue
Description The revenue counted for the goal. It works only with these metrics: goal conversions, goal conversion rate
Field type metric
Data type float.currency.value
analytics__location_city_name
Display name City
Description The city from which a visitor entered your website
Field type dimension
Data type string.geo.city
analytics__location_continent_iso_code
Display name Continent
Description The continent from which a visitor entered your website
Field type dimension
Data type string.geo.continent
analytics__location_country_name
Display name Country
Description The country from which a visitor entered your website
Field type dimension
Data type string.geo.country
analytics__lost_revenue
Display name Lost revenue
Description The revenue lost due to abandoned carts. It works only with these metrics: abandoned carts
Field type metric
Data type float.currency.value
analytics__operating_system
Display name Operating system
Description The name of the visitor's operating system
Field type dimension
Data type string.text.value
analytics__page_views
Display name Page views
Description The number of times a page was visited
Field type metric
Data type int.number.value
analytics__revenue
Display name Revenue
Description The grand total value of the order, including tax, shipping and subtracted discounts
Field type metric
Data type float.currency.value
analytics__revenue_discount
Display name Revenue (Discount)
Description The discount value of the order
Field type metric
Data type float.currency.value
analytics__revenue_shipping
Display name Revenue (Shipping)
Description The shipment value for the order
Field type metric
Data type float.currency.value
analytics__revenue_subtotal
Display name Revenue (Subtotal)
Description The subtotal value of the order
Field type metric
Data type float.currency.value
analytics__revenue_tax
Display name Revenue (Tax)
Description The tax value of the order
Field type metric
Data type float.currency.value
analytics__searches
Display name Searches
Description The number of searches on your website
Field type metric
Data type int.number.value
analytics__sessions
Display name Sessions
Description The number of sessions performed by visitors. A session starts with the first event and ends 30 minutes after the last event (after the session is over)
Field type metric
Data type int.number.value
analytics__total_quantity
Display name Total quantity
Description The sum of all item quantities added to the cart
Field type metric
Data type int.number.value
analytics__total_time_on_page
Display name Total time on page
Description The amount of time the visitor spent on the page
Field type metric
Data type int.number.value
analytics__unique_content_impressions
Display name Unique content impressions
Description The number of times a content block was uniquely displayed to visitors. Each unique combination of a content name, piece, and target is counted once per session
Field type metric
Data type int.number.value
analytics__unique_content_interactions
Display name Unique content interactions
Description The number of times visitors uniquely interacted with a content block, for example, clicked an element in a content block. Each unique combination of content name, piece, and target is counted once per session
Field type metric
Data type int.number.value
analytics__unique_custom_events
Display name Unique custom events
Description The number of tracked unique custom events. Each unique combination of an event category, action, and name is counted once per session
Field type metric
Data type int.number.value
analytics__unique_downloads
Display name Unique downloads
Description The number of unique clicks on links to downloadable files. When a visitor clicks the same link many times during a session, it will be counted only once
Field type metric
Data type int.number.value
analytics__unique_goal_conversions
Display name Unique goal conversions
Description The number of uniquely completed goals. Repeated goals are counted only once per session
Field type metric
Data type int.number.value
analytics__unique_page_views
Display name Unique page views
Description The number of times a page was uniquely visited. If a visitor views a page several times during one session, it will be counted only once
Field type metric
Data type int.number.value
analytics__unique_purchases
Display name Unique purchases
Description Unique purchases
Field type metric
Data type int.number.value
analytics__unique_searches
Display name Unique searches
Description The number of unique searches on your website. Each unique combination of a search keyword and category is counted once per session
Field type metric
Data type int.number.value
analytics__users
Display name Users
Description The number of visitors with the User ID
Field type metric
Data type int.number.value
analytics__visitor_returning
Display name Returning visitor
Description A new or returning visitor
Field type dimension
Data type string.text.value
analytics__visitors
Display name Visitors
Description The number of unique visitors. Every visitor is counted once, even if they visit the website many times during the day
Field type metric
Data type int.number.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

analytics__account
Display name Account name
Field type dimension
Data type string.text.value
analytics__account_id
Display name Account ID
Field type dimension
Data type string.text.value
analytics__bounces
Display name Bounces
Description The number of sessions during which visitors viewed an entry page but didn't continue to another page view, goal conversion, or ecommerce conversion
Field type metric
Data type int.number.value
analytics__campaign_content
Display name Campaign content
Description The content of an online campaign taken from utm_content
Field type dimension
Data type string.text.value
analytics__campaign_id
Display name Campaign ID
Description The ID of an online campaign taken from utm_id
Field type dimension
Data type string.text.value
analytics__campaign_name
Display name Campaign name
Description The name of an online campaign taken from utm_campaign
Field type dimension
Data type string.text.value
analytics__content_impressions
Display name Content impressions
Description The number of times a content block was displayed to visitors
Field type metric
Data type int.number.value
analytics__content_interactions
Display name Content interactions
Description Content interactions
Field type metric
Data type int.number.value
analytics__custom_events
Display name Custom events
Description The number of tracked custom events
Field type metric
Data type int.number.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__downloads
Display name Downloads
Description The number of clicks on links to downloadable files
Field type metric
Data type int.number.value
analytics__ecommerce_abandoned_carts
Display name Ecommerce abandoned carts
Description The number of abandoned carts
Field type metric
Data type int.number.value
analytics__ecommerce_conversions
Display name Ecommerce conversions
Description The number of purchases
Field type metric
Data type int.number.value
analytics__entries
Display name Entries
Description The number of page views for a page that was the first during a session
Field type metric
Data type int.number.value
analytics__events
Display name Events
Description The number of events performed by visitors, such as a page view, download, outlinks, searches custom events, and goals
Field type metric
Data type int.number.value
analytics__exits
Display name Exits
Description The number of page views for a page that was the last during a session
Field type metric
Data type int.number.value
analytics__goal_conversions
Display name Goal conversions
Description The total number of completed goals, repeated goals included
Field type metric
Data type int.number.value
analytics__goal_revenue
Display name Goal revenue
Description The revenue counted for the goal. It works only with these metrics: goal conversions, goal conversion rate
Field type metric
Data type float.currency.value
analytics__keyword
Display name Keyword
Description The keyword that a visitor used in a search engine or a keyword added as a campaign parameter
Field type dimension
Data type string.text.value
analytics__lost_revenue
Display name Lost revenue
Description The revenue lost due to abandoned carts. It works only with these metrics: abandoned carts
Field type metric
Data type float.currency.value
analytics__page_views
Display name Page views
Description The number of times a page was visited
Field type metric
Data type int.number.value
analytics__referrer_type
Display name Channel
Description Channel
Field type dimension
Data type string.text.value
analytics__referrer_url
Display name Referrer URL
Description The URL of the page that referred a visitor to your website
Field type dimension
Data type string.text.url
analytics__revenue
Display name Revenue
Description The grand total value of the order, including tax, shipping and subtracted discounts
Field type metric
Data type float.currency.value
analytics__revenue_discount
Display name Revenue (Discount)
Description The discount value of the order
Field type metric
Data type float.currency.value
analytics__revenue_shipping
Display name Revenue (Shipping)
Description The shipment value for the order
Field type metric
Data type float.currency.value
analytics__revenue_subtotal
Display name Revenue (Subtotal)
Description The subtotal value of the order
Field type metric
Data type float.currency.value
analytics__revenue_tax
Display name Revenue (Tax)
Description The tax value of the order
Field type metric
Data type float.currency.value
analytics__searches
Display name Searches
Description The number of searches on your website
Field type metric
Data type int.number.value
analytics__session_entry_title
Display name Session entry title
Description The title of the first visited page during a session
Field type dimension
Data type string.text.value
analytics__session_entry_url
Display name Session entry URL
Description The URL of the first visited page during a session
Field type dimension
Data type string.text.url
analytics__sessions
Display name Sessions
Description The number of sessions performed by visitors. A session starts with the first event and ends 30 minutes after the last event (after the session is over)
Field type metric
Data type int.number.value
analytics__source_medium
Display name Source/Medium
Description Source/Medium
Field type dimension
Data type string.text.value
analytics__total_quantity
Display name Total quantity
Description The sum of all item quantities added to the cart
Field type metric
Data type int.number.value
analytics__total_time_on_page
Display name Total time on page
Description The amount of time the visitor spent on the page
Field type metric
Data type int.number.value
analytics__unique_content_impressions
Display name Unique content impressions
Description The number of times a content block was uniquely displayed to visitors. Each unique combination of a content name, piece, and target is counted once per session
Field type metric
Data type int.number.value
analytics__unique_content_interactions
Display name Unique content interactions
Description The number of times visitors uniquely interacted with a content block, for example, clicked an element in a content block. Each unique combination of content name, piece, and target is counted once per session
Field type metric
Data type int.number.value
analytics__unique_custom_events
Display name Unique custom events
Description The number of tracked unique custom events. Each unique combination of an event category, action, and name is counted once per session
Field type metric
Data type int.number.value
analytics__unique_downloads
Display name Unique downloads
Description The number of unique clicks on links to downloadable files. When a visitor clicks the same link many times during a session, it will be counted only once
Field type metric
Data type int.number.value
analytics__unique_goal_conversions
Display name Unique goal conversions
Description The number of uniquely completed goals. Repeated goals are counted only once per session
Field type metric
Data type int.number.value
analytics__unique_page_views
Display name Unique page views
Description The number of times a page was uniquely visited. If a visitor views a page several times during one session, it will be counted only once
Field type metric
Data type int.number.value
analytics__unique_purchases
Display name Unique purchases
Description Unique purchases
Field type metric
Data type int.number.value
analytics__unique_searches
Display name Unique searches
Description The number of unique searches on your website. Each unique combination of a search keyword and category is counted once per session
Field type metric
Data type int.number.value
analytics__users
Display name Users
Description The number of visitors with the User ID
Field type metric
Data type int.number.value
analytics__visitors
Display name Visitors
Description The number of unique visitors. Every visitor is counted once, even if they visit the website many times during the day
Field type metric
Data type int.number.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: BEHAVIOR

analytics__account
Display name Account name
Field type dimension
Data type string.text.value
analytics__account_id
Display name Account ID
Field type dimension
Data type string.text.value
analytics__content_impressions
Display name Content impressions
Description The number of times a content block was displayed to visitors
Field type metric
Data type int.number.value
analytics__content_interactions
Display name Content interactions
Description Content interactions
Field type metric
Data type int.number.value
analytics__content_name
Display name Content name
Description The name of the tracked content block. It works only with these metrics: content impressions, unique content impressions, content interactions, unique content interactions, content interaction rate
Field type dimension
Data type string.text.value
analytics__content_piece
Display name Content piece
Description The piece of the tracked content block. It works only with these metrics: content impressions, unique content impressions, content interactions, unique content interactions, content interaction rate
Field type dimension
Data type string.text.value
analytics__content_target
Display name Content target
Description The target of the tracked content block. It works only with these metrics: content impressions, unique content impressions, content interactions, unique content interactions, content interaction rate
Field type dimension
Data type string.text.value
analytics__custom_event_action
Display name Custom event action
Description The action of the custom event. It works only with these metrics: custom events, unique custom events
Field type dimension
Data type string.text.value
analytics__custom_event_category
Display name Custom event category
Description The category of the custom event. It works only with these metrics: custom events, unique custom events
Field type dimension
Data type string.text.value
analytics__custom_event_name
Display name Custom event name
Description The name of the custom event. It works only with these metrics: custom events, unique custom events
Field type dimension
Data type string.text.value
analytics__custom_events
Display name Custom events
Description The number of tracked custom events
Field type metric
Data type int.number.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__download_url
Display name Download URL
Description The URL of the downloadable file clicked by the visitor. It works only with these metrics: downloads, unique downloads
Field type dimension
Data type string.text.url
analytics__downloads
Display name Downloads
Description The number of clicks on links to downloadable files
Field type metric
Data type int.number.value
analytics__ecommerce_abandoned_carts
Display name Ecommerce abandoned carts
Description The number of abandoned carts
Field type metric
Data type int.number.value
analytics__ecommerce_conversions
Display name Ecommerce conversions
Description The number of purchases
Field type metric
Data type int.number.value
analytics__entries
Display name Entries
Description The number of page views for a page that was the first during a session
Field type metric
Data type int.number.value
analytics__event_title
Display name Page title
Description The title of the page on which the event took place
Field type dimension
Data type string.text.value
analytics__event_url
Display name Page URL
Description The URL of the page on which an event took place
Field type dimension
Data type string.text.url
analytics__events
Display name Events
Description The number of events performed by visitors, such as a page view, download, outlinks, searches custom events, and goals
Field type metric
Data type int.number.value
analytics__exits
Display name Exits
Description The number of page views for a page that was the last during a session
Field type metric
Data type int.number.value
analytics__goal_conversions
Display name Goal conversions
Description The total number of completed goals, repeated goals included
Field type metric
Data type int.number.value
analytics__goal_revenue
Display name Goal revenue
Description The revenue counted for the goal. It works only with these metrics: goal conversions, goal conversion rate
Field type metric
Data type float.currency.value
analytics__goal_uuid
Display name Goal name
Description Goal name
Field type dimension
Data type string.text.value
analytics__goal_uuid_id
Display name Goal name (uuid)
Description Goal name (uuid)
Field type dimension
Data type string.text.value
analytics__lost_revenue
Display name Lost revenue
Description The revenue lost due to abandoned carts. It works only with these metrics: abandoned carts
Field type metric
Data type float.currency.value
analytics__next_event_title
Display name Next page view title
Description The title of the page that was viewed next
Field type dimension
Data type string.text.value
analytics__next_event_url
Display name Next page view URL
Description The URL of the page that was viewed next
Field type dimension
Data type string.text.url
analytics__page_views
Display name Page views
Description The number of times a page was visited
Field type metric
Data type int.number.value
analytics__previous_event_title
Display name Previous page view title
Description The title of the page that was viewed previously
Field type dimension
Data type string.text.value
analytics__previous_event_url
Display name Previous page view URL
Description The URL of the page that was viewed previously
Field type dimension
Data type string.text.url
analytics__revenue
Display name Revenue
Description The grand total value of the order, including tax, shipping and subtracted discounts
Field type metric
Data type float.currency.value
analytics__revenue_discount
Display name Revenue (Discount)
Description The discount value of the order
Field type metric
Data type float.currency.value
analytics__revenue_shipping
Display name Revenue (Shipping)
Description The shipment value for the order
Field type metric
Data type float.currency.value
analytics__revenue_subtotal
Display name Revenue (Subtotal)
Description The subtotal value of the order
Field type metric
Data type float.currency.value
analytics__revenue_tax
Display name Revenue (Tax)
Description The tax value of the order
Field type metric
Data type float.currency.value
analytics__search_category
Display name Search category
Description The category of the keyword used in the search engine on your website. It works only with these metrics: searches, unique searches
Field type dimension
Data type string.text.value
analytics__search_keyword
Display name Search keyword
Description The keyword used in the search engine on your website. It works only with these metrics: searches, unique searches
Field type dimension
Data type string.text.value
analytics__searches
Display name Searches
Description The number of searches on your website
Field type metric
Data type int.number.value
analytics__session_entry_title
Display name Session entry title
Description The title of the first visited page during a session
Field type dimension
Data type string.text.value
analytics__session_entry_url
Display name Session entry URL
Description The URL of the first visited page during a session
Field type dimension
Data type string.text.url
analytics__total_custom_event_value
Display name Total custom event value
Description The value of the custom event. It works only with these metrics: custom events, unique custom events
Field type metric
Data type float.number.value
analytics__total_quantity
Display name Total quantity
Description The sum of all item quantities added to the cart
Field type metric
Data type int.number.value
analytics__total_time_on_page
Display name Total time on page
Description The amount of time the visitor spent on the page
Field type metric
Data type int.number.value
analytics__unique_content_impressions
Display name Unique content impressions
Description The number of times a content block was uniquely displayed to visitors. Each unique combination of a content name, piece, and target is counted once per session
Field type metric
Data type int.number.value
analytics__unique_content_interactions
Display name Unique content interactions
Description The number of times visitors uniquely interacted with a content block, for example, clicked an element in a content block. Each unique combination of content name, piece, and target is counted once per session
Field type metric
Data type int.number.value
analytics__unique_custom_events
Display name Unique custom events
Description The number of tracked unique custom events. Each unique combination of an event category, action, and name is counted once per session
Field type metric
Data type int.number.value
analytics__unique_downloads
Display name Unique downloads
Description The number of unique clicks on links to downloadable files. When a visitor clicks the same link many times during a session, it will be counted only once
Field type metric
Data type int.number.value
analytics__unique_goal_conversions
Display name Unique goal conversions
Description The number of uniquely completed goals. Repeated goals are counted only once per session
Field type metric
Data type int.number.value
analytics__unique_page_views
Display name Unique page views
Description The number of times a page was uniquely visited. If a visitor views a page several times during one session, it will be counted only once
Field type metric
Data type int.number.value
analytics__unique_purchases
Display name Unique purchases
Description Unique purchases
Field type metric
Data type int.number.value
analytics__unique_searches
Display name Unique searches
Description The number of unique searches on your website. Each unique combination of a search keyword and category is counted once per session
Field type metric
Data type int.number.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