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 AG1 snapshot
The first data tab holds what the Meta Ad Library showed on 17 November 2026: 572 live US ads, 467 of them partnership ads under a creator's name, the top creators (Ty Hill 26, Devon Collins 20, KC Andrews 18), the opening line on 382 ads, and how old every ad is (median 5 days).
Write one message for many faces
The Ad template tab breaks the AG1 ad into four parts: one message everyone repeats, many faces saying it, a reason to act now that is true, and the proof behind the product. Write your own version in the blank column with your own claims and creators.
Run a creator roster and judge it at day 14
List your creators and how many videos each makes. The sheet totals creator fees and the test spend needed. At day 14, type spend and purchases: each creator is marked re-brief, stop or too early, with cost per sale including the creator's fee.
Log any competitor the same way
Open their Page in the Ad Library (US, active ads) and log each live ad. Days running and age calculate from the check date, and the summary reads whether they replace ads fast or keep winners once you have logged 20 or more.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Started | Days running (to 17 Nov 2026) | Format |
|---|---|---|
| 22 Jul | 118 | Video |
| 12 Aug | 97 | Video |
| 26 Aug | 83 | Image |
| 26 Aug | 83 | Image |
| 1 Sep | 77 | Video |
| Mostly 12 to 16 Nov | Median 5 | Mostly video |
Worked review example
Real AG1 data, 17 Nov 2026: 572 live US ads, 535 video. 467 (82%) are partnership ads; seven creators carry 128 of them. 'Sold out after launch. It's back (for now).' opens 382 ads. 378 ads started in the last 7 days; the oldest, 118 days, is a military and first-responder offer.
Fictional roster: 8 creators make 16 videos at $150 each ($2,400 in fees) and need $1,080 of test spend at a $45 target CPA. At day 14, 2 creators earn a re-brief, 4 are stopped and 2 are too early to judge.
What this template does and does not establish
AG1 data was read from the public Meta Ad Library on one day, 17 November 2026 (US, active ads). Outside the EU the library shows only running ads, so days running are 'so far', not lifetime. The library shows no spend or results, so the counts show what AG1 runs, not what performs. 'Sold out' is AG1's own claim. Keyword counts are text searches. Roster numbers are fictional.
Primary references
- Meta Ad Library: AG1 Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- FTC: Bringing Dark Patterns to Light (2022)
