Export to Excel your sales value, sales volume, market share value and market share volume:
Query your database using all your dimensions
Possibility of going down to daily sales over 36 months
This module is for you if:
You want to download raw data, in order to feed it back into a BI tool or to carry out analysis work in Excel
Export raw data to transmit it to your global team
Data from pharmacies
Metropolitan France data
DROM-COM: Guadeloupe, Reunion, Martinique, Guyana
No limitation on the size of the markets
Applicable to human medicinal products, veterinary medicinal products and non-medicinal products
Sales & Marketing Essential
Objects found in the sheet
Object 'My Data Archve'
Day and week timing on option
International data on request
Exhaustive listing of Indicators & measures to date in My Data Archive:
N To MS
N Vol MS
Fields found in the All Products / MP4U version
ANS ATCVet Level1
ANS ATCVet Level2
ANS ATCVet Level3
ANS ATCVet Level4
ANS ATCVet Level5
ANS Code ATCVet
EphMRA Code Level 1
EphMRA Code Level 2
EphMRA Code Level 3
EphMRA Code Level 4
OHC Classification Level 1
OHC Classification Level 2
OHC Classification Level 3
OHC Classification Level 4
OHC Classification Level 5
OMS Code Level 1
OMS Code Level 2
OMS Code Level 3
OMS Code Level 4
OMS Code Level 5
TECHNICAL CODE 2
THE_Dosage Base Substance Unit
THE_Market Authorization first approval
THE_Packaging Unit Name
THE_Packaging Units Number
THE_Substance Dosage Unit
Raising the drop-down selector Dimensions to the maximum of available space to facilitate selection
Fixed Total wording not displaying correctly (object)
Addition of the "Data Input" Warning within the traceability cartridge
Addition of 96 conditional display fields for the creation of All Products Apps in a standardized way.
Review of the positioning of objects according to the new grid for the implementation of the DOE (Internal Technical Improvement) cartridge
Complete review of the sheet in order to have an identical operating mode to the ODT sheet.
Change within the table to the caption of the "Product Code" field for "GTIN".
Added missing fields based on MP4U, as well as crossover with MPA.
Module accepted on version v2004271727 of the standard; no change compared to version v2004161511 of this module
My Data Archive v2004161511
Changed the type of On / Off Prescription selector for Sales With Prescription / Sales Without Prescription (Now allows this selection to be taken into account within favorites)
Datablank target900"70=ank Datablank target9DgijftJtC40 DatablE200
Variability of the subscription within the cartridge. (New variable)
Modification of the formatting of the "Quarter 'time dimension within the table of the" My Data Archive "sheet in order to perform pivot tables in Excel following a data export.
Modification of the formatting of the "Month 'time dimension within the table of the" My Data Archive "sheet in order to perform pivot tables in Excel following a data export.
Variabilisation of standard selectors.
Correction of your "Success" link following the redesign of the site.
Setting up hierarchical fields qualifying the market within the table.
Added link to Success site (top right)
Replaced Period_MonthName_Short with Period_MonthName (Internal Technical Improvement).
Replacement of the sheet icon by a new one recreated.
Absence of totals and sub-totals