This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Q3 2021 Business and Location Insights data packages are now available to plug into your analytic processes. The packages include analytics-ready data from a variety of vendors as well as data-specific analysis tools which will empower users to get the most from the packaged data.
We have identified that the Census information for this data is partially updated with 2020 Census data and IDs. Here we present two solutions for those using Census ID with Allocate using either Spatial Match Tool or our new US_2010CensusID_Geocoder Install containing Census IDs from Q1 2021 package.
Have you ever used the Allocate tools and received back some strange looking variable names? You're not alone! The Allocate Rename Fields Macro will allow you to rename your fields into readable variables.
We have identified an issue with the Consumer Expenditure variables defined in the VVF files installed with the Q2 2021 Experian US Allocate dataset, specifically Current Year Estimates (2021) - Total Expenditure (TCTOTALEXP) and Five-Year Estimates (2026) – Total Expenditure (TFTOTALEXP).
The Data Products team has identified the deprecated field CASS_StatusCode included in the US and Canada Dun & Bradstreet Analytical File. This field will be removed for the Q3 2021 Business and Location Insights release since the field had been replaced with CASS_ErrorCode long ago. We are making this post to notify any users currently running workflows referencing CASS_StatusCode so they can adjust their workflows before this update.
This article focuses on one key area of our Location Insights products – Maps. I'll use the US Location Insight product for this example, but all of our international Location Insight products are functionally the same unless I call it out specifically as a unique part of the US package.
Have some Latitude/Longitude points and not much else? Working with Spatial Objects and need more information than a simple map point? Time to call in the Reverse Geocoding macro. Reverse Geocoding can give some robust information to help make important business decisions when working with spatial data. Case in point: Your “friend” has hacked the Pokémon Go APK and hands you a list of Pokémon with the associated Latitude/Longitude. You can’t make an informed decision on your next weekend Poke-session without first understanding more than just the location on a map!
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?
I have CAPE installed and a newer version of a VGF (with updated names) is available in a new install. I uninstalled that version of the data, ran the new install but the old VGF names are still visible. I reran the install twice. What am I doing incorrectly? I notice when I run the install, the process happening more quickly than usual.