All Collections
HUB INDICATORS
Distribution Indicators
Customised rebased sales value distribution
Customised rebased sales value distribution
A
Written by Anthony Cabos
Updated over a week ago

Definition

The principle of rebasing is to refine your comparison universe.

Your comparator is no longer the entire pharmacy universe (in the case of "classic" distribution), but a specific variation of your market that you can define.

For a given product, the rebased selling value distribution compares the turnover of selling pharmacies of your selection, not to the turnover of total selling pharmacies of all products, but to the turnover of selling pharmacies of a selected variation of your dimension.

A rebased indicator allows you to work on a particular market segment in which you would be present.

To do this, you rebase your selector market in "On Demand Table".

The latter will allow the selection of the dimension(s) redefining the sales value distribution calculations.

Calculation

Customised rebased sales value distribution = Turnover of selling pharmacies of your selection / Turnover of selling pharmacies of the selected size

The interpretation of a rebased distribution of less than 5% should be taken with caution.

Butit would be incorrect :

• to add up the sales value distributions of several references, as it is possible (and highly probable) that the same pharmacy sells several products in the scope under consideration, not relating to the duplication of referencing.

• averaging the sales value distributions of several references, as this is not representative. As a minimum, for a selection of products, the distribution of selling values is the largest value of the observed numerical distributions and is usually higher.

# Example

A company A is active in the M, K and T markets.

You do not want to calculate your ratio on all products sold in pharmacies, but only on these three markets.

For market M, the pharmacies that sold A represent €1,200,000, whereas the total number of pharmacies in this market is €2,000,000
For market K, the pharmacies that sold A represent €2,000,000, whereas the total number of pharmacies in this market is €5,000,000

For market T, the pharmacies that sold A represent €1,300,000, whereas the total number of pharmacies in this market is €1,500,000

Then, Company A's custom rebased selling value distribution for markets M, K and T are :

• M : 60 % (1 200 000/2 000 000)

• K : 40 % (2 000 000/5 000 000)

• T : 87 % (1 300 000/1 500 000)

# Terminology

The Personalised Rebased Sales Value Distribution can be written as "Personalised Rebased VSL".

It is translated into English as "Custom Global WD Rebased".

# Geographical sectorisation / Customer type

In this case, the referent of your total value of pharmacies sold is that of the geographical or customer type sectorisation modality studied.

For example, your product is sold in 600 pharmacies in a geographical area with a turnover of €100,000,000 in your market segment and study period.

In the same sector, 1,000 pharmacies sold a product from your market segment over the same period for a total turnover of €150,000,000.

Your VED will then be 67% (€100,000,000 out of €150,000,000).

# Geographical territories

Metropolitan France excluding Corsica

Corsica

Monaco

DROM-COM

You can study the indicator in 3 ways:

• Aggregate over all the territories you follow,

• Individually for each territory,

• Aggregate in your geographical area.

# Limitations

The rebasing of the indicator is only in relation to the selection in Market Definition, so it cannot be done in relation to a hierarchical dimension.

Provision of data for Corsica-Monaco-DROM-COM :

• From the 15th of each month following the last month due

• PHARMA ONLY

Interpretation of the indicator for Monaco studied individually (not aggregated with other territories) :

• Given the disparity of pharmacies in this territory, care should be taken when interpreting the indicator when studying this territory alone