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 Poppi snapshot
The first data tab holds what the US Meta Ad Library showed on 17 November 2026: 34 live ads, median age 13 days, oldest 191. 17 run under a creator's name, 29 are video, and none says '% off' or 'free shipping'.
Log a competitor the same way
Open their Page in the Ad Library with active ads and your country, and log each card's library ID, start date, format, caption voice, offer words and first line. Days running and age calculate from the check date.
Write captions with the template
The thing (one product or flavour), the moment (when it shows up in someone's day), the prompt (a question or playful instruction), and nothing else: no price, no percentage, no claim. Keep claims and offers in separate ads.
Audit every caption
Paste captions into the caption audit. It counts words and characters, checks for capital letters, offer words and a question, and gives a verdict: reads like a post, in between, or reads like an ad. It is a style check; judge the ads on results.
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 |
|---|---|---|
| 10 May | 191 | Video |
| 14 Aug | 95 | Video |
| 14 Aug | 95 | Video |
| 28 Sep | 50 | Image |
Worked review example
Real Poppi data, 17 Nov 2026: the three oldest live ads (191, 95 and 95 days) are lowercase, post-style captions with no claim and no offer. The fourth-oldest (50 days) leads with the '5g sugar' claim, Poppi's most repeated opener (4 ads).
Caption audit on Poppi's real openers: 'root beer poppi asmr anyone?!' reads like a post; 'Mouthwatering soda flavors with 5g sugar...' is in between (capital letters). A fictional '20% off every flavor this weekend only' reads like an ad.
What this template does and does not establish
Poppi data was read by hand from the public Meta Ad Library on one day, 17 November 2026, US view, active ads. Outside the EU the library shows only running ads, so days running are 'so far'. The library shows no spend or results. We read caption opening lines, not the spoken or on-screen content of videos, and did not record which Page runs each of the oldest ads. The caption audit is a style check, not a performance prediction.
Primary references
- Meta Ad Library: Poppi Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- Poppi homepage (product facts, checked 17 Nov 2026)
