Dominick’s Dataset

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 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.

We have also provided these files in CSV format to make them more useful to researchers. Click here for the code used to convert SAS files to CSV. Note that the CSV files include the 'truncated' PRICE and PROFIT variables as well as the full precision in hexadecimal notation. Hence, the CSV files contain two new variables, PRICE_HEX and PROFIT_HEX, which if used give identical results as the original SAS files. All results based on the SAS files will be 100% replicable using the CSV files, i.e. there is no loss of information between conversion. Jens Mehrhoff completed this conversion and he suggests using the 'truncated' versions.

Note that there is no CSV file available for refrigerated juices. 

• Avichai Snir and Daniel Levy. "If You Think 9-Ending Prices Are Low, Think Again." JACR (2020): 33-47.
• Avichai Snir, Haipeng (Allan) Chen, Daniel Levy. "Zero-ending Prices, Cognitive Convenience, and Price Rigidity." Journal of Economic Behavior and Organization 203 (2022): 519-542.
• Levy, Daniel, Avichai Snir, Alex Gotler, and Haipeng (Allan) Chen. "Not All Price Endings Are Created Equal: Price Points and Asymmetric Price Rigidity." Journal of Monetary Economics 110 (2020): 33-49.
• Huang, Tao, Robert Fildes, and Didier Soopramanien. "The Value of Competitive Information in Forecasting FMCG Retail Product Sales and the Variable Selection Problem." European Journal of Operational Research (2014).

• Toro-González, Daniel, Jill J. McCluskey, and Ron C. Mittelhammer. "Beer Snobs do Exist: Estimation of Beer Demand by Type." Journal of Agricultural and Resource Economics (JARE) (2014).

• Jami, Ata and Himanshu Mishra. "Downsizing and Supersizing: How Changes in Product Attributes Influence Consumer Preferences." Journal of Behavioral Decision Making (2013).

• Eichenbaum, Martin, Nir Jaimovich and Sergio Rebelo. “Reference Prices, Costs, and Nominal Rigidities.” American Economic Review 101.1 (2011): 234–62.
• Guimaraes, Bernardo, and Kevin D. Sheedy. “Sales and Monetary Policy.” American Economic Review 101.2 (2011): 844–76. 
• Levy, Daniel, Dongwon Lee, Haipeng (Allan) Chen, Robert J. Kauffman, and Mark Bergen. “Price Points and Price Rigidity.” The Review of Economics and Statistics 93.4 (2011):1417-1431.
• Macé, Sandrine. “The Impact and Determinants of Nine-Ending Pricing in Grocery Retailing.” Journal of Retailing 88.1 (2012): 115-130. 
• Midrigan, Virgiliu. “Menu Costs, Multiproduct Firms, and Aggregate Fluctuations.” Econometrica 79.4 (2011): 1139–1180.
• Chahrour, Ryan A. "Sales and Price Spikes in Retail Scanner Data." Economics Letters 110 (2011) 143–146

• Meza, Sergio and K. Sudhir. “Do private labels increase retailer bargaining power?” Quantitative Marketing and Economics 8 (2010): 333–363. 
• Tsiros, Michael, and David M Hardesty. "Ending a Price Promotion: Retracting It in One Step or Phasing It Out Gradually." Journal of Marketing 74.1 (2010): 49-64.