Piano Analytics (AT Internet) data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: OVERALL_TRAFFIC

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
performance__bounces
Display name Bounces
Description Number of visits with less than 2 pages (0 or 1, regardless of the number of events)
Field type metric
Data type int.number.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__events
Display name Events
Description Number of times an event occurred
Field type metric
Data type int.number.value
performance__events_all
Display name Events (all)
Description Number of events counted, including excluded events
Field type metric
Data type int.number.value
performance__page_loads
Display name Page views
Description Number of times a page has been loaded. If the analysed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analysed page)
Field type metric
Data type int.number.value
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value
performance__src_portal_domain
Display name Src portal domain
Description URL (complete) that precedes the measured event, regardless of the type of source. Information within the "Event " range (several possible values per visit)
Field type dimension
Data type string.text.url
performance__src_portal_url
Display name Portal site - URL
Description URL of the site of your organisation (Portal option). Information within "visit" range (only 1 velue per visit, duplicated on all its events). It has value only when the "Source" property contains the value "Portal Sites"
Field type dimension
Data type string.text.url
performance__time_spent
Display name Time spent (minutes)
Description Total time spent on events. This metric is displayed in minutes
Field type metric
Data type float.number.value
performance__transactions
Display name Transactions
Description Number of transaction.confirmation events
Field type metric
Data type int.number.value
performance__transactions_turnover_withtax
Display name Turnover incl. tax (transaction)
Description Turnover (incl. tax) from transactions
Field type metric
Data type float.number.value
performance__unique_visitors
Display name Visitors
Description Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period
Field type metric
Data type int.number.value
performance__users
Display name Users
Description Number of users (identified visitors). These users are quite distinct over the period
Field type metric
Data type int.number.value
performance__visits
Display name Visits
Description A visit is defined as a set of events that occured on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends
Field type metric
Data type int.number.value

Table: TRAFFIC_SOURCES

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
performance__bounces
Display name Bounces
Description Number of visits with less than 2 pages (0 or 1, regardless of the number of events)
Field type metric
Data type int.number.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__events
Display name Events
Description Number of times an event occurred
Field type metric
Data type int.number.value
performance__events_all
Display name Events (all)
Description Number of events counted, including excluded events
Field type metric
Data type int.number.value
performance__page_loads
Display name Page views
Description Number of times a page has been loaded. If the analysed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analysed page)
Field type metric
Data type int.number.value
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value
performance__src
Display name Source
Description Source that generated a visit on your site. This source is based on several parameters (referrer, campaign marker) with priority rules between each of them. Information within "visit" range (only 1 value per visit, duplicated on all its events)
Field type dimension
Data type string.text.value
performance__src_campaign
Display name Campaign - Name
Description All marketing campaigns, all categories combined, that generated a visit on your site. Information within "visit" range (only 1 value per visit, duplicated on all its events). It should have value only when the type of source is "Marketing". To get clicks on campaigns, just filter on event "Campaign offsite click"
Field type dimension
Data type string.text.value
performance__src_detail
Display name Source - Detail
Description Source that gerenated a visit on your site with a finer level of detail than the global source. Information within "visit" range (only 1 value per visit, duplicated on all its events)
Field type dimension
Data type string.text.value
performance__src_type
Display name Campaign / Organic
Description Status to know if the source of the visit is of type "Marketing" (with campaign) or "Organic". Information within "visit" range (only 1 value per visit, duplicated on all its events)
Field type dimension
Data type string.text.value
performance__src_url
Display name Previous URL
Description URL that precedes the measured event, all types of sources combined. Information within "event" range (several possible values per visit)
Field type dimension
Data type string.text.url
performance__time_spent
Display name Time spent (minutes)
Description Total time spent on events. This metric is displayed in minutes
Field type metric
Data type float.number.value
performance__transactions
Display name Transactions
Description Number of transaction.confirmation events
Field type metric
Data type int.number.value
performance__transactions_turnover_withtax
Display name Turnover incl. tax (transaction)
Description Turnover (incl. tax) from transactions
Field type metric
Data type float.number.value
performance__unique_visitors
Display name Visitors
Description Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period
Field type metric
Data type int.number.value
performance__users
Display name Users
Description Number of users (identified visitors). These users are quite distinct over the period
Field type metric
Data type int.number.value
performance__visits
Display name Visits
Description A visit is defined as a set of events that occured on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends
Field type metric
Data type int.number.value

