Skip to Main Content
SEOSeb

Article · SEO & analytics · May 2025

Why Your Average Position Is Misleading (and the Formula I Use Instead)

The “average position” in Google Search Console and most tools is unweighted. Here’s why that matters, and my Excel formula for a weighted average by topic.

By Sebastien Edgar · 3 min read

Here’s a quick tactical SEO and analytics tip: the “average position” in Google Search Console (GSC) and most tools is often misleading because it’s unweighted.

When averaging keyword positions to assess performance by topic, a simple average gives every keyword equal weight, regardless of search volume. A low search volume keyword impacts the average as much as a high search volume one.

An example

Consider these keywords with their rankings and search volumes:

  • Keyword A: position 1, search volume 500
  • Keyword B: position 2, search volume 100
  • Keyword C: position 4, search volume 200
  • Keyword D: position 10, search volume 5,000
  • Keyword E: position 15, search volume 10,000

A normal average gives a position of ~6. A weighted average, factoring in search volume, yields ~12. That’s a huge difference, and far more accurate, as it prioritizes the terms actually driving traffic.

Image 1 from the original LinkedIn post

The solution: a weighted average

Use a weighted average to reflect the true impact of high volume (or high impression) keywords. Here’s the custom Excel formula I’ve been using for years to calculate a conditional weighted average by topic:

=IFERROR(SUMPRODUCT(--(ISNUMBER(SEARCH("topic", topics_column))), kw_position, search_volume) / SUMIF(topics_column, "topic", search_volume), 0)

The formula multiplies each keyword’s position by its search volume, sums the results, and divides by the total search volume for the topic. ISNUMBER is what makes a normal SUMPRODUCT / SUMIF formula conditional.

Image 2 from the original LinkedIn post
Image 3 from the original LinkedIn post

While not exactly the formula above, these resources can help: SUMPRODUCT weighted average and conditional weighted averages.