Tempio

Flight plan template for Ecommerce

Free download as CSV and Markdown. Nothing sits in front of the file: no form, no account, no email address.

The files

What it is

The flight plan with three columns a store needs: which slice of the catalogue this week is selling, which promotion it sits inside, and how much stock stands behind it on the day the week starts.

Everything else is the general flight plan, unchanged. One row per week of one line of spend, a phase on every row, a share of the flight on each, and a decision point at the end of every phase.

When to use it

Use it for any period built around a retail calendar rather than a reporting calendar: a season, a promotional run, a product drop. The weeks either side of a promotion decide the result, and a monthly rhythm reads straight past both of them.

Write it after the media plan is approved and before the creative is scheduled. Then read it every Monday, because stock and delivery cut-offs change what next week can honestly do.

Every field, and what belongs in it
TypeHow to fill it
FlightTextThe trading period this row sits in: a season, a promotional run, a product drop. Name it even when there is only one, so two seasons can be read side by side next year.
PhaseTextWhere in the season this week falls: tease, launch, sustain, peak, wind-down. In a store the peak is usually a single fortnight, and naming it keeps it from being averaged into the weeks around it.
ChannelTextThe platform this row's spend runs on, one per row, spelled as it is in the media plan so the two documents reconcile without a lookup table.
CampaignTextThe campaign name as it reads in the ad account, including the catalogue segment, so a week of spend can be traced to a part of the range rather than to a platform.
Week startingDate (YYYY-MM-DD)The Monday. Weeks rather than days, because a store's demand moves by weekday and a day-level plan is a schedule nobody keeps through a busy season.
Share of flight budgetPercentWhat proportion of the season this week is meant to carry. Read down the column and the shape of the trade appears: even through the quiet weeks, concentrated around the promotion, thin after the cut-off.
Budget (minor units)IntegerThe week's budget for this row, in the smallest unit of its currency. Whole numbers only, so a season of weekly rows still sums to the figure the trading meeting approved.
CurrencyISO 4217 codeThe ISO 4217 code this ad account charges in. A store selling into several markets carries several, and weekly rows in different currencies cannot be added into one season total.
Creative setTextWhich assets are in market this week. Store creative fatigues faster than most, so scheduling the sets across the season is what stops the sustain weeks running the launch cuts until nobody looks at them.
DependencyTextWhat this week needs from outside the ad account and does not have yet: the collection page, the product feed entry, the shoot, the offer configured at checkout. Put the date it is due in the cell.
Decision pointTextWhat is being decided at the end of this week, as a question. In a store the recurring three are whether the launch found the audience, whether stock supports the peak, and what happens at the cut-off.
OwnerTextThe person who answers for this row. In a store that is usually the media buyer, with the trading manager owning anything that changes which segment the week is pointed at.
NotesTextWhat the next person needs: the sell-out that ended a week early, the competitor sale that moved the auction, the delivery cut-off, the week where the weight was deliberately held back.
Catalogue segmentTextThe slice of the range this week's spend is pointed at: best sellers, new arrivals, a hero product, the long tail, clearance. It sets the margin and the creative together.
Promotion windowTextThe sale, drop or seasonal peak this week sits inside, or Full price. A week that straddles the edge of a promotion is two rows, because the offer changed underneath it.
Stock coverTextWhat stands behind this segment on the day the week starts, in weeks or units. A week pointed at four days of cover is a week spent teaching people about something they cannot buy.

The retail calendar sets the weeks, not the month

A store's spend is lumpy by design. Promotions, drops, seasonal peaks and delivery cut-offs all set dates that have nothing to do with the end of a month, and a plan read monthly will average across exactly the weeks that decided the quarter.

That is the whole case for a weekly plan in this category. One row per week per line, a phase name on every row, and a share of the flight budget on each, so the shape of the season is visible before it is spent rather than reconstructed afterwards from an export.

The shape matters more here than almost anywhere, because a store's demand is not flat. There are weeks where the same money buys twice the attention and weeks where it buys none, and the plan is the only place to say which is which in advance.

Cut the rows at the edges of a promotion

The promotion window column exists so that no row straddles a change of offer.

A line that runs from the last full-price week into the first sale week is two lines. The offer changed halfway through, and with it the creative, the expected conversion rate, the margin and the definition of a good result. Kept as one row, the two halves average into a number that describes neither, and the average lands precisely on the period anyone would most want to read clearly.

The same applies at the other edge. The week after a promotion closes is not a sustain week; it is a wind-down week with its own weight, its own creative and its own expectation, because demand pulled forward into the sale has to come out of somewhere.

Stock cover is read weekly, not once

A media plan can record stock cover at planning time. A flight plan has to record it every week, because it moves.

The failure this prevents is the most expensive one a store can have: a week at full weight pointed at a segment that sold out on Wednesday. The platform will keep spending, the creative will keep performing, and the money will buy disappointment that shows up later as returns, complaints and a worse audience for the next flight.

So the cover column carries what stands behind the segment on the Monday, with the date it was read. Where cover is thin, the honest options are to lower the weight, to point the week at a different segment, or to change the creative to something that does not promise a specific item. All three are decisions; spending through it is not.

Creative rotation is a schedule, not an instinct

The creative set column turns rotation from a reaction into a plan. Write which assets are in market each week, and the question of whether a week moved because of weight or because of work becomes answerable.

In a store this matters more than in most categories, because creative volume is usually the binding constraint. A season's worth of assets is finite, and spending it all in the launch phase leaves the sustain phase running the same three cuts for six weeks, which is where fatigue actually comes from. Scheduling the sets across the phases, in the plan, is how a limited library is made to last the flight.

Where a set is not made yet, it is a dependency with a due date, and the due date belongs at least a week before the row that needs it.

Delivery cut-offs are a fact about the week

Every seasonal flight has a date after which an order cannot arrive in time, and it is a week-level fact that belongs in this document rather than in somebody's head.

Put it in the notes on every row that runs into it, and plan the phase around it. Before the cut-off, the offer is the product. After it, the offer is something else — a gift card, a later delivery promise, a different segment entirely — and a week that carries the old message past the cut-off will convert badly for a reason the reporting cannot show.

The decision points a store actually makes

Every phase carries at least one decision point, and in a store there are three that recur.

The first is at the end of the launch week: whether the opening weight found the audience or exhausted it, which decides whether the sustain phase widens or holds. The second is the week before a promotion: whether the stock position still supports the planned weight, which decides how much the peak can be pushed. The third is at the cut-off: whether to keep selling the product or change the offer.

Write those as questions, with the week attached, and the conversation happens on a Monday with the numbers in front of everyone.

Before the flight starts

Every week of every line has a row. Every row names a catalogue segment and a promotion window, and none straddles the edge of one. Stock cover is written against every week carrying a budget, with the date it was read. Every phase names its first week, its last week and its intent. Every dependency has a due date before the week that needs it. And every phase carries a decision point, written as a question somebody has agreed to answer.

A flight that passes those six is not necessarily a good flight. It is a flight whose weeks can be argued with before they are spent, which in a season built around dates nobody controls is the only kind worth writing down.

The general template, and other industries

Templates that go with it

Related reading

Questions

Put frontier AI to work on every ad account you run.

Tempio connects your ad accounts into one workspace and hands your own AI the numbers and the tools. Every change it writes is a draft until you approve it, or until a rule you wrote does.

Request early access
  • Read and draft by default. Approve is a separate permission you grant.