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 Gymshark snapshot
The first data tab holds what the Meta Ad Library showed on 17 November 2026: 72 live US ad cards (the header's ~640 counts versions), 70 started on 15 and 16 November, 70 saying '% off' up to 50%, 42 mentioning Black Friday, and two older ads that are a waitlist for GSLC Miami.
Write one offer, two openings
The Ad template tab breaks the Gymshark sale ad into parts: the news, the offer said one way, who it's for (yourself or a gift), the product, plus one always-on non-sale ad. Write yours in the blank column.
Size the sale batch to your budget
Type the sale dates, products, opening lines, formats, daily budget and target CPA. The sheet works out the ads in the batch, the budget each one gets, the spend each needs to be read, and whether to cut the batch.
Log any competitor the same way
Open their Page in the Ad Library (US, active ads) and log each live ad, counting cards rather than the header. Read a sale-driven brand before and during its sale; the difference is its playbook.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Started | Live ads | What they say |
|---|---|---|
| 2 Nov 2026 | 2 | Want to be the first to know when GSLC Miami Founding m[embers]... (gym waitlist, no discount) |
| 15 Nov 2026 | 37 | Black Friday sale, up to 50% off |
| 16 Nov 2026 | 33 | Black Friday sale, up to 50% off |
| Opening line | 13 | The Black Friday sale has dropped. Up to 50% off the be[st]... |
| Opening line | 6 | Shopping for someone else? Save up to 50% on gifts they... |
Worked review example
Real Gymshark data, 17 Nov 2026: 72 live US ads, 21 video, 47 with several versions. 37 started on 15 November and 33 on 16 November; nothing still live started between 3 and 14 November. 59 run from Gymshark's page and 13 from partner pages.
Fictional sale batch: an 11-day sale with 10 products, 2 opening lines and 2 formats is 40 ads. At $1,000 a day each gets $25, below the $30 needed to show a purchase a day at a $30 target CPA, so read ads over two days or cut to 33.
What this template does and does not establish
Gymshark data was read from the public Meta Ad Library on one day, 17 November 2026 (US, active ads). 72 is a count of ad cards; each may hold several versions. Outside the EU the library shows only running ads, so earlier ads that were switched off aren't visible. The library shows no spend or results. 'Last 48 hours' is relative to 17 November. Planner numbers are fictional.
