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.

Fields:

• Server name

• date (time in seconds)

• Client

• 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:

Enhancements

Enhancement Request 1: Proposal Description and SIC description

Test

Issues / Discrepancies