Exporting as an Excel Workbook
Follow these steps to export the results of your Conjointly experiment to an Excel workbook.
1. Add outputs to export
Select which outputs you would like to add to export by navigating to each output and clicking on the “Add to export” button. Alternatively, click on the “Export analyses” button at the bottom of the page to open the analysis cart with respondent information, conjoint data, and data dumps automatically added.
2. Open analysis export cart
Click on the Export analyses button at the bottom of the screen in the insights tab to open the analysis export cart. Here you will be able to see all the outputs you have added to export.
You can also add respondent information, conjoint data, data dumps, and an interactive simulator through on the “Add more outputs” dropdown menu.
3. Export as Excel
Once all the desired outputs have been added to the cart, click the “Make Excel file” and Conjoint.ly will compile the download file.
This process can take a few seconds. When the file is ready, click on the “Download it now” button on the sidebar to download the Excel workbook.
Can I export a simulator for BPTOs
With Conjoint.ly, you can now export the Excel simulator for Brand Price Trade-Offs. The Excel simulator allows you to calculate the preference share of up to 150 SKUs, at varying prices, both before and after an adcept is shown.
How can I get Conjoint.ly’s Excel Plugin
To improve your Excel charting experience, the Conjoint.ly Excel Add-in is now available online. The add-in contains multiple functions that help with charting Conjoint.ly outputs.
Some of these functions include:
- The ability to automatically recolour charts from data cells, for quick and easy chart-making
- A function that enables quick calculation of the price elasticity of demand between two price points
- A button that transforms conditional formatting to static formatting with ease, allowing you to combine multiple forms of conditional formatting.
How do I get individual partsworth for each respondent
To view individual partworths for each respondent, ensure that “Conjoint data” is included in your export cart.
In order to understand the meaning of these coefficients in a Brand-Specific Conjoint, let’s take a look at Example experiment 2 in your experiment list:
- Column ASC: Opt-in is the reverse value of “None of the above” option. A higher opt-in value means that the respondent is less likely to select the “None of the above” option.
- Preferences for brands are highlighted in columns
B4. In this case, preferences for column B1 (Landrange Hoover) are not shown / set to 0 (because it is a dummy variable / point of reference for brands)
- Similarly, preference for levels are highlighted in subsequent columns. The columns highlighted below (
B1A2L3) represent the preferences for price of Landrange Hoover, where:
B1A2L1= Not shown / 0 (because it is a dummy variable / point of reference for prices)
B1A2L2= Preferences for Landrange Hoover price of $23,000
B1A2L3= Preferences for Landrange Hoover price of $25,000
To find the utility for “None of the above”, look for the “ASC Opt-in” column:
How do I download additional question answers for each respondent?
To download additional question answers for each respondent, make sure that “Respondent info” is included in the analysis cart when you export.
Each row represents one participant who responded to the survey. Respondents are identified through the ID in the row
Note that this sheet includes respondents that were not included within the analysis. Respondents may be excluded for a variety of reasons, including low-quality responses or being disqualified for not matching the survey criteria.
To filter by respondents who were only included within analysis for the report, filter the column
status_included_in_analysis to only show participants with a value of
How do you interpret individual Gabor-Granger results from Excel?
After downloading the Excel export with “Respondent info” included, navigate to the “Respondent” tab in the worksheet. You can then view the individual responses. Please note that:
Nomeans that the respondent indicated that they would not be willing to purchase the product at all.
Yesmeans that the respondent indicated that they would be willing to purchase the product but not at any of the presented prices.
- The number value indicates the highest price that the respondent would be willing to pay for the product.