Geographical Advanced Indicators

View leading indicators by region or sector

Written by OpenHealth - Customer Success Center
Updated over a week ago

Module name

Trigram: GAI



The Geographical Advanced Indicators module allows you to understand the levers of growth or decline of a region or a sector:

  • Break down the evolution of sales values into a volume effect and a price effect

  • Break down the volume effect into a VMM effect (organic growth) and a Digital distribution effect

  • View regional or sector retail VMMs, DNVs and DVVs

  • Break down your leading indicators by type of pharmacy (optional)

This sheet is for you if:

  • You want to go beyond simply monitoring the performance of your sales force in Sales Volume and Sales Value

Data sources

  • Data from pharmacies

Geographic territories

  • Metropolitan France data

  • Corsica

  • DROM COM (Planned for the roadmap for 2019-Q4)


  • Limitations may apply depending on the size of the market

  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products



  • Territory Management Advanced

  • Change of sheet icon

  • Map enlargement

Objects found in the sheet

  • Functional cartridge

  • Time buttons

  • Time selector

  • Indicator buttons

  • Company selector

  • Stacked horizontal bar of leading indicators

  • Table Advanced Indicators Details


  • Sales value (To)

  • Weighted Average Sales Price (WASP, Weighted Average Sales Price) Average Monthly Sales (AMS)

  • Adjusted Average Monthly Sales (AMS A)

  • Selling digital distribution (ND, Numeric Distribution)

  • Weighted Distribution (WD)

  • Global Selling Digital Distribution (Global ND, Global Numeric Distribution)

  • Global Weighted Distribution (Global WD)


  • Customer type not applicable


  • On fine granularities such as at the product level, the 'Advanced Indicators Detail' table may display slowness or fall into error

  • The export of the 'Advanced Indicators Detail' table does not display the 'Totals' row in Excel

  • The Advanced Indicators will not work on the 3rd sectorization if it is present.


Current version:

  • Removed the message indicating incompatible GAIs on the 3rd layer when 3 layers there are. (These are now available in this version on the 3rd layer)

Old versions:

  • Drop-down selector: Passed in dynamic value with listing modified by the flow vF200921

  • Table "Advanced Indicator's Details: Minor modification of the Geography dimension so that it can take into account the 3 rd sectorization formed by an Aggr (removal of the brackets, Internal Technical Improvement)

  • Switch to the new narrow grid modeled on Market Analysis (Internal Technical Improvement)

  • Addition of the Data Input Warning within the traceability cartridge. (Internal Technical Improvement)

  • Implementation of dynamic reporting of the values of the analysis period type buttons.

  • Module accepted in this version of the standard. No change to report.

  • Correction on the N Global ND, N Global ND Delta, N Global WD, N Global WD Delta indicators in the "Advanced Indicators Detail" table

  • Review of the size of the digits on the map for better readability

  • Enlarged a standard grid tile upwards due to the increase in font size.

  • Revariability of the subscription within the cartridge. (New variable)

  • Enlargement of the map identical to the Cartography module

  • Standardization of the placement of "Reload Time" on the SMA standard

  • New cartography based on native map.

  • Fix for the link button to the success site

Did this answer your question?