For TV Analytics, we will request spot logs from your broadcast or cable provider.
The requirements are as follows:
- Please ensure that the required fields are present in your file.
- Please ensure that the report contains 1 record per row (with no blank rows or columns, no row grouping and no summary rows).
- You may view a sample file by clicking here: Clarivoy TV Spot Log Template
- Please name your exported file with the dealership name, network, month(s) and year(s).
Example: ABC Automotive - Jan-Feb 2025 - WTVT Spot Logs.csv - Once you have built the report, please pull the data monthly and securely upload the file at https://upload.clarivoy.com/tva
| Field Name | Field Description | Required? |
|---|---|---|
| Air Date | The date a spot aired (preferred format: MM/DD/YYYY) | YES |
| Air Time | The actual time a spot aired (preferred format: HH:MM:SS AM/PM) | YES |
| Network/Station | The cable network or broadcast station on which a spot aired | YES |
| Program | The program/show a spot aired during | Highly Recommended |
| Spot Name | The unique designation, name, or Ad-ID given to each spot | YES |
| Spot Length | The total length of a spot in seconds | YES |
| Spot Cost | The cost of a spot | YES |
| Provider | The name of the cable provider | YES (only if cable) |
| Zone | The designation given to a specific smaller area within a DMA | YES (only if cable) |