Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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.

Image RemovedImage Added

Fields:

  • Server name

  • date (time in seconds)

  • company

  • venue plan instance id

  • traffic order number

  • flight number

  • venueplanid

  • P or F

  • SIC

  • priority, start hour, end hour, scheduled rotations

  • ad file name

Design

Final Data Model:

Image RemovedImage Added

Enhancements

Enhancement Request 1: Proposal Description and SIC description

Image RemovedImage Added

Test

Issues / Discrepancies