IDEAS home Printed from https://ideas.repec.org/a/eee/ejores/v217y2012i3p664-672.html
   My bibliography  Save this article

An optimization method to estimate models with store-level data: A case study

Author

Listed:
  • Trindade, Graça
  • Ambrósio, Jorge

Abstract

The quality of the estimation of a latent segment model when only store-level aggregate data is available seems to be dependent on the computational methods selected and in particular on the optimization methodology used to obtain it. Following the stream of work that emphasizes the estimation of a segmentation structure with aggregate data, this work proposes an optimization method, among the deterministic optimization methods, that can provide estimates for segment characteristics as well as size, brand/product preferences and sensitivity to price and price promotion variation estimates that can be accommodated in dynamic models. It is shown that, among the gradient based optimization methods that were tested, the Sequential Quadratic Programming method (SQP) is the only that, for all scenarios tested for this type of problem, guarantees of reliability, precision and efficiency being robust, i.e., always able to deliver a solution. Therefore, the latent segment models can be estimated using the SQP method when only aggregate market data is available.

Suggested Citation

  • Trindade, Graça & Ambrósio, Jorge, 2012. "An optimization method to estimate models with store-level data: A case study," European Journal of Operational Research, Elsevier, vol. 217(3), pages 664-672.
    • Handle: RePEc:eee:ejores:v:217:y:2012:i:3:p:664-672
    DOI: 10.1016/j.ejor.2011.08.032
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0377221711008034
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.ejor.2011.08.032?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Sivakumar, K., 2004. "Manifestations and measurement of asymmetric brand competition," Journal of Business Research, Elsevier, vol. 57(8), pages 813-820, August.
    2. González-Benito, Óscar & Martínez-Ruiz, María Pilar & Mollá-Descals, Alejandro, 2009. "Using store level scanner data to improve category management decisions: Developing positioning maps," European Journal of Operational Research, Elsevier, vol. 198(2), pages 666-674, October.
    3. Still, Claus & Westerlund, Tapio, 2010. "A linear programming-based optimization algorithm for solving nonlinear programming problems," European Journal of Operational Research, Elsevier, vol. 200(3), pages 658-670, February.
    4. Randolph E. Bucklin & Sunil Gupta, 1999. "Commercial Use of UPC Scanner Data: Industry and Academic Perspectives," Marketing Science, INFORMS, vol. 18(3), pages 247-273.
    5. Shen, Chungen & Xue, Wenjuan & Chen, Xiongda, 2010. "Global convergence of a robust filter SQP algorithm," European Journal of Operational Research, Elsevier, vol. 206(1), pages 34-45, October.
    6. Andrés Musalem & Eric T. Bradlow & Jagmohan S. Raju, 2009. "Bayesian estimation of random‐coefficients choice models using aggregate data," Journal of Applied Econometrics, John Wiley & Sons, Ltd., vol. 24(3), pages 490-516, April.
    7. Sriram, S. & Kadiyali, Vrinda, 2009. "Empirical investigation of channel reactions to brand introductions," International Journal of Research in Marketing, Elsevier, vol. 26(4), pages 345-355.
    8. Ostermark, Ralf, 1999. "Solving Irregular Econometric and Mathematical Optimization Problems with a Genetic Hybrid Algorithm," Computational Economics, Springer;Society for Computational Economics, vol. 13(2), pages 103-115, April.
    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. Trindade, Graça & Dias, José G. & Ambrósio, Jorge, 2017. "Extracting clusters from aggregate panel data: A market segmentation study," Applied Mathematics and Computation, Elsevier, vol. 296(C), pages 277-288.
    2. Fernández, Arturo J., 2012. "Minimizing the area of a Pareto confidence region," European Journal of Operational Research, Elsevier, vol. 221(1), pages 205-212.

    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. Csilla Horváth & Dennis Fok, 2013. "Moderating Factors of Immediate, Gross, and Net Cross-Brand Effects of Price Promotions," Marketing Science, INFORMS, vol. 32(1), pages 127-152, July.
    2. Shaobo Li & Matthew J. Schneider & Yan Yu & Sachin Gupta, 2023. "Reidentification Risk in Panel Data: Protecting for k -Anonymity," Information Systems Research, INFORMS, vol. 34(3), pages 1066-1088, September.
    3. Sungho Park & Sachin Gupta, 2012. "Handling Endogenous Regressors by Joint Estimation Using Copulas," Marketing Science, INFORMS, vol. 31(4), pages 567-586, July.
    4. Trindade, Graça & Dias, José G. & Ambrósio, Jorge, 2017. "Extracting clusters from aggregate panel data: A market segmentation study," Applied Mathematics and Computation, Elsevier, vol. 296(C), pages 277-288.
    5. Harald J. van Heerde & Peter S. H. Leeflang & Dick R. Wittink, 2004. "Decomposing the Sales Promotion Bump with Store Data," Marketing Science, INFORMS, vol. 23(3), pages 317-334, December.
    6. Emek Basker, 2012. "Raising the Barcode Scanner: Technology and Productivity in the Retail Sector," NBER Chapters,in: Standards, Patents and Innovations National Bureau of Economic Research, Inc.
    7. Almohri, Haidar & Chinnam, Ratna Babu & Colosimo, Mark, 2019. "Data-driven analytics for benchmarking and optimizing the performance of automotive dealerships," International Journal of Production Economics, Elsevier, vol. 213(C), pages 69-80.
    8. Harikesh S. Nair & Sanjog Misra & William J. Hornbuckle IV & Ranjan Mishra & Anand Acharya, 2017. "Big Data and Marketing Analytics in Gaming: Combining Empirical Models and Field Experimentation," Marketing Science, INFORMS, vol. 36(5), pages 699-725, September.
    9. Kurt A. Jetta & Erick W. Rengifo, 2009. "Improved Baseline Sales," Fordham Economics Discussion Paper Series dp2009-02, Fordham University, Department of Economics.
    10. Guhl, Daniel, 2019. "Addressing endogeneity in aggregate logit models with time-varying parameters for optimal retail-pricing," European Journal of Operational Research, Elsevier, vol. 277(2), pages 684-698.
    11. Sunhee Choi & Sangno Lee & Wesley Friske, 2018. "The Effects of Featured Advertising and Package Labeling on Sustainability of Cause-Related Marketing (CRM) Products," Sustainability, MDPI, vol. 10(9), pages 1-12, August.
    12. Zhou, Meihua & Angelopoulos, Spyros & Ou, Carol & Liu, Hongwei & Liang, Zhouyang, 2023. "Optimization of dynamic product offerings on online marketplaces: A network theory perspective," Other publications TiSEM 75d71155-88bf-4ff7-aba1-9, Tilburg University, School of Economics and Management.
    13. Ostermark, Ralf, 2001. "Genetic modelling of multivariate EGARCHX-processes: evidence on the international asset return signal response mechanism," Computational Statistics & Data Analysis, Elsevier, vol. 38(1), pages 71-93, November.
    14. Hugo Storm & Thomas Heckelei & Ron C. Mittelhammer, 2016. "Bayesian estimation of non-stationary Markov models combining micro and macro data," European Review of Agricultural Economics, Oxford University Press and the European Agricultural and Applied Economics Publications Foundation, vol. 43(2), pages 303-329.
    15. K. Sudhir, 2001. "Structural Analysis of Manufacturer Pricing in the Presence of a Strategic Retailer," Marketing Science, INFORMS, vol. 20(3), pages 244-264, October.
    16. Ceren Kolsarici & Demetrios Vakratsas, 2015. "Correcting for Misspecification in Parameter Dynamics to Improve Forecast Accuracy with Adaptively Estimated Models," Management Science, INFORMS, vol. 61(10), pages 2495-2513, October.
    17. Stockton, Matthew C. & Capps, Oral Jr., 2005. "Nerlovian Hedonic Models For Three Different Container Sizes Of Fluid Milk," A.E. Research Series 305038, University of Idaho, Department of Agricultural Economics and Rural Sociology.
    18. Kapetanios, George, 2007. "Variable selection in regression models using nonstandard optimisation of information criteria," Computational Statistics & Data Analysis, Elsevier, vol. 52(1), pages 4-15, September.
    19. Breugelmans, Els & Campo, Katia, 2016. "Cross-Channel Effects of Price Promotions: An Empirical Analysis of the Multi-Channel Grocery Retail Sector," Journal of Retailing, Elsevier, vol. 92(3), pages 333-351.
    20. Mesak, Hani I. & Bari, Abdullahel & Luehlfing, Michael S. & Han, Fei, 2015. "On modeling the advertising-operations interface under asymmetric competition," European Journal of Operational Research, Elsevier, vol. 240(1), pages 278-291.

    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:eee:ejores:v:217:y:2012:i:3:p:664-672. 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: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/eor .

    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.