Ad platforms report media costs and their own conversions. They may not show which leads the advertiser approved, how much software cost or when payouts actually arrived. A separate tracking sheet is needed to connect spend, approved outcomes and operating costs. A media buying spreadsheet should separate Meta Ads and Google Ads spend while connecting both to advertiser-approved payouts.
Columns to include
Create one row per date, campaign, traffic source, geography and offer. Record currency and owner. Add impressions, clicks, media spend, submitted leads, reviewed leads, approvals, payout per approval, revenue, additional expenses and net contribution.
Keep pending leads separate from approved ones. When validation takes days, record the lead date and approval date independently.
CPC = media spend / clicks. CTR = clicks / impressions × 100%. Click-to-lead conversion rate = submitted leads / clicks × 100%. Approval rate = approved / reviewed leads × 100%, where reviewed includes both approved and rejected outcomes.
Revenue = approved conversions × payout. Profit = revenue − media spend − other expenses. ROI = profit / total costs × 100%. Display an empty result when a denominator is zero or missing.
A worked example
A campaign spends $240 and produces 60 leads. Forty have been reviewed: 28 approved and 12 rejected. At $12 per approval, revenue is $336. Creative and tool expenses add $36. Profit is $336 − $240 − $36 = $60, giving approximately 21.7% ROI on $276 in total costs. Approval rate on reviewed leads is 70%; twenty leads remain pending.
Avoid misleading reporting
Separate accrued revenue from cash received. A payment delay affects cash flow but is not, by itself, proof that campaign economics are negative. Track holds, refunds, processing fees and currency effects separately.
For multiple markets and channels, use filters or pivot tables instead of copying totals manually. Formula cells should always reference underlying records.
Useful worksheet tabs
Organize the file into Raw Data, Approvals and Payments, Operating Costs, Campaign Summary and Decision Log. The last sheet records why a campaign was stopped or scaled.
Extra spreadsheet columns for Facebook and Google
Add platform, campaign type, campaign name, ad group/ad set IDs, creative ID and geography. For Meta Ads, track Facebook or Instagram placement and Pixel/Conversions API results alongside spend. For Google Ads, include campaign type, ad group, search term or inventory type, conversion action and spend. Do not average CTR across incomparable formats without consistent definitions and weighting.
Use one verified advertiser-approved conversion field and separate cost-per-payable-action and operating-cost fields for financial ROI. Preserve platform-attributed conversions in separate columns for diagnostics. A user can interact with both channels and be credited twice, so reconcile lead IDs or an agreed attribution model instead of adding dashboard totals.
Final reconciliation
Compare platform costs with payment charges, tracker events with affiliate network approvals, and dates and currency consistently. A verifiable sheet is more valuable than an attractive dashboard built on unreliable numbers.