Advertising Spend Tracker

About this template

When to use it

One media buy per row — what ran, where, for how long, what it was budgeted at and what the invoice actually said. Three sheets — Dashboard, Input data, Usage guide — and only Input data is typed into. The subtitle in B3 describes the template, so put your campaign or period there instead.

What the dashboard holds

Key metrics in B7:E7 — rows entered, Spend total, Spend average, Spend max — read column F of Input data. Summary by media in B12:F18 groups the same column by the media name in column C, one row per platform. The Monthly spend (KRW m) table (B22:C25) is typed in by hand.

Filling order

1. Rows 2–21 of Input data take Spend No., Campaign / Creative, Media, Run dates, Planned spend, Spend, Impressions, Clicks, Notes (A–I). Eight sample rows ship, AD-2606-01 to AD-2606-08.
2. Planned spend (column E) is the approved budget for that platform; Spend (column F) is only what the media owner’s tax invoice shows (note 5). If agency fees are inside the invoice figure, say so in Notes.
3. The media names on the Dashboard are Naver Search, Kakao Display, YouTube, Meta, Instagram, Google Search, Partner media (B12:B18). Those cells are the criteria, so a new platform needs both a new Input data value and a new summary row.
4. Copy Impressions and Clicks straight from the platform console for the same dates (note 7). Do not mix a 30-day platform figure with a 21-day buy.
5. Replace the four monthly figures (Mar–Jun: 38 · 42 · 47 · 60, in millions of KRW) with your own.

How the formulas calculate

• =COUNT(‘Input data’!$F$2:$F$21) counts buys that carry a spend figure.
• The media block is =COUNTIF(‘Input data’!$C$2:$C$21,$B12), =SUMIF(‘Input data’!$C$2:$C$21,$B12,’Input data’!$F$2:$F$21) and the matching AVERAGEIF, with a share of =IFERROR(C12/COUNT(‘Input data’!$F$2:$F$21),0).
• Under the monthly table, =SUM(C22:C25) and =AVERAGE(C22:C25) — 187 and 46.75 as shipped.
• Nothing compares Planned spend with Spend. The one figure a budget owner wants is not on the sheet, so add it: =SUM(‘Input data’!$E$2:$E$21)-SUM(‘Input data’!$F$2:$F$21), or per row =IFERROR(F2/E2-1,””) formatted as a percentage.
• Cost per click is not calculated either. =IFERROR(F2/H2,0) gives it per row — row 2 works out at KRW 467, which is what its Notes cell already says.
• The ranges stop at row 21; widen $C$21 and $F$21 when you add a ninth month of buys.

Know this first

The summary matches media names as exact text. “Naver” and “Naver Search” are two different platforms as far as COUNTIF is concerned, so a single inconsistent row silently disappears from its own line and the shares stop adding up (note 6). Agree the seven names once, and if you need an eighth, insert a summary row and copy the four formulas across rather than overwriting an existing label.

Examples

• Row 2 — AD-2606-01 · Summer product launch / search keywords · Naver Search · 2026-06-01~06-30 · planned 12,000,000 · spend 11,480,000 · 1,842,000 impressions · 24,600 clicks.
• The eight shipped buys were budgeted at 62,000,000 and spent 59,710,000, so Spend average reads 7,463,750 and the max 14,250,000.
• Naver Search carries two of the eight rows, so its share cell shows 25.0% and its spend total 14,740,000.
• The Meta row is the one overspend — 6,340,000 against a plan of 6,000,000, which is what “340,000 over plan” in Notes refers to.

Common mistakes

• Entering the agency’s invoice rather than the media owner’s, so the same money is counted twice.
• Typing “11.48M” or “KRW 11,480,000” into column F. Text drops out of every metric.
• Pulling impressions for the platform’s default 30-day window on a buy that ran for three weeks.
• Adding a platform to Input data and forgetting to add its row to Summary by media.