Sponsorship Campaign Tracker: Fields and Workflow

Inventory describes an opportunity that may be considered more than once: publisher, channel, audience, niche, format, list price, reach evidence, response evidence, contact, and notes. A deal describes a specific commercial attempt: selected slot, proposed price, stage, owner, tentative run date, negotiated terms, creative, and result.

Keeping these records separate avoids overwriting history when a publisher updates its rate card or when you run a second placement. The current inventory can show the latest offer while each completed deal preserves the conditions that actually applied at the time.

A practical pipeline can use prospect, contacted, negotiating, booked, live, completed, and declined. Define what must be true before a deal moves. This keeps the board from becoming a collection of hopeful labels and makes the next action visible.

Prospect means the slot has enough audience and pricing information for an initial model. Contacted means a request or proposal is with the publisher and has a follow-up date. Negotiating means inventory, price, or terms are actively being resolved. Booked requires written deliverables and a confirmed run date. Live means the placement is delivered or in its delivery window. Completed requires results captured through the agreed initial attribution window.

Store the inputs used to approve the placement: relevant audience, open or consumption rate, sponsor response rate, your conversion rate, customer value, media cost, incremental costs, projected acquisitions, projected CAC, and projected ROI. Add conservative, expected, and upside cases when uncertainty is meaningful.

Freeze the approved forecast rather than recalculating history every time a planning assumption changes. Later, put actuals beside the original figures. This turns variance into a learning tool: you can see whether delivery, response, conversion, or customer value caused the campaign to differ from plan.

Record agreed price, payment status, cancellation and rescheduling terms, category exclusivity, make-good conditions, placement position, included extras, and reporting deadline. Attach or link the insertion order, invoice, publisher proof, and final assets. Important terms should also be summarized in searchable fields rather than trapped only in a PDF.

For production, record asset owner, publisher contact, copy and creative deadlines, approval status, destination URL, UTM values, vanity URL or code, and final proof. Test the link and conversion path before the asset cutoff. A launch checklist is valuable precisely because broken tracking can make a well-delivered placement impossible to evaluate.

Record the channel's delivery measure first: delivered emails and opens, episode downloads, served impressions, page views, or video views. Then record sponsor clicks or attributable visits, conversion events, qualified or paid customers, attributed value, and all-in spend.

Calculate realised CPC when clicks are meaningful, realised CAC from acquired customers, and ROI from attributed value. Keep direct, promotion-code, self-reported, and assisted results distinguishable so the tracker does not double count or blend confidence levels. Add qualitative notes about editorial context, publisher execution, creative, and audience feedback.

At the end of the initial attribution window, verify the publisher report, fill every actual field, explain major variance, and assign a decision: repeat, retest with a stated change, hold, or do not repeat. A repeat recommendation should include the maximum acceptable price and what must stay true about format or audience.

Schedule later cohort checks based on the product's sales and retention cycle. Update paid conversion, activation, revenue, refunds, and retention without overwriting the initial snapshot. Review aggregated results by publisher, format, audience niche, creative angle, and acquisition cohort so repeated evidence improves future forecasts.

A tracker earns its keep when a new opportunity can be compared with past realised economics in minutes. Archive records rather than deleting misses; failed campaigns often contain the clearest constraints for the next buy.