The average bar (at the bottom of your reporting table) lets you quickly compare the performance of one ad group against the rest of the set. Here's how we calculate it and the best way to use it.
💡 Quick answer: the average bar shows a spend-weighted average of each ad's value. It isn't a campaign total, so for cost metrics like CPA it won't match Ads Manager. For a blended CPA, divide the Spend total by the Purchases total in the Net Results row.
Calculating average spend
Average Spend is calculated by taking a simple mean of the spend of all groups. (Total spend / total ads).
Calculating other average metrics
To calculate the other metrics, we take a weighted average of the metric against ad spend, leaving out ads where the metric has no value.
This prioritizes the ads that have more spend behind them, rather than considering all ads equally, whether they'd spend $1 or $1000.
Weighted average
For each metric first we weigh each group based on how much they have spent. Take the example below, which would be calculated to show a weighted average of 2.6 for the metric.
Ad | KPI Value | Total Spend | Weighting | Final Value |
Ad 1 | 2 | $8 | 0.8 | 1.6 |
Ad 2 | 5 | $2 | 0.2 | 1 |
With weighted averages, we get a final result that reflects the performance of the set as a whole, and eliminates potential outliers caused by data that is really high (or really low) but has very low spend (for example, an ad that has very high ROAS due to low ad spend).
When zero values count
If an ad spent money and the metric came out as zero, that zero counts in the average. For example, an ad with spend and no purchases has a CPA of $0, and it pulls the Avg CPA down.
Keep in mind your averages will always be more precise with longer date ranges and more ads compared in the set.
Example: Avg CPA vs blended CPA
Ad | Spend | Purchases | CPA | Weighting | Final Value |
Ad 1 | $80 | 2 | $40 | 0.8 | $32 |
Ad 2 | $20 | 0 | $0 | 0.2 | $0 |
Avg CPA (average bar): $32
Blended CPA (Spend ÷ Purchases): $100 ÷ 2 = $50
Why doesn't my Avg CPA match Ads Manager?
Ads Manager shows CPA as total spend divided by total purchases. The Avg in your Net Results row is a spend-weighted average of each ad's CPA, and ads that spent without a purchase count as $0. So the Avg is usually lower than your real CPA, especially when many ads have no purchases yet.
To get the CPA that matches Ads Manager:
Open your report in table view.
In the Net Results row, take the Spend total and divide it by the Purchases total.
Each individual row's CPA is already real spend ÷ purchases for that group. If your numbers still don't match, see Why don't my Motion results match Ads Manager?
Rounding
We round the final average to the nearest hundredth (two decimal places) or the nearest integer, depending on whether the metric is decimal-based (such as ROAS) or whole-number-based (such as comments).
Making accurate decisions with the average bar
The average bar lets you compare the performance of one ad group against the rest of the set, fast.
Keep these two points in mind when using them:
Longer date range = more accurate average. The more time that an ad has to collect data, the less likely outliers will affect your results (such as really high metric figures or values of zero).
More ads = more precise average. A report that contains more ads has a larger sample size of data to calculate the averages from.
