Dominick’s Dataset

DatasetsThis data is provided for academic research purposes only. All users of this data should acknowledge the James M. Kilts Center, University of Chicago Booth School of Business, in any working paper or publication that uses any portion of this data.

This is historical data. The products referred to in the UPC files are not for sale.

From 1989 to 1994, Chicago Booth and Dominick’s Finer Foods entered into a partnership for store-level research into shelf management and pricing. Randomized experiments were conducted in more than 25 different categories throughout all stores in this 100-store chain. As a by-product of this research cooperation, approximately nine years of store-level data on the sales of more than 3,500 UPCs is available in this dataset. This data is unique for the breadth of its coverage and for the information available on retail margins.


Dominick’s Dataset: Description and Download

The Dominick’s dataset covers store-level scanner data collected at Dominick’s Finer Foods over a period of more than seven years. The dataset contains two types of files: category-specific files and general files. The general files contain information pertaining to all the categories in the project.

The DFF dataset files, in zipped PC SAS format, are available for download. Please see the links below for more information on download locations. For more information, refer to the data manual.

General Files

Please refer to data manual for customer count file details, including variable names, descriptions, types, and lengths.

The customer count file includes information about in-store traffic. The data is store specific and on a daily basis. The customer count data refers to the number of customers visiting the store and purchasing something. Also in the customer count file is a total dollar sales and total coupons redeemed figure, by DFF defined department. These figures are compiled daily from the register/scanner receipts.

Please refer to data manual for customer count file details, including variable names, descriptions, types, and lengths.

Download the ccount file in the following formats:

for SAS V6 (ccount(sas6).zip)

for SAS V7 or higher ccount(sas7).zip)

for Stata (ccount(stata).zip)

The demographics file consists of store-specific demographic data. The data originally comes from US government (1990) census data for the Chicago metropolitan area. Market Metrics processed this data to generate demographic profiles for each of the DFF stores. The table below gives the descriptions for all the files in the demographics database.

Please refer to data manual for customer count file details, including variable names and descriptions.

Download the demographics file in the following formats:

for SAS V6 (demo(sas6).zip)

for SAS V7 or higher (demo(sas7).zip)

for Stata (demo(stata).zip)

Category-Specific Files

There are two files for each category studied in the course of the project. Each category is referenced by a three-letter acronym detailed in the manual, which you can download here.

The UPC files contain one record for each UPC in a category (xxx stands for the category acronym). They contain information about product name, size, commodity code, etc. The files are sorted by UPC.

The movement files contain weekly sales data for each UPC in each store for over five years. The variables included in these files comprise: price, unit sold, profit margin, deal code, etc. The files are sorted by UPC, store, week.

Category files can be downloaded by UPC or movement. Please refer to data manual for category details, UPC and movement data descriptions, file content, data organization, store numbers, dates for each week of data recorded, and other remarks.

The UPC files contain a description of each UPC in a category. The files are named upcxxx, where xxx is the three-letter acronym for the category. *Note: This is historical data and that the products referred to in the UPC files are not for sale.

The movement files contain sales information at the store level for each upc in a category. The information is stored on a weekly basis. The files are named wxxx where xxx is the three letter acronym for the category.

Use the UPC and Movement links below to download the category-specific datasets. Remember that the UPC files are named upcxxx and the movement files named wxxx where the xxx refers to the three-letter acronym used for file or variable naming purposes.

Category UPC Movement
Analgesics upcana wana
Bath Soap upcbat wbat
Beer upcber wber
Bottled Juices upcbjc wbjc
Cereals upccer wcer
Cheeses upcche wche
Cigarettes upccig wcig
Cookies upccoo wcoo
Crackers upccra wcra
Canned Soup upccso wcso
Dish Detergent upcdid wdid
Front-end-candies upcfec wfec
Frozen Dinners upcfrd wfrd
Frozen Entrees upcfre wfre
Frozen Juices upcfrj wfrj
Fabric Softeners upcfsf wfsf
Grooming Products upcgro wgro
Laundry Detergents upclnd wlnd
Oatmeal upcoat woat
Paper Towels upcptw wptw
Refrigerated Juices upcrfj wrfj
Soft Drinks upcsdr wsdr
Shampoos upcsha wsha
Snack Crackers upcsna wsna
Soaps upcsoa wsoa
Toothbrushes upctbr wtbr
Canned Tuna upctna wtna
Toothpastes upctpa wtpa
Bathroom Tissues upctti wtti

Dominick’s Dataset Papers

The Dominick’s data has been used in many working papers, published papers, and dissertations over the years. Below are some of the publications that have used the data from the Dominick’s research. If you know of a paper that is not listed below, please contact Katie Claussen Bell.

Sponsors

The project was financed by 17 manufacturers. Each sponsored one or two categories of products.

Sponsor Category
All-American Gourmet Frozen Entrees
Bristol-Meyers Analgesics
Campbell’s Soup Canned Soup
Coke Foods Frozen Beverages
Colgate-Palmolive Oral Care
Dish Detergent
Coors Brewing Co. Beer
General Mills Ready-to-Eat Cereals
Kraft Dairy Cheese
Nabisco Crackers
Pepsi Soft Drinks
Philip Morris Cigarettes
Procter & Gamble Laundry Detergent
Paper Towels
Quaker Oats Co. Hot Cereals
Scott Paper Bath Tissue
StarKist Canned Seafood
Tropicana Refrigerated Juices
Warner-Lambert Front-end Gum & Candy

Insights to Your Inbox

Sign up to receive emails from the Kilts Center to stay up to date on faculty research, alumni and student stories, and marketing at Booth.

Connect with Kilts

Connect with Kilts

Engage with the Kilts Center on social media by joining our LinkedIn showcase page.

Connect on LinkedIn »

Leverage Your Social Network

Share insights from the Kilts Center with colleagues and connections who share your passion for marketing.

Share This Page