Change the budget. See everything move.
The forecast starts where an ecommerce business does: the ad budget. From there it works out sales, units, stock cover, the gap and the date to order by.
How it works
- 01
Ad budget
Type a budget per week for up to 26 weeks, with a planned MER for the big weeks, like Black Friday.
- 02
Projected sales
Budget × 100 ÷ MER, using Triple Whale's MER over the last four complete weeks, or the week's planned MER.
- 03
Units needed
Those sales split by product, from each product's units per sales dollar, plus Target's own recent baseline.
- 04
Covered
Stock on hand and every inbound purchase order, checked day by day from today.
- 05
The gap
Units short, and the first day each product runs out.
- 06
Order by
The first short day minus the supplier's lead time. Suggest PO opens a draft with the plan's own quantity.
Plan a whole season
The season planner starts from a similar past period, like last Christmas, and plans marketing and stock together.
- 01
Pick the season
Products and channels, the season to plan and a reference period to learn from.
- 02
Set the increases, or don't
Type a sales or a marketing increase, or leave one blank and the planner works it out from how your sales have followed ad spend.
- 03
Read the answer
Money in, money out, what to order and by when, and a sense check of what each ad dollar must earn.
- 04
Follow the season
Once it starts, ad spend, sales and each product against the plan to date, with order-by dates the pace moves.
The details that matter
Projections, labelled
Every figure says it's a projection and names its assumptions on screen.
Missing data, named
No Triple Whale yet? No sales by product? The step says what it needs instead of showing zeros.
Evidence, not magic
"10% more ad spend went with about 7.8% more sales": the response it uses, with how well it fits.
Versions on record
Planned and adjusted versions are kept, so what the plan said stays on record.
Ahead or behind
During the season, products and spend more than 20% off plan get a badge, and Home lists plans that drift.
Shared by the team
Marketing and logistics plan in the same place, from the same numbers.
Questions
How does it know how sales respond to ads?
It measures how your sales have followed ad spend over the past year and shows the evidence with the fit. With too little history, it says so and asks you to type both numbers.
Does it place orders for us?
No. It tells you what to order and by when. Suggest PO opens a draft for you to review.
See it on numbers like yours.
Tell us about your store, and we'll show you Silver Connection on your own data.
Contact us