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
See who discounts
The 21 brands tab holds the count from the Meta Ad Library on 17 November 2026: live US ads, ads whose copy contains '% off', the share, and each brand's most-used opening line. Hims, Huel, Vuori and SKIMS ran 1,505 ads without a '% off'; Gymshark put it on 70 of 72.
Borrow an offer type, not the words
The Lines tab tags each brand's lines by offer type: percent off, free shipping, bundle, multi-buy, free gift, price argument, proof, social proof, customer voice. Pick the type that fits your margins and write your own line.
Price your offer
Type your price, product cost, shipping, payment fees, return rate and target CPA. The calculator shows profit per order after ad cost for no offer, 20% off, 30% off, free shipping, a free gift and a bundle, and how many more orders each needs to match full price.
Track competitors through Cyber Monday
Log a competitor's live ads, mark which say '% off' and their offer type. The tracker gives their discount share and offer mix; re-read weekly until 30 November.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Brand | Live US Meta ads | Ads with '% off' |
|---|---|---|
| Gymshark | 72 | 70 |
| Bombas | 82 | 68 |
| True Classic | 225 | 127 |
| Dr. Squatch | 462 | 250 |
| Quince | first 1,520 | 5 |
| Vuori | 534 | 0 |
| Hims | 428 | 0 |
| Huel | 421 | 0 |
| SKIMS | 122 | 0 |
Worked review example
Real data, 17 Nov 2026 (Grüns 16 Nov, all countries): 631 of 6,606 live ads contained '% off'. 10 of 21 brands had none. Quince had 5 in its first 1,520 and runs 'Their best sale price is still more than ours.'
Fictional offer example: a $60 product costing $15, $7 shipping, 3% fees, 5% returns and a $20 target CPA earns $18.72 per order at full price. At 20% off it earns $7.68 and needs 144% more orders to match; free shipping needs 42% more; a $5 free gift needs 36% more.
What this template does and does not establish
Counts copy containing '% off' only: bundles, multi-buys, gifts, free shipping and percentages shown only in the image are not counted, so 'no % off' does not mean 'no offer'. Read by hand on one day, 10 days before Black Friday; brands may switch to sale copy later. Outside the EU the library shows only running ads and no spend or results. Quince is its first 1,520 ad cards. Calculator numbers are fictional.
Primary references
- Meta Ad Library (read 17 Nov 2026)
- Quince: 'Competitors marked it down. We never marked it up.'
- Meta Transparency Center: Ad Library tools
