Insertion order reconciliation
Compare contracted media commitments with actual delivery and resolve gaps.
Replaces: the month-end spreadsheet matching IOs to delivery reports
Brightline Media Partners · Insertion order reconciliation
Insertion order reconciliationBrightline Media Partners
Teresa VaughnMedia operations managerTV
- Open IOs
- 18
- Across 9 publishers and 4 clients
- Underdelivered
- 3
- Outside the ±5% tolerance
- Reconciled
- 12
- Matched or variance accepted
| Order | Client | Contracted | Delivered | Variance | Status |
|---|---|---|---|---|---|
| Calloway Health | 1,200,000 imps | 984,000 | -18% | Gap | |
| Lakeshore Credit Union | 8 sends | 6 sends | -25% | Gap | |
| Oakmont Auto Group | 3,000,000 imps | 2,760,000 | -8% | Gap | |
| Calloway Health | 1,800,000 downloads | 1,512,000 | Held | Check | |
| Oakmont Auto Group | 900,000 imps | 412,000 mapped | Unmapped | Unmapped | |
| Lakeshore Credit Union | 400,000 imps | 401,250 | +0.3% | Matched | |
| Oakmont Auto Group | 500,000 views | 512,400 | +2.5% | Matched | |
| Oakmont Auto Group | 750,000 imps | 697,500 | -7% | Variance accepted |
Showing 8 of 18 open IOs
Ran today at 6:00 AM
- Pulled delivery for 18 open IOs from Supermetrics and publisher reports in Google Drive
Runs on its own
Reconciles open orders on a schedule
On a schedule it refreshes delivery for open orders, reconciles each line item against its contract terms and tolerance, and opens a case for every variance.
Waits for you
Contract terms it isn't sure about
Contract terms it isn't sure about wait for you to confirm, as do ambiguous mappings. Credits and make-goods stay proposals until you approve them.
Works with
Google Drive
Dropbox
Google Sheets
Supermetrics
What it keeps track of
- Insertion order
- Publisherclientcontract revisionflight
- Line item
- Unitratequantitytolerance
- Mapping
- Line itemreport campaignconfirmed by
- Delivery snapshot
- Sourcedateunits delivered
- Variance case
- Gapvalueevidenceresolution
