Texas Longhorn
Active Member
- Joined
- Sep 30, 2003
- Messages
- 493
Please forgive me if this makes no sense. Here goes:
I am working on a project to establish territories for our sales reps. Each sales rep gets a list of 50 "named" accounts.
The process we've been through thus far: My goal was to identify the top 1,500 companies in the U.S. based on various criteria. I pulled down about 40,000 records from Dun & Bradstreet, and applied various criteria to end up with a list of the top 1,500.
Now, this 1,500 consists of large companies, about 90% of which are what Dun & Bradstreet calls "Ultimate Parents" (parent companies with many subsidiaries). The other 10% are companies that are subsidiaries of other companies; however, for whatever reason, the parent company did not meet the criteria to make the list of 1,500. This 10% are not "Ultimate Parents", but they are all parents (so if a company was 6 layers deep on an org chart, they might be on level two or three).
The next step was to take the list of 1,500 companies and send their DUNS numbers (Dun & Bradstreet's unique number) to Dun & Bradstreet so they could give me a list of all subsidiaries for the companies I chose.
This is where the wheels have fallen off a bit. For some reason, D&B is claiming to be incapable of putting the data in the format I need which is as follows: In the first column, I need the numbers I requested; in the second column I need any company that rolls up to that number, no matter where it is in the org chart (e.g. If the DUNS number I requested represents a company on the 3rd level of an organization, I want to see it's number, any level 4 company that rolls up to it, and level 5 company that rolls up to a level 4 company that rolls up to it, etc.) The trick here is that I only need companies in the specific lineage of the number I specify.
Hopefully my examples will clarify this (I've had to post in separate messges due to size).
I am working on a project to establish territories for our sales reps. Each sales rep gets a list of 50 "named" accounts.
The process we've been through thus far: My goal was to identify the top 1,500 companies in the U.S. based on various criteria. I pulled down about 40,000 records from Dun & Bradstreet, and applied various criteria to end up with a list of the top 1,500.
Now, this 1,500 consists of large companies, about 90% of which are what Dun & Bradstreet calls "Ultimate Parents" (parent companies with many subsidiaries). The other 10% are companies that are subsidiaries of other companies; however, for whatever reason, the parent company did not meet the criteria to make the list of 1,500. This 10% are not "Ultimate Parents", but they are all parents (so if a company was 6 layers deep on an org chart, they might be on level two or three).
The next step was to take the list of 1,500 companies and send their DUNS numbers (Dun & Bradstreet's unique number) to Dun & Bradstreet so they could give me a list of all subsidiaries for the companies I chose.
This is where the wheels have fallen off a bit. For some reason, D&B is claiming to be incapable of putting the data in the format I need which is as follows: In the first column, I need the numbers I requested; in the second column I need any company that rolls up to that number, no matter where it is in the org chart (e.g. If the DUNS number I requested represents a company on the 3rd level of an organization, I want to see it's number, any level 4 company that rolls up to it, and level 5 company that rolls up to a level 4 company that rolls up to it, etc.) The trick here is that I only need companies in the specific lineage of the number I specify.
Hopefully my examples will clarify this (I've had to post in separate messges due to size).