Free editable template

Black Friday offer teardown: '% off' in 21 DTC brands' Meta ads, with an offer calculator

Decide whether your Black Friday ads should say '% off'. The Excel workbook holds the real count for 21 brands (631 of 6,606 live ads; 10 brands at zero), 22 opening lines tagged by offer type, a calculator that compares profit per order and the extra orders each offer needs against full price, and a tracker that gives any competitor's discount share and offer mix.

By GaaS editorial · Sources checked · 9 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

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.

BrandLive US Meta adsAds with '% off'
Gymshark7270
Bombas8268
True Classic225127
Dr. Squatch462250
Quincefirst 1,5205
Vuori5340
Hims4280
Huel4210
SKIMS1220

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

Continue the work