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.
I have the Alteryx License for the ConsumerView matching data, and I'm running some of our accounts against the tool. What I'm confused on is how the CAPE Ethnic Pop % fields work. It seems extremely difficult to find documentation on this, as in I can't find anything that relates directly to this tool and these %'s at the moment.
With that being said, it looks like the ConsumerView tool returns 4 fields (Asian, Black, Hispanic and White), and these do not sum to what looks to be 100% either with or without the Hispanic category (I did see some documentation that Hispanic might be intertwined with the other races but not sure in this case).
Anyways, I'm attaching some sample output to help answer this (this is in SQL, but it's the same data types / fields in Alteryx). Can anyone point me in the right direction as to how I can find out how to use this data properly?
Thanks, that helps a bit. I think what I'm needing though is a way to determine ethnicity from the Consumer View Matching Tool. I do see in the documentation that what I posted earlier for Asian, Black and White ethnicities means those alone. However this is still somewhat confusing.
I think a case example from the tool will help. In the attached example, you can see that the tool matched someone based on their full name and phone. And...there's just 1 person in the household. Now, it is showing that the 'CAPE: ETHNIC: POP % WHITE ONLY' is 64.3%, the black is 6.4% and the asian is 3.9%. I am newer to this data so any resources would help, but I'm wondering how I can practically interpret this. For example, do the %'s mean the 'confidence' that this 1 person in the household is a certain ethnicity? Or is it the entire block group is 64.3% white and I can say something like - based on the block group of this household and the fact that the entire group is significantly more white than other measured ethniticies, I can say with a certain probability that this is a white only household (or something like that)?
There are no other ethnic output fields from the consumer view matching tool to my knowledge other than what has been shared here, so I'm wondering how others have interpreted this data at the household level.
So the value ConsumerView is returning is the ethnic % for the Block Group that a household falls in - but it's only a subset of all the Race and Ethnicity data available (as you noted correctly - Hispanic is an Ethnicity and not a Race).
Since you have a US data license - do you also have the "Experian US" demographic data installed? If so - you can use the Allocate Input tool and select "Experian US" as your dataset. This will give you access to the full CAPE variables for further exploration. Specifically you can find the Race and Ethnicity percentage variables under Basic Variables > Current Year Estimates > By Percent > Race and Ethnicity.