ChatGPT search query extractor
You can use my ‘ChatGPT Search Query Extractor’ bookmarklet to easily view search queries in any ChatGPT conversation that grounds its response using a web search (with Bing search engine).…
JavaScript snippet to analyze XML sitemap
Trying to make sense of large XML sitemaps isn’t easy. Thankfully, I’ve got your back with the power of JavaScript.
You can use the snippet below to instantly generate a pivot table showing a breakdown of a website’s path segments based on the URLs found in the XML sitemap.…
Hreflang Detector – the international SEO bookmarklet
SEO crawlers (and Ibuprofen) are extremely useful in helping you fix hreflang and other internationalization issues at scale. But sometimes, it’s practical to delve deep into the complexities of hreflang by manually pulling up a page in your browser and inspecting the code with your own eyes.…
How to manually extract Google Search Console data from a table with JavaScript
There are many ways to extract analytics data from Google Search Console (GSC).
While I mostly like to extract data in bulk using the native BigQuery connector, Looker Studio or the GSC API, there are times when the GSC dashboard is good enough.…
How to use Google Search Console’s Bulk Data Export for BigQuery
If you’re a heavy user of Google Search Console (GSC) for SEO , you’ll find the native bulk data export for BigQuery to be a game-changer.…
Are JSON requests wasting your website’s crawl budget?
I’ve recently come across a couple of scenarios with a similar issue: Googlebot was spending a significant portion of its crawl budget on discovering and crawling JSON requests.…
The canonicalized homepage with a 308 redirect
I recently came across Koala’s website, an Australian furniture manufacturer and retailer. Being the curious individual I am, I opened up some of my go-to Chrome extensions to scope out the technical SEO setup for the site.…
Bulk internal linking with Screaming Frog and Google Sheets
I recently came across an excellent post by Ryan Darani from a while back on LinkedIn that shows how to find internal link opportunities using Screaming Frog’s custom extraction feature and Excel formulas.…
Google Sheets Template: Bulk generate query list with RegEx for Google Search Console
Google Search Console allows you to apply advanced regex filters in many ways. One type of Regular Expression that I return to regularly is bulk matching queries with a list of keywords.…
Let’s talk about the ‘Crawled – currently not indexed’ status
The ‘Crawled – not yet indexed’ status is one of the most important and often seen in Google Search Console (GSC) accounts.…