Pharmacy Monitoring (1/2)

Follow the evolution of pharmacy traffic

Maxime LE MOIGNIC avatar
Written by Maxime LE MOIGNIC
Updated over a week ago



Because the evolution of in-office traffic is symptomatic of particular health contexts, it is important to analyse these indicators as exogenous factors to your commercial performance:

  • Number of working days

  • Number of pharmacy tickets across all products

  • Number of items (volume) per ticket

This module is for you if:

  • You want to better understand exogenous factors in pharmacy

  • Create pro forma analyses of your performance, excluding traffic trends and number of working days

Sources of data

  • Pharmacy data. Possibility to filter data with or without

Geographic territories

  • Data for Metropolitan France excluding Corsica & DROM-COM


  • Market definition 'all products' only

  • Applicable on human drug, veterinary drug and non-drug



  • Functional cartridge

  • Time buttons

  • Nested table objects 'Analysis of days, traffic and average basket'


  • Total number of (working) days

  • Number of tickets (traffic)

  • Number of tickets / working days

  • Volume / ticket


The temporalits in this sheet are to be considered in relation to the defined deadline.

The nested curve graphs present either a month-to-month or cumulative PAS view.

Type of analysis period available:

  • Month (Mth)

  • Qtr (Quarter)

  • YTD (Year To Date)

  • MAT (Mooving Annual Total)


Current version:

  • Module received on the v2004271727 version of the standard; no change from the v2004070930 version of this module

Previous versions:

  • Adding value labels to the 5 nested graphs on the sheet

  • Setting up the dynamic scaling for each.

  • Variability of subscription within the cartridge.

  • From the evolution table (in the Pharmacy Monitoring Evolution sheet)

  • Calculating the current month for the analysis table

  • Changing the wording

  • Change to the calculation of the latest pharmacy data present

  • Variable addition of the term "Global pharmacy traffic"

  • Deletion of the market name from the title block to highlight that this is indeed all pharmacy traffic

  • Changing the chronological order of years on the "Year on year comparison" dot plot

  • Adding the MAT button

  • Correction to the Year on year comparison graph on the "Cumulated" part for NB OF WORKING DAYS and NB OF TICKETS / WORKING DAYS

  • Creating the sheet



Did this answer your question?