Features of the OpenHealth panel

The panel of OpenHealth pharmacies in Metropolitan France (excluding Corsica) is built on a multi-stratified model taking into account several criteria, including :

  • The overall turnover of pharmacies

  • Their geographical positioning

  • Their location situation

The multi-stratified model is a multi-dimensional vision of the officinal universe, there are as many dimensional axes as there are stratification criteria.

We work on a daily basis with data at D+1 which are frozen after a period of 5 days.

Thus, on the 6th of each month you can consult the frozen data of the previous month.

Territory covered: Metropolitan France

Evolution of the OpenHealth panel

#Reference pharmacies (as of 24/09/2020)

The OpenHealth pharmacy reference database lists all city pharmacies (20,661* in metropolitan France excluding Corsica on 24/09/2020).

Control of the reference system, updated daily and in real time, ensures a very good quality of information on the pharmacy stratification criteria. This repository is the basis for extrapolation.

*Pharmacy pharmacies in the following territory: Metropolitan France (excluding Corsica, Monaco, excluding DROM COM) (source: FINESS)

#Panel of 11,243 pharmacies (as at 24/09/2020) - (excluding Corsica / Monaco / DROM COM)

Since the model is adaptive, the increase in the number of transmitters has no impact on the quality of the current and future extrapolation on each of the strata.

The results will be comparable and will ensure continuity in the monitoring of pharmacy sales.

The increase in the number of transmitters over the last few years (see below) has several advantages for the benefit of customers:

  • Increased measurement of low-DN products and launches.

  • Offer extended coverage of market-specific pharmacies, such as large manufacturers

  • Enable finer geographic granularities for sector data

  • The evolution of the OpenHealth panel takes into account the concentration of sales and the emergence of mega-pharmacies.

#8,100 stockist pharmacies (as of 03/06/2020)

72% of the pharmacies in the OpenHealth sales panel are mobilized to constitute the stock panel (i.e. 8,100 stockist pharmacies).

In the same way that criteria of good transmission are used for sales, the same is true for stocks.

Criteria for the quality of stock transmission are added, in terms of quality and timing, to the criteria for the quality of sales transmission in order to define the panel of stockist pharmacies.

#Coverage rate (as at 28/09/2019)

#Detailed coverage on different criteria (as at 28/09/2019)

Turnover strata :

Zone implantation :

UDA (5 Regions) :

Panel specification: extrapolation model

#Dynamic extrapolations

The pharmacy sales data extrapolation model is a dynamic and adaptive model based on all these criteria.

The principle of extrapolation of the OpenHealth panel is based on assigning a representativeness weight to each of the strata.

These weights are calculated in real time, and for each stratum, by the ratio of the number of pharmacies that have transmitted data to the actual number of pharmacies meeting all the stratum's criteria.

The extrapolation coefficients thus obtained are applied to the sales ticket data to obtain the sales extrapolated to the total for metropolitan France (excluding Corsica).

As the extrapolation model is adapted to the number of transmitters, the consequence is that the application of extrapolation coefficients leads to comparable results regardless of the number of transmitters.

#Parameterization of the platform The HUB

Each subscription on the HUB platform provides for the setting up of a panel extrapolation parameterization that is either static or dynamic.

Some of our customers choose a static parameterization, within the framework of certain personalized options (in particular for the follow-up of a "CUSTOMER TYPE").

# Traceability of The HUB platform

OpenHealth has a commitment of traceability towards its clients.

This concerns the critical points of parameterization of its deliverables:

  • Definition of product aggregates: list of underlying GTINs available at any time + traceability on the evolution over time

  • Method of calculating the indicators (available at https://www.successthehub.com)

This traceability throughout its industrial process has given OpenHealth a special position vis-à-vis the Health Authorities and has done so for more than 10 years.

Did this answer your question?