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 Glossier snapshot
The first data tab holds what the US Meta Ad Library showed on 17 November 2026: 63 live ads, none older than 20 days, 30 started on 28 October, 35 mentioning the holidays and none saying '% off'. Of the repeated opening lines that name a product, 16 are fragrance and 4 makeup.
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, the product the first line names, the offer words and the first line. Days running and age calculate from the check date; the summary counts the rest.
Write the holiday drop with the template
Hero product, a set or gift built around it, a value line without a percentage, and one seasonal drop of 20 to 40 variants launched together. Use your own products and words; never copy another brand's ads.
Check your product mix
Type each product line's revenue share, its goal share for the season and how many live ads open with it. The sheet flags any line more than 10 points under- or over-advertised against the goal.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Opening line | Ads | Product it names |
|---|---|---|
| Have yourself a merry little meltdown with new Glossier... | 12 | None named |
| Meet Glossier You Doux. Sweet violet, warm woods... | 5 | Fragrance |
| You, Doux, Soie, Fleur. Why choose? Gift all four... | 4 | Fragrance |
| Build your own set with the pieces you love most. Fragrance... | 4 | Fragrance |
| Get holiday-ready with the Black Cherry Lip Line + Balm... | 4 | Makeup |
| One You for your Top Shelf. One for your holiday escape (oldest, 20 days) | 1 | Fragrance |
| One scent, two ways. Save on Crème de You + Glossier You (oldest, 20 days) | 1 | Fragrance and body care |
| Smells different on everyone and that's totally the point (oldest, 20 days) | 1 | Fragrance |
Worked review example
Real Glossier data, 17 Nov 2026: 63 live US ads, median age 19 days, oldest 20. 34 are video and 3 are partnership ads. The three oldest all sell Glossier You. Zero say '% off'; value is sold as sets and 'save on' lines.
Fictional product mix: a skincare brand wants gift sets at 35% of holiday revenue, but only 2 of 20 ads open with a set (10%). The sheet flags sets as under-advertised and the best-known serum (60% of ads against a 40% goal) as over-advertised.
What this template does and does not establish
Glossier 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. The fragrance count is ours, based on opening lines that name a product; 43 of 63 cards name no product in the first line. Product mix numbers are fictional.
Primary references
- Meta Ad Library: Glossier Page (read 17 Nov 2026)
- Meta Transparency Center: Ad Library tools
- Glossier homepage (fragrance family and set prices, checked 17 Nov 2026)
- FTC Guides Against Deceptive Pricing (16 CFR Part 233)
