Skip to main content

How do you calculate the average bar?

The average bar provides a baseline to compare the performance of one ad against the rest of the set. Learn how we calculate it.

Written by Joel Charboneau

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:

  1. Open your report in table view.

  2. 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:

  1. 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).

  2. More ads = more precise average. A report that contains more ads has a larger sample size of data to calculate the averages from.

Did this answer your question?