Median, Mode, and Average Order Value in BigQuery using SQL

Learn about your customers’ ordering habits and choose the best strategy for increasing the value of your orders

Why use median, mode, or average order value?

These metrics can help you in understanding how your customers purchase at an “order level”. Different dimensions, such as your product portfolio’s price range, acquisition channel, and location, can have an impact on these metrics. You can also use them as a comparison to other industries.

bigquery business data science ecommerce sql value