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 Q1 2020 Business and Location Insights data packages are now available for analysis. 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.
There are thousands of unique coded values in ConsumerView: 4,070 to be exact! It can be overwhelming to have to look them up. Fear not! The ConsumerView Output Decoder brings back the functionality of the ConsumerView Renaming Macro, but is now included with our data releases as of Q4 2019.
It decodes ConsumerView Field Values into readable values. No more will you have to search through a data dictionary to understand your data.
We listened to your feedback during development and the new tool can decode values from both the ConsumerView Household and Individual files with no configuration. The new version is over 6 times faster than the previous macro and will be updated every quarter with ConsumerView.
Using the Tool:
No configuration is required, simply drag it on to the canvas and connect your data stream with ConsumerView fields. The O output will contain the decoded value.
Be sure to use the ConsumerView Output Decoder at the very end of your analysis. Experian codes the values to reduce the size of the dataset and speed up processing. Using it early in a workflow will bloat the data in the workflow and slow down processing.
The tool is powered by the Dynamic Replace tool and the cv_key_value.yxdb in the Supporting_Macros folder relative to the macro. Dynamic Replace will return null if a value is in a field that is decoded, but not in the data stream of the R anchor. Be sure to only use this on unmodified ConsumerView fields.
Extract error while installing data package on an external drive
Product - US Business Insights data package
When installing the US Business Insights data package on an external drive that is connected by USB, an extract error from the Alteryx Data Manager may occur.
Larger files over 4 GB in the data set could not be installed and are missing. Right click on the drive in File Explorer and go to the Properties. If the file system is FAT32, the drive will need to be reformatted, as the maximum file size on FAT32 is 4 GB.
Right-click on the drive, select Format, and then choose NTFS.
Note: working with data from a USB drive will be slower than having the data installed on the computer’s local internal drive. Also, the associated drive letter for the USB drive must remain the same for the data to be found by the Designer initialization files. The use of a file server and UNC paths are recommended to maintain a stable file path.
Location Data Knowledge Base
You know what really stinks? Working with addresses that aren’t standardized or verified. Whether human-input, or one of the many address formatting standards in the U.S., being stuck with an address you can’t either (1) identify or (2) ensure it exists can be a real pain in the… well…
CASS is here to help!
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!
As of the Q4 2018 data release, Experian's CAPE offering accessed through Alteryx's Demographics Analysis toolset will move to an annual update schedule instead of semi-annual. The change was made by the vendor, whose research determined there isn't enough variance to warrant updating the Annual Update to the Thin Update (“A” to “B” in Alteryx terms).
This affects the following data sets:
CAPE Demographics, “Current Year Estimates” and “Five Year Projections” (CYE & FYP)
CAPE Seasonal Population
CAPE Daytime Population
CAPE Consumer Expenditure, CYE & FYP
CAPE Retail Demand & Retail Supply (Scaled)
American Community Survey, Mosaic Workplace and Mosaic Residential are already on an annual update schedule and will remain on that release cycle. However, the annual Mosaic updates will be delivered with the rest of the CAPE updates beginning with the Q2 2019 release.
This change does not affect the quarterly Alteryx Data delivery frequency to our customers, as geographies and other data sets follow their own release cycles. We will continue to deliver Alteryx Data quarterly as the other data sets included within the offering follow their own update release cycles.
The Q3 2018 US Data package includes analytics-ready data from TomTom, Experian, Dun & Bradstreet and the US Census as well as data-specific analysis tools to get the most from the packaged data. The documentation package attached includes –
Release notes, variable list and change log
Experian CAPE demographic data methodology document, Mosaic segment descriptions
Experian ConsumerView Analytical file – user guide and penetration report
D&B Analytical file - data description, SIC lookup code, penetration report
Kalibrate Technologies traffic count overview and metadata
Spatial products include documentation on drive time methodology and Alteryx map layers
What's new in this release?
Sample workflows included with the data installs are now grouped within a top-level "Data Install Samples" category
Annual updates for Places, Other Name Places, CBSAs, and CCDs/MCDs
Please download and extract the attached 'Q32018_US_Data.zip' for the complete documentation.
The US and CA Data and Spatial Bundles contains many datasets, including the Melissa Data CASS engine. While the US and CA Data Bundles are updated every quarter, CASS is updated every 2 months. Luckily, the install file size for CASS is just over 1gb, so we are able to provide this update as a download. Once downloaded, a few simple steps will get you on your way to using the most updated version of CASS. On occasion though, users have reported a few issues with being unable to utilize CASS. Because of this, we have decided to provide full download and install instructions, with a final portion of frequent questions and issues. To install the latest CASS:
Download the latest version of CASS. This is sent via email from Alteryx Products on a bi-monthly basis and will be in the format of the following:
YY is the current year and MM is the current month release of CASS.
Double-click on the .exe file. This starts the 7-Zip Self-Extractor. Choose a location where you would like to extract the install files.
IMPORTANT: This does not actually install the files, it only extracts the install files.
Once the install files have been extracted, located and double-click the file DataInstall.exe. This will be in the directory you just extracted to in the previous step.
When the install dialogue pops up, check the box to accept the license agreement and click Next.
The next screen allows you to select datasets to install. Depending on which install you've chosen, you will see the option to install US, Canada, or both versions of CASS. Check all boxes, then click Next.
This screen displays all current datasets installed on your machine. Checking any box here will uninstall the dataset. By default, the previous version of CASS will be checked for uninstall. Make sure all prior versions of CASS are checked, then click Next.
IMPORTANT: You must uninstall all previous versions of CASS during this process. If you have any expired versions of CASS on your local machine, no other versions of CASS will work properly.
Browse to the directory you wish to install CASS to, then click Finish.
Once the above steps have been completed, you will be able to use CASS on your local machine. FAQ/Common Errors:
Error: CASS (2): CASS is not installed properly or it has expired. Please contact your reseller or Client Services at 1-866-516-2400 1-866-516-2400 FREE to receive an updated CASS database.
This is often because a prior version of CASS is still installed. Re-run DataInstall.exe and make sure all prior versions of CASS are checked in the Uninstall screen.
CASS was installed on a network drive and permissions are not allowing you to see it. Try re-running DataInstall.exe and install CASS on a local drive.
Error: CASS (1): The Melissa Data CASS engine appears to not be installed (can't find dll).
This is often the result of mismatched registry entries or install folders. Please contact firstname.lastname@example.org for resolution.
In most cases, the solutions for error 1 above will resolve your issue, but if not please don't hesitate to reach out to email@example.com for handling. Thanks, and until next time! Chad Follow me on Twitter! @AlteryxChad
This note is to alert users of 2010 Census SF1 Data in the Core and Spatial Data Bundles (including Q4 2015) of the reversed values in a report template. The report SF1 2010 Report - US Census 2010 Overview Comparison reflects reversed values for % Hispanic and % Not Hispanic. The corrected report will be included in Q1 2016. This report can also be updated in a desktop install now by overwriting the existing report template with the corrected report template.
Action required: Replace the incorrect report template file
Close open instances of Alteryx or Allocate
Download, unzip and extract US Census 2010 Overview Comparison.rptx from the Community Article to the local Alteryx location. A typical install location is C:\Program Files (x86)\Alteryx\DataProducts\Portfolio\ALTERYX_US_Census_2010_SF1_15D\Reports
Overwrite the existing template dated from 2011 with the updated templated dated 4/18/2016
Launch Alteryx or Allocate and generate output for the report SF1 2010 Report - US Census 2010 Overview Comparison If you have other concerns or need assistance with these instructions, please contact our Customer Support team at firstname.lastname@example.org.
How do you know if the report is corrected? Generate the report SF1 2010 Report - US Census 2010 Overview Comparison for the United States and review the fields % Hispanic and % Not-Hispanic. Depending upon the version of data installed the values may differ slightly but the proportions will be similar to the image below.
If you have other concerns or need assistance with these instructions, please contact our Customer Support team at email@example.com.
Why do values in the ConsumerView HH & Individual fields contradict the Household Composition Code? Sometimes other field values in a CV household record don't support the description of the Household Composition value. For example, there might be two adult females in a household record but the Household Composition is A (HH w/1 adult female). Or another record has 2 adults with a Composition code of B (HH w/1 adult male).
The first thing to note is the ConsumerView file delivers 6 of up to 8 persons in a Living Unit. Not every person is delivered which may impact the Household Composition Code. Another consideration is the description does not define the exact makeup of the household. For example, a Household Composition code of "A" (HH w/1 adult female) does not mean this household is exclusively made up of a single adult female.
Household Composition - This field is calculated based on gender and children present in the Living Unit. On the Household Composition, Experian looks at everyone in the Living Unit provided to them and determines how many adults are present in each Living Unit, gender of those individuals and if children are present in that living unit, coding them according to the codes chart.
* A = HH w/1 adult female (no adult male, no child) * B = HH w/1 adult male (no adlt F, no child) * C = HH w/1 adult female and 1 adult male (no child) * D = HH w/1 adult female, 1 adult male and children present * E = HH w/1 adult female and children present (no adult male) * F = HH w/1 adult male and children present (no adult female) * I = HH w/2 or more adult males and children present (This does not mean there is not an adult female present in the household) * J = HH w/2 or more adult females and children present (This does not mean there is not an adult male present in the household) * G = HH w/2 or more adult males (An adult female can also be present in household, no child)) * H = HH w/2 or more adult females (An adult male can also be present in household, no child) * U = Unable to code
Records coded with C and D are typically scenarios where there's a male and female with/without children. I - H could be one of these situations below:
1.) Scenarios where an elderly parent living with their adult children. 2.) Roommates (both male and female, young and old) 3.) Scenarios where a married couple allows an in-law (the brother or sister of a spouse) to reside with them 4.) Scenarios where a relative (uncle, cousin, etc.) may live with their relatives 5.) College age children (ages 19+) living with parents.
When might the Household Composition value not match the houehold attributes? In one scenario, 2 Adults in a household with a Code of "A," more than likely there are two female adults in the household. This could be a roommate situation, it could be a mother and older daughter. Only one female may be a PDM in a household. Because of this, the record would receive the Household Composition code of “A” meaning a household with one adult female even though there are two adult females present.
In the "Question" example of two adult females in a household record but the Household Composition is A (HH w/1 adult female), this household looks as if it is more likely two sisters residing together as the ages are close together. One is listed as the PDM, the other is listed as the other adult. The system assigned the living unit an A denoting the female PDM.
The second "Question" example of 2 adults with a Code of "B" may be a household with a parent living with adult child situation. The adult child is coded as the PDM and the other person is only an initial and coded as the other adult. The system assigned the living unit a B denoting the male PDM.
In situations where fields in specific records are questionable and need further validation, provide those records to firstname.lastname@example.org explaining the issue. Also include the vintage of the ConsumerView Household or Individual file.
Experian's ConsumerView file is built directly from hundreds of public and proprietary sources. They employ rigorous data testing including applying proprietary models and algorithms to ensure only the most deliverable addresses and accurate data elements are on the ConsumerView database. Attached to this article is an excellent User Guide for the ConsumerView dataset. This User Guide is also included in the US Data Bundle documentation.
This note is to alert users of Alteryx 8.6 to 10.5 of an error message that may appear if a user previously installed the combined US and Canada CASS dataset and then in subsequent data updates separately installs CASS for a single country.
Some clients reported receiving a message in the Alteryx Designer that “CASS is not installed properly or it has expired.” Once CASS is installed for both countries, supporting program files continue to look for the combined dataset even if CASS is uninstalled and a single country is reinstalled.
The instigating files are identified and a resolution is being explored, however, this error appears to be inherent to the source data itself.
Action required: 1. Close open instances of Alteryx 2. Delete the CASS.ini file which in most cases resides on the user’s local drive (C:\ProgramData\Alteryx\DataProducts\DataSets\CASS\CASS.ini) 3. Locate the most recent CASS installs and re-run the installation executables 4. Relaunch Alteryx and verify the CASS tool is no longer reporting an error
This note is to alert users of Alteryx 8.6 to 10.1 of a potential message window that may appear after updating the US and Canadian CASS engine. Subsequent to completing the CASS installation and closing the installer, some clients have reported receiving a message window stating that the program may not have been installed correctly. This message can be disregarded and will not impact dataset functionality.
The source of the problem is being identified and a fix will be included in future Alteryx software releases.
Action Simply choose ‘Cancel’ to close the Program Compatibility Assistant window. Alteryx can then be opened and workflows can be run as normal.
Was the installation of CASS successful? Yes, CASS was installed fully and all scripts have finished running.
Will this message impact my installation or existing workflows? This message is entirely cosmetic; there are no impacts to the installation or workflows.
Alteryx Data Artisans occasionally identify problems with how street segments are displayed or where addresses may be located. They want to pass along corrections and may reach out to Alteryx to help. Artisans can actually provide feedback directly back to our spatial vendor, TomTom, by logging into this web site: http://www.mapsharetool.com/external-iframe/external.jsp.
You can submit a report after logging in with Facebook, Google or Yahoo. As noted on the linked page, your reports help them keep their maps as accurate as possible.