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
Data for Metropolitan France excluding Corsica & DROM-COM
Market definition 'all products' only
Applicable on human drug, veterinary drug and non-drug
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:
YTD (Year To Date)
MAT (Mooving Annual Total)
Module received on the v2004271727 version of the standard; no change from the v2004070930 version of this module
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