Offline data collection for conjoints
If your team has collected conjoint data outside of Conjointly (for example, through face-to-face interviews, paper-based surveys, or another survey platform) you can upload that data directly into your Conjointly experiment for analysis.
When this feature is available
The offline data upload page is available when all of the following conditions are met:
- You are the primary owner or co-owner of the experiment.
- The experiment has been launched.
- The experiment contains at least one suitable conjoint question: General Conjoint, Brand-Specific Conjoint (or their MaxDiff variants), where the Number of alternatives per choice set is not set to automatic.
This means you need to first prepare and launch a suitable conjoint experiment before you can upload your data.
Preparing your .csv data file
You will be asked to select which conjoint question your data relates to, then upload a single .csv file containing the responses.
Each row in the file represents one alternative shown to one respondent in one choice set. The file must include the following columns:
| Column | Type | Example values | Requirements |
|---|---|---|---|
PARTICIPANT | String | 12345wer_232D123DW | Unique respondent identifier. Between 1 and 255 characters. |
QES | Positive integer | 1, 2, 3 | Choice set number. Must be consecutive integers starting from 1, up to a maximum of 100, for each respondent. Order does not matter. |
ALT | Positive integer | 1, 2, 3 | Alternative number within the choice set. Must be consecutive integers starting from 1, up to the Number of alternatives per choice set configured for the conjoint. |
CHOICE | Integer | -1 or 0 or 1 | Whether this alternative was chosen. For standard conjoints: 0 (not chosen) or 1 (chosen) — exactly one alternative must be chosen per choice set per respondent. For MaxDiff: -1 (worst), 0 (not chosen), or 1 (best) — exactly one worst and one best must be indicated per choice set per respondent. |
A1, A2, A3, … | String | A1L1, A2L4 | One column per attribute in the conjoint, named A1 through to the last attribute. Values are level identifiers in the format A{attribute number}L{level number} (e.g. A1L1, A2L4). For Brand-Specific Conjoints, every alternative must be consistent with the applicability matrix. |
See the example .csv file for a sample of how the data should be structured.
On Basic licence, you can only upload 20 offline respondents per experiment. On Professional licence and above, you can upload up to 20,000 offline respondents per experiment. If your file contains more respondents than the limit allows, the excess respondents will not be uploaded.
Uploading your data
Navigate to your experiment’s settings page and select Upload data from the menu.
Once you have selected the conjoint question and uploaded your file, Conjointly will validate the data. Any validation errors will be displayed on the same page.
Upon a successful upload:
- A new offline source is created for the uploaded responses.
- You will be redirected to the report page.
- A confirmation message will confirm how many offline responses were uploaded.
- Nothing in your existing analysis is automatically reset.
How offline respondents appear in your experiment
Uploaded respondents are marked as complete and included in analysis by default. They are identified as offline respondents by their source, which is labelled “Offline responses 1”, “Offline responses 2”, etc.
You can exclude offline respondents from your analysis on the Participants page or in the Quality Checker tab, just as you would with any other respondent.