Advertising delivery reconciliation history: what to inventory before an ad platform replacement

Short answer

Before an ad platform replacement, inventory the records that explain each advertising delivery reconciliation: line-item delivery reports and event logs in the ad server, the placement terms in the order system that define which impressions count, the discrepancy and invalid-traffic adjustments finance applied, and the makegoods or credits advertisers accepted. For each, note the system, the years covered, who owns it and the date the old platform's history stops being reachable. Then introduce the executive who can authorize a data discussion.

Visual briefFull-size diagram
A replacement timeline from inventory to go-live to old contract end, with six reconciliation record classes sorted into those that move to the new ad platform and those that stay behind unless the company decides otherwise.
Illustrative inventory for a fictional publisher. Which records move depends on the company's own migration plan.

What should be inventoried before an ad platform replacement affects advertising delivery reconciliation history?

Record classes, time coverage, system owners and the real access deadline. A replacement usually moves open orders and active line items. Closed campaigns, their delivery logs and the reasoning behind billing adjustments are the history most likely to stay behind.

Record classUsual homeWhy it may not moveAsk the operations director
Delivery reports and event logs by line itemAd serverOnly live line items migrateHow many years of closed campaigns can still be reported on?
Insertion orders and placement termsOrder systemSigned orders sit outside the ad serverAre placement lists, flight dates and caps stored as fields or as PDFs?
Third-party and verification reportsShared drive, emailNever part of a platform migrationAre they filed against the order or the campaign name?
Discrepancy and invalid traffic adjustmentsBilling spreadsheet, finance systemTreated as finance, not ad opsIs each adjustment tied to a line item and a reason?
Makegoods and creditsAd server, order system, emailOften booked as new line itemsDoes each makegood point back to the original?
Advertiser correspondenceAccount managers' mailboxesPersonal mailboxes have their own retentionWho keeps the thread where the remedy was agreed?

A partner collects answers, not files: no logs, orders, exports or logins. Do not suggest retaining data beyond the company's retention policy, its advertiser contracts or the authority of the person asking.

Why does reconciliation history fall out of a platform migration?

Because reconciliation is a join across systems, and migrations are planned one system at a time. The ad server team moves what the new platform needs to serve ads tomorrow. Finance keeps its own adjustment workbook. Account managers keep the advertiser threads. Nobody owns the link between them.

Three details make the history fragile:

  • Counts depend on settings. Google's Ad Manager help notes that its counts and third-party counts can differ, and that reports should cover the same date range, time zone and line items before they are compared. A delivery report re-run later on a new platform, with different defaults, may not reproduce the figure the advertiser was billed on.
  • Billing figures settle after the fact. For reconciliation, Google recommends its Billed impressions metric over the billing URL ping, which fires before invalid-traffic and discrepancy adjustments, and suggests generating reports a few days after activity. The number that mattered is the settled one, so ask where settled figures were saved.
  • Makegoods live as separate line items. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details. If only the makegood line migrates, or neither does, the connection between shortfall and remedy disappears.

Invalid traffic adjustments add one more field worth asking about. The Media Rating Council distinguishes General Invalid Traffic, found through routine list-based filtration, from Sophisticated Invalid Traffic, which needs advanced analytics or significant human intervention. Whether the company recorded which kind it removed is a useful metadata answer, and it costs nothing to ask.

An illustrative inventory sheet

Illustrative only; the publisher and figures are fictional. A 180-person regional news and events publisher is replacing its ad server and order system within one financial year. Its ad operations director fills in the sheet in a single meeting, from memory and the migration plan, without opening any records.

Record classSystemYears heldOwnerMoves to new platform?Reachable until
Line-item delivery reportsLegacy ad server2016 to nowAd operations directorOpen line items onlyOld ad server contract end
Placement termsOrder management system2015 to now, PDFs before 2019Sales operationsActive orders onlyOrder system cutover date
Verification reportsShared drive2018 to nowAd operationsNoShared drive is kept
Discrepancy and invalid traffic adjustmentsFinance workbook2017 to nowBilling managerNoFinance retention policy
Makegoods and creditsAd server and order system2016 to nowAd operations directorNoOld ad server contract end
Advertiser threadsAccount managers' mailboxesVaries by personCommercial directorNoMailbox retention for leavers

Reading the sheet: the history most likely to be lost is the makegood link and the settled delivery figure, both tied to the old ad server contract end. The sheet also shows the export question to test before go-live: can closed line items and their makegood references be exported with their IDs intact? The answer comes from the company's own test, not from a vendor's general claim. Contract rights to get data out are covered in SaaS data export rights.

Which dates set the real access deadline?

Use the company's own documents, never an assumed date. Three dates usually matter: the new platform go-live, the date the old ad server contract ends, and the date the order system is switched off or set read-only. Add the date report exports were last tested. If none of these is written down, there is no deadline yet, and the right next step is for the company to fix one, not for a partner to invent urgency.

Ask the advertising operations director about coverage and rights

The ad operations director usually knows coverage; rights sit higher. Insertion orders often carry advertiser confidentiality terms, and campaign rates are commercially sensitive, so the company's counsel decides what could ever be licensed and what would need removing or de-identifying first. The person who can authorize a licensing discussion is the CEO, with the CFO or commercial director often preparing the case.

The company baseline is 50+ full-time employees at peak (contractors excluded), documented operating history, rights to license and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English. Unknown until SourceX reviews it: whether the records match a dataset need, the rights review result and any terms. Partners sign the Channel Partner Agreement before submitting introductions; attribution goes to the first valid introduction within the 90-day window. Related record patterns are on the reconciliation exceptions data page, agency clients on marketing agencies, and other sectors on the industries hub. If records were ever sent to the wrong vendor, see sensitive data accidentally shared with a vendor.

Go deeper on advertising delivery reconciliation

Next step

Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If a publisher client is replacing its ad server and the inventory shows years of reconciled campaigns that will not be migrated, register as a partner, check the company against who qualifies and read the program terms before you introduce its decision-maker.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardthe greater of $50,000 plus 5% and 15% of the actual supplier payout, with no cap. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Are advertiser names and campaign rates a problem for licensing?

They are sensitive, and insertion orders often carry confidentiality terms. SourceX's rights review decides what can be included and what must be removed or de-identified before anything is licensed. The partner never needs to see them.

Does a makegood count as an exception if the advertiser was happy?

Yes. The accepted makegood is the documented resolution of a delivery exception. The useful record is the full sequence: what was reported, what was removed and why, what was offered and who accepted it.

Is invalid traffic the only kind of ineligible inventory?

No. Impressions can also fall outside the contract because they ran on placements, sites, geographies or dates the order did not include. Each kind leaves different evidence, so ask how the team classified them.

Sources

  1. support.google.com/admanager/answer/9659935
  2. developers.google.com/ad-manager/api/reference/v202502/ProposalLin…
  3. support.google.com/admanager/answer/6160380
  4. support.google.com/authorizedbuyers/answer/13531755
  5. mediaratingcouncil.org/sites/default/files/Standards/IVT Addendum U…
  6. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 70% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment