Bambuser data warehouse table groups

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

Table: SHOW

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
show_statistics__account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
show_statistics__created_at
Display name Show creation date
Description The date when the show was created
Field type dimension
Data type string.time.date
show_statistics__created_at_datetime
Display name Show creation datetime
Description The datetime when the show was created
Field type dimension
Data type string.time.datetime
show_statistics__end_date
Display name End date
Description The date when the show was ended
Field type dimension
Data type string.time.date
show_statistics__end_datetime
Display name End datetime
Description The datetime when the show was ended
Field type dimension
Data type string.time.datetime
show_statistics__is_live
Display name Is live
Description Whether the show is live or not
Field type dimension
Data type bool
show_statistics__is_published
Display name Is published
Description Whether the show has been published or not
Field type dimension
Data type bool
show_statistics__is_test_show
Display name Is test show
Description Whether or not the show is a test show
Field type dimension
Data type bool
show_statistics__organization_id
Display name Organization ID
Description The ID of the organization
Field type dimension
Data type string.text.value
show_statistics__preview_url
Display name Preview URL
Description The URL of the show preview
Field type dimension
Data type string.text.url
show_statistics__scheduled_start_date
Display name Scheduled start date
Description The date when the show was scheduled to start at
Field type dimension
Data type string.time.date
show_statistics__scheduled_start_datetime
Display name Scheduled start datetime
Description The datetime when the show was scheduled to start at
Field type dimension
Data type string.time.datetime
show_statistics__show_id
Display name Show ID
Description The ID of the show
Field type dimension
Data type string.text.value
show_statistics__show_length_minutes
Display name Show length (minutes)
Description The total show length in minutes
Field type metric
Data type float.number.value
show_statistics__show_length_seconds
Display name Show length (seconds)
Description The total show length in seconds
Field type metric
Data type int.number.value
show_statistics__start_date
Display name Start date
Description The date when the show was started
Field type dimension
Data type string.time.date
show_statistics__start_datetime
Display name Start datetime
Description The datetime when the show was started
Field type dimension
Data type string.time.datetime
show_statistics__statistics__average_viewing_time_live_minutes
Display name Average viewing time (live, minutes)
Description Average viewing time for a live show in minutes
Field type metric
Data type float.number.value
show_statistics__statistics__average_viewing_time_live_seconds
Display name Average viewing time (live, seconds)
Description Average viewing time for a live show in seconds
Field type metric
Data type int.number.value
show_statistics__statistics__average_viewing_time_minutes
Display name Average viewing time (minutes)
Description Average viewing time for a show in minutes
Field type metric
Data type float.number.value
show_statistics__statistics__average_viewing_time_recorded_minutes
Display name Average viewing time (recorded, minutes)
Description Average viewing time for a recorded show in minutes
Field type metric
Data type float.number.value
show_statistics__statistics__average_viewing_time_recorded_seconds
Display name Average viewing time (recorded, seconds)
Description Average viewing time for a recorded show in seconds
Field type metric
Data type int.number.value
show_statistics__statistics__average_viewing_time_seconds
Display name Average viewing time (seconds)
Description Average viewing time for a show in seconds
Field type metric
Data type int.number.value
show_statistics__statistics__chat_messages
Display name Chat messages
Description Total number of chat messages for the show
Field type metric
Data type int.number.value
show_statistics__statistics__chat_messages_live
Display name Chat messages (live)
Description Total number of chat messages during live show
Field type metric
Data type int.number.value
show_statistics__statistics__closes
Display name Closes
Description Total number of closes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__closes_live
Display name Closes (live)
Description Total number of closes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__closes_recorded
Display name Closes (recorded)
Description Total number of closes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__cookies_enabled
Display name Cookies enabled
Description Total number of cookies enabled for the show
Field type metric
Data type int.number.value
show_statistics__statistics__cookies_enabled_recorded
Display name Cookies enabled (recorded)
Description Total number of cookies enabled during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__currency
Display name Currency
Description Currency code
Field type dimension
Data type string.currency.code
show_statistics__statistics__device
Display name Device
Description Currency code
Field type dimension
Data type string.currency.code
show_statistics__statistics__fullscreen_exits
Display name Fullscreen exits
Description Total number of fullscreen exits for the show
Field type metric
Data type int.number.value
show_statistics__statistics__fullscreen_exits_live
Display name Fullscreen exits (live)
Description Total number of fullscreen exits during live show
Field type metric
Data type int.number.value
show_statistics__statistics__fullscreen_exits_recorded
Display name Fullscreen exits (recorded)
Description Total number of fullscreen exits during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__hide_all_products_overlay
Display name Product list hides
Description Total number of product list hides for the show
Field type metric
Data type int.number.value
show_statistics__statistics__hide_all_products_overlay_live
Display name Product list hides (live)
Description Total number of product list hides during live show.
Field type metric
Data type int.number.value
show_statistics__statistics__hide_all_products_overlay_recorded
Display name Product list hides (recorded)
Description Total number of product list hides during live show
Field type metric
Data type int.number.value
show_statistics__statistics__likes
Display name Likes
Description Total number of likes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__likes_live
Display name Likes (live)
Description Total number of likes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__likes_recorded
Display name Likes (recorded)
Description Total number of likes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__minimizes
Display name Minimizes
Description Total number of minimizes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__minimizes_live
Display name Minimizes (live)
Description Total number of minimizes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__minimizes_recorded
Display name Minimizes (recorded)
Description Total number of minimizes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__mutes
Display name Mutes
Description Total number of mutes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__mutes_live
Display name Mutes (live)
Description Total number of mutes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__mutes_recorded
Display name Mutes (recorded)
Description Total number of mutes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__pauses
Display name Pauses
Description Total number of pauses for the show
Field type metric
Data type int.number.value
show_statistics__statistics__pauses_recorded
Display name Pauses (recorded)
Description Total number of pauses during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__purchases
Display name Purchases
Description The total number of purchases
Field type metric
Data type int.number.value
show_statistics__statistics__replays
Display name Replays
Description Total number of replays for the show
Field type metric
Data type int.number.value
show_statistics__statistics__replays_live
Display name Replays (live)
Description Total number of replays during live show
Field type metric
Data type int.number.value
show_statistics__statistics__replays_recorded
Display name Replays (recorded)
Description Total number of replays during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__restores
Display name Restores
Description Total number of restores for the show
Field type metric
Data type int.number.value
show_statistics__statistics__restores_live
Display name Restores (live)
Description Total number of restores during live show
Field type metric
Data type int.number.value
show_statistics__statistics__restores_recorded
Display name Restores (recorded)
Description Total number of restores during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__resumes
Display name Resumes
Description Total number of resumes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__resumes_live
Display name Resumes (live)
Description Total number of resumes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__resumes_recorded
Display name Resumes (recorded)
Description Total number of resumes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__revenue
Display name Revenue
Description Total revenue
Field type metric
Data type int.currency.value
show_statistics__statistics__show_all_products_overlay
Display name Product list opens
Description Total number of product list opens for the show
Field type metric
Data type int.number.value
show_statistics__statistics__show_all_products_overlay_live
Display name Product list opens (live)
Description Total number of product list opens during live show
Field type metric
Data type int.number.value
show_statistics__statistics__show_all_products_overlay_recorded
Display name Product list opens (recorded)
Description Total number of product list opens during live recording
Field type metric
Data type int.number.value
show_statistics__statistics__total_views
Display name Views
Description Total number of views
Field type metric
Data type int.number.value
show_statistics__statistics__total_views_desktop
Display name Views (desktop)
Description Total number of views on desktop
Field type metric
Data type int.number.value
show_statistics__statistics__total_views_mobile
Display name Views (mobile)
Description Total number of views on mobile devices
Field type metric
Data type int.number.value
show_statistics__statistics__unique_chat_messages_live
Display name Unique chat messages (live)
Description Total number of unique chat messages during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_closes
Display name Unique closes
Description Total number of unique closes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_closes_live
Display name Unique closes (live)
Description Total number of unique closes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_closes_recorded
Display name Unique closes (recorded)
Description Total number of unique closes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_cookies_enabled
Display name Unique cookies enabled
Description Total number of unique cookies enabled for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_cookies_enabled_recorded
Display name Unique cookies enabled (recorded)
Description Total number of unique cookies enabled during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_fullscreen_exits
Display name Unique fullscreen exits
Description Total number of unique fullscreen exits for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_fullscreen_exits_live
Display name Unique fullscreen exits (live)
Description Total number of unique fullscreen exits during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_fullscreen_exits_recorded
Display name Unique fullscreen exits (recorded)
Description Total number of unique fullscreen exits during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_hide_all_products_overlay
Display name Unique product list hides
Description Total number of unique product list hides for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_hide_all_products_overlay_live
Display name Unique product list hides (live)
Description Total number of unique product list hides during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_hide_all_products_overlay_recorded
Display name Unique product list hides (recorded)
Description Total number of unique product list hides during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_likes_live
Display name Unique likes (live)
Description Total number of unique likes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_likes_recorded
Display name Unique likes (recorded)
Description Total number of unique likes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_minimizes
Display name Unique minimizes
Description Total number of unique minimizes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_minimizes_live
Display name Unique minimizes (live)
Description Total number of unique minimizes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_minimizes_recorded
Display name Unique minimizes (recorded)
Description Total number of unique minimizes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_mutes
Display name Unique mutes
Description Total number of unique mutes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_mutes_live
Display name Unique mutes (live)
Description Total number of unique mutes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_mutes_recorded
Display name Unique mutes (recorded)
Description Total number of unique mutes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_pauses
Display name Unique pauses
Description Total number of unique pauses for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_pauses_recorded
Display name Unique pauses (recorded)
Description Total number of unique pauses during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_replays
Display name Unique replays
Description Total number of unique replays for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_replays_live
Display name Unique replays (live)
Description Total number of unique replays during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_replays_recorded
Display name Unique replays (recorded)
Description Total number of unique replays during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_restores
Display name Unique restores
Description Total number of unique restores for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_restores_live
Display name Unique restores (live)
Description Total number of unique restores during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_restores_recorded
Display name Unique restores (recorded)
Description Total number of unique restores during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_resumes
Display name Unique resumes
Description Total number of unique resumes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_resumes_live
Display name Unique resumes (live)
Description Total number of unique resumes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_resumes_recorded
Display name Unique resumes (recorded)
Description Total number of unique resumes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_show_all_products_overlay
Display name Unique product list opens
Description Total number of unique product list opens for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_show_all_products_overlay_live
Display name Unique product list opens (live)
Description Total number of unique product list opens during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_show_all_products_overlay_recorded
Display name Unique product list opens (recorded)
Description Total number of unique product list opens during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_unmutes
Display name Unique unmutes
Description Total number of unique unmutes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_unmutes_live
Display name Unique unmutes (live)
Description Total number of unique unmutes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unique_unmutes_recorded
Display name Unique unmutes (recorded)
Description Total number of unique unmutes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__unmutes
Display name Unmutes
Description Total number of unmutes for the show
Field type metric
Data type int.number.value
show_statistics__statistics__unmutes_live
Display name Unmutes (live)
Description Total number of unmutes during live show
Field type metric
Data type int.number.value
show_statistics__statistics__unmutes_recorded
Display name Unmutes (recorded)
Description Total number of unmutes during recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__viewers
Display name Total viewers
Description Total number of viewers
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_chatted_count
Display name Viewers chatted
Description The number of unique viewers who chatted
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_desktop
Display name Viewers (desktop)
Description Total number of viewers on desktop
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_liked_count
Display name Viewers liked
Description The number of unique viewers who liked
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_live
Display name Viewers (live)
Description Total number of viewers during live show
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_live_desktop
Display name Viewers (live, desktop)
Description Total number of viewers during live show on desktop
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_live_mobile
Display name Viewers (live, mobile)
Description Total number of viewers during live show on mobile devices
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_mobile
Display name Viewers (mobile)
Description Total number of viewers on mobile devices
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_recorded
Display name Viewers (recorded)
Description Total number of viewers for the recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_recorded_desktop
Display name Viewers (recorded, desktop)
Description Total number of viewers for the recorded show on desktop
Field type metric
Data type int.number.value
show_statistics__statistics__viewers_recorded_mobile
Display name Viewers (recorded, mobile)
Description Total number of viewers for the recorded show on mobile devices
Field type metric
Data type int.number.value
show_statistics__statistics__views_live
Display name Views (live)
Description Total number of views during live show
Field type metric
Data type int.number.value
show_statistics__statistics__views_live_desktop
Display name Views (live, desktop)
Description Total number of views during live on desktop
Field type metric
Data type int.number.value
show_statistics__statistics__views_live_mobile
Display name Views (live, mobile)
Description Total number of views during live show on mobile devices
Field type metric
Data type int.number.value
show_statistics__statistics__views_recorded
Display name Views (recorded)
Description Total number of views for the recorded show
Field type metric
Data type int.number.value
show_statistics__statistics__views_recorded_desktop
Display name Views (recorded, desktop)
Description Total number of views for the recorded show on desktop
Field type metric
Data type int.number.value
show_statistics__statistics__views_recorded_mobile
Display name Views (recorded, mobile)
Description Total number of views for the recorded show on mobile devices
Field type metric
Data type int.number.value
show_statistics__title
Display name Show title
Description The title of the show
Field type dimension
Data type string.text.value
show_statistics__traffic_acquisition__multistreaming_clicks
Display name Multistreaming clicks
Description Total number of multistreaming clicks
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_clicks_facebook
Display name Multistreaming clicks (Facebook)
Description Total number of multistreaming clicks via Facebook
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_clicks_others
Display name Multistreaming clicks (others)
Description Total number of multistreaming clicks via other platforms
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_clicks_youtube
Display name Multistreaming clicks (YouTube)
Description Total number of multistreaming clicks via YouTube
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_viewers
Display name Multistreaming viewers
Description Total number of multistreaming viewers
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_viewers_facebook
Display name Multistreaming viewers (Facebook)
Description Total number of multistreaming viewers via Facebook
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_viewers_others
Display name Multistreaming viewers (others)
Description Total number of multistreaming viewers via other platforms
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__multistreaming_viewers_youtube
Display name Multistreaming viewers (YouTube)
Description Total number of multistreaming viewers via YouTube
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_clicks
Display name Organic clicks
Description Total number of organic clicks
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_clicks_channels
Display name Organic clicks (channels)
Description Total number of organic clicks through channels
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_clicks_direct
Display name Organic clicks (direct)
Description Total number of direct organic clicks
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_clicks_fab
Display name Organic clicks (fab)
Description Total number of fab organic clicks
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_viewers
Display name Organic viewers
Description Total number of organic viewers
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_viewers_channels
Display name Organic viewers (channels)
Description Total number of organic viewers through channels
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_viewers_direct
Display name Organic viewers (direct)
Description Total number of direct organic viewers
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__organic_viewers_fab
Display name Organic viewers (fab)
Description Total number of fab organic viewers
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__share_clicks
Display name Share clicks
Description Total number of share clicks
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__share_viewers
Display name Share viewers
Description Total number of share viewers for the show
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__total_clicks
Display name Total clicks
Description Total number of clicks for the show
Field type metric
Data type int.number.value
show_statistics__traffic_acquisition__total_viewers
Display name Total viewers (traffic acquisition)
Description Total number of organic, multistreaming and share viewers combined
Field type metric
Data type int.number.value