Build Your Own Rank Tracker (Google Is Poisoning the Third-Party Ones) — Transcript
Full transcript
- 0:00Building your own rank tracker is one of
- 0:01the most important SEO things that you
- 0:03can do. We just made our own rank
- 0:06tracker tracking the rankings for the
- 0:08company that I'm funding. So, this is
- 0:10the data that our tracker shows so you
- 0:13can copy us, what we don't track, so you
- 0:15know what to avoid and why we're doing
- 0:17this in the first place. And if you're
- 0:18listening the YouTube version of this,
- 0:20I'm showing screenshots. And if you're
- 0:22watching, these screenshots are with a
- 0:24madeup company. I I gave our actual rank
- 0:27tracker screenshots to Claude. I said,
- 0:29"Change all the keywords, change the
- 0:31URLs, do it for this madeup company."
- 0:33But all the data that's shown in the way
- 0:35that it's presented is how it actually
- 0:37looks with our rank tracker. Why even do
- 0:39this in the first place? As I've talked
- 0:41about, third party rank trackers are
- 0:43less reliable than they've ever been.
- 0:45You might see your weekby- week rankings
- 0:48just completely plummet and it looks
- 0:50like everything's going wrong, but then
- 0:51you go to Google Search Console, which
- 0:53is a source of truth. Google Search
- 0:55Console is showing business as usual.
- 0:57things are stable or they're even
- 0:58increasing. Google is giving rank
- 1:00trackers third-party rank trackers
- 1:03poison SERs and poison data and just
- 1:06making it a lot harder to track your
- 1:08weekly rankings extremely accurately.
- 1:11And if you're doing SEO and you're
- 1:13targeting keywords, you need to have
- 1:16accurate data to know if the changes you
- 1:18make are getting you progress, are
- 1:20hurting you, you can make a change and
- 1:22see that your rankings completely
- 1:25dropped the next week and think that you
- 1:27have to roll back that change. But if
- 1:29you went and checked out Google Search
- 1:30Console, everything is normal. And
- 1:32actually, you shouldn't roll it back
- 1:33because maybe if you left in the change,
- 1:35your rankings would increase. Getting
- 1:37volatile data for your own rankings when
- 1:40you are actively doing SEO is very
- 1:43dangerous. Now the other problem, why
- 1:44can't you just use Google Search
- 1:46Console? Google Search Console only
- 1:47gives you 16 months of data. So you have
- 1:50to back up your data with BigQuery,
- 1:52which is extremely inexpensive, pretty
- 1:54much free for most businesses, very easy
- 1:56to do. And then you use this BigQuery
- 1:58data to vibe your rank tracker. We have
- 2:01our rank tracker on
- 2:02analytics.website.com.
- 2:04and then you sign in with an email
- 2:06address to see it. Our rank tracker is
- 2:08using BigQuery data which comes from
- 2:10Google search console as the source of
- 2:13truth and it is the best source of
- 2:15truth. It's data directly from Google.
- 2:17You can't get better data than that. Now
- 2:19in terms of what we track despite what
- 2:21other people say, I actually don't think
- 2:24for SEO the most important thing to
- 2:26track each week is revenue. A lot of
- 2:28influencers, people on X, people on
- 2:30LinkedIn are saying SEO data is more
- 2:33unreliable. there's more zeroclick
- 2:35searches, all this stuff, and you just
- 2:37got to track revenue each week. And I
- 2:39think that's really bad advice because
- 2:41revenue has way too many other variables
- 2:44than SEO. Way too many variables. Your
- 2:46offering, pricing, brand support, or how
- 2:50fast you respond to potential customers,
- 2:52bugs, conversion rate optimization,
- 2:54trust, the list goes on and on and on
- 2:56and on and on. There's so many different
- 2:58variables other than SEO that can affect
- 3:00revenue. SEO is a proxy for some of
- 3:03those things. It could be a proxy for
- 3:06some aspects of conversion rate
- 3:08optimization or bugs, but revenue just
- 3:10has too many variables. What you want to
- 3:13track is the results that you can
- 3:15control from SEO, which is your rankings
- 3:18for your target keywords. It's very
- 3:21simple. You have a date range starting
- 3:23from all time and then you can zoom in
- 3:25to the last 12 months, 6 months, 3
- 3:27months, last months, last 30 days, last
- 3:3012 weeks, last 28 days, last 7 days. You
- 3:33can see day-by-day movements. You can
- 3:35see weekby- week movements. You can see
- 3:37monthby- monthth movements. But what are
- 3:39the things that you're seeing movements
- 3:41for? What are the things you are seeing
- 3:43for the date ranges? It's the rankings
- 3:46for your target keywords. When you are
- 3:48doing SEO, you should have keywords that
- 3:51you are targeting. You should be doing
- 3:52keyword research. You should be looking
- 3:54at average search volume each month. You
- 3:57should be picking keywords because
- 3:58they're valuable to you in a variety of
- 4:00ways, not just volume. Could be
- 4:03potential revenue that this keyword
- 4:05would bring if you were ranking well for
- 4:07it. It could be that showing up number
- 4:09one for it could give you a different
- 4:10advantage. Maybe important people are
- 4:13searching this keyword, but it doesn't
- 4:14have a lot of volume. Maybe you're a
- 4:16SAS. You have an embed function. You're
- 4:19targeting a keyword that has embed doing
- 4:21so and so. People are searching this and
- 4:24then they're embedding your SAS on their
- 4:26website and giving you links or there's
- 4:28a share function. They're sharing your
- 4:30SAS. They're giving you links. There's
- 4:32all sorts of different reasons that
- 4:33keywords could be valuable. And you got
- 4:35to find those keywords doing keyword
- 4:37research and target them precisely with
- 4:39SEO landing pages or blog posts and then
- 4:42see your weekby- week. Our default is 3
- 4:46months. Like, so when you land on the
- 4:48analytics tool for our rank tracker,
- 4:50it's 3 months. It's weekby- week
- 4:52movements. There's a graph showing
- 4:54overall averaged movements from our
- 4:56tracked keywords. We only track keywords
- 4:59that we accurately target. This is
- 5:00important. We could track all the
- 5:02keywords that our pages show for, but
- 5:05that would give us so much noise. It
- 5:08would ruin the averages. It would
- 5:10distract us from the keywords that
- 5:11matter most. you only want to track the
- 5:14keywords that you are actively targeting
- 5:16with SEO. It could be a page is oriented
- 5:20around that entire keyword. It could be
- 5:22you just added the keyword to an H2
- 5:25because you think an existing page could
- 5:27rank better for it. But either way, you
- 5:29are actively targeting the keyword in
- 5:32some way. You are not accidentally
- 5:34ranking for the keyword. So, you see a
- 5:36graph when you land on the tool showing
- 5:38the average movements from all of the
- 5:41tracked keywords. You can scroll down
- 5:43from the graph. You can filter by most
- 5:46moved, by the top ranks, by average
- 5:49monthly volume. We're bringing that data
- 5:51in from the clickstream data API from
- 5:54data for SEO. This way, we can sort
- 5:56keywords by the potential volume if we
- 5:59were ranking number one for these
- 6:00keywords in order to prioritize the SEO
- 6:03work that we're doing. Then we also have
- 6:04a column for clicks just to see if the
- 6:08volume estimates are relatively
- 6:10accurate. You also see the top page from
- 6:12your site, the top URL that's ranking
- 6:14best for your target keyword. And we
- 6:16have labels. Extremely important, so
- 6:19important is putting in labels. You want
- 6:21to be able to group your keywords by
- 6:24subfolder, by hub page, maybe intent,
- 6:28maybe the purpose of the keyword. You
- 6:30should be doing very structured SEO. And
- 6:32then doing structured SEO makes it
- 6:34really easy to organize your keywords
- 6:36into labels. That way you can see how an
- 6:39entire label is doing. So maybe all of
- 6:42your services are in a services hub page
- 6:44and you're doing the people also ask
- 6:46strategy that I've talked about so many
- 6:48times on this show and all your people
- 6:50also ask keywords are in an FAQ hub
- 6:53page. So you have a label for services,
- 6:55you have a label for PAA which is people
- 6:57also ask and then you can see the
- 6:59movement for all your target keywords
- 7:01within this hub page. Then when you
- 7:03click on a keyword, it's the most simple
- 7:06thing. You see the keyword, you see the
- 7:08label, you see the average monthly
- 7:09search volume that's coming from data
- 7:11for SEO, you see your current ranking,
- 7:13you see the movement from the start of
- 7:16your selected time period to the end of
- 7:18the selected time period, which most
- 7:20often will be the current date. You see
- 7:22an average for the period and then you
- 7:24see a graph with your week by week or
- 7:27day by day or month by month movements,
- 7:29which is and this graph is so important.
- 7:32Oh my gosh. Because you're out there,
- 7:34you're targeting keywords, you're
- 7:36revisiting your pages months later, and
- 7:38you're saying, "Okay, this page isn't
- 7:40ranking as well for my target keyword as
- 7:43I hoped. Oh, wow. Look at this page.
- 7:45It's garbage. When I created it, I
- 7:47thought it was great. Now, looking at it
- 7:49with fresh eyes, I realize it's garbage
- 7:51and it doesn't give the searcher what
- 7:52they want above the fold. Let me fix
- 7:54that." And so, you do that, and you see
- 7:56that your rankings start to increase
- 7:58because you're looking at this graph.
- 8:00That's great. Wow. And then you're like,
- 8:02"Wow, maybe I could actually improve
- 8:03this page a little bit more." And so
- 8:05then you go overboard and you improve it
- 8:07too much. Maybe use the keyword too many
- 8:09times. You keyword stuff a little bit by
- 8:11accident. And now your rankings are
- 8:13decreasing. And something that you
- 8:14should be doing is keep a journal of all
- 8:17the SEO changes you do, of the changes
- 8:19you do on your SEO pages and posts. Keep
- 8:21a journal of that stuff. And so now you
- 8:23see that your rankings are decreasing.
- 8:25You go back to your journal. Okay, what
- 8:26did I change around this time? Oh, wow.
- 8:28I put in a few too many mentions of this
- 8:31keyword or I put in this JavaScript
- 8:33thing above the fold and Google can't
- 8:36tell what's on it or just the JavaScript
- 8:38thing was broken and it's giving
- 8:40searchers a bad experience and you can
- 8:42go and you can fix the things that you
- 8:44see in your SEO journal. You're making
- 8:46informed improvements because you have
- 8:49the data to back it up. Now, you got to
- 8:51consider there's a lot of data that we
- 8:53could show in this that we're not
- 8:55showing because when you have more data,
- 8:57you have more noise, and that makes it a
- 9:00lot harder to make the best decisions.
- 9:02More noise gives you more to focus on,
- 9:05but you really want to focus on the
- 9:06things that are going to move the
- 9:08needle. I actually had to debate whether
- 9:10or not it was worth putting clicks in.
- 9:12And the reason we did it, and we might
- 9:14remove it, is again just because we want
- 9:16to see that the relative search volume
- 9:18data is accurate. But if you do this
- 9:20yourself, and I would encourage you to
- 9:21do it yourself. It's super easy. You can
- 9:23vibe code this. Everything is so cheap.
- 9:25Data for SEO is so cheap. It's so
- 9:28simple. But if you do it, I would
- 9:29encourage you put the most minimal data
- 9:32that you can. You could copy what I'm
- 9:34showing in this podcast. I hope you do.
- 9:36In fact, you know what I'm going to do?
- 9:38I'm going to take these screenshots. I'm
- 9:40going to upload them to the media
- 9:41library of my website. I'm going to put
- 9:43links to them in the description for
- 9:46this episode. And you can take these
- 9:47screenshots and you can give it to an
- 9:49LLM and it'll make remaking this a lot
- 9:52easier. But I wanted to share this. It's
- 9:53one of the things that we're working on.
- 9:55I'm very excited about it. Use this to
- 9:57monitor the changes and your progress
- 10:00and see if what you are doing is moving
- 10:03your most important SEO KPI and that is
- 10:07rankings. There's so many other things
- 10:09that get in the way of you controlling
- 10:11revenue. But if you're the SEO and
- 10:13you're doing SEO, you have a lot of
- 10:15control. not total control because
- 10:16there's off-site branding, there's
- 10:18links, there's all sorts of stuff, but
- 10:19you have a lot of control for rankings.
- 10:21And so, I hope everybody will do this.
- 10:24It's so important to have backed up,
- 10:26reliable data, especially now, and it's
- 10:29not that hard to do. You could do this
- 10:31in a couple of hours. If you want to see
- 10:33how I find keywords, because in order to
- 10:35do great SEO, you need to know the right
- 10:37keywords to target. how I target these
- 10:39keywords with pages that are made to
- 10:41convert high intent searchers, how I
- 10:44build links, how long it takes to rank,
- 10:46and how do I know how long it takes to
- 10:48rank, by the way? It's because I have
- 10:49the weekby- week keyword movements from
- 10:52my rank tracker. And this was back when
- 10:54rank trackers were a lot more reliable.
- 10:55They're not terrible now, but if you're
- 10:58going super hard with SEO, this is free.
- 11:01This is easy. It's going to take you a
- 11:02couple of hours. You should totally make
- 11:04your own rank tracker. If you want to
- 11:05see how I do SEO, sharing my screen with
- 11:07examples in every niche with templates,
- 11:10Google Docs, Google Sheets, things that
- 11:13you can give to the LLM of your choice
- 11:15to help the LLM recreate my method, how
- 11:18to do SEO that makes money. That's my
- 11:20course, compactkeywords.com.
- 11:22I hope you'll check it out. It is
- 11:24literally doing SEO that gets paying
- 11:26customers, users, warm leads calling you
- 11:29up. It's SEO at the bottom of the
- 11:31funnel, which is the most durable form
- 11:33of SEO. So check that out. And that's
- 11:35everything that I got for you on this
- 11:36episode of the show. This is episode
- 11:381,228
- 11:40of the podcast. 1,228
- 11:43days in a row doing this podcast. Fun
- 11:46fact, this is the second podcast that I
- 11:49recorded today. Normally I record one a
- 11:52day. Sometimes I have to frontload them.
- 11:54Tomorrow I'm doing some traveling, so I
- 11:56need to have a podcast ready to go. So I
- 11:59recorded right before this an episode
- 12:01with the amazing Harpit Singh that came
- 12:03out yesterday. That was a great episode.
- 12:05We had so much fun and I was feeling so
- 12:07good afterwards. I said, "Let me jump
- 12:08into this next podcast." And I have my
- 12:10coffee excited and it's two podcasts
- 12:14today and yeah, I just honestly I love
- 12:16SEO. I love doing this show. Thank you
- 12:18everybody for watching. If you watch
- 12:19this on YouTube, thank you so much. If
- 12:21you listened on Spotify or Apple
- 12:23Podcast, thank you so much for listening
- 12:25and I will talk to you again tomorrow.
- 12:27B.
About this transcript
This page contains the full transcript of Build Your Own Rank Tracker (Google Is Poisoning the Third-Party Ones) by Edward Sturm, generated from the public captions YouTube serves with the video. The transcript has 2,447 words across 346 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.
What you can do with it
Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.
Free YouTube transcript tool
YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.