Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email for assistance.

Location Data Knowledge Base

Data methodologies, and Release schedules.

What is the field coverage for the D&B Calgary file (Business records)?

Alteryx Alumni (Retired)


Occasionally someone asks the question, “how many businesses have ACTUAL YEAR STARTED” (or referenced another field) and you have no idea how to respond. You looked in the quarterly Variable List and didn’t see the answer. Now what? You could run a query in Alteryx but should you?


Fortunately, there is a document available with just this information and it’s created for each quarterly update. This information is found in the Documentation folder of the quarterly US and CA Data Installs media plus installed to a local DNB_US_Qx_201x Documentation folder. The file is titled DnB US Analytical File Penetration Report Qx 201x.csv. The example image contains a sample of the fieldnames.

DB Penetration Report.png

The Quantity is the number of records populated for a Fieldname, the % penetration and whether the field is provided by D&B (DnB) or Alteryx. Depending upon your license, the entire list of fields may not be available for query/return but are still provided for reference.

Feel free to share the information since this document is delivered on the installation media. If you have comments or questions, contact

No ratings