How can we calculate median order value in Shopify analytics?

Shopify Discussion
,

Topic summary

Users are requesting Median Order Value (MOV) as a metric in Shopify’s analytics dashboard. The original poster explains that while Average Order Value (AOV) is useful, it can be distorted by outliers—particularly rare high-value orders—making it less representative of typical transactions.

Key Points:

  • The median (middle value in a dataset) provides a more stable view of regular order sizes, unaffected by extreme values
  • Multiple users confirm they’ve searched extensively but cannot find this “pretty basic metric” in Shopify’s current analytics
  • Community members are seeking:
    1. Any existing workarounds to calculate MOV within Shopify
    2. How to formally recommend this feature to Shopify
    3. Manual calculation methods if the feature won’t be released soon

Status: The discussion remains open with no official Shopify response or solution provided. Users are actively following up on the request’s progress.

Summarized with AI on November 2. AI used: claude-sonnet-4-5-20250929.
1

Hello Community,

I’ve been using Shopify’s analytics tools extensively and have found them to be incredibly valuable in understanding our store’s performance. However, there’s one specific metric I believe would be a great addition: Median Order Value.

While the Average Order Value (AOV) provides a general sense of the typical order size, it can sometimes be skewed by outliers, especially those rare high-value orders. For businesses like ours, where occasional large orders can significantly impact the AOV, the median order value would offer a more balanced and consistent insight into our regular transactions.

The median, as many of you might know, is the middle value in a list of numbers, which means it’s less affected by extreme values on either end of the spectrum. By having a report that shows the median order value, we can get a clearer picture of our typical order size without the distortion caused by those occasional high or low orders.

I wanted to reach out and see if:

  1. There’s already a solution or workaround within Shopify to obtain this metric?
  2. If not, how can we, as a community, recommend this as a report for Shopify to consider offering in the future?

I believe many store owners would benefit from this additional insight, and it would be a valuable tool for making more informed business decisions.

Thank you for taking the time to read my suggestion. I look forward to hearing your thoughts and any potential solutions or steps forward.

Warm regards,

-Jon (steelmantools.com, 212performance.com)

1 Like
2

Hey,

Your suggestion for adding the Median Order Value metric in Shopify’s analytics tools makes a lot of sense, as it can provide a more stable and representative view of order values, especially for businesses with varying order sizes.

3 Likes
3

I too would like to know the median order value as a front page metric similar to average order value. I searched and searched as this is a pretty basic metric and I could not find it. Lets go Shopify, give us this option to display in analytics.

1 Like
4

Hello Shopify. How is this request coming?

5

How would we go about calculating the MOV if this feature isn’t to be released soon?