Creative Testing Roadmap Template for Meta Ads

Build it as two tabs: a plan and a log. Every test then gets planned before it launches and judged after seven days.

A roadmap and a tracker are not the same thing

Most teams keep an ad creative test tracker: a list of ads, some spend, some ROAS. That tells you what happened. It does not tell you what to make next.

A roadmap sits in front of the tracker. It says which batches you will test over the next four to six weeks and why. Each batch is one concept inside one ad set. That one rule keeps results clean, because when the ad set wins or loses, you know the concept did it.

So the spreadsheet needs three tabs. A roadmap tab for what is planned. A log tab for what ran and the verdict. A hit rate tab that rolls the log up. The next two sections give you the columns for the first two.

Tab 1: the roadmap (plan before you film)

One row per batch. Number them in order (B001, B002, and so on) and never reuse a number. The number is what ties the plan to the result later.

Fill every column before anyone shoots anything. If you cannot fill one, the batch is not ready.

• Batch number and planned launch date.
• Product and campaign it will launch into.
• Concept in one sentence. What is the ad about?
• Core desire. What does the buyer want that this product gives them?
• Angle. The way you frame that desire, such as relief from a pain, a before and after, or a comparison with the usual fix.
• Awareness stage. Does the viewer know the problem, know the solution, or know your product?
• Format. UGC talking head, static, demo, split screen, and so on.
• Creator or editor responsible.
• Hypothesis. One line: we think this wins because...
• Proof for any claim. A review, a test, a number you can show. If there is none, mark it as an assumption.
• Status: idea, briefed, in production, live, judged.

Tab 2: the test log (what ran and what it earned)

One row per batch again, same number. The log is where the roadmap row gets its results and its label.

Start with the ad names. A name like B014_Sleep_Relief_ProblemAware_UGC_Maya_V1 packs the batch, desire, angle, awareness stage, format and creator into one string. Exports from Ads Manager then split back into your columns with no guesswork. Pick the pattern once and never change it mid-quarter. A sloppy name is the most common reason a result cannot be traced to its batch.

Then log the numbers at day 7, not before:

• Spend of the batch over its first 7 days.
• Share of the campaign's spend that went to the batch.
• Campaign spend per day this week versus the week before.
• ROAS of the batch, and the campaign's own ROAS for the same days. Use target CPA instead if that is how you run the account.
• Verdict, from the rule in the next section.
• What we learned, in one sentence, and what the next batch should do about it.

The 7-day verdict rule

Without a written rule, verdicts drift. A batch with a nice ROAS on little spend gets called a winner. A batch that ate the budget gets called a loser because someone had a bad Monday. Write the rule once, per campaign, and apply it the same way every time.

Here is the one Hitrate uses. A big share of spend means 30% of a campaign that spends under $1,000 a day, 20% under $5,000 a day, and 10% above that. Change the numbers if your account needs it, but write them down.

Then give each batch one label after 7 days:

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

One worked example (numbers are illustrative)

Say a campaign spent $14,000 this week, which is $2,000 a day. Last week it averaged $1,800 a day. Batch B014 took $3,500 of the spend.

The campaign sits between $1,000 and $5,000 a day, so a big share is 20%. B014 took 25%. The campaign grew 11% per day. B014 is a Scaler.

Now B015 in the same campaign: ROAS of 2.4 against the campaign's 2.0, but only 6% of the spend. That is Efficient. It earned a second look, not the trash. Give it a sharper brief or more budget in its own batch.

One more rule: a batch can still become a Scaler in week 2 or 3. Log the day-7 verdict, and keep the row open if the spend is still climbing. Do not rewrite history. Add a note.

Tab 3: hit rate by desire, angle, awareness and format

Hit rate is the share of tested batches that became a Scaler or a Spender. Both mean the algorithm gave the batch real money. Efficient batches are worth a note, but they are not hits yet.

Add a summary tab that counts hits and batches per desire, per angle, per awareness stage and per format. As an example only: 12 batches tested, 3 Scalers and 2 Spenders, gives a hit rate of 5 of 12, or 42%.

The totals matter less than the splits. If most hits come from one desire and one awareness stage, your next four batches should lean there. If a format has six tests and no hits, stop briefing it until you change something. This is how the next brief starts from what sold instead of from the loudest opinion in the room.

Mistakes that make these spreadsheets die

Mixing concepts in one ad set. You cannot read the verdict if three ideas share it.

Naming ads by hand, differently each week. Results stop mapping back.

Judging on day 2. Judge at day 7 by the written rule.

Skipping the verdict because the batch looked mediocre. Misses teach as much as wins. A blank verdict column is a lost lesson.

No owner for the log. If someone fills it in on Fridays when they remember, half the tests never get a verdict. Assign the update to one person and one day.

Claims with no proof. Mark each line proven, likely or assumption in the brief. Then you can see whether a loss came from the idea or from a claim nobody believed.

Where Hitrate fits: it plans each test as a numbered batch, writes the ad names for you so results map back, syncs results daily from Meta, read-only, and labels each batch after 7 days by the rule above. The hit rate splits are built from those labels. If you are not connected to Meta yet, you can import an Ads Manager export. The spreadsheet works. This just removes the Friday chore.

Related guides

• Facebook ads naming convention: a copyable template
• UGC creative brief template you can send to creators today
• Creative brief template for Facebook ads (with a worked example)
• Ad Creative Analysis Template for Meta Ads

Updated 2026-10-02