
Manufacturing KPIs in Salesforce: Forecast Accuracy, Fill Rate, Churn
Manufacturing KPIs like forecast accuracy, fill rate (and OTIF), and customer churn can be operationalized in Salesforce by (1) defining each KPI clearly, (2) assigning a system of record for the inputs (ERP actuals, Salesforce agreements/forecasts), and (3) using one certified dashboard set for Sales, Ops, and Finance. The goal is to stop KPI debates and start managing exceptions: where demand is changing, where supply is failing, and where customers are quietly leaving.
This matters most for manufacturers using Manufacturing Cloud (sales agreements + account forecasting), ERP integrations for orders/inventory, and channel programs where performance signals are fragmented.
If forecast accuracy is unclear → then planning becomes reactive and Sales/Ops alignment breaks.
If fill rate/OTIF isn’t visible by customer/product → then service failures hide until churn shows up.
If churn isn’t defined consistently → then leaders argue about “lost” vs “inactive” and action stalls.
A “good” manufacturing KPI program includes:
KPI definitions + time windows + inclusion rules
A committed vs actual baseline from ERP actuals
Segmentation (account, product family, region, channel partner)
Exception thresholds and action owners
Dashboards that drive weekly/monthly cadences
KPI 1: Forecast Accuracy (The Alignment KPI)
What it measures
How close your forecast was to what actually happened.
Why it matters
Forecast accuracy is the leading indicator for planning confidence: production plans, inventory levels, and revenue predictability.
Practical decision logic
If accuracy drops in a segment → investigate demand shifts, channel inventory, or missed commitments.
If bias is consistently high/low → adjust forecast process, not just the number.
Recommended definition (start simple)
Forecast Accuracy % (MAPE-style)
Accuracy = 1 − ( |Actual − Forecast| / Actual )
Reported as a % and averaged across accounts/products (choose weighting rules).
Bias (directional error)
Bias = (Forecast − Actual) / Actual
Positive bias = over-forecasting, negative = under-forecasting.
What to segment by
Account / parent account
Product family / SKU
Region / plant/warehouse (if relevant)
Channel partner vs direct
Data sources (typical)
Forecast: Manufacturing Cloud Account Forecasting / Advanced Account Forecasting (or agreed forecast object)
Actual: ERP orders/shipments (your chosen “actuals” definition)
Common trap
Teams compare forecast to “bookings” sometimes and “shipments” other times. Pick one definition of actual and stick with it.
KPI 2: Fill Rate (and OTIF) — The Service Reality KPI
What it measures
Whether you are fulfilling demand as promised.
Why it matters
Fill rate/OTIF connects supply performance to customer experience. Poor fill rate usually shows up later as churn, margin pressure, or channel conflict.
Practical decision logic
If fill rate drops for a customer → expect escalations, expedite costs, and renewal risk.
If fill rate drops for a product family → investigate supply constraints, allocation rules, or quality issues.
If fill rate is high but OTIF is low → you’re shipping complete orders, but late.
Fill rate definitions (choose one and document it)
Line Fill Rate %
(Shipped quantity / Ordered quantity) × 100
Order Fill Rate %
(# orders shipped complete / total orders) × 100
OTIF definition (most useful paired KPI)
OTIF % (On Time In Full)
% of orders delivered on time and complete
What to segment by
Customer tier / strategic accounts
Product family/SKU
Distribution center / location
Channel vs direct
“Constraint reason” (if captured)
Data sources (typical)
ERP/WMS shipments and delivery timestamps
Order line quantities (ordered vs shipped vs backordered)
Common trap
Fill rate looks “fine” at the total level but hides failures for top customers or top SKUs. Always segment.
KPI 3: Churn (and Retention) — The Silent KPI
Churn in manufacturing often isn’t a clean “cancel.” It’s gradual: fewer orders, mix shifts, partner switching, or a competitor displacing you in one product family.
What it measures
Lost revenue or lost activity over a defined time window.
Why it matters
Churn is the lagging indicator of everything else: service performance, pricing, relationship strength, and competitive pressure.
Practical decision logic
If churn rises in a segment → investigate fill rate/OTIF, price changes, and service escalations.
If churn rises for one product family → likely competitive displacement or quality/supply issues.
Choose a churn definition that matches your business
Revenue churn (period-over-period)
Lost revenue from customers who decreased purchases beyond a threshold.
Logo churn (customer count)
Customers who had purchases in baseline period but not in the current period.
Product-family churn
Customers who stopped buying a category (even if they still buy other products).
Recommended “manufacturing-friendly” churn approach
Use a rolling window and a threshold:
Baseline: last 12 months spend
Current: last 3–6 months spend annualized
Flag churn risk if current is down > X% and trend persists
Data sources (typical)
ERP actuals (orders/shipments/invoices)
Salesforce account segmentation and relationship data
Service Cloud cases/escalations (as a risk signal)
Channel sell-through (if relevant)
Common trap
Calling churn “lost accounts” when accounts still buy something. Track both total churn and product-family churn.
The KPI Backbone: Committed vs Actual (Your Ground Truth Layer)
Before you argue about forecast accuracy or churn, you need committed vs actual by account and time.
Why it matters
Agreements and commitments define expectations
Actuals define reality
Variance defines what to do next
Minimum view to build
Commitment (Sales Agreement) vs actual (ERP) by month
Variance thresholds (e.g., >10% or >$X)
Exception list (accounts needing action)
Dashboards to Build First (One Scorecard + Two Drill-Downs)
Dashboard 1: Manufacturing Exec Scorecard (10–12 KPIs)
Forecast accuracy (overall + by segment)
Forecast bias
Fill rate
OTIF
Backorder rate
Top at-risk accounts (by service failures + demand drop)
Churn rate (revenue + logo) with trend
Channel health snapshot (if channel-heavy)
Dashboard 2: Forecast Accuracy Drill-Down
Accuracy by account/product/month
Biggest movers (“what changed”)
Exceptions list with owners
Dashboard 3: Fulfillment + Churn Risk Drill-Down
Fill rate/OTIF by customer and SKU family
Backorder and late shipment drivers
Churn-risk list (drop-off + service issues)
Operationalize KPIs (So They Drive Actions)
KPIs only matter if you run meetings on them.
Weekly
Exceptions: forecast gaps, fill rate drops, top churn-risk accounts
Monthly
Forecast review: bias, accuracy trend, key shifts
Quarterly
Account reviews: agreement performance, retention plan, channel strategy
Quick win
Assign owners per exception type:
Forecast variance: Sales + demand planning
Fill rate: supply chain/operations
Churn risk: account teams + customer success/service
Common Pitfalls (And How to Avoid Them)
Pitfall: Different teams use different “actuals”
Fix: Pick booked vs shipped vs invoiced and standardize it.
Pitfall: KPIs exist but aren’t segmented
Fix: Always segment by account and product family.
Pitfall: Too many metrics, no decisions
Fix: 10–12 exec KPIs, and use drill-down for detail.
Pitfall: Churn definition is vague
Fix: Use rolling windows + thresholds and track product-family churn separately.
Pitfall: Dashboards don’t lead to action
Fix: Add exception lists with owners and next steps.
Frequently Asked Questions
What’s the best definition of forecast accuracy for manufacturers?
One you can explain and consistently compute against the same “actuals” (booked, shipped, or invoiced). Start simple, then refine weighting and segmentation.
Should we track fill rate or OTIF?
Track both if possible. Fill rate measures completeness; OTIF measures completeness and timeliness.
How do you measure churn in manufacturing when customers still buy sometimes?
Use rolling windows with thresholds and track both revenue churn and product-family churn.
Do we need Manufacturing Cloud to track these KPIs?
Manufacturing Cloud helps with commitments and account forecasting, but you can still track KPIs with Salesforce + ERP data if modeled and governed properly.
How do we stop KPI debates between Sales and Ops?
Standardize definitions, assign system of record for inputs, and use one certified dashboard set with governance.
Book a Manufacturing KPI Working Session
If you want a KPI scorecard that Sales and Ops will actually trust, book time with our team. We’ll define your KPI formulas (forecast accuracy, fill rate/OTIF, churn), map the ERP and Salesforce data inputs, and design a dashboard + exception workflow that turns metrics into action.