SNT Schedule from AWS

Owned by Abe Ahn (Unlicensed)
Last updated: May 10, 2021
1 min read

Link to Prod: https://looker.captivate.com/dashboards-next/aws

Requirements

The intent of this reporting project is to recreate data export functionality in the form of ver logs. These text files were available before the cloud migration and provided the Traffic team with a way to verify that the scheduled ads were playing as intended.

Fields:

  • Client

  • VP Instance ID

  • traffic order

  • flight no

  • venueplanid

  • add_fill (0 or 1)

  • SIC

  • priority

  • start hr

  • end hr

  • sch rotation

  • ad file

Design

Final Data Model:

Enhancements

Enhancement Request 1: Proposal Description and SIC description

Testing

Issue / Discrepancies

  1.