Start with a business goal · Pharma commercial sales

Where should we focus next month?

You lead regional sales for Brand A. Choose the business goal and see how the same evidence leads to different actions. All figures are synthetic.

Grow secondary sales by 8% this quarter

Keep field capacity fixed and check distributor stock before replenishing.

Decision and rationale

Pilot replenishment for two weeks at affected East stockists after checking stock on hand and open orders. Compare results with a similar territory before expanding.

Review and reconsider

Track stock-out days and secondary sales. If availability improves and sales stay flat, check whether reps reached priority doctors.

What the evidence says

Brand A quarter-to-date secondary sales are up 2% year over year. East sales are down 8% while visits rose 12%. Two declining SKUs had recorded stock-outs. Other SKUs have slow-moving stock at unaffected stockists.

Stock-outs are one plausible explanation. Visit counts alone leave priority-doctor coverage uncertain.

What the manager weighs

Restore availability where stock-outs are verified. Refocus visits if priority doctors were missed. Investigate further where coverage and availability look adequate.

The regional sales head owns the decision, with input from area managers and distribution.

Pharma data model · Six workbook tabs
TabOne row perFields and use
Brand targetsBrand, territory and monthMonth, brand ID, territory ID, target value. Compare performance to plan.
Secondary salesStockist invoice lineDate, stockist ID, SKU, downstream territory where available, net units and sales value. Locate the growth gap.
Primary salesCompany-to-stockist invoice lineDate, stockist ID, SKU, net units and sales value. Compare shipments with secondary movement.
Stock and availabilityStockist, SKU and weekWeek, stockist ID, SKU, closing stock and stock-out days. Check product availability.
Field effortRep visitDate, rep ID, doctor ID, territory, brand detailed and priority segment if available. Check relevant doctor coverage.
Master dataProduct, stockist, rep or doctor mappingSKU to brand, stockist and rep to territory, doctor to priority segment. Align sources and check coverage.

DecisionOS compares aligned data by brand, territory and month. If a stockist serves multiple territories and invoice territory is missing, keep those sales at stockist level and flag the allocation gap.

Discuss your use case ↗