YouTube2Text

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

by Edward Sturm · 2,447 words · 346 segments · language en · Watch on YouTube

Full transcript

  1. 0:00Building your own rank tracker is one of
  2. 0:01the most important SEO things that you
  3. 0:03can do. We just made our own rank
  4. 0:06tracker tracking the rankings for the
  5. 0:08company that I'm funding. So, this is
  6. 0:10the data that our tracker shows so you
  7. 0:13can copy us, what we don't track, so you
  8. 0:15know what to avoid and why we're doing
  9. 0:17this in the first place. And if you're
  10. 0:18listening the YouTube version of this,
  11. 0:20I'm showing screenshots. And if you're
  12. 0:22watching, these screenshots are with a
  13. 0:24madeup company. I I gave our actual rank
  14. 0:27tracker screenshots to Claude. I said,
  15. 0:29"Change all the keywords, change the
  16. 0:31URLs, do it for this madeup company."
  17. 0:33But all the data that's shown in the way
  18. 0:35that it's presented is how it actually
  19. 0:37looks with our rank tracker. Why even do
  20. 0:39this in the first place? As I've talked
  21. 0:41about, third party rank trackers are
  22. 0:43less reliable than they've ever been.
  23. 0:45You might see your weekby- week rankings
  24. 0:48just completely plummet and it looks
  25. 0:50like everything's going wrong, but then
  26. 0:51you go to Google Search Console, which
  27. 0:53is a source of truth. Google Search
  28. 0:55Console is showing business as usual.
  29. 0:57things are stable or they're even
  30. 0:58increasing. Google is giving rank
  31. 1:00trackers third-party rank trackers
  32. 1:03poison SERs and poison data and just
  33. 1:06making it a lot harder to track your
  34. 1:08weekly rankings extremely accurately.
  35. 1:11And if you're doing SEO and you're
  36. 1:13targeting keywords, you need to have
  37. 1:16accurate data to know if the changes you
  38. 1:18make are getting you progress, are
  39. 1:20hurting you, you can make a change and
  40. 1:22see that your rankings completely
  41. 1:25dropped the next week and think that you
  42. 1:27have to roll back that change. But if
  43. 1:29you went and checked out Google Search
  44. 1:30Console, everything is normal. And
  45. 1:32actually, you shouldn't roll it back
  46. 1:33because maybe if you left in the change,
  47. 1:35your rankings would increase. Getting
  48. 1:37volatile data for your own rankings when
  49. 1:40you are actively doing SEO is very
  50. 1:43dangerous. Now the other problem, why
  51. 1:44can't you just use Google Search
  52. 1:46Console? Google Search Console only
  53. 1:47gives you 16 months of data. So you have
  54. 1:50to back up your data with BigQuery,
  55. 1:52which is extremely inexpensive, pretty
  56. 1:54much free for most businesses, very easy
  57. 1:56to do. And then you use this BigQuery
  58. 1:58data to vibe your rank tracker. We have
  59. 2:01our rank tracker on
  60. 2:02analytics.website.com.
  61. 2:04and then you sign in with an email
  62. 2:06address to see it. Our rank tracker is
  63. 2:08using BigQuery data which comes from
  64. 2:10Google search console as the source of
  65. 2:13truth and it is the best source of
  66. 2:15truth. It's data directly from Google.
  67. 2:17You can't get better data than that. Now
  68. 2:19in terms of what we track despite what
  69. 2:21other people say, I actually don't think
  70. 2:24for SEO the most important thing to
  71. 2:26track each week is revenue. A lot of
  72. 2:28influencers, people on X, people on
  73. 2:30LinkedIn are saying SEO data is more
  74. 2:33unreliable. there's more zeroclick
  75. 2:35searches, all this stuff, and you just
  76. 2:37got to track revenue each week. And I
  77. 2:39think that's really bad advice because
  78. 2:41revenue has way too many other variables
  79. 2:44than SEO. Way too many variables. Your
  80. 2:46offering, pricing, brand support, or how
  81. 2:50fast you respond to potential customers,
  82. 2:52bugs, conversion rate optimization,
  83. 2:54trust, the list goes on and on and on
  84. 2:56and on and on. There's so many different
  85. 2:58variables other than SEO that can affect
  86. 3:00revenue. SEO is a proxy for some of
  87. 3:03those things. It could be a proxy for
  88. 3:06some aspects of conversion rate
  89. 3:08optimization or bugs, but revenue just
  90. 3:10has too many variables. What you want to
  91. 3:13track is the results that you can
  92. 3:15control from SEO, which is your rankings
  93. 3:18for your target keywords. It's very
  94. 3:21simple. You have a date range starting
  95. 3:23from all time and then you can zoom in
  96. 3:25to the last 12 months, 6 months, 3
  97. 3:27months, last months, last 30 days, last
  98. 3:3012 weeks, last 28 days, last 7 days. You
  99. 3:33can see day-by-day movements. You can
  100. 3:35see weekby- week movements. You can see
  101. 3:37monthby- monthth movements. But what are
  102. 3:39the things that you're seeing movements
  103. 3:41for? What are the things you are seeing
  104. 3:43for the date ranges? It's the rankings
  105. 3:46for your target keywords. When you are
  106. 3:48doing SEO, you should have keywords that
  107. 3:51you are targeting. You should be doing
  108. 3:52keyword research. You should be looking
  109. 3:54at average search volume each month. You
  110. 3:57should be picking keywords because
  111. 3:58they're valuable to you in a variety of
  112. 4:00ways, not just volume. Could be
  113. 4:03potential revenue that this keyword
  114. 4:05would bring if you were ranking well for
  115. 4:07it. It could be that showing up number
  116. 4:09one for it could give you a different
  117. 4:10advantage. Maybe important people are
  118. 4:13searching this keyword, but it doesn't
  119. 4:14have a lot of volume. Maybe you're a
  120. 4:16SAS. You have an embed function. You're
  121. 4:19targeting a keyword that has embed doing
  122. 4:21so and so. People are searching this and
  123. 4:24then they're embedding your SAS on their
  124. 4:26website and giving you links or there's
  125. 4:28a share function. They're sharing your
  126. 4:30SAS. They're giving you links. There's
  127. 4:32all sorts of different reasons that
  128. 4:33keywords could be valuable. And you got
  129. 4:35to find those keywords doing keyword
  130. 4:37research and target them precisely with
  131. 4:39SEO landing pages or blog posts and then
  132. 4:42see your weekby- week. Our default is 3
  133. 4:46months. Like, so when you land on the
  134. 4:48analytics tool for our rank tracker,
  135. 4:50it's 3 months. It's weekby- week
  136. 4:52movements. There's a graph showing
  137. 4:54overall averaged movements from our
  138. 4:56tracked keywords. We only track keywords
  139. 4:59that we accurately target. This is
  140. 5:00important. We could track all the
  141. 5:02keywords that our pages show for, but
  142. 5:05that would give us so much noise. It
  143. 5:08would ruin the averages. It would
  144. 5:10distract us from the keywords that
  145. 5:11matter most. you only want to track the
  146. 5:14keywords that you are actively targeting
  147. 5:16with SEO. It could be a page is oriented
  148. 5:20around that entire keyword. It could be
  149. 5:22you just added the keyword to an H2
  150. 5:25because you think an existing page could
  151. 5:27rank better for it. But either way, you
  152. 5:29are actively targeting the keyword in
  153. 5:32some way. You are not accidentally
  154. 5:34ranking for the keyword. So, you see a
  155. 5:36graph when you land on the tool showing
  156. 5:38the average movements from all of the
  157. 5:41tracked keywords. You can scroll down
  158. 5:43from the graph. You can filter by most
  159. 5:46moved, by the top ranks, by average
  160. 5:49monthly volume. We're bringing that data
  161. 5:51in from the clickstream data API from
  162. 5:54data for SEO. This way, we can sort
  163. 5:56keywords by the potential volume if we
  164. 5:59were ranking number one for these
  165. 6:00keywords in order to prioritize the SEO
  166. 6:03work that we're doing. Then we also have
  167. 6:04a column for clicks just to see if the
  168. 6:08volume estimates are relatively
  169. 6:10accurate. You also see the top page from
  170. 6:12your site, the top URL that's ranking
  171. 6:14best for your target keyword. And we
  172. 6:16have labels. Extremely important, so
  173. 6:19important is putting in labels. You want
  174. 6:21to be able to group your keywords by
  175. 6:24subfolder, by hub page, maybe intent,
  176. 6:28maybe the purpose of the keyword. You
  177. 6:30should be doing very structured SEO. And
  178. 6:32then doing structured SEO makes it
  179. 6:34really easy to organize your keywords
  180. 6:36into labels. That way you can see how an
  181. 6:39entire label is doing. So maybe all of
  182. 6:42your services are in a services hub page
  183. 6:44and you're doing the people also ask
  184. 6:46strategy that I've talked about so many
  185. 6:48times on this show and all your people
  186. 6:50also ask keywords are in an FAQ hub
  187. 6:53page. So you have a label for services,
  188. 6:55you have a label for PAA which is people
  189. 6:57also ask and then you can see the
  190. 6:59movement for all your target keywords
  191. 7:01within this hub page. Then when you
  192. 7:03click on a keyword, it's the most simple
  193. 7:06thing. You see the keyword, you see the
  194. 7:08label, you see the average monthly
  195. 7:09search volume that's coming from data
  196. 7:11for SEO, you see your current ranking,
  197. 7:13you see the movement from the start of
  198. 7:16your selected time period to the end of
  199. 7:18the selected time period, which most
  200. 7:20often will be the current date. You see
  201. 7:22an average for the period and then you
  202. 7:24see a graph with your week by week or
  203. 7:27day by day or month by month movements,
  204. 7:29which is and this graph is so important.
  205. 7:32Oh my gosh. Because you're out there,
  206. 7:34you're targeting keywords, you're
  207. 7:36revisiting your pages months later, and
  208. 7:38you're saying, "Okay, this page isn't
  209. 7:40ranking as well for my target keyword as
  210. 7:43I hoped. Oh, wow. Look at this page.
  211. 7:45It's garbage. When I created it, I
  212. 7:47thought it was great. Now, looking at it
  213. 7:49with fresh eyes, I realize it's garbage
  214. 7:51and it doesn't give the searcher what
  215. 7:52they want above the fold. Let me fix
  216. 7:54that." And so, you do that, and you see
  217. 7:56that your rankings start to increase
  218. 7:58because you're looking at this graph.
  219. 8:00That's great. Wow. And then you're like,
  220. 8:02"Wow, maybe I could actually improve
  221. 8:03this page a little bit more." And so
  222. 8:05then you go overboard and you improve it
  223. 8:07too much. Maybe use the keyword too many
  224. 8:09times. You keyword stuff a little bit by
  225. 8:11accident. And now your rankings are
  226. 8:13decreasing. And something that you
  227. 8:14should be doing is keep a journal of all
  228. 8:17the SEO changes you do, of the changes
  229. 8:19you do on your SEO pages and posts. Keep
  230. 8:21a journal of that stuff. And so now you
  231. 8:23see that your rankings are decreasing.
  232. 8:25You go back to your journal. Okay, what
  233. 8:26did I change around this time? Oh, wow.
  234. 8:28I put in a few too many mentions of this
  235. 8:31keyword or I put in this JavaScript
  236. 8:33thing above the fold and Google can't
  237. 8:36tell what's on it or just the JavaScript
  238. 8:38thing was broken and it's giving
  239. 8:40searchers a bad experience and you can
  240. 8:42go and you can fix the things that you
  241. 8:44see in your SEO journal. You're making
  242. 8:46informed improvements because you have
  243. 8:49the data to back it up. Now, you got to
  244. 8:51consider there's a lot of data that we
  245. 8:53could show in this that we're not
  246. 8:55showing because when you have more data,
  247. 8:57you have more noise, and that makes it a
  248. 9:00lot harder to make the best decisions.
  249. 9:02More noise gives you more to focus on,
  250. 9:05but you really want to focus on the
  251. 9:06things that are going to move the
  252. 9:08needle. I actually had to debate whether
  253. 9:10or not it was worth putting clicks in.
  254. 9:12And the reason we did it, and we might
  255. 9:14remove it, is again just because we want
  256. 9:16to see that the relative search volume
  257. 9:18data is accurate. But if you do this
  258. 9:20yourself, and I would encourage you to
  259. 9:21do it yourself. It's super easy. You can
  260. 9:23vibe code this. Everything is so cheap.
  261. 9:25Data for SEO is so cheap. It's so
  262. 9:28simple. But if you do it, I would
  263. 9:29encourage you put the most minimal data
  264. 9:32that you can. You could copy what I'm
  265. 9:34showing in this podcast. I hope you do.
  266. 9:36In fact, you know what I'm going to do?
  267. 9:38I'm going to take these screenshots. I'm
  268. 9:40going to upload them to the media
  269. 9:41library of my website. I'm going to put
  270. 9:43links to them in the description for
  271. 9:46this episode. And you can take these
  272. 9:47screenshots and you can give it to an
  273. 9:49LLM and it'll make remaking this a lot
  274. 9:52easier. But I wanted to share this. It's
  275. 9:53one of the things that we're working on.
  276. 9:55I'm very excited about it. Use this to
  277. 9:57monitor the changes and your progress
  278. 10:00and see if what you are doing is moving
  279. 10:03your most important SEO KPI and that is
  280. 10:07rankings. There's so many other things
  281. 10:09that get in the way of you controlling
  282. 10:11revenue. But if you're the SEO and
  283. 10:13you're doing SEO, you have a lot of
  284. 10:15control. not total control because
  285. 10:16there's off-site branding, there's
  286. 10:18links, there's all sorts of stuff, but
  287. 10:19you have a lot of control for rankings.
  288. 10:21And so, I hope everybody will do this.
  289. 10:24It's so important to have backed up,
  290. 10:26reliable data, especially now, and it's
  291. 10:29not that hard to do. You could do this
  292. 10:31in a couple of hours. If you want to see
  293. 10:33how I find keywords, because in order to
  294. 10:35do great SEO, you need to know the right
  295. 10:37keywords to target. how I target these
  296. 10:39keywords with pages that are made to
  297. 10:41convert high intent searchers, how I
  298. 10:44build links, how long it takes to rank,
  299. 10:46and how do I know how long it takes to
  300. 10:48rank, by the way? It's because I have
  301. 10:49the weekby- week keyword movements from
  302. 10:52my rank tracker. And this was back when
  303. 10:54rank trackers were a lot more reliable.
  304. 10:55They're not terrible now, but if you're
  305. 10:58going super hard with SEO, this is free.
  306. 11:01This is easy. It's going to take you a
  307. 11:02couple of hours. You should totally make
  308. 11:04your own rank tracker. If you want to
  309. 11:05see how I do SEO, sharing my screen with
  310. 11:07examples in every niche with templates,
  311. 11:10Google Docs, Google Sheets, things that
  312. 11:13you can give to the LLM of your choice
  313. 11:15to help the LLM recreate my method, how
  314. 11:18to do SEO that makes money. That's my
  315. 11:20course, compactkeywords.com.
  316. 11:22I hope you'll check it out. It is
  317. 11:24literally doing SEO that gets paying
  318. 11:26customers, users, warm leads calling you
  319. 11:29up. It's SEO at the bottom of the
  320. 11:31funnel, which is the most durable form
  321. 11:33of SEO. So check that out. And that's
  322. 11:35everything that I got for you on this
  323. 11:36episode of the show. This is episode
  324. 11:381,228
  325. 11:40of the podcast. 1,228
  326. 11:43days in a row doing this podcast. Fun
  327. 11:46fact, this is the second podcast that I
  328. 11:49recorded today. Normally I record one a
  329. 11:52day. Sometimes I have to frontload them.
  330. 11:54Tomorrow I'm doing some traveling, so I
  331. 11:56need to have a podcast ready to go. So I
  332. 11:59recorded right before this an episode
  333. 12:01with the amazing Harpit Singh that came
  334. 12:03out yesterday. That was a great episode.
  335. 12:05We had so much fun and I was feeling so
  336. 12:07good afterwards. I said, "Let me jump
  337. 12:08into this next podcast." And I have my
  338. 12:10coffee excited and it's two podcasts
  339. 12:14today and yeah, I just honestly I love
  340. 12:16SEO. I love doing this show. Thank you
  341. 12:18everybody for watching. If you watch
  342. 12:19this on YouTube, thank you so much. If
  343. 12:21you listened on Spotify or Apple
  344. 12:23Podcast, thank you so much for listening
  345. 12:25and I will talk to you again tomorrow.
  346. 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.