The gap between sell-in data and sell-out data is a major analytical challenge in CPG/FMCG trade promotion management. Sell-in data, shipments from the manufacturer to the retailer, and sell-out data, consumer purchases scanned at the retailer’s point of sale, measure two different phenomena that diverge significantly during promotional periods.
Retailers including Walmart, Kroger, Target, Costco, and Amazon routinely pre-buy promotional stock one to three weeks ahead of the consumer promotional window. This creates sell-in spikes that precede the actual consumer demand response.
CPG/FMCG brands that analyze trade promotion performance using only sell-in data systematically misattribute retailer forward-buying as promotional lift. As a result, their results dramatically overstate promotional ROI. In reality, this increase is either partially or entirely funded by inventory build rather than genuine incremental consumer demand.
Blue RGM by UpClear integrates sell-in data from ERP systems including SAP, Oracle, MS Dynamics, and NetSuite with sell-out data from NielsenIQ, Circana, SPINS, and retailer EPOS systems. This enhanced view enables automated reconciliation and accurate promotional ROI calculation based on true consumer demand.
Sell-in data, also called shipment data or depletions, records the volume of product shipped from a CPG/FMCG manufacturer to a retail customeror or distributor. It is captured in the manufacturer’s ERP system (SAP, Oracle, NetSuite) at the point of invoice and represents the manufacturer’s recognized revenue for accounting purposes.
Sell-out data, also called point-of-sale (POS) data, consumer scan data, or EPOS data, records the volume of product purchased by consumers at the retailer’s checkout. It is available from the retailer directly (Walmart Scintilla, Kroger 84.51) or from syndicated data providers (NielsenIQ, Circana, SPINS). The critical difference: sell-in measures what retailers ordered, sell-out measures what consumers bought. During normal trading periods, the two are loosely aligned. During promotional periods, particularly for large CPG promotions at major retail chains, they diverge sharply due to retailer forward-buying.
Retailers pre-purchase promotional stock ahead of a consumer promotional window for three reasons:
This forward-buying creates a timing mismatch that distorts promotional performance analysis when sell-in data is the only volume basis.
A CPG brand running a four-week consumer promotion at Walmart may see a sell-in spike beginning two to three weeks before the promotion starts, because Walmart is pre-building inventory. If the brand uses that sell-in spike as its promotional volume basis, it will calculate an inflated lift figure and an overstated ROI. Post-promotion, when Walmart depletes the pre-built inventory before ordering again, the brand sees a sell-in trough. This further distorts period-over-period comparisons.
Forward-buying distortion affects a major proportion of large-format promotional events at US mass and grocery retailers, making sell-out data the required basis for accurate promotional ROI measurement.
Accurate trade promotion analysis for CPG/FMCG brands requires using sell-in and sell-out data together, with each serving a distinct analytical purpose.
Sell-out data is the primary basis for promotional ROI calculation. It measures the true consumer response to the promotion and eliminates forward-buy distortion. Incremental volume should always be calculated from sell-out when NielsenIQ, Circana, SPINS, or retailer EPOS data is available.
Sell-in data remains essential for financial management. It determines when revenue is recognized in the manufacturer’s ERP system and often drives accrual forecasting calculations. Reconciling sell-out promotional demand against sell-in actuals reveals the forward-buy component of any promotional shipment spike.
UpClear’s Blue RGM automates this reconciliation, connecting sell-out data from NielsenIQ, Circana, or SPINS with sell-in data from SAP, Oracle, or NetSuite to produce a unified view of promotional performance. This results in a view that is accurate for both ROI measurement and financial management.
Beyond promotional ROI analysis, sell-out to sell-in translation is a critical input for CPG/FMCG supply chain planning. For instance, say a brand’s account management team builds a promotional volume forecast in Blue RGM’s Planner based on expected consumer sell-out. From there, that consumer forecast needs to be converted into a shipment-level production requirement for supply chain demand planning.
Blue RGM’s integrated business planning (IBP) capability facilitates this conversion. It provides the infrastructure for teams to translate account-level sell-out forecasts from NielsenIQ, Circana, or SPINS into sell-in shipment requirements that feed Blue RGM’s consensus demand signal.
This automation eliminates the manual forecast translation step that generates errors and delays in the commercial-to-supply-chain handoff. Enhanced visibility ensures that promotional volume spikes are visible to demand planning and production teams early enough to be accommodated without emergency production runs or retailer stockouts.
Sell-in data records shipments from a manufacturer to a retail customer or distributor, captured in the manufacturer’s ERP system at the point of invoice. Sell-out data records what consumers purchased at the retailer’s checkout, sourced from the retailer directly or from syndicated providers.
Retailers often pre-buy promotional stock one to three weeks ahead of a promotional window. This lead time may be built in to ensure availability, capture favorable funding rates, or build working capital advantages. This forward-buying creates a sell-in spike that precedes actual consumer demand, causing brands that rely only on sell-in data to overstate promotional lift and ROI.
No, sell-in data is still necessary for accounting. The problem is that using it as the basis for lift fails to account for forward-buying distortion, inflating ROI.
Sell-out data should be the primary basis for calculating promotional ROI, since it reflects true consumer response. Sell-in data remains essential for financial management, since it determines when revenue is recognized and often drives accrual forecasting. Reconciling the two reveals the forward-buy component of any shipment spike for a complete, accurate view.
UpClear es una empresa de software y desarrolladora de Blue, una intelligence platform utilizada por marcas de bienes de consumo. Ofrecemos una solución integral de gestión del crecimiento de los ingresos (Revenue Growth Management), que incluye funcionalidades de TPM, TPO, IBP y RGM. Nuestra misión es capacitar a las marcas para que maximicen el rendimiento de sus ingresos y la rentabilidad de sus inversiones comerciales mediante un software inteligente y colaborativo, que proporciona una única fuente de información fiable, una automatización optimizada e información útil para la toma de decisiones.
Blue , RGM Intelligence Platform, da soporte a los procesos integrales de gestión de ingresos, desde los brutos hasta los netos: planificación operativa anual, planificación de cuentas y ejecución. Las soluciones se integran con herramientas de análisis, inteligencia artificial intelligence y gestión de datos que conectan a los equipos y los sistemas empresariales.
Estamos aquí para ayudarte.
[email protected]
