Extracting Service Quality from Online User Reviews: A Comparison of NLP Techniques
April 14, 2021
Deep Dives with Lichess I: Rating Transitions
August 1, 2021
Extracting Service Quality from Online User Reviews: A Comparison of NLP Techniques
April 14, 2021
Deep Dives with Lichess I: Rating Transitions
August 1, 2021
Show all

Estimating Market Shares w/o Sales Data

A Novel Approach using Online Listings and Reviews

Any market analysis starts with understanding the competitive landscape as well as the role and power of main players in that market, whether it is for an antitrust analysis or a regulatory counterfactual analysis.

In the absence of publicly available sales data, calculating market shares becomes nearly impossible.1 In one such instance, our team produced a novel approach for a federal investigation (by the International Trade Commission) to estimate market shares of home appliance manufacturers in the U.S., using product listings (prices and reviews) on the publicly available websites for Home Depot, Lowe’s, and Best Buy. In this white paper, we discuss the methodology and its strengths and weaknesses.

Online Shopping and User Reviews
There are many reasons why customers increasingly prefer shopping online, including convenience, ability to compare prices and consumer reviews, avoiding time and travel costs, and even avoiding crowds during the pandemic.2 According to a 2016 survey conducted by Pew Research Center, “82% of U.S. adults say they at least sometimes read online customer ratings or reviews before purchasing items for the first time, including 40% who say they always or almost always do so.3

Inspired by these observations, our team explored a seemingly simple but intuitive approach to approximating market shares using online product listings.  For product markets with a significant online presence and a relatively low number of seller platforms, is it possible to use product list prices and the number of customer reviews to estimate sales volumes?

In an ideal world, market shares are calculated either using units sold (quantity) or revenues (price times quantity sold). An illustration of this approach is shown below (per firm per product):4

Publicly available online listings contain information, such as list price and the number of reviews, on products sold by competitors in a specific product market. For major retail outlets (e.g., Sears, Best Buy, Home Depot, and Lowe’s, who collectively cover more than 80% of the U.S. home appliance market) we can aggregate such online data by utilizing [Price] x [Reviews] as “estimated sales”, in order to calculate the market shares. The accuracy of this estimation relies on multiple factors, which are discussed at a high level below.

i. How sensitive are the estimation results to the date of data scrape? 
Timing of the data collection can affect results due to price fluctuations and product variety and life-cycles. This can be a significant concern if the market shares rely exclusively on a few products instead of a variety of products. For example, if one product is at the beginning of its sales cycle and another at its end, this approach would bias the older product.5 In our case, home appliances cover hundreds of products across multiple manufacturers, and not any single manufacturer relies heavily on a single line item. Therefore, independent of when the price-review data are collected, there would be products in their mature stage and others in their early stage, preventing the methodology from biasing one brand over another due to timing.

CR Consumer Reports Inc., a non-profit research organization, reports that an average home appliance price typically falls slightly but steadily over time during its life cycle: about ~10% off its initial launch price within 12 months of its launch date.6 However, this applies to U.S. markets only, where we observe very stable and minimal inflation. For markets experiencing high inflation, this requires careful treatment. Even still, high inflation should not create a bias since the price is only a nominal and relative adjustment factor in this estimation. 

ii. How well the number of customer reviews represents the number of units sold?
To examine how well online user reviews represent quantity sold, we tested the underlying relationship by scraping data from the German online retailer Mind Factory,7 which discloses units sold for all of its online listed products along with the price information. Below we display the relationship between the number of online reviews and the total quantity sold for the best selling products.8 The hypothesized relationship is evident in the left graph. The graph on the right shows that this relationship becomes linear with higher number of sales (i.e. review percentage of units sold converges to a constant). These strongly suggest that reviews can be an appropriate proxy of the sales amount.

We observe, as suspected, that the relationship between the number of reviews and units sold is highly linear for larger samples, suggesting the number of reviews can be an asymptotically consistent estimator for quantity sold, a much desired statistical property.

iii. Number of outlets selling the products?
Lastly, and very importantly, the majority of the shopping platforms must be covered in the data collection process in order to ensure that a brand that is exclusively sold on a single platform is not biased against. In our example, over 80% of the home appliance market is represented by the top four players (Best Buy, Lowe’s Home Depot and Sears), enabling our approach to cover a majority of the market.

Results
We collected data from the top four retailer giants as described above, and compiled Price x Review based market share estimates.9 Then, we compared our estimates to (i) a publicly available estimate, and (ii) a Google Trends based estimation (another useful method commonly used to estimate market shares in product markets) as shown below:

BrandOur Approach:
[P x R] Estimated Market Shares
[Feb, 2020]
Actual Market
Share by Revenue, Ibis World estimate, [2017]10
Google Trends Based Market Shares
[Nov 19 – Oct 20]
GE25.84%23.60%27.80%
Whirlpool19.76%19.10%14.28%
LG Electronics7.86%9.10%12.69%
Electrolux1.89%8.00%1.88%
Samsung7.15%n/a13.35%
Others~ 30%
<Comparison of Price-Review Based Market Share Estimates For Major Home Appliances>

The results indicate that, in the absence of other options, researchers can turn to online product listings to estimate market shares, given the limitations considered in this white paper.

We are in the process of fine tuning this approach for a more rigorous application. Stay tuned for more!

  1. Although market share data of the largest players are crucial, in most cases it is nearly impossible to access such information due to the confidentiality of sales data. An exception is when all players are publicly traded and serve a very narrow range of products, where their SEC filings (10-K reports etc.) reflect their sales accurately for a specific product market.
  2. https://medium.com/@nyxonedigital/importance-of-e-commerce-and-online-shopping-and-why-to-sell-online-5a3fd8e6f416
  3. https://www.pewresearch.org/internet/2016/12/19/online-reviews/
  4. This illustration is artificially simulated to imitate the typical home appliance market product life-cycle process. See Parker, P., & Neelamegham, R. (1997). Price elasticity dynamics over the product life cycle: A study of consumer durables. Marketing Letters, 8(2), 205-216.
  5. In such cases, a strong remedy is to conduct periodic data pulls to ensure covering the full life-cycle of the products, and not to rely on a single data pull.
  6. https://www.consumerreports.org/discounts-rebates/when-to-get-the-best-deals-on-appliances/
  7. https://www.mindfactory.de/
  8. We limited our data collection to computer processors because Mind Factory has limited number of sales data in the household appliance market, which is insufficient for the statistical analysis that follows.
  9. Available upon request, please email at info@iamecon.com
  10. http://staging.laminations.greatnorthernpackaging.com/wp-content/uploads/2018/02/33522-Major-Household-Appliance-Manufacturing-in-the-US-Industry-Report.pdf