Icon

Market Share KPI - survey data (volume)

<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 units sold in 2023, using data from a survey. 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 data and extract date and time information</p></li><li><p>Count how many people responded "YES" to the survey</p></li><li><p>Count how many items were bought per product type</p></li><li><p>Apply the 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_

1. Market Share KPI for:

  • one time purchase scenario (like a car)

  • Whole 2023

  • in number of sold units

  • based on survey data

  • one company selling one product "prod A"

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 using by volume, assuming that the survey data are statistically representative of the population in the area.

VISUALIZE


Market Share by Volume (sold units)

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.


survey results toget infos aboutmarket size
Excel Reader
units / total market %
Math Formula
extract year and monthfrom sale date
Date&Time Part Extractor
Visualize KPI
Market Share KPI
Extract data 2023

Nodes

Extensions

Links