D&B Customer (%) vs. Norm (%)
D&B Customer (%) vs. Norm (%)
Technical name: 0DB_MC01_Q0003
Based on InfoCube:
D&B Marketing Universe (0DB_MC01)Use
This query shows the number of customers and the number of all businesses for each primary industry sector as percentages, allowing you to assess the split of where your customers are in relation to the rest of the businesses. In addition, this can also be shown by split of employees, turnover, and by country.
This allows you to compare the allocation of your customer base to the norm base.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DB_MAKTCO = 1 |
Marketability Code |
Free Characteristics
|
InfoObject |
Description |
|
0DBEMPBND |
Employee Band |
|
0DBSALBND |
Annual Turnover Band |
|
0DBCTRYCOD |
Country Code |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DB87SIC1 |
US 1987 SIC Code |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DB_MC01_RK002 |
Number of Customers |
|
0DB_MC01_RK003 |
Number of Businesses |
|
%GT 0DB_MC01_RK002 |
Customer % |
|
%GT 0DB_MC01_RK003 |
Norm % |
Report Report Interface Targets
|
Query |
Description of the Query |
|
0DB_MC01_Q0002 |
D&B Marketing Details - All Businesses |
|
0DB_MC01_Q0010 |
D&B Marketing Details - Customers |
|
0DB_MC01_Q0011 |
D&B Marketing Details - Prospects |