Module name

Trigram: MQ

v2007231507

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

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)

My Query v2007171051

  • Addition of Age and Gender fields for this specific version of the sheet available only in UAN version

My Query v2007071428

  • Repositioned CQCP number 7 that had jumped into the selections container object. (Internal Technical Improvement)

My Query v2006261511

  • Implementation of conditional display on Customer Type, Area, Sector filters.
  • Implementation of the Territory filter without conditional display.

My Query v2006221015

  • Setting up conditional display on the Network filter.

My Query v2006151637

  • Added Customer Type filter in conditional display

My Query v2006091427

  • 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

My Query v2005051144

  • Module accepted on version v2005051144 of the standard, no change compared to version v2004201754 of this module.

My Query v2004271727

  • Module accepted on version v2004271727 of the standard; no change compared to version v2004201754 of this module

My Query v2004201754

  • Variability in the wording of the KPIs as well as the explanatory insert

target _blank30

  • 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.

My Query v2001071559

  • Variability of the Product Code label for "GTIN"

target"> My2M50 vnblk4

  • Internal Technical Improvement

target1hOoDgzH4nhank target1hOoDgzH4nhank target1hOoDgz"> QueryyWpfn1hOoDgz

MyYWpfn1hOoDgz

QueryyWpfn1hOoDgz"

  • Correction of your "Success" link following the redesign of the site.

My Query v1907261527

  • Internal Technical Improvement

My Query v1907021711

  • Internal Technical Improvement

MyQuery v1906261510

  • Internal Technical Improvement

My Query v1904240949

  • Automatic integration of 16 qualifying hierarchical fields in a generic way taking into account the market restriction in MD.
  • Addition of the "Customer Type".

My Query v1904091040

  • 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
Did this answer your question?