Skip to content

Benchmark Reports

Create a Benchmark Report of some KPIs for various sites. Reports are produced monthly or on ad-hoc basis.

Configurable Options

  • site_id: Sites to include in report.
  • node_exclude: Exclude specific nodes from stats.
  • profile: Profile table source to use for each system. The profile tables used here are used across all reports for the given region.
  • profile_field: Profile field to use, choose from either {profile|profile_parent}.
  • company_field: Choose from either {company|company_parent}.
  • topic_field: Choose from either {topic|topic_parent}. Some topics are grouped together under a parent topic (this is controlled via Retool here).
  • topic_exclude: Exclude certain topics from report.
  • keyword: Select videos based on some keyword in video title. This allows you to create a report for a specific topic, for example 'Masterclass'.
  • date_range: Choose from {ytd|year|month|quarter}. A typical Benchmark report is produced for the previous month (option: month).
  • owner_exclude: Exclude certain video owners.
  • filter_private: Choose from {True|False}, filter out private videos.
  • domain_published: Filter for specific published domains.
  • subscribers_count: Choose from {True|False}, add subscribers count to output. Currently only supported for ATV ZA.
  • life_time_av: Choose from {True|False}, whether to add output for lifetime average time.
  • topics_by_profile: Choose from {True|False}, separate topic sheets per profile. For example top topic by profile 'Wealth Managers'.
  • metrics_by_profile: Choose from {True|False}, separate stats by profile.
  • contacts_count: Choose from {True|False}, stats by unique viewers if True.
  • reach_media_pack: Custom profile percentages. Currently only supported for ATV UK.

Data sources

Analytics API endpoints

  • Site videos: api/v2/analytics/videos
  • Site viewers: api/v2/analytics/viewers
  • Site video viewers: api/v2/analytics/viewers_per_video
  • Site guest viewers: api/v2/analytics/guest_viewers

Reference endpoints (DMT Database)

  • reference.system_sites (originating from: api/v2/list/sites)
  • reference.esp_user_tokens
  • reference.taxonomy (originating from: api/v2/list/taxonomy)
  • reference.{profile_table}
  • reference.system_users_{system}_active (originating from API: api/v2/list/user-gdpr)
  • email.impressions
  • email.cm_list_member

Default sites per system

output_name system_id sites_include sites_exclude
atv_gb 1 [529] []
atv_eu 1 [534] []
atv_asia 1 [530] []
atv_us 0 [All available site IDs] [598, 608, 584, 612, 583, 605, 585, 607, 586, 587, 601]
itv_gb 2 [115, 118, 114, 111, 122, 112, 123, 117, 132] []
atv_za 3 [3318] []
atv_za_all 3 [3318, 3486, 3488 ] []

Output

Each report is output as an XLSX document, comprising of multiple sheets:

Sheet name Data Columns
top_videos Videos watched sorted by views [node_id, title, company_s, thumbnail, rank]
total_views Total views per site [system_id, site_id, label, views]
total_impressions Total email impressions [system_id, impressions]
average_views Average views per video (within report date range) [system_id, site_id, label, views]
average_views_life Average views per video (lifetime) [system_id, site_id, label, views_alltime]
average_views_minus12m Average views per video (within -12 month date range) [system_id, site_id, label, views]
average_mins Average viewing time (minutes) per site [system_id, site_id, label, av_time]
av_views_av_mins_by_profile Average views & viewing time (minutes) per profile [profile_upload, views, av_time]
avg_mins_top50pc_videos_avtime Average viewing time (minutes) per site (top 50pc of the videos) [system_id, site_id, label, av_time]
top_topics Topics watched sorted by views [topic, rank]
top_speakers Video speakers sorted by views [speaker, views, company, speaker_img, rank]
top_viewed_company Companies viewed sorted by views [company, rank]
top_viewing_company Viewer companies sorted by views [company, rank]
audience_profile Viewers profile breakdown [profile_upload, profile_upload_pc]
topics_{profile} Topics watched sorted by views for this [topic, rank]
videos_{profile} Videos watched sorted by views for this [node_id, title, company_s, thumbnail]
reach_media_pack Pre-defined viewers profile breakdown, UK only [label, pc, count]
config_dates Start & end dates of report [date_start, date_end]
config_system Sites included/excluded in report [system_id, site_id, site_exclude]