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
Check the carrier dates
The Carrier cutoffs tab holds the 2026 USPS and FedEx last days to ship for delivery before Christmas, with links to each carrier's page. They are recommendations and can change, so check them before you publish. UPS rows are blank on purpose: type the dates from ups.com.
Turn them into your order-by dates
Type your handling time and whether you ship at weekends, and pick your standard, faster and express options. The sheet moves each carrier date back to a weekday you ship and subtracts your packing days. In the example, FedEx Express Saver's Monday 21 December cutoff becomes a Friday 18 December order-by date.
Give every day a phase and a message
The Day plan gives each day from 15 to 27 December a phase, the budget split and the order-by line for ads, banners and emails. The Ad copy tab writes a headline and primary text per phase. Upload each phase as its own ads with start and end times, so no 'order by' ad runs past its date.
Move budget, then watch it
Set each phase's total budget and gift-card share on the Inputs tab. During the ten days, type actual spend and revenue each evening; each day is coloured against your break-even ROAS. The checklist tracks banners, Merchant Center delivery settings, the gift card product and customer-service replies.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Date (2026) | Days to Christmas | Phase (example store) |
|---|---|---|
| Tue 15 Dec | 10 | Standard shipping |
| Wed 16 Dec | 9 | Standard shipping |
| Thu 17 Dec | 8 | Upgrade shipping |
| Fri 18 Dec | 7 | Express only |
| Sat 19 Dec | 6 | Express only |
| Sun 20 Dec | 5 | Express only |
| Mon 21 Dec | 4 | Express only |
| Tue 22 Dec | 3 | Gift cards and digital |
| Wed 23 Dec | 2 | Gift cards and digital |
| Thu 24 Dec | 1 | Gift cards and digital |
| Fri 25 Dec | 0 | Christmas Day |
| Sat 26 Dec | -1 | After Christmas |
| Sun 27 Dec | -2 | After Christmas |
Worked review example
Illustrative store: ships USPS Ground Advantage free, offers USPS Priority Mail and FedEx 2Day as paid upgrades, needs one business day to pack and doesn't ship at weekends. Its customers must order by Wednesday 16 December for standard shipping, Thursday 17 December for Priority Mail and Monday 21 December for FedEx 2Day.
With a normal budget of $500 a day, the example plan spends $5,150 from 15 to 27 December, of which $2,285 (44%) goes to gift-card and digital ads, almost all of it after the express cutoff.
What this template does and does not establish
Carrier dates are the carriers' recommendations for 2026, checked on 17 November 2026; they are not guarantees and can change. UPS dates are not included because we could not confirm them from UPS. Dates are for the contiguous US; Alaska, Hawaii, international and military addresses have earlier dates. The budget split is an example to show the method, not a benchmark.
Primary references
- USPS: 2026 holiday shipping dates
- FedEx: 2026 last days to ship (PDF)
- UPS: holiday shipping schedule (check by hand)
- NRF: 2026 holiday survey (gift cards wanted by 47%)
- Google Merchant Center: set up estimated delivery time
- Shopify: add recipient fields to gift card products
- Meta: Significant edits and learning phase
- Meta: About daily budgets
