Module name
Trigram: MQ
Screenshot
Value
My Query is a functional use module
Check the list of products contained in your segments and qualifying fields. Select a product and visualize in which segment (s) and qualifying field (s) it belongs
Calculate the number of references present in a segment or in a qualifying field
Use My Query to view your indicators in all the HUB sheets with the segments and qualifying fields of your choice
This module is for you if
You have added qualifying segments or fields to your product database
You have applied a Market restriction or by TECHNICAL CODE 2 list or GTIN list.
Data sources
Geographic territories
Metropolitan France data
Corsica
DROM-COM: Guadeloupe, Reunion, Martinique, Guyana
Market
No limitation on the size of the markets
Applicable to human medicinal products, veterinary medicinal products and non-medicinal products
Status
Subscription
Sales & Marketing Essential
Objects found in the sheet
Dimensions as standard filters
Dimensions specific to your subscription in the form of filters (Ex: Customer type)
KPIs Number of Selected products, #of active products, TOTAL of products
Specific dimensions relating to your market such as your Qualifying Fields / Product Fields.
OHC_DateInscriptionDTM
OHC_DateInscriptionSRC
TECHNICAL CODE 1 filter
TECHNICAL CODE 2 filter
Restricted Perimeter Code GTIN filter (YES / NO)
Restricted Perimeter Code 7 filter (YES / NO)
Restricted Perimeter Market filter
Indicators
Total of products
# of active products
Options
NA
Limitations
My Query does not allow rebasing market share. Use 'Market Definition'
Version
Current version
Added filters:
Restricted Perimeter Filter GTIN Code (YES / NO)
Restricted Perimeter Code 7 filter (YES / NO)
Restricted Perimeter Market filter
Addition of the traceability cartridge "Restricted Perimeter: Traceability"
Addition of the TECHNICAL CODE 1 filter
Addition of the TECHNICAL CODE 2 filter
Added OHC_DateInscriptionDTM filter
Added OHC_DateInscriptionSRC filter
Old Versions (Classic MQ)
Addition of Age and Gender fields for this specific version of the sheet available only in UAN version
Repositioned CQCP number 7 that had jumped into the selections container object. (Internal Technical Improvement)
Implementation of conditional display on Customer Type, Area, Sector filters.
Implementation of the Territory filter without conditional display.
Setting up conditional display on the Network filter.
Added Customer Type filter in conditional display
Sheet revised to display CQCPs in auto according to their number.
Review of the grid to prevent the fact that the Sub-Segment, Sub-Sub-segment and Sub-sub-sub-segment type fields will be with the other CQCPs
Module accepted on version v2005051144 of the standard, no change compared to version v2004201754 of this module.
Module accepted on version v2004271727 of the standard; no change compared to version v2004201754 of this module
Variability in the wording of the KPIs as well as the explanatory insert
Addition of the explanatory insert "Following field will not restrict product but sales" specific to "Network" and "Customer Type".
Added the Market Definition KPI "#Of Active Products" restricted to the market predefined by the user.
Correction of the TOTAL OF PRODUCT KPI so that no user selection can modify it.
Variability of the Product Code label for "GTIN"
Internal Technical Improvement
target1hOoDgzH4nhank target1hOoDgzH4nhank target1hOoDgz"> QueryyWpfn1hOoDgz
MyYWpfn1hOoDgz
QueryyWpfn1hOoDgz"
Correction of your "Success" link following the redesign of the site.
Internal Technical Improvement
Internal Technical Improvement
Internal Technical Improvement
Automatic integration of 16 qualifying hierarchical fields in a generic way taking into account the market restriction in MD.
Addition of the "Customer Type".
Internal Technical Improvement
Modification of the Market, Network, Segment, Area, Sector, Company, Brand, Product Code, Product filters for Market Definition