Skip to main content
AmigoFish

Build Your Own Rank Tracker (Google Is Poisoning the Third-Party Ones)

From The Edward Show · · 12 min

This plays from the publisher's own server. We do not host a copy.

Open at the source

Not rated yet

Description

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

Back to The Edward Show · Report a problem