IDEAS home Printed from https://ideas.repec.org/p/swe/wpaper/2015-13.html
   My bibliography  Save this paper

Sales Spotter: An Algorithm to Identify Sale Prices in Point-of-Sale Data

Author

Listed:
  • Iqbal A. Syed

    (School of Economics and CAER, UNSW Business School, UNSW)

Abstract

This paper develops an algorithm, called the sales spotter, which identifies the sale prices in the transaction price series provided in point-of-sale data. The goal of the sales spotter is to identify the maximum number of sale prices while minimizing the incorrect attribution of non-sale price reductions to sale prices. The spotter is developed and the values of its parameters are selected by analysing around 7.5 million agged sales in a US supermarket scanner data. At the optimal values of the parameters, the spotter identifies 84% of authentic agged sale weeks in the data.

Suggested Citation

  • Iqbal A. Syed, 2015. "Sales Spotter: An Algorithm to Identify Sale Prices in Point-of-Sale Data," Discussion Papers 2015-13, School of Economics, The University of New South Wales.
    • Handle: RePEc:swe:wpaper:2015-13
    as

    Download full text from publisher

    File URL: http://research.economics.unsw.edu.au/RePEc/papers/2015-13.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Daniel Hosken & David Reiffen, 2004. "Patterns of Retail Price Variation," RAND Journal of Economics, The RAND Corporation, vol. 35(1), pages 128-146, Spring.
    2. Dutta, Shantanu & Bergen, Mark & Levy, Daniel, 2002. "Price flexibility in channels of distribution: Evidence from scanner data," Journal of Economic Dynamics and Control, Elsevier, vol. 26(11), pages 1845-1900, September.
    3. Levy, Daniel & Müller, Georg & Chen, Haipeng (Allan) & Bergen, Mark & Dutta, Shantanu, 2010. "Holiday Price Rigidity and Cost of Price Adjustment," EconStor Open Access Articles and Book Chapters, ZBW - Leibniz Information Centre for Economics, vol. 77(305), pages 172-198.
    4. Patrick J. Kehoe & Virgiliu Midrigan, 2008. "Temporary price changes and the real effects of monetary policy," Working Papers 661, Federal Reserve Bank of Minneapolis.
    5. Judith A. Chevalier & Anil K. Kashyap & Peter E. Rossi, 2003. "Why Don't Prices Rise During Periods of Peak Demand? Evidence from Scanner Data," American Economic Review, American Economic Association, vol. 93(1), pages 15-37, March.
    6. Chahrour, Ryan A., 2011. "Sales and price spikes in retail scanner data," Economics Letters, Elsevier, vol. 110(2), pages 143-146, February.
    7. T.A. Lloyd & C.W. Morgan & S. McCorriston & E. Zgovu, 2011. "Do Sales Matter? Evidence from UK Food Retailing," Discussion Papers 11/01, University of Nottingham, School of Economics.
    8. Martin Eichenbaum & Nir Jaimovich & Sergio Rebelo, 2011. "Reference Prices, Costs, and Nominal Rigidities," American Economic Review, American Economic Association, vol. 101(1), pages 234-262, February.
    9. Jeffrey R. Campbell & Benjamin Eden, 2014. "Rigid Prices: Evidence From U.S. Scanner Data," International Economic Review, Department of Economics, University of Pennsylvania and Osaka University Institute of Social and Economic Research Association, vol. 55, pages 423-442, May.
    10. Emi Nakamura & Jón Steinsson, 2008. "Five Facts about Prices: A Reevaluation of Menu Cost Models," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 123(4), pages 1415-1464.
    11. Lloyd, Tim A. & Morgan, C. Wyn & McCorriston, Steve & Zgovu, Evious, 2011. "Do Sales Matter? Evidence from UK Food Retailing," 85th Annual Conference, April 18-20, 2011, Warwick University, Coventry, UK 108774, Agricultural Economics Society.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Ray, Sourav & Snir, Avichai & Levy, Daniel, 2023. "Retail Pricing Format and Rigidity of Regular Prices," EconStor Open Access Articles and Book Chapters, ZBW - Leibniz Information Centre for Economics, pages 1-1.
    2. Fox, Kevin J. & Syed, Iqbal A., 2016. "Price discounts and the measurement of inflation," Journal of Econometrics, Elsevier, vol. 191(2), pages 398-406.
    3. Kevin J, Fox. & Iqbal A. Syed, 2016. "Price Discounts and the Measurement of Inflation: Further Results," Discussion Papers 2016-05, School of Economics, The University of New South Wales.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Fox, Kevin J. & Syed, Iqbal A., 2016. "Price discounts and the measurement of inflation," Journal of Econometrics, Elsevier, vol. 191(2), pages 398-406.
    2. Snir, Avichai & Levy, Daniel, 2021. "If You Think 9-Ending Prices Are Low, Think Again," EconStor Open Access Articles and Book Chapters, ZBW - Leibniz Information Centre for Economics, vol. 6(1 (Forthc).
    3. Ray, Sourav & Snir, Avichai & Levy, Daniel, 2023. "Retail Pricing Format and Rigidity of Regular Prices," EconStor Open Access Articles and Book Chapters, ZBW - Leibniz Information Centre for Economics, pages 1-1.
    4. Kevin J, Fox. & Iqbal A. Syed, 2016. "Price Discounts and the Measurement of Inflation: Further Results," Discussion Papers 2016-05, School of Economics, The University of New South Wales.
    5. Levy, Daniel & Snir, Avichai & Gotler, Alex & Chen, Haipeng (Allan), 2020. "Not all price endings are created equal: Price points and asymmetric price rigidity," EconStor Open Access Articles and Book Chapters, ZBW - Leibniz Information Centre for Economics, issue forthcomi.
    6. Snir, Avichai & (Allan) Chen, Haipeng & Levy, Daniel, 2022. "Zero-ending prices, cognitive convenience, and price rigidity," Journal of Economic Behavior & Organization, Elsevier, vol. 203(C), pages 519-542.
    7. Avichai Snir & Daniel Levy, 2011. "Shrinking Goods and Sticky Prices: Theory and Evidence," Working Paper series 17_11, Rimini Centre for Economic Analysis.
    8. Giulietti, Monica & Otero, Jesús & Waterson, Michael, 2020. "Rigidities and adjustments of daily prices to costs: Evidence from supermarket data," Journal of Economic Dynamics and Control, Elsevier, vol. 116(C).
    9. Holzer, Patrick Sebastian, 2020. "The effect of time-varying factors on promotional activity in the German milk market," Journal of Retailing and Consumer Services, Elsevier, vol. 55(C).
    10. Bocionek, Milena & Anders, Sven M., 2012. "Estimating Price Rigidity in Vertically Differentiated Food Product Categories with Private Labels," Staff Paper Series 139931, University of Alberta, Department of Resource Economics and Environmental Sociology.
    11. Knotek, Edward S., 2024. "The roles of price points and menu costs in price rigidity," Journal of Monetary Economics, Elsevier, vol. 145(C).
    12. Daniel Levy & Dongwon Lee & Haipeng (Allan) Chen & Robert J. Kauffman & Mark Bergen, 2011. "Price Points and Price Rigidity," The Review of Economics and Statistics, MIT Press, vol. 93(4), pages 1417-1431, November.
    13. Tifaoui, Said & Cramon-Taubadel, Stephan von, 2015. "Temporary sales prices and findings of asymmetric vertical price transmission in scanner data," 89th Annual Conference, April 13-15, 2015, Warwick University, Coventry, UK 204295, Agricultural Economics Society.
    14. Guojun He & Jeffrey T. LaFrance & Jeffrey M. Perloff & Richard Volpe, 2024. "How do Everyday-Low-Price Supermarkets Adjust Their Prices?," Review of Industrial Organization, Springer;The Industrial Organization Society, vol. 64(1), pages 117-146, February.
    15. Joseph Vavra, 2011. "Inflation Dynamics and Time-Varying Uncertainty: New Evidence and an Ss Interpretation," 2011 Meeting Papers 126, Society for Economic Dynamics.
    16. Said Tifaoui & Stephan Cramon‐Taubadel, 2017. "Temporary Sales Prices and Asymmetric Price Transmission," Agribusiness, John Wiley & Sons, Ltd., vol. 33(1), pages 85-97, January.
    17. Alex Nikolsko‐Rzhevskyy & Oleksandr Talavera & Nam Vu, 2023. "The flood that caused a drought," Economic Inquiry, Western Economic Association International, vol. 61(4), pages 965-981, October.
    18. Berck, Peter & Brown, Jennifer & Perloff, Jeffrey M & Villas-Boas, Sofia B., 2007. "Sales: Tests of Theories on Causality and Timing," Department of Agricultural & Resource Economics, UC Berkeley, Working Paper Series qt2g56n1jk, Department of Agricultural & Resource Economics, UC Berkeley.
    19. Benjamin Eden, 2018. "Price Dispersion And Demand Uncertainty: Evidence From U.S. Scanner Data," International Economic Review, Department of Economics, University of Pennsylvania and Osaka University Institute of Social and Economic Research Association, vol. 59(3), pages 1035-1075, August.
    20. Berck, Peter & Brown, Jennifer & Perloff, Jeffrey M. & Villas-Boas, Sofia Berto, 2008. "Sales: Tests of theories on causality and timing," International Journal of Industrial Organization, Elsevier, vol. 26(6), pages 1257-1273, November.

    More about this item

    Keywords

    Promotional price; regular price; shelf price; sales filter; scanner data;
    All these keywords.

    JEL classification:

    • E30 - Macroeconomics and Monetary Economics - - Prices, Business Fluctuations, and Cycles - - - General (includes Measurement and Data)
    • M37 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Marketing and Advertising - - - Advertising

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:swe:wpaper:2015-13. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Hongyi Li (email available below). General contact details of provider: https://edirc.repec.org/data/senswau.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.