E1228: Third-party rank trackers are becoming less reliable. Google is making it harder for them to collect accurate rankings, and the result can be dramatic ranking drops that don't match what Google Search Console shows.
I show you the rank tracker we built for the company I'm funding, explain why we built it, and walk through how to make your own using Google Search Console, BigQuery, and DataForSEO.
The YouTube version includes screenshots of our dashboard. I've replaced the company name, keywords, and URLs to keep the business private, but the dashboard layout and data presentation reflect the tool we use.
Here's what I cover:
- Why third-party rank trackers can show sudden ranking losses even when Google Search Console shows stable or improving performance.
- How Google's efforts to disrupt automated SERP collection can cause misleading rank tracking data and bad SEO decisions.
- Why Google Search Console is the data source I trust for tracking our own search performance.
- Why we back up Google Search Console data to BigQuery instead of relying on just Search Console.
- How to build a private rank tracking dashboard from that data, without writing the code yourself.
- Why we track only keywords we're deliberately targeting instead of every query our site appears for.
- How our dashboard shows ranking trends across different date ranges, with daily, weekly, and monthly views.
- How we use DataForSEO's clickstream-based search volume estimates to sort keywords by potential opportunity.
- Why we also display clicks to compare our traffic against estimated search volume.
- How we organize target keywords using labels for hub pages, subfolders, search intent, and other categories.
- What appears on each keyword's detail page: current position, movement over the selected period, period average, search volume, labels, and historical rankings.
- How a journal of SEO changes can explain ranking movements and guide page improvements.
- Why I consider rankings a more useful weekly SEO performance measure than revenue, which depends on pricing, product, conversion rate, support, and other factors.
- Why a simple dashboard that shows the metrics you act on is better than one cluttered with data.
You can use the screenshots from this episode as a reference when building your own dashboard. I also explain what we leave out and why.
The goal is to know whether the SEO changes you make are improving rankings for the keywords that matter to your business, without making decisions based on unreliable third-party data or distracting noise.
⭐️ Screenshots and episode transcript: https://edwardsturm.com/articles/build-your-own-rank-tracker/
⭐️ Clickstream Data API (DataForSEO) - https://dataforseo.com/pricing/keywords-data/clickstream-api-pricing
⭐️ Export GSC Data to BigQuery - https://support.google.com/webmasters/topic/12917674?hl=en&ref_topic=9354552&sjid=9661028753422321451-NA
💎 Compact Keywords - My SEO Course - Get paying customers through SEO - Clear step-by-step video breakdowns - SEO templates to be copied and adapted for your products and services: https://compactkeywords.com/
00:00 Why Build Your Own Tracker
00:38 Rank Trackers Are Breaking
01:43 BigQuery Source Of Truth
02:19 Rankings Not Revenue
03:39 Keyword Targeting Basics
05:35 Dashboard Filters And Labels
07:02 Keyword Detail And SEO Journal
08:50 Keep It Minimal And Copy
11:37 Podcast Outro And Thanks
The Edward Show. Your daily search engine optimization podcast: https://edwardsturm.com/the-edward-show/
#searchengineoptimization #seo #martech #performancemarketing
