Been meaning to revisit a few of my old projects and this is the first (public) one I wanted to do so. Presenting. --> Google Index Checker 2.0 web app. jlhernando.com/blog/google-i… Login with your Google account, choose your property, paste the urls and get the results. Enjoy!

If you already live in Google Sheets, Apps Script is the natural next step into automation. Same tool, no setup. Custom formulas, scheduled reports, BigQuery queries. All inside the spreadsheet you and your team already use. This is the intro I wish I had when I got started. jlhernando.com/blog/intro-go… #seo #automation

Recently we had to migrate our GSC bulk data export to a completely different GCP project after Adevinta Spain was acquired by EQT Group. I couldn't find much info in the official docs about this specific scenario, so together with the data engineering team we worked out a process that kept every day of data intact and it's now running without issue in our infra. I've put together a guide with the full steps we followed in case anyone runs into the same thing. jlhernando.com/blog/gsc-bulk…

SEO Automation is more accesible than ever. If you know me, you know I have a clear favourite (despite its reputation in SEO...) JavaScript! I wrote about how easy and practical it is to get started. Browser, Nodejs or Apps Script. Choose you own adventure! jlhernando.com/blog/javascri…

"LLMs favor content that does X" is not a thing! LLMs don't favor anything. They're not information retrieval systems; they're next-token predictors. They guess the most statistically likely response based on patterns in training data. The search engine layer bolted on top via RAG? That's IR (Information Retrieval)!! The base LLM model? Not even close. During training, LLMs process text from across the web, but they don't log URLs, store sources, or remember where anything came from. What's left is a frozen statistical snapshot (Gao et al., 2023). Not an index. Not a database. Search engines do the crawling, indexing, and retrieval. LLMs lean on them heavily to surface real-time info (because on their own, they can't). Stop optimizing for 'AI.' Optimize for search engines (so retrieval-based AI can cite you) earn third-party coverage (so the model already knows you before the prompt is typed).

Made a chrome extension to grab all Index status data from your Google Search Console in one click, for all your properties. Couldn't do a big write up explaining (it was my birthday on Sunday 😅) but i've tried to put all the essentials there. jlhernando.com/blog/gsc-inde… Toodles!

I like Search Console’s Compare view. BUT I hate doing the maths in the UI. So I built a tiny Chrome extension that overlays absolute and % change directly on the scorecards. No more mental calculations or spreadsheets. Try it. Let me know! jlhernando.com/blog/search-c…

Hola SEOs! Anyone else seeing 22nd of Apr as the latest available date in Bulk Export? @estevecastells @antoineripret @JohnMu @danielwaisberg @rustybrick #seo #searchconsole

Simple & straightforward explanation of the 3 ways you can use to get GSC data (with examples) - 🔥 article by @antoineripret buff.ly/4dSPPHV

Hi SEO Twitter anyone else having issues extracting data from the GSC API data since 2024-05-09? @danielwaisberg @googlesearchc

I just published my first article on the Adevinta Tech Blog. If you are curious about how we are leveraging AI and you would like to get some ideas on how to prepare for the future of SEO then look no further. medium.com/adevinta-tech-blo…

¿Veis factible un script que funcione en Google Sheets para extraer las transcripciones de listas de URLs de Youtube? Eliminando marcas de tiempo y unificando el contenido, que quede algo como la segunda imagen? Alguie se anima? Tengo ideas perversas xD

Packed & ready for the #eusearchawards ✈️🎉😎

If you work with Node.js and Google apis you’ve probably at one time or another been frustrated at Node not being supported by one or more APIs. No longer. I give you sdkbuilder which will build out a node.js sdk of google apis. gist.github.com/sterlingsky/…

Following feedback from the community, today we're updating bulk data exports to allow multiple GSC properties to export to one Cloud project. To do so, you need to customize your dataset name when setting up your export to have a unique dataset name for each export.