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 Bombas snapshot
The first data tab holds what the US Meta Ad Library showed on 17 November 2026: 82 live ads, median age 4 days, 68 saying '% off' and 25 opening with '25% OFF SITEWIDE'. The two oldest, at 221 days, are plain product cards.
Log a competitor and mark the lanes
Open their Page in the Ad Library with active ads and your country, and log each card's library ID, start date, format, lane (evergreen or promo), offer words and first line. The summary shows the share that say '% off', the share older than 30 days and the count per lane.
Build the evergreen lane
Plain product cards: a photo and a clean product title. The title builder writes titles in the 'Product - Colour - Size' pattern of the Bombas cards. Keep the product feed's names and prices correct.
Plan the split and check each lane
Type your daily budget, sale dates and the evergreen share outside and during the sale. The planner works out daily and total spend per lane. Then type spend and purchases per lane; each is checked against its own target cost per purchase.
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 |
|---|---|---|
| 10 Apr | 221 | Image |
| 10 Apr | 221 | Image |
| 17 Oct | 31 | Image |
| Last 7 days | 4 (median) | Mixed |
Worked review example
Real Bombas data, 17 Nov 2026: 43 of 82 live ads started in the last 7 days and only 4 are older than 30 days. The two that have run since 10 April show a sock, a product name and no '% off' in their text.
Fictional plan: a $300 daily budget keeps $210 a day on product cards outside the sale and $90 a day during a 7-day sale, putting $1,470 behind the promo lane. In the lane check the evergreen lane is on target at $30.73 per purchase against $35; the promo lane is over target at $28.27 against $25.
What this template does and does not establish
Bombas 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. 'Plain product card' describes how the two oldest ads look; the library does not say whether they were built from a catalogue. Planner numbers are fictional.
Primary references
- Meta Ad Library: Bombas Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- Meta for Developers: Advantage+ catalog ads
