Content Performance Tracker

About this template

When to use it

One published piece per row, with the numbers you read back at a fixed point after publishing. Three sheets — Dashboard, Input data, Usage guide — and only Input data is typed into. The subtitle in B3 describes the template, so replace it with your channel or quarter.

What the dashboard holds

Key metrics in B7:E7 — rows entered, Views total, Views average, Views max — read column E of Input data. Summary by channel in B12:F16 groups the same column by the channel in column C. The Content published per month table (B20:C23) is typed in by hand and does not count rows for you.

Filling order

1. Rows 2–21 of Input data take No., Content title, Channel, Issue date, Views, Clicks, Conversions, Avg. dwell (sec), Notes (A–I). Eight sample rows ship and rows 9–20 are pre-numbered.
2. Decide once how long after publishing you take the reading — note 7 suggests publish + 14 days — and write that rule in Notes so a two-day-old post is never compared with a two-month-old one.
3. The channel labels on the Dashboard are Blog, YouTube, Newsletter, Instagram, LinkedIn (B12:B16). Those cells are the criteria the summary matches on.
4. Copy views, clicks and conversions straight from each platform’s analytics screen for the same window (note 5). One estimated row makes the whole channel comparison unusable.
5. Replace the four monthly counts (Mar–Jun: 14 · 17 · 21 · 26) with your own.

How the formulas calculate

• =COUNT(‘Input data’!$E$2:$E$21) counts pieces that carry a view figure.
• The channel block is =COUNTIF(‘Input data’!$C$2:$C$21,$B12), =SUMIF(‘Input data’!$C$2:$C$21,$B12,’Input data’!$E$2:$E$21) and the matching AVERAGEIF, with a share of =IFERROR(C12/COUNT(‘Input data’!$E$2:$E$21),0).
• Under the monthly table, =SUM(C20:C23) and =AVERAGE(C20:C23) — 78 and 19.5 as shipped.
• Only views are summarized. Columns F, G and H are captured but never aggregated, which matters because views flatter video and starve a newsletter. Add the ratios you actually manage on: =IFERROR(F2/E2,0) for click-through and =IFERROR(G2/F2,0) for conversion, both formatted as percentages.
• The ranges stop at row 21. A 21st piece is not counted until you widen $C$21 and $E$21.

Know this first

Column D is headed Issue date, and it is the date the piece went out, not the date you took the reading — the reading date is the rule you wrote in Notes. Ranking by Views alone will always put the video channels on top: the shipped data has YouTube at 66,400 views against the newsletter’s 12,800, yet the newsletter converted 132 readers against the videos’ 200 from five times the audience. Read the Views summary next to your own click-through and conversion columns rather than on its own.

Examples

• Row 2 — 1 · How to use the summer product line · Blog · 2026-06-02 · 18,400 views · 1,240 clicks · 96 conversions · 214 sec · 72% from search.
• The eight shipped pieces total 159,700 views, so Views average reads 19,963 and Views max reads 42,600.
• Blog holds three of the eight rows, so its share cell shows 37.5% and its view total 42,700.
• Avg. dwell separates formats sharply: 412 seconds on the live replay against 32 on the Instagram carousel.

Common mistakes

• Coining a channel name — “YouTube Shorts”, “Blog (KR)” — which counts in no summary row.
• Refreshing views for older rows but not newer ones, so the average drifts upward with age.
• Putting “18.4K” in column E. It becomes text and leaves the total.
• Judging a channel on Views when the goal was leads.