The Results page shows statistics and product metrics for each Ecommerce question. When analyzing the results of an Ecommerce simulation, the geometric mean is often used as a way to account for outliers in the data. The geometric mean is most frequently used in economics and finance but can also be used when dealing with values that don't have a finite range, such as money. Unlike the standard arithmetic mean, the geometric mean does a better job at trying to account for and not be as influenced by extreme outliers.
In the case of the Ecommerce, because there could be so much behavioral variation where some respondents might fill up their carts, rather than removing them as outliers altogether, the geometric means acknowledges this could be real life behavior but does not let it skew the results.
For example, in the Ecommerce, average cart spend is calculated using geometric mean because it is a more robust metric that avoids the extreme influence of outliers.
1. Analyzing Ecommerce Summary Statistics
Ecommerce summary statistics include:
- Average cart spend is the average sum (geometric mean) of money spent by each respondent
- Average cart size is the average number (arithmetic mean) of products purchased by each respondent
- Average number of unique products in cart is the average number (arithmetic mean) of products purchased by each respondent
- Total products purchased is the count of products purchased by all respondents in the Ecommerce exercise
- Total products picked up shows the total number of products picked up on the Ecommerce across all respondents
- Total product spend is the sum of money spent on products purchased by all respondents in the Ecommerce exercise
- Average time at shelf is the average time (geometric mean) spent by each respondent from entering the exercise to exiting the exercise
- Average time to first click is the average time (geometric mean) each respondent took from entering the exercise to clicking on a product to examine it closer for the first time
- Average attention span per product refers to the average (arithmetic mean) of the average amount of time each product's details were viewed by respondents, calculated using the geometric mean within respondent.
2. Analyzing Ecommerce Summary Statistics
- Click the Product Metrics drop-down menu below the shop summary statistics to toggle between results pertaining to Purchase selection, Purchase quantity, Purchase amount, Purchased, picked up only, Attention span, Time to cart, and Time to First Click.
- Purchase selection represents the proportion of individuals who bought a product.
- Purchase quantity is the average number (arithmetic mean) of a product purchased among those who purchased that product.
- Purchase amount is the average spend (geometric mean) on a product among those who purchased that product.
- Purchased, picked up only chart shows the percentages of individuals who purchased the product, those who solely picked it up, and those who did neither.
- Picked up only shows the percentages of individuals who picked up the product that did not buy it out of the total number of respondents that saw the Ecommerce question.
- Total products picked up shows the percentages of individuals who picked up the product AND bought it out of the total number of respondents that saw the Ecommerce question.
- No Action shows the percentages of individuals who did not pick up the product AND did not buy the product, out of the total number of respondents that saw the Ecommerce question.
- Attention span represents the average time (geometric mean) spent viewing a product's detail view, among those who clicked on the product.
- Time to cart represents the average time (geometric mean) between starting the task and adding a product to cart among those who added that product to the cart at any point in the exercise.
- Time to first click represents the average time (geometric mean) between entering the exercise to clicking on a product to examine it closer for the first time.
- Hover over bars to get a further breakdown of data per product. When Purchase selection is visualized, hovering will also show live significance testing.
3. Exporting the Results
- Click the Export icon in the left-hand navigation.
- Select Raw CSV or Excel to yield a report that shows only purchase intent.
- Select Excel with coded map or JMP to yield a report that shows additional metrics. In Excel with coded map, each Ecommerce question added will yield its own sheet of data.