Data quality sensor (DQ Sensor) periodically scans the CRM database, with the purpose to give a current status of the CRM database as well as a trend over a given time frame.
What do you want to do?
You can use the Data quality sensor of Autoline to monitor the quality of CRM records and make trend analysis over a given time frame. The DQ sensor is divided in five separate categories:
Data uniqueness, identification of duplicated CRM records by Autoline or interface with Fuzzy!Double.
Data correctness, analysis the outcome of the validation of company addresses and/or customer addresses by Fuzzy!Post.
Data completeness, check whether the required user specified CRM records’ fields are filled completely.
Data actuality, analysis of the contact history of customers and companies’ customers.
Potential, interdepartmental check if full potential of every customer is raised.
The quality of the CRM records is determined by running the DQ Sensor - Calculation of the selected measurement categories.
The check of Data uniqueness can be performed in two different ways; either by the data quality analysis of Autoline or Fuzzy!Double’s data uniqueness analysis.
Data correctness is determined by an external software package Fuzzy!Post, which is interfaced in the CRM module. However, Autoline performs the analysis of the data quality. The use and setup of Fuzzy!Post is described in the CRM Step I help files.
Autoline also performs the analysis of data quality for Data completeness, Data actuality and Potential.
The summary of the results is displayed per marketing company in DQ Sensor - Trend analysis. You can get the detailed results by using DQ Sensor - Export results or CRM reports of Mercedes-Benz.
Tip: You can setup the DQ Sensor - Calculation program in Timed operations with module MS and option MSMBDQP.
This form is displayed when you click Manufacturer-specific > MB. Mercedes-Benz > Menu - Marketing > Menu - Data Quality Sensor > DQ Sensor - Calculation and starts a initialization before the calculation program is started. The following steps are run:
First a temporary file is created that holds all measurement category settings, for background use of the program itself. The file is deleted when you exit the program DQ Sensor - Calculation.
Then Measurement Categories are loaded.
After that the existence of the compiled selection criteria are checked.
Finally if compiled selection criteria are not available, the Compile selections option of the Measurement Category Maintenance form is run.
Note: The last run of Compile selections is used. If you make new changes in the measurement categories, please run the Compile selection option to make the changes effective.
When no errors occur, the DQ Sensor Calculation form is displayed. It determines the data quality of CRM records.
By default all measurement categories are selected, all selected items are displayed in blue.
You can make your own selection. With CTRL + click, you can select and cancel the selection of the various measurement categories in Category groups and Record types fields.
Menu Bar and Toolbar
| Menu bar | Toolbar | Action |
|---|---|---|
| File > Exit |  |
Leaves the program and returns to the menu. |
| DQ Sensor > Run |  |
Runs the DQ Sensor Calculation program on the highlighted measurement categories. |
| DQ Sensor > Trend Analysis | - | Opens the DQ Sensor Trend Analysis form. |
| Tools > View log with browser |  |
Opens the log in a XML file. The outcome per run is stated in this file. |
| Tools > View log file |  |
Opens the log file in Autoline. The outcome per run is stated in this file. |
| Tools > Purge log file |  |
Deletes the entire log file. |
| Help > Help |  |
Displays this help topic in a web browser. |
| Help > About | — | Displays version and copyright information. |
Category groups: Select the Category Code. The list contains the codes: Data Uniqueness, Data Correctness, Data Completeness, Data Actuality and Potential.
Record types: Select the record type. The list contains the CRM split: Customer, Company and Vehicle.
Progress: Displays the progress of the calculation and the number of the current DQ sensor run.
Data quality sensor (DQ Sensor) periodically scans the CRM database, with the purpose to give a current status of the CRM database as well as a trend over a given time frame.
When performing a DQ Sensor - Calculation, not all records are taken into account. Whether a record is considered in the DQ Sensor analysis depends on certain criteria.
First of all, non-defined records (company/customer/vehicle) for exclusion are used in the run.
Second, the records marked as Identified non-duplicate are filtered out.
Third, there are some objective specific criteria:
If vehicles are of a valid franchise, the records are considered.
Customers marked as being from one household are not taken into account.
To run the calculation:
On the master menu, select Manufacturer-specific > MB. Mercedes-Benz > Menu - Marketing > Menu - Data Quality Sensor > DQ Sensor - Calculation.
The initialization is automatically started and DQ Sensor Calculation form is displayed.
Select with CTRL + click the various measurement categories in Category groups and Record types required for this calculation.
The selected options are displayed in blue.
Click the Run toolbar button or click the DQ Sensor > Run menu bar command.
The progress is displayed of all measurement categories selected. The number of processed records of a measurement category is displayed on bottom of the DQ Sensor Calculation form and a dialog box, if the run is successful, is displayed.
Click the OK.
Returns you to the DQ Sensor Calculation form.
In the log file the outcome per run is stated. Any errors occurred for a certain measurement category is written in this log file. In that case no DQ Sensor results are written in the table and the existing results of a previous run are taken over. The log file is saved in the subdirectory of the systems main directory ../DQSensor/logs/DQSensor_Calculation.xml by default.
To view the log file:
On the master menu, select Manufacturer-specific > MB. Mercedes-Benz > Menu - Marketing > Menu - Data Quality Sensor > DQ Sensor - Calculation.
The initialization is automatically started and DQ Sensor Calculation form is displayed.
Do one of the following (a or b):
Click the View log with browser toolbar button or click the Tools > View log with browser menu bar command.
Opens the log in a XML file, the log file is displayed in Windows explorer. The outcome per run is stated in this file.
Click the View log file toolbar button or click the Tools > View log file menu bar command.
Opens the log file, the log file is displayed in Autoline. The outcome per run is stated in this file.
Because the log file can grow enormousness, you have the possibility to purge the log file.
To purge the log file:
On the master menu, select Manufacturer-specific > MB. Mercedes-Benz > Menu - Marketing > Menu - Data Quality Sensor > DQ Sensor - Calculation.
The initialization is automatically started and DQ Sensor Calculation form is displayed.
Click the Purge log file toolbar button or click the Tools > Purge log file menu bar command.
A dialog box, if you want to continue deleting the log file, is displayed.
Click the OK.
A dialog box, that the log file is deleted, is displayed.
Click the OK.
Returns you to the DQ Sensor Calculation form.