Table: CONTENT_PAGES

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
performance__bounces
Display name Bounces
Description Number of visits with less than 2 pages (0 or 1, regardless of the number of events)
Field type metric
Data type int.number.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__events
Display name Events
Description Number of times an event occurred
Field type metric
Data type int.number.value
performance__events_all
Display name Events (all)
Description Number of events counted, including excluded events
Field type metric
Data type int.number.value
performance__page
Display name Page label
Description Label of the pages consulted. Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__page_loads
Display name Page views
Description Number of times a page has been loaded. If the analysed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analysed page)
Field type metric
Data type int.number.value
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value
performance__time_spent
Display name Time spent (minutes)
Description Total time spent on events. This metric is displayed in minutes
Field type metric
Data type float.number.value
performance__transactions
Display name Transactions
Description Number of transaction.confirmation events
Field type metric
Data type int.number.value
performance__transactions_turnover_withtax
Display name Turnover incl. tax (transaction)
Description Turnover (incl. tax) from transactions
Field type metric
Data type float.number.value
performance__unique_visitors
Display name Visitors
Description Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period
Field type metric
Data type int.number.value
performance__users
Display name Users
Description Number of users (identified visitors). These users are quite distinct over the period
Field type metric
Data type int.number.value
performance__visit_entrypage
Display name Entry page
Description Label of the entry pages (the one of the 1st event of type "page.display" of the visit). Information within "visit" scope (only 1 value per visit)
Field type dimension
Data type string.text.value
performance__visit_exitpage
Display name Exit page
Description Label of the output pages (the one of the last "page.display" event of the visit). Information within "visit" scope (only 1 value per visit)
Field type dimension
Data type string.text.value
performance__visits
Display name Visits
Description A visit is defined as a set of events that occured on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends
Field type metric
Data type int.number.value

Table: CONTENT_EVENTS

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
performance__bounces
Display name Bounces
Description Number of visits with less than 2 pages (0 or 1, regardless of the number of events)
Field type metric
Data type int.number.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__event_collection_platform
Display name Collection platform
Description Event collection platform
Field type dimension
Data type string.text.value
performance__event_collection_version
Display name Collection tag version
Description Version of the tag used to measure the site. It allows you to see if your tags are up to date to benefit from all the new features. Information within "event" range (several possible values per visit)
Field type dimension
Data type string.text.value
performance__event_name
Display name Event
Description Event name that creates traffic
Field type dimension
Data type string.text.value
performance__event_url
Display name URL event
Description URL of the measured event. Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.url
performance__events
Display name Events
Description Number of times an event occurred
Field type metric
Data type int.number.value
performance__events_all
Display name Events (all)
Description Number of events counted, including excluded events
Field type metric
Data type int.number.value
performance__page_loads
Display name Page views
Description Number of times a page has been loaded. If the analysed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analysed page)
Field type metric
Data type int.number.value
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value
performance__time_spent
Display name Time spent (minutes)
Description Total time spent on events. This metric is displayed in minutes
Field type metric
Data type float.number.value
performance__transactions
Display name Transactions
Description Number of transaction.confirmation events
Field type metric
Data type int.number.value
performance__transactions_turnover_withtax
Display name Turnover incl. tax (transaction)
Description Turnover (incl. tax) from transactions
Field type metric
Data type float.number.value
performance__unique_visitors
Display name Visitors
Description Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period
Field type metric
Data type int.number.value
performance__users
Display name Users
Description Number of users (identified visitors). These users are quite distinct over the period
Field type metric
Data type int.number.value
performance__visits
Display name Visits
Description A visit is defined as a set of events that occured on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends
Field type metric
Data type int.number.value

