About Exporting & Importing Conjoint Designs
This feature is primarily for advanced users familiar with conducting conjoints on other platforms. This tool allows you to export a CSV containing the explicit design of the conjoint, down to every available choice combination (and disregarding exclusions).
This page will explain how to read the conjoint design CSV and give parameters for the type of information that can be imported.
Understanding the Export
This section explains what the different columns in the CSV export of a conjoint design mean.
This column refers to the set of questions. This value will repeat row by row until you have reached the maximum number of questions for a set.
Under Advanced in this example, the maximum number of questions is 4 and each question has two choices. As soon as each question has choice 1 and choice 2 defined, the question_set row’s value can change.
The question column identifies which question in the question set you are defining.
Under Advanced in this example, the maximum number of questions is 4. So the question column can only ever have values from 1-4.
The choice column identifies which option in the question you are defining.
Under Advanced in this example, the number of options per conjoint question is 2. So the question column can only ever have the value 1 or 2.
Each feature you have defined in Attributes will get its own column. You cannot use this CSV to add new features or remove these columns.
In our example, we have the following features with the following levels, defined on the page in this exact order:
- Aruba (1)
- Jamaica (2)
- Bermuda (3)
- $1000 (1)
- $2000 (2)
- $5000 (3)
- 3 days (1)
- 1 week (2)
- 2 weeks (3)
The “recode values” are listed in parentheses next to each level. These match the order of the levels as listed on the Attributes page and cannot be edited or defined by the user.
As you can see in the image below, each feature (Destination, Price, Duration) gets a column.
Because each feature has only 3 levels, the maximum value in each column is 3. However, if you added another destination, you’d be able to have up to 4 in the Destination column, and still only 3 in Price or Duration.
When you make changes to your CSV, it is unlikely that you will add or remove just one line at a time. There are rules you have to follow before the import will succeed.
- You must stay within the bounds of the features and levels defined on the Attributes page. You cannot define a new feature or ignore an existing feature during an import, and the level indexes used in the import CSV must be within the bounds of the number of levels defined for that feature on the Attributes page.
Example: If your package only offers 3 prices, you cannot put a 4 in the Price column. In addition, you cannot erase the Price column altogether just because you suddenly don’t want to study this feature. To make edits like this, you must modify attributes in the product.
- You can change the number of questions and choices, but you must be consistent across the CSV provided. All versions must have the same number of questions, and all questions must have the same number of choices. They don’t need to match up with the numbers defined on the Advanced page.
- Exclusions are not checked in this CSV. They are also not configured using this CSV. To add exclusions, you must use the tool inside the product.