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
- Number of selected products
- # of active products
Options
NA
Limitations
- My Query does not allow rebasing market share. Use 'Market Definition'
Version
Current version
Products"72 Quarantine Target> 200
- 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
vankfNoQCs.RiKgS10> My_QKDtarget"52"VankfNoQCs.RiKgS10 My_QKs31
- Modification of the Market, Network, Segment, Area, Sector, Company, Brand, Product Code, Product filters for Market Definition