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
Start from the Jones Road snapshot
408 live US ads on 17 Nov 2026: 235 started on 16 Nov, nothing older than 16 days. 1 says '% off'; none mention free shipping or a free gift. 98 mention the holidays, 93 say 'sold out' or 'limited'.
Copy the system, not the ads
A customer's sentence as the first line (real words, with permission), one product per ad, the objection said out loud, urgency without a discount, and the batch launched in one go.
Plan the batch
Voice lines x products x formats gives the batch size; with your target CPA and minimum spend per variant the sheet works out the test budget and the daily spend over 14 days.
Judge it at day 14
Type spend and purchases for each variant. Each is marked keep and make versions, kill, or too early to judge. Then read a competitor the same way in the ad log.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Opening line | Live ads | What it does |
|---|---|---|
| Not gonna lie, these might be gifts I end up keeping fo… | 47 | Gift angle in a customer's words |
| The Foundation Stick delivers real coverage while feeli… | 30 | One product, one result |
| Some days I don't want to fuss with foundation, but I s… | 24 | Starts from the customer's lazy day |
| Okay, the before and after?? This concealer and neut… | 17 | Sounds like a text; points at proof |
| Foundation sticks have a reputation—formulas that settl… | 16 | Says the objection first |
Worked review example
Real Jones Road data, 17 Nov 2026: 408 live US ads; 235 started 16 Nov, 76 on 1 Nov, 53 on 5 Nov. 355 run from its own Page; 53 are partnerships (Emily DiDonato 14, Forbes 8).
Fictional batch: 24 variants at a $35 target CPA, judged after $52.50 each, need $1,260 (about $90 a day for 14 days). Of the first 12, 4 are keepers, 3 kills and 5 too early.
What this template does and does not establish
Jones Road data was read from the public Meta Ad Library (US, active ads) on one day, 17 November 2026, 10 days before Black Friday; a discount could still go live closer in. Outside the EU the library shows only running ads and no spend or results. Keyword counts are text matches. Batch planner numbers are fictional.
Primary references
- Meta Ad Library: Jones Road Beauty Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
