D&B Family Tree Analysis
D&B Family Tree Analysis
Technical Name: 0DB_MC01_Q0012
Based on InfoCube:
D&B Marketing Universe (0DB_MC01)Use
This query is structured similarly to the
D&B Marketing Analysis query, only distinguished by the starting point. By using the characteristic value to Global Ultimate D-U-N-S as the starting point, the query provides you with the valuable ‘Family analysis’ view that shows which organizations belong to which family. From this family, you can look at your customers’ spending habits in any one family. The condition ‘Global Ultimates with at least one customer’ delivered by the standard Business Content ensures that only those Global Ultimates are displayed to which at least one of your customers belongs. The condition ‘Global Ultimate with more than one family member’ delivered by the standard Business Content ensures that only those Global Ultimates are displayed where there is more than one company in the family.When you open this query a variable popup is displayed, allowing you to choose the monthly interval for which you would like to view the sales amount with your customers.
Filter
|
InfoObject |
Description |
|
0DB_MAKTCO = 1 |
Marketability Code |
|
0DBSECTCOD |
Sector Code |
Free Characteristics
|
InfoObject |
Description |
|
0DB87SIC1 |
US 1987 SIC Code |
|
0DBEMPBND |
Employee Band |
|
0DBSALBND |
Annual Turnover Band |
|
0DBYRSBND |
Year Started Band |
|
0DBCUSTAT |
Indicator of Current Customer Status |
|
0DBLGLSTAT |
Legal Status |
|
0DBCTRYCOD |
Country Code |
|
0DBREGCOD |
Region Code |
|
0DBAREACOD |
Area Code |
|
0DBDISTRCOD |
District Code |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DBGUDUNS |
Global Ultimate D-U-N-S |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DB_MC01_RK002 |
Number of Customers |
|
0DB_MC01_RK003 |
Number of Businesses |
|
0DB_MC01_RK010 |
No Contact |
|
0DB_MC01_RK003-0DB_MC01_RK002-0DB_MC01_RK010 |
Number of Prospects |
|
100*0DB_MC01_RK002/0DB_MC01_RK003%100 |
Penetration % |
|
0DB_MC01_RK0001 |
Revenue |
|
0DB_MC01_RK0001/ 0DB_MC01_RK002 |
Average Revenue |
|
Avg Revenue * Nbr of prospects *Penetration % /100 |
Potential Revenue |
Report Report Interface Targets
|
Query |
Description |
|
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 |
|
0DB_MC01_Q0005 |
D&B GIS Penetration Analysis |
|
0DB_MC01_Q0001 |
D&B Marketing Analysis |