Correctly calculate Average Order Value in GA4
In GA4, the ‘Average Order Value’ metric is called ‘Average purchase revenue’.
It is calculated as ‘Purchase Revenue’ / ‘Transactions’.
‘Average purchase revenue’ is the average value of an e-commerce transaction.
Since a refund is also considered a transaction in GA4, it can impact the ‘average purchase revenue’ metric.
So, you need to take this factor into account when calculating the average order value in GA4.
Follow the steps below to correctly calculate the average order value in GA4:
Step-1: Login to your GA4 property and then click on ‘Explore’ from the left-hand navigation menu:
Step-2: Click on ‘Blank‘ to create an exploration report from scratch:
Step-3: Name this report ‘Average Order Value’:
Step-4: Add the following dimensions to this report:
- Event Name.
- Session Default Channel Group.
Step-5: Add the following metrics to this report:
- Purchase Revenue.
- Transactions.
- Average Purchase Revenue.
Step-6: Double click on the ‘Session default channel group’ dimension to add it to the canvas on right.
Step-7: Double click on the metrics one by one (in the order they are listed) to add them to the canvas on right.
Your screen should now look like the one below:
Step-8: Apply the following dimension filter to your report so that only the ‘purchase’ event is taken into account when calculating the ‘transactions’ and ‘average purchase revenue’ metrics.
Event name exactly matches purchase.
You should now see the accurate reporting of the average order value in your GA4 report via the ‘Average Purchase Revenue’ metric:
In GA4, the ‘Average Order Value’ metric is called ‘Average purchase revenue’.
It is calculated as ‘Purchase Revenue’ / ‘Transactions’.
‘Average purchase revenue’ is the average value of an e-commerce transaction.
Since a refund is also considered a transaction in GA4, it can impact the ‘average purchase revenue’ metric.
So, you need to take this factor into account when calculating the average order value in GA4.
Follow the steps below to correctly calculate the average order value in GA4:
Step-1: Login to your GA4 property and then click on ‘Explore’ from the left-hand navigation menu:
Step-2: Click on ‘Blank‘ to create an exploration report from scratch:
Step-3: Name this report ‘Average Order Value’:
Step-4: Add the following dimensions to this report:
- Event Name.
- Session Default Channel Group.
Step-5: Add the following metrics to this report:
- Purchase Revenue.
- Transactions.
- Average Purchase Revenue.
Step-6: Double click on the ‘Session default channel group’ dimension to add it to the canvas on right.
Step-7: Double click on the metrics one by one (in the order they are listed) to add them to the canvas on right.
Your screen should now look like the one below:
Step-8: Apply the following dimension filter to your report so that only the ‘purchase’ event is taken into account when calculating the ‘transactions’ and ‘average purchase revenue’ metrics.
Event name exactly matches purchase.
You should now see the accurate reporting of the average order value in your GA4 report via the ‘Average Purchase Revenue’ metric:
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.