Table: TECHNOLOGY

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
performance__app_id
Display name App ID
Description Application ID. Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__bounces
Display name Bounces
Description Number of visits with less than 2 pages (0 or 1, regardless of the number of events)
Field type metric
Data type int.number.value
performance__browser_cookie_acceptance
Display name Cookies
Description Acceptance of cookies by the browser (yes/no). Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__browser_group
Display name Browser - group
Description Browser group. Information within event scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__device_brand
Display name Device - Brand
Description Brand of the device used by the visitor. Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__device_type
Display name Device - Type
Description A device represents the support used (computer, tablet, smartphone, etc.). Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__events
Display name Events
Description Number of times an event occurred
Field type metric
Data type int.number.value
performance__events_all
Display name Events (all)
Description Number of events counted, including excluded events
Field type metric
Data type int.number.value
performance__os_group
Display name OS - Group
Description Operating system group. Information within "event" scope (several possible values per visit)
Field type dimension
Data type string.text.value
performance__page_loads
Display name Page views
Description Number of times a page has been loaded. If the analysed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analysed page)
Field type metric
Data type int.number.value
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value
performance__time_spent
Display name Time spent (minutes)
Description Total time spent on events. This metric is displayed in minutes
Field type metric
Data type float.number.value
performance__transactions
Display name Transactions
Description Number of transaction.confirmation events
Field type metric
Data type int.number.value
performance__transactions_turnover_withtax
Display name Turnover incl. tax (transaction)
Description Turnover (incl. tax) from transactions
Field type metric
Data type float.number.value
performance__unique_visitors
Display name Visitors
Description Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period
Field type metric
Data type int.number.value
performance__users
Display name Users
Description Number of users (identified visitors). These users are quite distinct over the period
Field type metric
Data type int.number.value
performance__visits
Display name Visits
Description A visit is defined as a set of events that occured on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends
Field type metric
Data type int.number.value

Table: TRANSACTIONS

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
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__payment_mode
Display name Payment method
Description Payment method used (e.g. credit card)
Field type dimension
Data type string.text.value
performance__shipping_delivery
Display name Shipping method
Description Selected shipping method
Field type dimension
Data type string.text.value
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value
performance__transaction_firstpurchase
Display name First purchase?
Description Information (true/false) to determine if the recorded transaction is the customer's first. It has an "Event" scope and is only available on the "transaction.confirmation" event
Field type dimension
Data type string.text.value
performance__transaction_promocode
Display name Promotion code (transaction)
Description Promotion code filled in on the transaction
Field type dimension
Data type string.text.value
performance__transactions
Display name Transactions
Description Number of transaction.confirmation events
Field type metric
Data type int.number.value
performance__transactions_prod_bought
Display name Distinct products (transaction)
Description Number of distinct products in transactional events
Field type metric
Data type int.number.value
performance__transactions_prod_bought_qty
Display name Product quantities (transaction)
Description Summed quantities of products present in transactional events
Field type metric
Data type int.number.value
performance__transactions_turnover_taxfree
Display name Turnover excl. tax (transaction)
Description Turnover (excl. tax) from transactions
Field type metric
Data type float.number.value
performance__transactions_turnover_withtax
Display name Turnover incl. tax (transaction)
Description Turnover (incl. tax) from transactions
Field type metric
Data type float.number.value
performance__transactions_with_turnover
Display name Transactions with turnover
Description Number of transaction events with turnover
Field type metric
Data type int.number.value

