Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Set the rule and pace
On Settings, keep the default (a new ad must change at least 2 of 5 lines) or raise it, and type your monthly budget, testing share (Meta suggests 20–30%) and how many new ads you can make a week.
Tag your live ads
On the Ad audit tab, one row per live ad (up to 40): ad set, angle, format, person, first 3 seconds and look, in short consistent words. Each ad gets the number of lines it differs from its closest ad, that twin's name, and NEAR-DUPLICATE or DISTINCT.
Read the coverage
Distinct values per line with a chart, distinct ideas, near-duplicates, ad sets in use, the gap to 20 different ads, your weekly test spend per new ad and the weeks to close the gap.
Check every new ad
Answer six Yes/No questions on the New-ad checklist. GO needs at least 2 of the first 5 lines changed and the ad going into the broad ad set in this week's batch.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Line | What it is | Examples |
|---|---|---|
| Angle | The reason to buy: the message | Pain, proof, offer, story, comparison, myth |
| Format | The container | Talking head, static, carousel, demo, screenshot |
| Person | Who's on screen | Founder, customer, creator, expert, no face |
| First 3 seconds | The opening shot and line | A new hook, not the same hook in a new colour |
| Look | Production style | UGC, studio, lo-fi phone, screenshot |
| Different enough? | Lines different from the closest live ad | Default: at least 2 of 5 |
| One broad ad set | Structure | Combine ad sets; add new ads in one weekly batch |
| Distinct ideas | Unique mixes of angle, format, person and look | Target: Meta's 20 diversified ads |
Worked review example
Fictional skincare brand with 12 ads in 4 ad sets: 8 are the founder talking about acne with one of three opening lines, 2 are the founder reading reviews, 2 are static review cards. The audit finds 3 distinct ideas, 2 angles, 2 formats, 2 people and 3 hooks, and all 12 ads have a twin that differs on one line or none.
With a $9,000 monthly budget, 20% for testing and 4 new ads a week, that's about $104 of test spend per new ad and about 5 weeks to reach Meta's suggested 20 diversified ads.
What this template does and does not establish
Meta has not published how Andromeda treats similar ads or any similarity threshold; the two-line rule is our working rule built on Meta's 'themes, messages, and visuals' wording. The audit is only as good as your tags. Meta's 20-ad and 20–30% testing guidance was written for Advantage+ shopping campaigns in November 2024. Diversity is necessary, not sufficient: judge every ad on results.
Primary references
- Meta Engineering: Meta Andromeda (Dec 2024)
- Meta: The Creative Advantage (Apr 2025)
- Meta: Three steps to optimize with creative diversification (Nov 2024)
- Meta: Performance marketing
