Search

 
  In this section  
  Publications  
    ACNielsen Insights Asia Pacific  
    Consumer Insight Magazine  
    RFID: Insights Beyond the Bar Code  
  Reports and Studies  
  Related information  
  Business Issues  
    Brand Dynamics  
    Category Dynamics  
    Competitive Analysis  
    Consumer Loyalty  
    Distribution  
    Location Information Management  
    Market Dynamics  
    New Brand Launch  
    New Product Introductions  
    Pricing  
    Product Opportunities  
    Promotion Efficiency and Effectiveness  
    Retail Performance  
    Understanding the Consumer  
 
Trends & Insights     >     Publications   >     Consumer Insight Magazine

Case Study: The Power of Integrated Data

Allied Domecq Makes Full Use of Available Data to Gain Better Business Insights

John Petch
Director, Category Development
Allied Domecq

Marianne Frasco
SVP, Strategic Market Development
TDLinx


Facing stiff competition, beverage alcohol suppliers need to make use of all available data to draw actionable insights about their business. However, just determining total sales alone from off- and on-premise channels is a complicated and cumbersome process. Disparate data that help compile sales information— shipments to, distributors, depletions to stores, and sales from control state agencies—come from a variety of sources.

Once pieced together, these data elements comprise the total sales picture; however, to analyze what is happening in the marketplace beyond just raw sales data, one needs to add in retail measurement data. This becomes an almost insurmountable task when bringing all the pieces to analyze in aggregate. A solution to this industry challenge is to link the disparate data sources through a common standard. TDLinx, an ACNielsen brand, provides that solution [See chart 1].



Challenges for the Beverage Alcohol Industry
An underlying challenge for the industry is the three-tier distribution process for spirits and wine marketers. It is made up of manufacturers (suppliers), who ship product to wholesalers, who then distribute product to off-premise (retail) and on-premise outlets. Complicating this system are individual state laws that govern the sale of alcohol.


"Control states," comprised of 18 states plus Montgomery County, MD, use government agencies at the wholesale level to control the sale of distilled spirits and wine [See chart 2]. Twelve of these jurisdictions also exercise control over retail sales through government operated package stores or designated outlets.


Control state sales data is compiled by the National Alcohol Beverage Control Association (NABCA), which serves as a data clearinghouse for account and depletion level data for their members.

Wholesaler depletion data for open states is collected and made available by Beverage Data Network (BDN), the primary source of depletion and retail account data collection in the wine and spirits industry. Complementing retail depletion data from BDN is the syndicated POS data from ACNielsen's Scantrack service. The POS information generally covers about 50% of off-premise retail volume (or 35% of the total volume), as scanning markets for the sale of alcohol are limited to "open states" and to selected markets and accounts [See chart 3].



"Rocky"—A Case Study
For Allied Domecq, the need was to better understand their marketplace to boost sales beyond traditional methods as traditional methods were not providing enough data to analyze the consumer attitude of the brand nor quantify specific marketing targeting changes. To do this, the company needed to use all the data and tools available to make sure they understood shipments and depletions—connecting the raw data to find nuances and trends. Allied Domecq demonstrated how they used these tools in a case study. The brand is masked here under the name "Rocky."
Allied Domecq used ACNielsen Scantrack services to identify the market or markets that represented the biggest issue. By drilling into market- and account-level information, they were able to identify the problem areas. Florida market and accounts emerged as an issue.

The next step was to identify their Rocky consumers and where they shopped. Traditionally, Allied Domecq had relied on their own consumer research and ACNielsen Homescan consumer panel data to understand the consumer demographic profiles on a national level. However, as is often the case with beverage/alcohol accounts, samples can be small on a regional or state level.

Using distributor depletion data as fuel for Spectra's Localizer system, the stores and neighborhoods where Rocky was selling exceptionally were identified. With the help of TDLinx, Allied Domecq had confidence that their depletion data—linked to actual stores through TDLinx Codes—was correct, and that they could drill down into the marketplace. This allowed for more precise targeting to project same store sales, volume and profits.

After looking at depletion movement information over the current two-year period, Allied Domecq identified over 3,000 stores, of which 578 stores were found to have sufficient movement to create a local Rocky Florida profile.



Allied Domecq then looked at Florida designated market areas (DMAs) to create the local Rocky Florida profiles. Out of the ten DMAs, there were five with a sufficient sample: Miami, Orlando, Jacksonville, Fort Myers and Tampa. The national profile for Rocky showed that Rocky skewed toward the younger households with no kids. Allied Domecq's advertising message was going out to "Party People."

However, for Rocky in Florida, they discovered there were differences among the markets. The market profiles skewed toward younger households with kids, as well as an older empty nester skew. This made sense because of Florida's high concentration of aging consumers and Hispanic families with kids.

By gaining these new insights into how to reach consumers in Florida, the decision was made to market to people within each DMA, getting out the right message by DMA. Allied Domecq was able to identify stores that fit the high opportunity Rocky profile but were under-performing. They then were able to calculate the potential upside for targeting and converting those shoppers. The end result was an upside potential opportunity of an incremental 15% increase.

By combining several information sources—depletion data, ACNielsen Scantrack and Homescan information, targeted with Spectra information, all combined via TDLinx—Allied Domecq had the key to uncovering untapped consumer opportunities within local markets as never before. Allied Domecq was able to establish a better picture of local consumers, so their marketing dollars could be used to more effectively target stores with the right consumer message. These are opportunities that, if only partially realized, could represent millions of dollars to the bottom line.





Email this page

Download PDF
(356k)



More Trends & Insights

Executive Insight

Alternative Marketing Vehicles: The Future of Marketing ‘To One’

ACNielsen 2002 Trade Promotion Practices Study

Case Study: Combining Product Assortment and Space Management

The Changing Medical Needs of Consumers

As the World Turns... Hispanic Medical Needs

Trendwatch—Consumers Quench Thirst with a Flood of Bottled Waters

© The Nielsen Company Sitemap             Privacy policy             Terms of use             Help             Contact Nielsen Answers login