Table: AV_INSIGHTS

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
performance__av_average_content_time_consumed
Display name AV - Content-time consumed (minutes)
Description Duration of content consumed in average during an Audio/Video Playback. This metric is expressed in minutes. This metric considers events within sessions
Field type metric
Data type float.number.value
performance__av_average_global_time_buffering
Display name AV - Total time buffering (minutes)
Description Time spent buffering (before and after playback start), on average during an Audio/Video session. This metric is expressed in minutes
Field type metric
Data type float.number.value
performance__av_average_playback_completion_rate
Display name AV - Playback completion rate
Description Rate between content-time consumed and cumulative duration for contents. This metric is expressed in percentage. This metric considers events within sessions
Field type metric
Data type float.number.ratio
performance__av_average_time_playback
Display name AV - Playback time (minutes)
Description Time spent consuming content, on average, during an Audio/Video playback. This metric does not include pause and buffering periods. This metric is expressed in minutes. This metric considers events within sessions
Field type metric
Data type float.number.value
performance__av_average_time_rebuffering
Display name AV - Time spent rebuffering (minutes)
Description Time spent buffering after playback start, on average, during an Audio/Video session. This metric is expressed in minutes
Field type metric
Data type float.number.value
performance__av_average_time_spent
Display name AV - Time spent (minutes)
Description Time spent on average during an Audio/Video session. This metric includes pause and buffering time spent. This metric is expressed in minutes
Field type metric
Data type float.number.value
performance__av_broadcasting_type
Display name AV - Broadcast type
Description Type of Audio/Video content broadcast. Information within the "event" scope (several values per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_channel
Display name AV - Channel
Description Channel broadcasting Audio/Video content. Information within the "event" scope (usually one value per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_content
Display name AV Content - Title
Description Title of the Audio/Video content. Information within the "event" scope (several values per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_content_genre
Display name AV Content - Genre
Description Type of Audio/Video content. Information within the "event" scope (usually one value per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_content_type
Display name Av content - type
Description Type of Audio/Video content. Information within the "event" scope (usually one value per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_playbacks
Display name AV - playbacks
Description Number of Audio/Video sessions where Audio/Video content was consumed. This metric considers events within sessions
Field type metric
Data type int.number.value
performance__av_player
Display name AV Player - ID
Description Audio/Video player ID. Information within the "event" scope (usually one value per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_plays
Display name AV - plays
Description Number of plays over all Audio/Video sessions
Field type metric
Data type int.number.value
performance__av_resumes
Display name AV - resumes
Description Number of resume playback over all Audio/Video sessions
Field type metric
Data type int.number.value
performance__av_sessions
Display name AV - Sessions
Description Number of Audio/Video sessions. A session is created from the first Audio/Video event, even if no Audio/Video content was consumed. A session is created after a STOP and also as soon as the content consumed changes
Field type metric
Data type int.number.value
performance__av_shares
Display name AV - Shares
Description Number of Audio/Video content shares
Field type metric
Data type int.number.value
performance__av_show
Display name AV Content - Show
Description Audio/Video content broadcast. Information within the "event" scope (usually one value per Audio/Video session)
Field type dimension
Data type string.text.value
performance__av_starts
Display name AV - Starts
Description Number of playback starts over all Audio/Video sessions
Field type metric
Data type int.number.value
performance__av_stops
Display name AV - Stops
Description Number of stops over all Audio/Video sessions
Field type metric
Data type int.number.value
performance__av_time_playback
Display name AV - Cumulative playback time
Description Time spent consuming content, over all Audio/Video sessions. This metric does not include pause and buffering periods. This metric is expressed in milliseconds
Field type metric
Data type float.number.value
performance__av_time_spent
Display name AV - Cumulative time spent (minutes)
Description Cumulative time spent on Audio/Video contents. This metric includes pause and buffering time spent. This metric is expressed in milliseconds
Field type metric
Data type float.number.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__site
Display name Site
Description Label of the site related to the measured event
Field type dimension
Data type string.text.value
performance__site_id
Display name Site ID
Description Level 1 sites (mandatory) with information on all measured events. This information has a "Site" range (and therefore only 1 possible value per visit)
Field type dimension
Data type string.text.value