Marketing Mix Modeling for a US-based Consumer Durables Firm

  • 20%

    net sales opportunities

  • 12.7%

    improvement in incremental sales

  • $28m

    annualized cost savings

  • 16%

    ROI improvement


CLIENT CHALLENGES
  • The client, a US CPG firm, wanted to quantify ROI of media vehicles such as DM and DRTV
  • The ROI was to be quantified over a two-year period, for which time series data on marketing spending on these vehicles and total sales through different channels was available
  • A multiplicative model was developed to forecast sales and arrive at the ROI from each vehicle
OUR APPROACH
  • Identified data elements, e.g. sales, media spending, macro variables
  • Performed sanity checks for variables, e.g. missing values, extreme values, etc.
  • Calculated ad-stock functions to arrive at the most appropriate function for decay
  • Tested for stationarity and autocorrelation in the sales time series and determined the appropriate differencing, autoregressive, and moving average terms
  • Developed models incorporating alternate sales response functions
  • Compared alternate models based on forecast accuracy and model stability
  • Derived ROI the change in sales per unit change in spend based on the model prediction
IMPACT DELIVERED
  • Enabled the client to estimate and comparatively evaluate the ROI from its various marketing channels
  • Both DRTV and DM spending contributed significantly to sales growth (DRTV was a larger contributor than DM and also had superior ROI)
Thank you for sharing your details

Your file will start downloading automatically

If it does not download within 1 minute,

Share this on

What we have done

Operational Process Efficiency Improvement for a Leading ERP Software Provider
What we are proud of

>50%

savings in staffing costs

25%

increase in outreach

Procurement in non-Food FMCG Industry
What we are proud of

>50%

savings in staffing costs

25%

increase in outreach