Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | show_statistics_year | dim | |
| Year of week (Sun-Sat) | show_statistics_year_of_week | dim | ||
| Year of week (Mon-Sun) | show_statistics_year_of_week_iso | dim | ||
| Year & month | show_statistics_year_month | dim | ||
| Month | show_statistics_month | dim | ||
| Year & week (Sun-Sat) | show_statistics_year_week | dim | ||
| Year & week (Mon-Sun) | show_statistics_year_week_iso | dim | ||
| Week (Sun-Sat) | show_statistics_week | dim | ||
| Week (Mon-Sun) | show_statistics_week_iso | dim | ||
| Day of month | show_statistics_day_of_month | dim | ||
| Day of week (Sun-Sat) | show_statistics_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | show_statistics_day_of_week_name_iso | dim | ||
| Date | show_statistics_date | dim | ||
| Datetime | show_statistics_atom | dim | ||
| Account | Account name | show_statistics_account_name | dim | The name of the account. |
| Shows | Show title | show_statistics_title | dim | The title of the show. |
| Show ID | show_statistics_show_id | dim | The ID of the show. | |
| Organization ID | show_statistics_organization_id | dim | The ID of the organization. | |
| Is live | show_statistics_is_live | dim | Whether the show is live or not. | |
| Is test show | show_statistics_is_test_show | dim | Whether or not the show is a test show. | |
| Show creation datetime | show_statistics_created_at_datetime | dim | The datetime when the show was created. | |
| Show creation date | show_statistics_created_at | dim | The date when the show was created. | |
| Scheduled start datetime | show_statistics_scheduled_start_datetime | dim | The datetime when the show was scheduled to start at. | |
| Scheduled start date | show_statistics_scheduled_start_date | dim | The date when the show was scheduled to start at. | |
| Start datetime | show_statistics_start_datetime | dim | The datetime when the show was started. | |
| Start date | show_statistics_start_date | dim | The date when the show was started. | |
| End datetime | show_statistics_end_datetime | dim | The datetime when the show was ended. | |
| End date | show_statistics_end_date | dim | The date when the show was ended. | |
| Preview URL | show_statistics_preview_url | dim | The URL of the show preview. | |
| Is published | show_statistics_is_published | dim | Whether the show has been published or not. | |
| Currency | show_statistics_statistics__currency | dim | Currency code. | |
| Device | show_statistics_statistics__device | dim | Currency code. | |
| Show length (seconds) | show_statistics_show_length_seconds | met | The total show length in seconds. | |
| Show length (minutes) | show_statistics_show_length_minutes | met | The total show length in minutes. | |
| Views | show_statistics_statistics__total_views | met | Total number of views. | |
| Views (mobile) | show_statistics_statistics__total_views_mobile | met | Total number of views on mobile devices. | |
| Views (desktop) | show_statistics_statistics__total_views_desktop | met | Total number of views on desktop. | |
| Total viewers | show_statistics_statistics__viewers | met | Total number of viewers. | |
| Viewers (mobile) | show_statistics_statistics__viewers_mobile | met | Total number of viewers on mobile devices. | |
| Viewers (desktop) | show_statistics_statistics__viewers_desktop | met | Total number of viewers on desktop. | |
| Purchases | show_statistics_statistics__purchases | met | The total number of purchases. | |
| Revenue | show_statistics_statistics__revenue | met | Total revenue. | |
| Average viewing time (seconds) | show_statistics_statistics__average_viewing_time_seconds | met | Average viewing time for a show in seconds. | |
| Average viewing time (minutes) | show_statistics_statistics__average_viewing_time_minutes | met | Average viewing time for a show in minutes. | |
| Likes | show_statistics_statistics__likes | met | Total number of likes for the show. | |
| Viewers liked | show_statistics_statistics__viewers_liked_count | met | The number of unique viewers who liked. | |
| Percentage of viewers liked | show_statistics_statistics__viewers_liked_percentage | met | The percentage of viewers who liked the show. | |
| Chat messages | show_statistics_statistics__chat_messages | met | Total number of chat messages for the show. | |
| Viewers chatted | show_statistics_statistics__viewers_chatted_count | met | The number of unique viewers who chatted. | |
| Percentage of viewers chatted | show_statistics_statistics__viewers_chatted_percentage | met | The percentage of viewers chatted. | |
| Unmutes | show_statistics_statistics__unmutes | met | Total number of unmutes for the show. | |
| Unique unmutes | show_statistics_statistics__unique_unmutes | met | Total number of unique unmutes for the show. | |
| Mutes | show_statistics_statistics__mutes | met | Total number of mutes for the show. | |
| Unique mutes | show_statistics_statistics__unique_mutes | met | Total number of unique mutes for the show. | |
| Minimizes | show_statistics_statistics__minimizes | met | Total number of minimizes for the show. | |
| Unique minimizes | show_statistics_statistics__unique_minimizes | met | Total number of unique minimizes for the show. | |
| Restores | show_statistics_statistics__restores | met | Total number of restores for the show. | |
| Unique restores | show_statistics_statistics__unique_restores | met | Total number of unique restores for the show. | |
| Closes | show_statistics_statistics__closes | met | Total number of closes for the show. | |
| Unique closes | show_statistics_statistics__unique_closes | met | Total number of unique closes for the show. | |
| Fullscreen exits | show_statistics_statistics__fullscreen_exits | met | Total number of fullscreen exits for the show. | |
| Unique fullscreen exits | show_statistics_statistics__unique_fullscreen_exits | met | Total number of unique fullscreen exits for the show. | |
| Pauses | show_statistics_statistics__pauses | met | Total number of pauses for the show. | |
| Unique pauses | show_statistics_statistics__unique_pauses | met | Total number of unique pauses for the show. | |
| Resumes | show_statistics_statistics__resumes | met | Total number of resumes for the show. | |
| Unique resumes | show_statistics_statistics__unique_resumes | met | Total number of unique resumes for the show. | |
| Replays | show_statistics_statistics__replays | met | Total number of replays for the show. | |
| Unique replays | show_statistics_statistics__unique_replays | met | Total number of unique replays for the show. | |
| Cookies enabled | show_statistics_statistics__cookies_enabled | met | Total number of cookies enabled for the show. | |
| Unique cookies enabled | show_statistics_statistics__unique_cookies_enabled | met | Total number of unique cookies enabled for the show. | |
| Product list opens | show_statistics_statistics__show_all_products_overlay | met | Total number of product list opens for the show. | |
| Unique product list opens | show_statistics_statistics__unique_show_all_products_overlay | met | Total number of unique product list opens for the show. | |
| Product list hides | show_statistics_statistics__hide_all_products_overlay | met | Total number of product list hides for the show. | |
| Unique product list hides | show_statistics_statistics__unique_hide_all_products_overlay | met | Total number of unique product list hides for the show. | |
| Number of shows | show_statistics_statistics__number_of_shows | met | Total number of shows. | |
| Views (live) | show_statistics_statistics__views_live | met | Total number of views during live show. | |
| Views (live, mobile) | show_statistics_statistics__views_live_mobile | met | Total number of views during live show on mobile devices. | |
| Views (live, desktop) | show_statistics_statistics__views_live_desktop | met | Total number of views during live on desktop. | |
| Viewers (live) | show_statistics_statistics__viewers_live | met | Total number of viewers during live show. | |
| Viewers (live, mobile) | show_statistics_statistics__viewers_live_mobile | met | Total number of viewers during live show on mobile devices. | |
| Viewers (live, desktop) | show_statistics_statistics__viewers_live_desktop | met | Total number of viewers during live show on desktop. | |
| Likes (live) | show_statistics_statistics__likes_live | met | Total number of likes during live show. | |
| Unique likes (live) | show_statistics_statistics__unique_likes_live | met | Total number of unique likes during live show. | |
| Percentage of viewers liked (live) | show_statistics_statistics__viewers_liked_live | met | The percentage of viewers who pressed like during live show. | |
| Chat messages (live) | show_statistics_statistics__chat_messages_live | met | Total number of chat messages during live show. | |
| Unique chat messages (live) | show_statistics_statistics__unique_chat_messages_live | met | Total number of unique chat messages during live show. | |
| Percentage of viewers chatted (live) | show_statistics_statistics__viewers_chatted_live | met | The percentage of viewers who sent a chat message during live show. | |
| Average viewing time (live, seconds) | show_statistics_statistics__average_viewing_time_live_seconds | met | Average viewing time for a live show in seconds. | |
| Average viewing time (live, minutes) | show_statistics_statistics__average_viewing_time_live_minutes | met | Average viewing time for a live show in minutes. | |
| Unmutes (live) | show_statistics_statistics__unmutes_live | met | Total number of unmutes during live show. | |
| Unique unmutes (live) | show_statistics_statistics__unique_unmutes_live | met | Total number of unique unmutes during live show. | |
| Mutes (live) | show_statistics_statistics__mutes_live | met | Total number of mutes during live show. | |
| Unique mutes (live) | show_statistics_statistics__unique_mutes_live | met | Total number of unique mutes during live show. | |
| Minimizes (live) | show_statistics_statistics__minimizes_live | met | Total number of minimizes during live show. | |
| Unique minimizes (live) | show_statistics_statistics__unique_minimizes_live | met | Total number of unique minimizes during live show. | |
| Restores (live) | show_statistics_statistics__restores_live | met | Total number of restores during live show. | |
| Unique restores (live) | show_statistics_statistics__unique_restores_live | met | Total number of unique restores during live show. | |
| Closes (live) | show_statistics_statistics__closes_live | met | Total number of closes during live show. | |
| Unique closes (live) | show_statistics_statistics__unique_closes_live | met | Total number of unique closes during live show. | |
| Fullscreen exits (live) | show_statistics_statistics__fullscreen_exits_live | met | Total number of fullscreen exits during live show. | |
| Unique fullscreen exits (live) | show_statistics_statistics__unique_fullscreen_exits_live | met | Total number of unique fullscreen exits during live show. | |
| Resumes (live) | show_statistics_statistics__resumes_live | met | Total number of resumes during live show. | |
| Unique resumes (live) | show_statistics_statistics__unique_resumes_live | met | Total number of unique resumes during live show. | |
| Replays (live) | show_statistics_statistics__replays_live | met | Total number of replays during live show. | |
| Unique replays (live) | show_statistics_statistics__unique_replays_live | met | Total number of unique replays during live show. | |
| Product list opens (live) | show_statistics_statistics__show_all_products_overlay_live | met | Total number of product list opens during live show. | |
| Unique product list opens (live) | show_statistics_statistics__unique_show_all_products_overlay_live | met | Total number of unique product list opens during live show. | |
| Product list hides (live) | show_statistics_statistics__hide_all_products_overlay_live | met | Total number of product list hides during live show.. | |
| Unique product list hides (live) | show_statistics_statistics__unique_hide_all_products_overlay_live | met | Total number of unique product list hides during live show. | |
| Views (recorded) | show_statistics_statistics__views_recorded | met | Total number of views for the recorded show. | |
| Views (recorded, mobile) | show_statistics_statistics__views_recorded_mobile | met | Total number of views for the recorded show on mobile devices. | |
| Views (recorded, desktop) | show_statistics_statistics__views_recorded_desktop | met | Total number of views for the recorded show on desktop. | |
| Viewers (recorded) | show_statistics_statistics__viewers_recorded | met | Total number of viewers for the recorded show. | |
| Viewers (recorded, mobile) | show_statistics_statistics__viewers_recorded_mobile | met | Total number of viewers for the recorded show on mobile devices. | |
| Viewers (recorded, desktop) | show_statistics_statistics__viewers_recorded_desktop | met | Total number of viewers for the recorded show on desktop. | |
| Likes (recorded) | show_statistics_statistics__likes_recorded | met | Total number of likes during recorded show. | |
| Unique likes (recorded) | show_statistics_statistics__unique_likes_recorded | met | Total number of unique likes during recorded show. | |
| Percentage of viewers liked (recorded) | show_statistics_statistics__viewers_liked_recorded | met | The percentage of viewers who liked during recorded show. | |
| Average viewing time (recorded, seconds) | show_statistics_statistics__average_viewing_time_recorded_seconds | met | Average viewing time for a recorded show in seconds. | |
| Average viewing time (recorded, minutes) | show_statistics_statistics__average_viewing_time_recorded_minutes | met | Average viewing time for a recorded show in minutes. | |
| Unmutes (recorded) | show_statistics_statistics__unmutes_recorded | met | Total number of unmutes during recorded show. | |
| Unique unmutes (recorded) | show_statistics_statistics__unique_unmutes_recorded | met | Total number of unique unmutes during recorded show. | |
| Mutes (recorded) | show_statistics_statistics__mutes_recorded | met | Total number of mutes during recorded show. | |
| Unique mutes (recorded) | show_statistics_statistics__unique_mutes_recorded | met | Total number of unique mutes during recorded show. | |
| Minimizes (recorded) | show_statistics_statistics__minimizes_recorded | met | Total number of minimizes during recorded show. | |
| Unique minimizes (recorded) | show_statistics_statistics__unique_minimizes_recorded | met | Total number of unique minimizes during recorded show. | |
| Restores (recorded) | show_statistics_statistics__restores_recorded | met | Total number of restores during recorded show. | |
| Unique restores (recorded) | show_statistics_statistics__unique_restores_recorded | met | Total number of unique restores during recorded show. | |
| Closes (recorded) | show_statistics_statistics__closes_recorded | met | Total number of closes during recorded show. | |
| Unique closes (recorded) | show_statistics_statistics__unique_closes_recorded | met | Total number of unique closes during recorded show. | |
| Fullscreen exits (recorded) | show_statistics_statistics__fullscreen_exits_recorded | met | Total number of fullscreen exits during recorded show. | |
| Unique fullscreen exits (recorded) | show_statistics_statistics__unique_fullscreen_exits_recorded | met | Total number of unique fullscreen exits during recorded show. | |
| Pauses (recorded) | show_statistics_statistics__pauses_recorded | met | Total number of pauses during recorded show. | |
| Unique pauses (recorded) | show_statistics_statistics__unique_pauses_recorded | met | Total number of unique pauses during recorded show. | |
| Resumes (recorded) | show_statistics_statistics__resumes_recorded | met | Total number of resumes during recorded show. | |
| Unique resumes (recorded) | show_statistics_statistics__unique_resumes_recorded | met | Total number of unique resumes during recorded show. | |
| Replays (recorded) | show_statistics_statistics__replays_recorded | met | Total number of replays during recorded show. | |
| Unique replays (recorded) | show_statistics_statistics__unique_replays_recorded | met | Total number of unique replays during recorded show. | |
| Cookies enabled (recorded) | show_statistics_statistics__cookies_enabled_recorded | met | Total number of cookies enabled during recorded show. | |
| Unique cookies enabled (recorded) | show_statistics_statistics__unique_cookies_enabled_recorded | met | Total number of unique cookies enabled during recorded show. | |
| Product list opens (recorded) | show_statistics_statistics__show_all_products_overlay_recorded | met | Total number of product list opens during live recording. | |
| Unique product list opens (recorded) | show_statistics_statistics__unique_show_all_products_overlay_recorded | met | Total number of unique product list opens during live show. | |
| Product list hides (recorded) | show_statistics_statistics__hide_all_products_overlay_recorded | met | Total number of product list hides during live show. | |
| Unique product list hides (recorded) | show_statistics_statistics__unique_hide_all_products_overlay_recorded | met | Total number of unique product list hides during live show. | |
| Total clicks | show_statistics_traffic_acquisition__total_clicks | met | Total number of clicks for the show. | |
| Total viewers (traffic acquisition) | show_statistics_traffic_acquisition__total_viewers | met | Total number of organic, multistreaming and share viewers combined. | |
| Conversion rate (total) | show_statistics_traffic_acquisition__conversion_rate_total | met | The percentage of clicks that turned into viewers (total viewers / total clicks). | |
| Organic clicks | show_statistics_traffic_acquisition__organic_clicks | met | Total number of organic clicks. | |
| Organic viewers | show_statistics_traffic_acquisition__organic_viewers | met | Total number of organic viewers. | |
| Conversion rate (organic) | show_statistics_traffic_acquisition__conversion_rate_organic | met | The percentage of clicks that turned into viewers (organic viewers / organic clicks). | |
| Multistreaming clicks | show_statistics_traffic_acquisition__multistreaming_clicks | met | Total number of multistreaming clicks. | |
| Multistreaming viewers | show_statistics_traffic_acquisition__multistreaming_viewers | met | Total number of multistreaming viewers. | |
| Conversion rate (multistreaming) | show_statistics_traffic_acquisition__conversion_rate_multistreaming | met | The percentage of clicks that turned into viewers (multistreaming viewers / multistreaming clicks). | |
| Share clicks | show_statistics_traffic_acquisition__share_clicks | met | Total number of share clicks. | |
| Share viewers | show_statistics_traffic_acquisition__share_viewers | met | Total number of share viewers for the show. | |
| Conversion rate (share) | show_statistics_traffic_acquisition__conversion_rate_share | met | The percentage of clicks that turned into viewers (share viewers / share clicks). | |
| Organic clicks (channels) | show_statistics_traffic_acquisition__organic_clicks_channels | met | Total number of organic clicks through channels. | |
| Organic clicks (direct) | show_statistics_traffic_acquisition__organic_clicks_direct | met | Total number of direct organic clicks. | |
| Organic clicks (fab) | show_statistics_traffic_acquisition__organic_clicks_fab | met | Total number of fab organic clicks. | |
| Organic viewers (channels) | show_statistics_traffic_acquisition__organic_viewers_channels | met | Total number of organic viewers through channels. | |
| Organic viewers (direct) | show_statistics_traffic_acquisition__organic_viewers_direct | met | Total number of direct organic viewers. | |
| Organic viewers (fab) | show_statistics_traffic_acquisition__organic_viewers_fab | met | Total number of fab organic viewers. | |
| Multistreaming clicks (Facebook) | show_statistics_traffic_acquisition__multistreaming_clicks_facebook | met | Total number of multistreaming clicks via Facebook. | |
| Multistreaming clicks (YouTube) | show_statistics_traffic_acquisition__multistreaming_clicks_youtube | met | Total number of multistreaming clicks via YouTube. | |
| Multistreaming clicks (others) | show_statistics_traffic_acquisition__multistreaming_clicks_others | met | Total number of multistreaming clicks via other platforms. | |
| Multistreaming viewers (Facebook) | show_statistics_traffic_acquisition__multistreaming_viewers_facebook | met | Total number of multistreaming viewers via Facebook. | |
| Multistreaming viewers (YouTube) | show_statistics_traffic_acquisition__multistreaming_viewers_youtube | met | Total number of multistreaming viewers via YouTube. | |
| Multistreaming viewers (others) | show_statistics_traffic_acquisition__multistreaming_viewers_others | met | Total number of multistreaming viewers via other platforms. |