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 Hims snapshot
428 live US ads on 17 Nov 2026: 0 say '% off', 0 mention Black Friday or a holiday, 195 mention free shipping, 88 GLP-1 or Wegovy. 405 run from Hims's own Page. Hims sells prescription care, which may shape how it promotes.
Copy the system, carefully
Proof in a true number, the name the buyer already knows, one outcome in plain words, a small first step, and friction removed instead of price cut. Check Meta's and your regulator's rules for health products first.
Run the offer calculator
Type your price, product and shipping cost, normal shipping fee, payment fees and discount. It shows profit per order before ads for no offer, free shipping and % off, and how many extra orders each needs to match no offer.
Read a competitor the same way
Log their live ads from the Ad Library and search their copy for '% off', 'free shipping' and 'Black Friday'. A brand that never discounts sells with something else; find what.
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 |
|---|---|---|
| Don't wait — join the hundreds of thousands of guys who… | 98 | Social proof |
| Get Wegovy® with Hims, plus access to provider-led care | 78 | Names the drug the buyer knows |
| The 2-in-1 pill to get harder, and go longer. Sex Rx +… | 56 | Two outcomes, one product |
| This is your sign to get a testosterone check. See if i… | 26 | A small first step |
| If traditional ED pills don't work for you, Hard Mints… | 19 | An alternative for people the usual option failed |
Worked review example
Real Hims data, 17 Nov 2026: 428 live US ads; median 8 days old, oldest 55 (23 Sep). 277 (65%) open with one of five lines.
Fictional offer: on a $60 order with $18 product cost and $7 shipping, free shipping costs $6.79 per order and needs about 20% more orders; 20% off costs $11.64 and needs about 41% more.
What this template does and does not establish
Hims data was read from the public Meta Ad Library (US, active ads) on one day, 17 November 2026, 10 days before Black Friday. Outside the EU the library shows only running ads and no spend or results. Keyword counts are text matches and miss discounts written another way. Hims sells prescription treatment; its lack of discounts may reflect advertising rules, which we did not check. Offer calculator numbers are fictional.
Primary references
- Meta Ad Library: Hims Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- Meta Advertising Standards (including health and prescription products)
