Creating Custom Metadata Field Post-Survey

Question

Hello! I am working with a client who is building a lifecycle survey. The client has provided me an employee file containing your standard metadata, but Age and Tenure are provided as specific dates. The dashboard filters will be much easier to navigate if these two fields are presented as buckets (i.e. Tenure Band of

TimR · Answer

I'm sure you could work this out in the Survey Flow with Embedded Data, but I wouldn't take that route.Is there a reason you wouldn't just create Recode Value import files for the dashboard fields? On this support page, see the sub-section titled IMPORTING RECODE VALUES. I've used this often for importing files to cover the possible range of unique values and putting them into manageable buckets.This would not work if the range of possible values that you're recoding into buckets have more than 5,000 unique values. For example, if Tenure is captured to three decimals, you could have >50,000 unique values to recode into buckets, but you'd hit the Qualtrics recode limit of 5,000, maxing you at 5 years.If this is the case, the participant import file needs to have a new column added that covers the "Tenure Bands" and "Age Bands".If the Tenure and Age are out to two decimals, you max at 50 years. So hopefully you're dealing with just one decimal place - only a superhuman would exceed your range. Based on extremes I've seen, I usually recode up to 75 years of tenure and 100 years on age.However, Recode Values do not work with the Response Rates widget, so if the client wants either Tenure or Age to be used there, the participant file should include the buckets as new metadata columns as mentioned above.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded