Key Elements: Cleans, baselines, models, and integrates direct-from-retailer DSR data with syndicated or other tracking information Provides normal price and sales rates by store, item, week, or day Forecasts demand at the day/store/SKU level and helps inventory planning Can cover full marketing mix, including advertising and coupons

Many leading retailers are now sharing store level POS and inventory data directly with their major consumer goods partners. CPG companies can use this information to manage their supply chain more efficiently with fewer stock outs and to execute trade promotions more profitably.

While retailers such as Walmart provide data through proprietary interfaces, other retailers provide data in multiple formats, including EDI data feeds, Excel files, etc. Each retailer has its own data sharing and business rules for interpreting the data. Marketing Analytics has proven experience in integrating and harmonizing such data sets to analytic applications. We have an extensive library of tested, reusable data load and integration programs. Our ability to scale, automate, and produce rapid updates to existing models is unmatched in the industry.

We successfully built models for many of our clients using data directly from Walmart’s Retail Link® resource. With this weekly, store-level sales detail, we can provide the same kind of visibility into Walmart price and promotion response that you used to get only from trade channels reporting POS to Nielsen and IRI. Given necessary additional data on the full marketing mix, we can extend Retail Link® sales models to show how advertising and consumer promotions impact your Walmart business.

Decompose Sales into Baseline and Incremental

►   Baseline sales ►   Base Prices (regular prices) ►   Percent ACV with various promotional conditions ►   Base price elasticities ►   Promoted price elasticities ►   Lifts by type of merchandising