IDEAS home Printed from https://ideas.repec.org/p/ems/eureri/22614.html
   My bibliography  Save this paper

To Aggregate or Not to Aggregate: Should decisions and models have the same frequency?

Author

Listed:
  • Kiygi Calli, M.
  • Weverbergh, M.
  • Franses, Ph.H.B.F.

Abstract

We examine the situation where hourly data are available to design advertising-response models, whereas managerial decision making can concern hourly, daily or weekly intervals. The key question is how models for hourly data compare to models based on weekly data with respect to forecasting accuracy and with respect to assessing advertising impact. Simulation experiments suggest that the strategy, which entails modeling the least aggregated data and forecasting more aggregate data, yields better forecasts, provided that one has a correct model specification for the higher frequency data. A detailed analysis of three actual data sets confirms this conclusion. A key feature of this confirmation is that aggregation affects data transformation to dampen the variance. The estimated advertising impact is sensitive to the appropriate transformation. Our conclusion is that disaggregated models are preferable also when decision have to be made at lower frequencies.

Suggested Citation

  • Kiygi Calli, M. & Weverbergh, M. & Franses, Ph.H.B.F., 2010. "To Aggregate or Not to Aggregate: Should decisions and models have the same frequency?," ERIM Report Series Research in Management ERS-2010-046-MKT, Erasmus Research Institute of Management (ERIM), ERIM is the joint research institute of the Rotterdam School of Management, Erasmus University and the Erasmus School of Economics (ESE) at Erasmus University Rotterdam.
    • Handle: RePEc:ems:eureri:22614
    as

    Download full text from publisher

    File URL: https://repub.eur.nl/pub/22614/ERS-2010-046-MKT.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Robert C. Blattberg & Abel P. Jeuland, 1981. "A Micromodeling Approach to Investigate the Advertising-Sales Relationship," Management Science, INFORMS, vol. 27(9), pages 988-1005, September.
    2. Ram C. Rao, 1986. "Estimating Continuous Time Advertising-Sales Models," Marketing Science, INFORMS, vol. 5(2), pages 125-142.
    3. Gary J. Russell, 1988. "Recovering Measures of Advertising Carryover from Aggregate Data: The Role of the Firm's Decision Behavior," Marketing Science, INFORMS, vol. 7(3), pages 252-270.
    4. Winer, Russell S, 1979. "An Analysis of the Time-varying Effects of Advertising: The Case of Lydia Pinkham," The Journal of Business, University of Chicago Press, vol. 52(4), pages 563-576, October.
    5. Gerard J. Tellis & Philip Hans Franses, 2006. "Optimal Data Interval for Estimating Advertising Response," Marketing Science, INFORMS, vol. 25(3), pages 217-229, 05-06.
    6. Windal, Pierre M & Weiss, Doyle L, 1980. "An Iterative GLS Procedure for Estimating the Parameters of Models with Autocorrelated Errors Using Data Aggregated over Time," The Journal of Business, University of Chicago Press, vol. 53(4), pages 415-424, October.
    7. Robert P. Leone, 1995. "Generalizing What Is Known About Temporal Aggregation and Advertising Carryover," Marketing Science, INFORMS, vol. 14(3_supplem), pages 141-150.
    8. Paul De Bruin & Philip Hans Franses, 1999. "Forecasting power-transformed time series data," Journal of Applied Statistics, Taylor & Francis Journals, vol. 26(7), pages 807-815.
    Full references (including those not matched with items on IDEAS)

    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. Kiygi-Calli, Meltem & Weverbergh, Marcel & Franses, Philip Hans, 2017. "Modeling intra-seasonal heterogeneity in hourly advertising-response models: Do forecasts improve?," International Journal of Forecasting, Elsevier, vol. 33(1), pages 90-101.
    2. Gerard J. Tellis & Philip Hans Franses, 2006. "Optimal Data Interval for Estimating Advertising Response," Marketing Science, INFORMS, vol. 25(3), pages 217-229, 05-06.
    3. Prasad A. Naik & Murali K. Mantrala & Alan G. Sawyer, 1998. "Planning Media Schedules in the Presence of Dynamic Advertising Quality," Marketing Science, INFORMS, vol. 17(3), pages 214-235.
    4. Eelco Kappe & Ashley Stadler Blank & Wayne S. DeSarbo, 2014. "A General Multiple Distributed Lag Framework for Estimating the Dynamic Effects of Promotions," Management Science, INFORMS, vol. 60(6), pages 1489-1510, June.
    5. Franses, Philip Hans, 2006. "Forecasting in Marketing," Handbook of Economic Forecasting, in: G. Elliott & C. Granger & A. Timmermann (ed.), Handbook of Economic Forecasting, edition 1, volume 1, chapter 18, pages 983-1012, Elsevier.
    6. Chan, Tat Y. & Narasimhan, Chakravarthi & Yoon, Yeujun, 2017. "Advertising and price competition in a manufacturer-retailer channel," International Journal of Research in Marketing, Elsevier, vol. 34(3), pages 694-716.
    7. Lizhen Xu & Jason A. Duan & Andrew Whinston, 2014. "Path to Purchase: A Mutually Exciting Point Process Model for Online Advertising and Conversion," Management Science, INFORMS, vol. 60(6), pages 1392-1412, June.
    8. Zizhuo Wang & Chaolin Yang & Hongsong Yuan & Yaowu Zhang, 2021. "Aggregation Bias in Estimating Log‐Log Demand Function," Production and Operations Management, Production and Operations Management Society, vol. 30(11), pages 3906-3922, November.
    9. M. Berk Ataman & Carl F. Mela & Harald J. van Heerde, 2008. "Building Brands," Marketing Science, INFORMS, vol. 27(6), pages 1036-1054, 11-12.
    10. Philip Hans Franses, 2021. "Marketing response and temporal aggregation," Journal of Marketing Analytics, Palgrave Macmillan, vol. 9(2), pages 111-117, June.
    11. Grewal, Rajdeep & Mills, Jeffrey A. & Mehta, Raj & Mujumdar, Sudesh, 2001. "Using cointegration analysis for modeling marketing interactions in dynamic environments: methodological issues and an empirical illustration," Journal of Business Research, Elsevier, vol. 51(2), pages 127-144, February.
    12. Harald J. van Heerde & Shuba Srinivasan & Marnik G. Dekimpe, 2010. "Estimating Cannibalization Rates for Pioneering Innovations," Marketing Science, INFORMS, vol. 29(6), pages 1024-1039, 11-12.
    13. Frank M. Bass & Norris Bruce & Sumit Majumdar & B. P. S. Murthi, 2007. "Wearout Effects of Different Advertising Themes: A Dynamic Bayesian Model of the Advertising-Sales Relationship," Marketing Science, INFORMS, vol. 26(2), pages 179-195, 03-04.
    14. Michele Giordano & Anton Yurchenko-Tytarenko, 2024. "Optimal control in linear-quadratic stochastic advertising models with memory," Decisions in Economics and Finance, Springer;Associazione per la Matematica, vol. 47(1), pages 275-298, June.
    15. Mingyung Kim & Eric T. Bradlow & Raghuram Iyengar, 2022. "Selecting Data Granularity and Model Specification Using the Scaled Power Likelihood with Multiple Weights," Marketing Science, INFORMS, vol. 41(4), pages 848-866, July.
    16. Michis Antonis A, 2009. "Regression Analysis of Marketing Time Series: A Wavelet Approach with Some Frequency Domain Insights," Review of Marketing Science, De Gruyter, vol. 7(1), pages 1-43, July.
    17. Sridhar, Shrihari & Naik, Prasad A. & Kelkar, Ajay, 2017. "Metrics unreliability and marketing overspending," International Journal of Research in Marketing, Elsevier, vol. 34(4), pages 761-779.
    18. Dorotic, Matilda & Verhoef, Peter C. & Fok, Dennis & Bijmolt, Tammo H.A., 2014. "Reward redemption effects in a loyalty program when customers choose how much and when to redeem," International Journal of Research in Marketing, Elsevier, vol. 31(4), pages 339-355.
    19. Bradley T. Shapiro, 2020. "Advertising in Health Insurance Markets," Marketing Science, INFORMS, vol. 39(3), pages 587-611, May.
    20. Cotterill, Ronald W & Putsis, William P, Jr & Dhar, Ravi, 2000. "Assessing the Competitive Interaction between Private Labels and National Brands," The Journal of Business, University of Chicago Press, vol. 73(1), pages 109-137, January.

    More about this item

    Keywords

    advertising effectiveness; advertising response; aggregation; normative and predictive validity;
    All these keywords.

    JEL classification:

    • C44 - Mathematical and Quantitative Methods - - Econometric and Statistical Methods: Special Topics - - - Operations Research; Statistical Decision Theory
    • M - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics
    • M31 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Marketing and Advertising - - - Marketing

    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:ems:eureri:22614. 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: RePub (email available below). General contact details of provider: https://edirc.repec.org/data/erimanl.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.