Icon

Market Share KPI - sales company data (volume, sales)

<p>The market share KPI definition is:</p><p>"Measures the percentage of the target market accounted for by the business, from the overall existing market."</p><p>It can be measured by sales, <strong>your_sales / all_market_sales,</strong> or by volume, <strong>your_units_sold / all_market_unit<em>_</em>sold</strong></p><p>In this workflow we compute the market share KPI according to sales and units sold in 2023, using company sales data and survey data. We assume that customers only buy one product per year (ex. car, fridge).</p><p>We assume that the people who participated to the survey are representative of the population in the area.</p><p>These are the steps:</p><ol><li><p>Import sales and survey data and extract date and time information</p></li><li><p>Import competition prices</p></li><li><p>Count how many people responded "YES" to the survey and what products they purchased </p></li><li><p>Compute revenue from sales data </p></li><li><p>Use the market share from the survey and the sales data to estimate the reference market </p></li><li><p>Apply both KPI formula</p></li><li><p>Create a visualization</p></li></ol>

URL: KNIME for Finance - KNIME TV on YouTube https://www.youtube.com/playlist?list=PLz3mQ6OlTI0YHApzMfS3NBqctJo8mAMF_

3. Market Share KPI for:

  • one time purchase scenario (like a car)

  • Whole 2023

  • in amount of sales $

  • based on company data and survey data (for estimation of market size)

  • one company selling one product "prod A" for 100$

The market share KPI definition is: "Measures the percentage of the target market accounted for by the business, from the overall existing market." It can be measured by sales, your_sales / all_market_sales, or by volume, your_units_sold / all_market_unit_sold

In this workflow we compute the market share KPI for 2023 from survey data, assuming that the survey data are statistically representative of the population in the area.

VISUALIZE


Market Share by Volume (sold units) and by Sales ($)

IMPORT DATA


To calculate the market share KPI, we import the following data:

  • The results of a survey where a sample of consumers were asked about their purchases


CALCULATE KPI


Now that all the necessary data is prepared we have to apply the KPI formula.

PREPARE DATA


We start by computing the total number of sold units for the whole year (units), which will serve as the numerator in the KPI calculation.

Next, we use the survey data to estimate the size of our reference market in terms of volume for 2023, i.e. we count the number of survey respondants who bought this or a similar product in 2023. This estimate will serve as the denominator in the KPI calculation.

Since we assume that customers are buying only one item per year, the volume data corresponds to the total number of buyers.


units / total market %
Math Formula
all products prices
Excel Reader
extract year and monthfrom sale date
Date&Time Part Extractor
survey results toget infos aboutmarket size
Excel Reader
Extract survey data
transactionsby company
Excel Reader
units / total market %
Math Formula
monthly data
Extract company data
extract year and monthfrom sale date
Date&Time Part Extractor
title + KPI +bar charts
Market Share KPI
add prices
Joiner
adjust market size

Nodes

Extensions

Links