Bucketing Variable Creation
About Bucketing Variable Creation
Let’s say you internationally distribute a survey asking what country each respondent lives in. Halfway through data collection, you realize you don’t just want to do analyses on the countries, but the whole continents. It’s too late to add a new question or an embedded data element that captures this information, so how do you group the countries into continents without invalidating your data?
Bucketing creates custom variables that combine values from previously existing variables into new groups. Values assigned with a bucketed variable will be applied to both collected and future data, making it an alternative to embedded data in situations where you need a variable to be added retroactively. Once created, bucketed variables can be used in the Data and Weighting sections of the Data & Analysis tab and in the Results section of the Reports tab. They can also be exported with your dataset or be retrieved by API if you use Create Response Export, Get Response Export Progress, and Get Response Export File calls.
Need to make changes to an existing bucketed variable? See our Editing Custom Variables page.
Creating a Variable with Bucketing
- Go to the Data & Analysis tab.
- Select Field Editor.
- Select Create Field.
- Select Bucketing at the top.
- Name your variable.
- Click Select Field to choose the variable you are going to bucket. You can choose from all available survey questions, survey metadata, contact fields, or embedded data.
Qtip: Bucketing cannot be used to combine different variables; it is only for combining different values of one variable. If you’d like to create a variable based off of multiple questions, our Manual Variable Creation feature might be right for you.Qtip: You can use bucketing with numeric values as long as your embedded data field type is set to Number. If your embedded data stays as a text set when it’s meant to be numeric, you’ll receive an error that there are too many values to bucket.
- Name the groups your values will be sorted into. If your variable requires more groups, you can add more by clicking Add Group below the existing ones, as seen below.
- Drag fields from the Source Values box to the groups on the right. Note that you do not need to have every field sorted into a group.
- Click Create Variable.
Qtip: Whenever a value isn’t sorted into a group, it is marked Uncategorized within your new bucketed variable.
- Click Review and Publish to save your changes.
- Click Publish your Changes.
Qtip: Click Data Table to return to your data table.
Projects Where You Can Create These Custom Fields
Data & Analysis is available in many different types of projects. The options described on this page are available in:
- Survey projects
- XM Solutions
- Imported data projects
- 360 projects
Qtip: See Creating New Fields (360) for more details.
- Conjoint
- MaxDiff
While the functionality is technically available, we do not recommend using these custom fields with other types of Employee Experience projects. See Creating New Fields (EX) for more details.