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 Liquid I.V. snapshot
On 17 Nov 2026 the US Meta Ad Library showed 103 live ads: median age 11 days, 84 two weeks old or less, 91 video, 23 creator partnerships. The 5 oldest (40 to 55 days) all sell 'subscribe and save 30%'.
Check the subscription pays
Type your price, margin, discount and how often one-time buyers and subscribers order in a year. The sheet compares 12-month gross profit and says whether a standing subscription ad is worth running.
Build the always-on lane
3 to 5 plain stills with the deal as the headline and a reason to belong. Show renewal terms and how to cancel as clearly as the discount.
Rotate the other lane
Product, flavour, season and creator ads in batches every couple of weeks, judged on cost per purchase.
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 |
|---|---|---|
| 23 Sep | 55 | Video |
| 23 Sep | 55 | Image |
| 1 Oct | 47 | Image |
| 1 Oct | 47 | Image |
| 8 Oct | 40 | Image |
Worked review example
Real Liquid I.V. data, 17 Nov 2026: 'Subscribe and save 30% on every order plus free gifts…' and 'Ready for hydration on auto-pilot?' 55 days; 'Put a ring on it, subscribe today and save 30%…' 47 days. 4 of the 5 oldest are still images.
Fictional maths: a $25 order at 65% margin. A one-time buyer (1.6 orders a year) earns $26.00 gross profit; a subscriber at 30% off (5 orders) earns $43.75, 1.7 times more. Break-even is about 3 subscriber orders a year.
What this template does and does not establish
Liquid I.V. data was read by hand from the public US Meta Ad Library on 17 Nov 2026; the header said ~150 and 103 distinct cards loaded. Outside the EU the library shows only running ads, and it shows no spend or results. 'Rotates every two weeks' is our reading of the age spread, not a Liquid I.V. policy. Subscription numbers are fictional.
Primary references
- Meta Ad Library: Liquid I.V. Page, active US ads (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- Liquid I.V. homepage (free shipping over $40, subscriptions page, checked 17 Nov 2026)
