Skip to content

Views Tracker - GDS Report List

Useful information

Input

  • List of client IDs, controlled via the Retool App. Staff can add or remove client IDs from the list. Any changes would be reflected the next time the report is updated.
  • Tagging on individual videos within CMS. This is done within the 'taxonomies' section when editing a video record.

Output

  • Data is written to the Google Sheet for that region.

How it works

This report is updated throughout the working day. The data can be updated ad-hoc at request.

Terms

Term Definition
Defined client list See the Retool App which lists all included client IDs.
Minimum report date Today's date minus 3 months. Then get the first day of the month.
For example, today is 2024-03-07, therefore the minimum date is 2023-12-01.

Filtering

First, we load the raw video information with the following filters applied:

(
    System is 'Asset TV US' or 'Asset TV UK' (i.e. api/v2/list/taxonomy API endpoints)
    AND 'published_status' = 'Yes'
    AND 'private_video' = 'No'
    AND 'owner_id' is not empty
    AND 'domains_published_to' includes either of the following, depening on the region: ('Asset TV US' or 'Asset TV CA') or ('Asset TV UK')
)

Then, we apply the following filters to define the list of videos to be included:

(
    (
        'owner_id' of the video appears in the defined client list
        AND 'created' (also referred to as 'post_date') of the video is greater than or equal to the minimum report date
    )
    OR 'tags' contains 'single report'
    OR 'tags' contains 'old content'
)

Viewing stats

Once the list of videos is established, the tool then gets the viewing stats for these videos.

Included sites

The tool loads the video view data for each of the specified sites:

Asset TV US:

Site ID
Asset TV US 602
Asset TV US Channels 603
Asset TV FII 580
Asset TV CA 608
Asset TV CA Channels 598

Asset TV UK:

Site ID
Asset TV UK 529

Column outputs

The tool produces the following columns:

  • Client ID
  • Client Name
  • Node ID
  • Title
  • Post Date (Also referred to as created)
  • Domains
  • Target Category (The target applied based on the age of the video)
  • Target Multiplier (See below)
  • Engagement %
  • Days Live (Days elapsed since post date)
  • Asset TV {region} ({id}) (Total views on this site ID)
  • Asset TV {region} ({id}) (Total views on this site ID)
  • Asset TV {region} ({id}) (Total views across the previous columns)
  • Asset TV {region} ({id}) (The target this video needs to achieve)
  • Asset TV {region} ({id}) (The difference between the views actual and the target)
Target multiplier

Some videos get an increased target based on certain factors.

  1. Masterclass appears in the title, with the exception of the highlights which is designated by owner 17253.
  2. The video is tagged as 'Views Boost'.

Note: Videos tagged as 'Views Boost' must meet all of the default criteria detailed in the 'Filtering' section in order to be included in the report. This means they must be owned by a defined client within the date parameters or also tagged with 'Single Report' or 'Old Content'. The 'Views Boost' tag only increases their target multiplier but does not guarantee their inclusion in the report on its own.

Included sheets (example)

The column output is repeated multiple times that are written to different sheets within the document.

This table is for illustrative purposes only, additional sheets follow the same syntax of Data ([Current | Previous]}) {region} [All | Missing]

Sheet Name Description
Data (Current) US [All] Limited to videos on the 'Asset TV US' domain. Showing viewing stats for the current month for the US site IDs from the table above.
Data (Current) US [Missing] Limited to videos on the 'Asset TV US' domain. Showing viewing stats for the current month for the US site IDs from the table above. Limited to videos where the actual views is lower than the target views.
Data (Current) CA [All] Limited to videos on the 'Asset TV CA' domain. Showing viewing stats for the current month for the CA site IDs from the table above.
Data (Current) CA [Missing] Limited to videos on the 'Asset TV CA' domain. Showing viewing stats for the current month for the CA site IDs from the table above. Limited to videos where the actual views is lower than the target views.
Data (Previous) US [All] Limited to videos on the 'Asset TV US' domain. Showing viewing stats for the previous month for the US site IDs from the table above.
Data (Previous) US [Missing] Limited to videos on the 'Asset TV US' domain. Showing viewing stats for the previous month for the US site IDs from the table above. Limited to videos where the actual views is lower than the target views.
Data (Previous) CA [All] Limited to videos on the 'Asset TV CA' domain. Showing viewing stats for the previous month for the CA site IDs from the table above.
Data (Previous) CA [Missing] Limited to videos on the 'Asset TV CA' domain. Showing viewing stats for the previous month for the CA site IDs from the table above. Limited to videos where the actual views is lower than the target views.