TL;DR Trade promotion optimization (TPO) is how a Philippine brand checks which promos paid and puts the next peso of trade spend where it bought the most extra volume. Three numbers drive it: what sari-sari stores and supermarkets would have bought anyway, what the promo added, and what that extra cost. It stalls when field data cannot show which outlets really ran the scheme.
Every quarter someone in the sales meeting asks the same thing: the distributors took the stock and the discount went out, so did the promo work? Trade promotion optimization is the habit of answering that with numbers instead of memory. You review each scheme after it ends, find out how much extra it really moved, and shift the next round of promo budget toward the schemes that bought extra volume cheapest. Three questions sit behind all of it. What would the stores have bought without the promo? How much more did they buy with it? And what did each extra case cost, after the discount, the free goods and the orders it stole from later weeks or from your other SKUs?
The hard part is not the maths. It is knowing what happened on the ground. Which sari-sari stores heard about the scheme? Which supermarkets built the display? What did the distributor invoice to each store? If the model only sees shipments to distributors and your guesses about execution, it will rank your promos with total confidence and still get them wrong.
Trade promotion optimization vs trade promotion management
People mix these two up, but they do different jobs. Trade promotion management (TPM) is the admin of promos. It covers the budget, the calendar and scheme setup. It also covers the message to distributors and stores, and claim checking and payment. Trade promotion optimization is the judgment layer. Before a promo it forecasts what the scheme should add, and after it ends it measures what the scheme actually did.
| Trade promotion management (TPM) | Trade promotion optimization (TPO) | |
|---|---|---|
| Question it answers | Did we set it up, run it and pay it correctly? | What should we run next, in which outlets, and at what depth? |
| Main users | Trade marketing, sales ops, finance | Trade marketing, revenue management, analysts |
| When it works | Throughout the life of a promo | At planning time and again at the post-event review |
| What goes in | Budgets, scheme rules, outlet lists, claims | Sales history, promo records, proof of execution, costs |
| What comes out | Live schemes, accruals, settled claims | Baselines, uplift forecasts, return per promo, a better next plan |
Get TPM in order first. Optimization needs records of past promos, and those only exist if schemes are set up, run and claimed in one place. If yours still sit in Excel trackers, Viber threads and emailed memos, fix that before you buy any forecasting. Our guide to trade promotion covers how to plan and run promos. This page is about measuring them and making the next one better.
What data does trade promotion optimization need?
Forecasts are only as good as the records under them. Before you trust one, make sure you can pull these five kinds of data, ideally by SKU, by outlet or account, and by week.
- Sales history. Weekly sales in non-promo periods, with each season seen at least once (the Ber months and fiesta weeks included) so normal looks normal to the model.
- Secondary sales by outlet. What the distributor sold to each store, not only what you shipped to the distributor. Primary shipments show who stocked up. Secondary sales show what moved toward the shopper.
- Promo records. Mechanic, depth, start and end dates, SKUs, target outlets, and who funded it.
- Execution proof. Was the scheme offered at the order, did the display go up, did the store claim? Without this you cannot separate a weak offer from one nobody heard about.
- Costs. Discounts, free goods, display fees and paid claims, each tied back to the promo behind it.
Some supermarket and convenience chains share till data, and panel data exists for a few categories. Use it where you can. For sari-sari stores, though, nothing like that exists, and the distributor’s invoice to each store is the nearest thing to sell-out you will get. Shipments only tell you how much stock the trade took. This is why a distributor management system that records secondary sales is usually the first data project. It also ends a familiar headache: distributor sales reports that arrive late, are keyed in by hand and never quite match.
How does trade promotion optimization work? Five methods
Each method rests on the one before it, so do them in this order. A shaky baseline spoils everything after it.
1. Baseline and uplift
The baseline is your estimate of normal sales: what the same outlets would have bought in that period given the season and the trend. Uplift is actual sales minus that baseline. If the baseline is too low, every promo looks like a winner. Real weeks are messy. A typhoon that keeps your vans off the road can move sales more than the scheme does. So can a payday week, so the baseline has to allow for both.
2. Post-event analysis
When the promo closes, set the forecast beside the result. Then ask where the volume came from: new demand, your other SKUs, later weeks pulled forward, or sales you would have made anyway. Write it up as a one-page profit and loss for that promo. Teams that skip this repeat last quarter’s mistakes with a new poster.
3. Price elasticity
Elasticity is how far volume moves when price moves. It settles the depth question: will a bigger discount bring enough extra volume to cover itself? Beyond some point the extra discount just pays people who would have bought anyway. In sari-sari stores shoppers buy by the peso, in sachets and small packs, so a shift in the price point can matter more than a percentage off.
4. Product switching and pull-forward
Two things flatter a promo. One: buyers move from your other SKUs to the promoted one, and the brand gains nothing. Two: stores stock up during the deal and then reorder less for weeks. Distributors and wholesalers do this with primary-order schemes (forward buying), and shoppers do it at home (pantry loading). Look at the weeks after the promo, not only the weeks of it, and the dip appears.
5. Scenario planning
With baselines and past uplift in hand, you can try a plan on paper before paying for it. Change the mechanic, the depth, the dates or the outlet list and compare forecast volume, cost and profit. The goal is modest: cut the options that obviously lose money before they get on the calendar.
An example of how the methods change a decision
Picture a made-up beverage brand that offers buy ten, get one free for a month. The offer goes to a group of sari-sari stores through wholesalers and van sales routes. Sales that month jump, and the team celebrates. The post-event review is less happy. Much of the jump was customers trading down from the brand’s own bigger pack, and the same stores ordered less than usual the month after. With both effects and the free goods counted, the scheme only broke even. A small display payment in similar stores caused no trading down and no dip, and it returned more for every extra case.
Trade promotion analysis: which measures show a promo paid?
Judge a promo on the extra volume it added above the baseline, and read these measures side by side. Any single one can make a losing promo look good.
| Measure | What it tells you | How to work it out |
|---|---|---|
| Incremental volume | What the promo really added | Promo-period sales less baseline, less the dip afterwards |
| Promotion ROI | Whether the trade investment made money | (Gross profit on incremental volume minus total promo cost) divided by total promo cost. Above zero means the promo made money |
| Cost per incremental case | How cheaply the promo bought extra volume | Total promo cost divided by incremental cases |
| Post-promotion dip | How much volume was borrowed from later weeks | Baseline less actual sales in the weeks that follow |
| Execution rate | Whether the trade actually ran it | Outlets with the scheme offered or display verified, divided by outlets targeted |
| Claim accuracy | Whether the money went where it should | Claims that match verified sales or proof, divided by claims paid |
Compare mechanics on the same SKU with cost per incremental case. Compare across SKUs and categories with promotion ROI, since a cheap extra case of a thin-margin product can still lose money. Always read both beside the execution rate: a promo with poor returns and poor execution should be fixed in the field before anyone decides to kill it.
Agree who owns each number
Ask sales, finance and trade marketing whether a promo worked and you will get three answers: volume, cost and reach. Bigger brands add a fourth, because TPO often sits within revenue growth management beside pricing and pack decisions. Decide ownership before the first review. One team holds the baseline, usually trade marketing or revenue management. Finance owns cost. Sales owns the execution rate. After that, everyone reads the same promo report.
Why optimization fails without clean field data
Unless told otherwise, a model assumes a promo planned for certain outlets ran in those outlets. In traditional trade it often did not. The rep never mentioned it. Or the distributor applied the discount at the invoice rather than at the order. Or the display stayed in the stockroom, or the owner never filed a claim. The model reads that as weak demand and advises you to drop a promo that nobody really tried.
Three habits close most of the gap:
- Show the scheme at the order. When the rep’s sales force automation app shows the live schemes for that outlet and applies them as the order is taken, the store owner hears the offer. That happens while they are still deciding how much to buy. The record also shows that the scheme was offered.
- Get proof of display. A geo-tagged shelf photo taken during a retail audit shows whether the display went up. Visual merchandising tools can score those photos so nobody has to check them by hand.
- Check claims against secondary sales. Match each claim to the distributor’s invoices to that outlet before you pay it.
A leading paints brand in the Philippines saw 30% higher sales productivity after moving its field team onto BeatRoute (read the leading paints brand case study). That result came from better field execution, and the same outlet-level data is what a TPO model needs.
Coverage counts too: a scheme cannot work in a store nobody visits. In supermarkets and convenience chains, promodisers and display checks decide whether the agreed promo is visible on the shelf. For the field side of running schemes, see how to run trade promotions in retail distribution.
What AI and predictive models add to trade promotion optimization
AI earns its place where the job is too big for one analyst and an Excel file. A predictive model can:
- set baselines for every SKU and outlet cluster in one go
- pick out which traits of past promos went with stronger uplift
- test many more scenarios than a team could by hand
- warn you mid-promo about outlets whose claims run far above or below their sales
It has limits. It learns from your history, so it copies the gaps in your records. When nothing shows that a scheme reached an outlet, the model assumes the scheme was heard and rejected. It also says little about a mechanic you have never tried. Use its forecast as a draft that someone who knows the trade reviews and signs.
How trade promotion optimization changes by channel: modern trade vs traditional trade
Modern trade. A handful of supermarket, convenience and chain pharmacy accounts take most of the volume. Each promo is negotiated with the account, and many chains share till data, so TPO can work by account, SKU and week. Your levers are depth, timing against the chain’s own promo calendar, and display fees. Whether the shopper sees the deal depends on the promodiser and the display check.
Traditional trade. Here you reach a great many sari-sari stores and small groceries through distributors, wholesalers and van sales, with no scanner data. Individual stores are too small to model, so cluster them by type, size and area. A cluster might be Metro Manila, a Cebu district or a provincial town. Compare each cluster with look-alike outlets that did not get the scheme. Distributor invoices stand in for sell-out. The levers are different as well: quantity slabs, free goods and period purchase schemes that reward what a store buys across a month or a season. Many sari-sari owners buy on credit, with a listahan, so check whether a scheme moved real stock or only moved the due date.
If you sell in both, analyse them separately. A promo that pays in a supermarket chain can lose money in sari-sari stores, and the reverse.
How trade promotion optimization differs by industry
FMCG and food and beverage. Wide ranges and frequent schemes make switching and pull-forward the main risks. Watch for pack sizes and flavours that compete with each other.
Pharmaceuticals. Schemes run with chain pharmacies, drugstores and wholesalers, and rules often restrict promoting medicines directly to consumers. Measure by secondary sales to each pharmacy, and check that every scheme stays within those rules. Nurturemed Pharma saw a 20% increase in PMR productivity after moving its medical reps onto BeatRoute (read the Nurturemed case study). Productive reps are what let a pharmacy scheme be offered and recorded visit after visit.
Building materials, paints and lubricants. Dealer slab schemes and period schemes, often with loyalty schemes for painters, mechanics or contractors. Buying cycles are longer, so the dip after a promo takes longer to show. Measure over a longer window.
The tools a trade promotion optimization program needs
No one tool does all of TPO for every brand, so it is easier to sort tools by what they do and who they suit.
- Planning and optimization suites. They set baselines, forecast uplift and run scenarios, and many also hold the promo calendar, budgets and accruals. Best for large brands with long modern trade calendars and an analytics team.
- Field execution and distributor systems. These carry schemes into the rep’s order app and the distributor’s billing, collect display proof and log secondary sales by outlet. Best for brands selling through distributors to many small stores.
- Spreadsheets and dashboards. Good enough for a first post-event review of a few promos. They fall apart as promos, outlets and SKUs pile up and nobody owns the baseline.
Whichever kind you shortlist, put these questions to the vendor:
- How is the baseline built, and can my team see and change it?
- Does it capture the post-promo dip and switching between my own SKUs?
- Is the model at outlet, cluster, account or region level?
- Where does proof of execution come from, and does it feed the analysis?
- Can it run on secondary sales when I have no sell-out data?
- Does it work offline on the Android phones my reps already carry, in provincial areas with weak signal?
- How quickly can I see a first post-event review on my own data?
Where BeatRoute fits. BeatRoute is the execution and secondary sales side of TPO. Its field sales app shows reps the live schemes for each outlet and applies them at the order, online or offline. Its distributor management system holds the scheme and claim rules and records what each distributor sells to each store, and its retail audit tools record whether displays went up. Goal-Driven AI turns a scheme goal, such as must-sell compliance in a set of outlets, into targets and nudges for each rep. That gives a TPO model clean data on what ran, where, and what it sold. If your main need is planning a large modern trade promo calendar with detailed price models, a dedicated planning suite is the better fit. BeatRoute’s outlet data can sit alongside it through integrations.
Run a pilot before you scale
Try TPO on a single promo cycle before you change how the whole budget is set.
- Choose one category and one area where you promote often, such as a province or a single distributor territory.
- Pick two or three mechanics to compare, for example a price-off, free goods and a display payment.
- Divide look-alike outlets into test groups, and keep one control group with no scheme.
- Before you start, write down the measure and the bar it must clear, such as a cost per incremental case below your current average.
- Run one full cycle and track execution: scheme offered at the order, display photos taken, claims checked against secondary sales.
- Compare results with the control group, and include the weeks after the promo.
Before rolling out, check four things. Did the scheme really run in the test outlets? Did the winner still beat the control once the dip is counted? Did it hold in every outlet cluster? Could your own team repeat the analysis without outside help?
If execution data is your weak link, book a demo to see how BeatRoute puts schemes in the rep’s hand and tracks secondary sales by outlet.
Frequently Asked Questions
What is trade promotion optimization (TPO)?
It is the practice of reviewing past promos with data so you can pick the offer, depth, timing and outlets that pay best next time. For each promo you find out what it added beyond normal sales and what that extra volume cost, then move budget to the promos that bought volume most cheaply.
What is the difference between TPM and TPO?
TPM is the running of promos: budgets, calendars, scheme setup and claims. TPO is the deciding of which promos to run, by forecasting and then measuring what each adds. TPO relies on the tidy records TPM leaves behind.
What data do you need for trade promotion optimization?
Five things. You need weekly sales history and secondary sales by outlet. You need a record of each promo’s mechanic, depth, dates and outlets. You also need proof it actually ran, and its full cost. Till data from supermarket chains is a bonus where available.
How do you measure trade promotion effectiveness?
Take incremental volume over the baseline and deduct the dip after the promo. Then calculate promotion ROI and cost per incremental case, and read them with the execution rate so a scheme that never reached the store is not blamed on the offer.
Can TPO work in traditional trade without scanner data?
Yes. Take the distributor’s secondary sales to each sari-sari store as your sales figure, cluster similar outlets, and compare those that got the scheme with look-alikes that did not.
What role does AI play in trade promotion optimization?
It speeds up baselines, spots patterns across many past promos, runs scenarios and flags outlets with under- or over-claimed schemes. It cannot make up for missing data: if nothing records whether a scheme ran, the model draws the wrong conclusion.
How long should a trade promotion run in the Philippines?
At least one full ordering cycle of the outlets in the scheme, so each sari-sari store and supermarket can buy on it. Do not run it so long that the deal becomes the price the trade expects. Your own post-event reviews of different lengths, including promos in the Ber months, are the best guide for your category.
