Table of Contents

Marketshare queries

Ramya Priya Updated by Ramya Priya

Marketshare is a performance metric used to measure a company's sales or market share relative to the total sales or performance of a specific market or industry. The following documentation includes syntax and examples that will help you understand how to accurately calculate marketshare and get valuable insights into your company's performance.

Syntax

Marketshare KPI for target variable for/by filters/dimensions

  • Green-colored text represents the KPI (key performance indicator) that you want to measure, such as TRx or NRx. It is always the word that follows “Marketshare”.
  • Red-colored text is the target variable or marketshare filter (i.e., filter in numerator which will not be present in the denominator). This is the text that follows the KPI; unless there is a "vs" or "compared to" keyword, in which case it would be the first two words.
  • Blue-colored text is the list of global filters (the parameters you want to apply in your marketshare analysis). There could be multiple filters after a "for" or "in”.
For refined search query results, please make sure to add a time period. Example: for L4W (last 4 weeks), in 2023, for L4W vs L4WYA

Examples

Marketshare dollar sales for Brand A in 2019

MathJax Example

$$\frac{\text{Dollar sales for Brand A in 2019}}{\text{Total dollar sales in 2019}}$$

Marketshare dollar sales for Brand A vs Brand B for New York for Derm            

is the same as

Marketshare dollar sales for Brand A compared to Brand B for Derm for New York

MathJax Example

$$\frac{\text{Dollar sales for Brand A in New York}}{\text{Total dollar sales in New York}}\ =\ \frac{\text{Dollar sales for Brand B in New York}}{\text{Total dollar sales in New York}}$$

Marketshare dollar sales for brand by state

This shows the multiple values for each brand for a particular state, where the different brands would sum upto 100%

MathJax Example

$$\frac{\text{Dollar sales for a particular brand for state}}{\text{Total dollar sales for state}}$$

Marketshare dollar sales for state by brand

This shows the multiple values for each brand with the shares of state among other tiers (where the different brands would not sum upto 100%)

MathJax Example

$$\frac{\text{Dollar sales for state for a particular brand}}{\text{Total dollar sales for the brand}}$$

Marketshare dollar sales for Brand X by segment

This shows the share of sales Brand X has within each segment (which does not add up to 100%)

MathJax Example

$$\frac{\text{Dollar sales for Brand X in a particular segment}}{\text{Total dollar sales for a particular segment}}$$

Marketshare dollar sales for/by segment for Brand X

This shows the share of each segment's sales for Brand X (same as the percentage of dollar sales in XYZ, and adds up to 100%)

MathJax Example

$$\frac{\text{Dollar sales for Brand X in a particular segment}}{\text{Total dollar sales for Brand X}}$$

Marketshare dollar sales for Brand X in 2021 compared to 2022

MathJax Example

$$\frac{\text{Dollar sales for Brand A in 2021}}{\text{Total dollar sales in 2021}}\ =\ \frac{\text{Dollar sales for Brand A in 2022}}{\text{Total dollar sales in 2022}}$$

Did we help you?

List View In Search Results

Contact