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.

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.


While not exactly the formula above, these resources can help: SUMPRODUCT weighted average and conditional weighted averages.
More articles
Panel · October 2026
Building B2B Trust in Japan and Korea: Where Content Ends and People Begin
Notes from my panel with Li Yong (Nuvei) on why global playbooks break in Japan, why Korea moves faster online, and where content should hand over to people.
Read article (8 minute read)
Panel · 2025
SEO in the Era of AI and Reduced Clicks: What’s Actually Working
From my Ahrefs Evolve panel: modular content, HTML tables, why your comparison pages get ignored by AI Overviews, and why CRO matters more than ever.
Read article (11 minute read)
Podcast · 2026
AI and Trust Are Not Competing Priorities
Podcast notes on responsible AI: monitoring drift and cost, data infrastructure, new job metrics, provenance, AEO budgets and why trust is what lets AI scale.
Read article (10 minute read)
Article · April 2026
How We Grew AI Overview Visibility From 5% to 32%
Insights from my DMS 2026 presentation: how footer, header and homepage links plus refreshed guides moved AI Overview visibility and average position at Liferay – and why ChatGPT didn’t budge.
Read article (3 minute read)
Article · January 2026
How We Grew Homepage Conversions by 79%
A simple homepage hero test at Liferay: new CTAs, a motion graphic and localized partner logos lifted CTA clicks globally – but not in every market.
Read article (3 minute read)
Article · May 2025
JavaScript Rendering for LLMs: Why Isomorphic Rendering Matters
LLM crawlers don’t render JavaScript (aside from Gemini, which uses Googlebot). Why full client-side rendering is a problem and how Next.js and Nuxt solve it.
Read article (3 minute read)
Article · May 2025
Getting Your Brand Mentioned by LLMs Starts With Association
LLMs predict the next word based on patterns in their training data. What that means for your brand, and what the temperature parameter tells us about it.
Read article (3 minute read)
Article · April 2025
Help Centers: The Most Overlooked Source of Internal Links
In my study of top SaaS brands, support pages supplied only 1.5% of internal links to conversion pages – despite having as many pages as blogs or resources.
Read article (3 minute read)
Article · April 2025
Think Page Discoverability, Not Internal Linking
From my DMS 2025 talk in Seoul: why I reframe internal linking as page discoverability, and how to build a discoverability matrix for SaaS sites.
Read article (3 minute read)
Article · April 2025
Hreflang Tags and Global Content Sequencing
Hreflang tags don’t just show the right page to the right market – they pass authority. What that means when you grow content across markets.
Read article (3 minute read)