Free editable template

Liquid I.V. ad teardown: subscription maths and two-lane ad template

See why Liquid I.V.'s longest-running ads sell the reorder, then check the same lane pays for you. The Excel workbook holds the real Liquid I.V. counts (ages, formats, creators, offer words, opening lines), an ad log and summary to read any competitor, and a subscription maths sheet that compares 12-month gross profit for a one-time buyer and a subscriber at your price, margin and discount.

By GaaS editorial · Sources checked · 5 worksheet rows

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.

StartedDays running (to 17 Nov 2026)Format
23 Sep55Video
23 Sep55Image
1 Oct47Image
1 Oct47Image
8 Oct40Image

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

Continue the work