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
- GSA drugstore data
- 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
- Functional cartridge
- Time buttons
- Time selector
- 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