Ad Creative Analysis Template for Meta Ads

Most creative tests never produce a learning anyone can reuse. This template fixes that with one row per batch, one verdict rule and one short entry per test.

Track batches, not single ads

The usual sheet has one row per ad. That is why it tells you nothing. One ad is a coin flip. It can win because of a lucky audience pocket, a weak competitor week or a quirk in delivery.

Group the test instead. A batch is one concept in one ad set: one desire and one angle, shown in a few creative variations. Number it (Batch 14, Batch 15). The batch is the unit you judge, and the unit you learn from.

This gives you a clean question for every test: did this idea work? It is a better question than which of these six videos got the lowest CPA.

The columns your template needs

Keep it to the fields you will actually fill in. Every column below earns its place because you will slice results by it later.

Setup columns, filled in before launch:

Batch number and launch date
Campaign the batch runs in
Concept, in one sentence
Desire: the thing the buyer wants (for example, sleep through the night)
Angle: the way you argue for it (for example, cost per night versus a bad mattress)
Awareness stage: problem-aware, solution-aware, product-aware and so on
Format: UGC talking head, static, demo, founder video
Creator or editor who made it
Hook and promise, in the exact words used

The result columns, filled in at day 7

Result columns are where most sheets go wrong. They list spend, ROAS and CPA for the ad, and stop. That is not enough to judge anything, because ROAS means different things in different campaigns.

Add the context that makes the number readable:

Batch spend and its share of the campaign's spend
Batch ROAS (or CPA) next to the campaign's own ROAS that week
Campaign daily spend this week versus the week before
Verdict: Scaler, Spender, Efficient or Miss
One-line learning
Next action: iterate, scale, retest or kill

Copy this learnings entry

Paste one block per batch into your sheet or doc and fill every line before you close the batch.

Batch: # / launch date / campaign
Concept: one sentence
Desire: / Angle: / Awareness stage: / Format: / Creator:
Hook and promise: the exact words used
Day-7 numbers: batch spend, share of campaign, batch ROAS vs campaign ROAS, campaign daily spend vs last week
Verdict: Scaler / Spender / Efficient / Miss
Learning: one claim that could be wrong
Confidence: proven / likely / assumption
Next action: iterate / scale / retest / kill, with a date
Brief change: what the next brief does differently because of this

Stop filling in the tracker on Fridays

14 days free, no card. $299 a month after that, every feature and every teammate included.

Plan your first batch

Give every batch a verdict after 7 days

A learning needs a verdict, and a verdict needs a rule written down before the results come in. Otherwise the loudest person in the meeting decides.

Here is the rule Hitrate uses, per campaign. First, work out whether the batch took a big share of its campaign's spend. A big share is 30% of a campaign under $1,000 a day, 20% under $5,000 a day, and 10% above that. Then use these four labels:

Scaler: a big share of spend, and the campaign spent at least 10% more per day than the week before. Spender: a big share, but no growth. Efficient: beat the campaign's own ROAS but got little spend. Miss: neither.

An example, with made-up numbers. A campaign spends $2,000 a day, up from $1,700 the week before. That is growth of about 18%. Batch 14 takes $560 a day, which is 28% of the campaign and above the 20% bar for that size. Batch 14 is a Scaler. If the campaign had stayed flat at $1,700, it would be a Spender.

Judge on ROAS against the campaign's own baseline, or on a target CPA if that is how you buy. Do not compare a prospecting campaign's ROAS with a retargeting campaign's. And let a batch earn its label later: a Miss at day 7 can still become a Scaler in week 2 or 3. Change every threshold to fit your brand, but change it once and write it down.

Roll up to hit rate by desire, angle, awareness and format

Single verdicts are useful. Patterns are where the money is. Once you have 15 to 20 batches, count your hit rate: the share of tested batches that became a Scaler or a Spender.

Then split that number four ways: by desire, by angle, by awareness stage and by format. A table with four small tabs is enough.

The split tells you things a single winner never will. Maybe the cost angle hits often on one desire and never on another. Maybe problem-aware batches carry the account while product-aware ones sit at Miss. Maybe one format wins only when a certain creator makes it. These are the findings that shape next month's briefs.

Treat small counts with care. Two batches of one angle with one hit are a hint, not a law. Mark it as a hint until you have run more.

Write a creative learnings document people will read

A creative learnings document fails when it becomes a diary. Nobody reads 40 pages of what happened. Keep one entry per batch, no longer than five lines, and sort the entries by desire so a strategist can find what they need before writing a brief.

Each entry holds the setup, the verdict, the reason you believe it and the next move. Mark how sure you are: proven (seen in several batches), likely (one clear result) or assumption (no result yet). That habit alone stops a single lucky test from turning into brand doctrine.

Write the learning as a claim that could be wrong. 'UGC works' is useless. 'Problem-aware UGC with a cost hook beat the campaign ROAS in two of three batches' is something you can test again. Copy the entry format in the checklist below.

A weekly page for creative reporting on Meta ads

For creative reporting on Meta ads, one page a week is plenty. Anyone who needs more than a page is hiding something in the detail.

Put these on it, in this order:

Batches that reached day 7 this week, each with its verdict
Batches still running, with days left
Hit rate for the last 8 to 12 weeks, split by desire and angle
The one decision: what gets iterated, scaled or stopped
Next week's batches, with the question each one answers

Questions

What should an ad creative analysis template include?

One row per batch with its desire, angle, awareness stage, format and creator. Add spend share, ROAS against the campaign's own baseline, a verdict, a one-line learning and a next action. Without the setup fields you cannot slice results later.

Why group ads into batches instead of analyzing each ad?

A single ad is too noisy to teach you anything. A batch is one concept in one ad set, so the result answers whether the idea worked. That is the question your next brief needs answered.

How long should I wait before calling a creative test?

Seven days is a good default, and the rule should be written before the test starts. A Miss at day 7 can still become a Scaler in week 2 or 3, so keep an eye on late movers rather than deleting them.

How do I measure whether a batch won?

Compare it with its own campaign. Check whether it took a big share of the spend and whether the campaign grew its daily spend by at least 10% week on week. Use ROAS against the campaign baseline, or a target CPA if that is how you buy.

What is hit rate and why does it matter?

Hit rate is the share of tested batches that became a Scaler or a Spender. Split it by desire, angle, awareness stage and format and it shows where your wins come from. That tells you what to brief next.

Can I run this in a spreadsheet?

Yes. The template works in any sheet if you keep the naming strict and fill the verdict on day 7. Hitrate takes over the parts that break first: it writes the ad names, syncs results daily from Meta (read-only) and applies the label by the written rule. If you are not connected yet, you can import an Ads Manager export.

How often should I update the creative learnings document?

Once a week, when batches reach day 7. Add one entry per finished batch and update the confidence mark on older entries if new results back them up or contradict them.

Related guides

Stop filling in the tracker on Fridays

14 days free, no card. $299 a month after that, every feature and every teammate included.

Plan your first batch

Updated 2026-10-02