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 Athletic snapshot
The first data tab holds what the US Meta Ad Library showed on 17 November 2026: 58 live ads, 57 under 90 days old and one at 530 days. 7 are partnership ads, 3 of them run by NFL quarterbacks. 16 mention the holidays or Black Friday; none says '% off'.
Log a competitor the same way
Open their Page in the Ad Library with active ads and your country, and log each card's library ID, start date, format, angle (access, seasonal, offer, proof), offer words and first line. Their oldest ad usually shows the reason they think people buy from their site.
Write the access ad
What can people get only from you, and what is the shelf missing? Keep that ad running, layer seasonal drops on top, and use a threshold and a gift for the sale instead of a percentage.
Compare the offers
Type your price, cost per unit, multi-buy threshold, the discount you would otherwise run and the gift cost. The calculator shows revenue, cost and profit per order for each offer, and how many discounted orders match one multi-buy order.
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 |
|---|---|---|
| 5 Jun 2025 | 530 | Image |
| 20 Aug 2026 | 89 | Image |
| 1 Sep 2026 | 77 | Video |
Worked review example
Real Athletic Brewing data, 17 Nov 2026: the oldest live ad, started 5 June 2025, opens 'Online only limited-edition brews...'. The Black Friday ads say 'Buy 5 or more'; athleticbrewing.com adds a limited-edition free glass on 5 or more packs.
Fictional offer compare: a $14 pack costing $6. Five packs at 25% off leave $22.50 profit; five packs with a $4 glass leave $36.00. The discount needs 1.6 orders to match one multi-buy order.
What this template does and does not establish
Athletic Brewing data was read by hand from the public Meta Ad Library on one day, 17 November 2026, US view, active ads. Outside the EU the library shows only running ads, so days running are 'so far'. The library shows no spend or results. A small account: one ad carries the main finding. Offer calculator numbers are fictional; a multi-buy only works if enough buyers reach the threshold.
Primary references
- Meta Ad Library: Athletic Brewing Company Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- Athletic Brewing homepage (online-only brews and Black Friday offer, checked 17 Nov 2026)
