Do you need support in running a pricing or product study? We can help you with agile consumer research and conjoint analysis.Request consultation
Conjoint.ly now supports exporting simulation charts to Excel, to make it easier than ever to include your simulations into documents or presentation decks. Even the colours assigned in the online simulator will be carried over to the exported charts!
This walk-through demonstrates how to export beautiful charts from the Conjoint.ly simulator in less than two minutes.
To follow the instruction you can view and export Report for Example experiment 8: Subscription plan optimisation for a streaming service.
Within the Conjoint.ly online simulator, assign colours to your tested SKUs in a meaningful way. Here we have two separate brands, so we are assigning all SKUs of one brand different shades of red, and the other different shades of blue.
Specify the formula used in calculating the revenue/profit. Here we are going to follow Conjoint.ly’s default formula for a market index of 1000 products.
Under the market overview tab, select export to Excel. Enable the option to export simulation charts. This will only take a couple of minutes.
Moving to the simulation tab, we see that the preference share graph has already been built, following the colours specified in the online simulator.
Now let’s also create the revenue graph from scratch. We will select all of the revenue data and insert a new stacked column chart. Using the Conjoint.ly Excel Add-in, we will:
Finally we can add turn out charts into a presentation slide. By simply adding titles, the charts are transformed into a professional looking presentation slide.
Would you like to try new excel export functionality? Log in to explore simulation reports.
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.
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: