Short version
In Proof of play, set the filters you want, then press Export breaks (one row per break) or Export spots (one row per spot). Both open in any spreadsheet.
Choose what to include
Both exports use the same status and date filters as the screen. To export last weekend's completed breaks, choose Completed and set From and To first, then export.
Export breaks
One row per break.
| Column | What it holds |
|---|---|
id | The break's number. |
started_at, ended_at | When it started and ended. |
requested_break_seconds | The length pressed. |
actual_break_seconds | How long it ran. |
state | Its state when exported. |
used_pod, used_slate | Whether a pod or the slate was used. |
interrupted_manually | Whether someone pressed Return to live. |
operator_id | Who ran it, as a number. The spots export has names. |
failure_reason | Why it failed, if it did. |
Export spots
One row per spot in each break, including spots that were skipped and the slate. Use the result column to keep only what aired.
| Column | What it holds |
|---|---|
break_id, break_started_at | The break the spot was in. |
operator | Who ran the break, by name. |
position | Its place in the break. |
type | Spot or slate. |
spot, advertiser, file | What it was. |
planned_seconds, actual_seconds | How long it was meant to run, and ran. |
result | Played or skipped. |
break_state, interrupted_manually | How the break ended. |
spot_started_at | When the spot started. |
For a sponsor, use the campaign report
The campaign report adds up plays and airtime per spot, and has its own export. See Use the campaign report.
Related guides
Proof for sponsorsRead proof of playEvery break and every spot, with times, who ran it, and how it ended.Proof for sponsorsUse the campaign reportPlays, airtime and plays by week for a campaign, against its targets.Proof for sponsorsShare a report with a sponsorA read-only link to one campaign's report. No sign-in for the sponsor.