Jose Luis Hernando

Tech SEO | Automation 🦾🔥 🚀 | Insatiable Traveller | Street Art Enthusiast | Adventure Starter | Positivity Generator

[Jose Luis Hernando @jlhernando]

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.

https://t.co/Af3dVzAYbZ

Login with your Google account, choose your property, paste the urls and get the results.

Enjoy!

[Jose Luis Hernando @jlhernando]

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.

https://t.co/w3s6Mvveep

#seo #automation

[Jose Luis Hernando @jlhernando]

@GastonRiera Gracias :) Estas cosas se salen fuera de la zona de control asi que mejor seguir para adelante y ya se vera

[Jose Luis Hernando @jlhernando]

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.

https://t.co/FFxvsGuad2

[Jose Luis Hernando @jlhernando]

@GastonRiera @googlesearchc @JohnMu @danielwaisberg Seems like it fixed itself and the data has been back filled. Trust in the system restored 😜

[Jose Luis Hernando @jlhernando]

@googlesearchc @JohnMu I'm seeing an issue with url_impression bulk export tables missing 2 days. However i got the data from 2 days ago... site_impression tables are fine. Nothing has changeed from our end. Any issue detected from GSC? Any chance this data will be backfilled?

[Jose Luis Hernando @jlhernando]

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!

https://t.co/Li6noZ8KDl

[Britney Muller @BritneyMuller]

"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).

[Jose Luis Hernando @jlhernando]

@Marc0dev Nice, sounds like a good automation! Did you open source it?

[Jose Luis Hernando @jlhernando]

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.
https://t.co/BuWpTe0v63

Toodles!

[Jose Luis Hernando @jlhernando]

@MontseCano Gracias Montse!

[Jose Luis Hernando @jlhernando]

@antoineripret next in the pipeline is Dataform (now in easy mode😬)

[Jose Luis Hernando @jlhernando]

If you ever wanted to get into SEO automation this is the time. Go wild!

My new stack for SEO Automation: Claude Code + Apps Script https://t.co/ZDI6UBTpg3

[Jose Luis Hernando @jlhernando]

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!
https://t.co/hYn6GZqCMg

[Jose Luis Hernando @jlhernando]

@estevecastells Careful you might be reported to AIHR

[Jose Luis Hernando @jlhernando]

Hola SEOs!

Anyone else seeing 22nd of Apr as the latest available date in Bulk Export?

@estevecastells @antoineripret @JohnMu @danielwaisberg @rustybrick

#seo #searchconsole

[Jose Luis Hernando @jlhernando]

@estevecastells Esa es la manera de empezar un proyecto nuevo si señor!

[Jose Luis Hernando @jlhernando]

@stonetatara New version shipped 🚀 Wanted to make some improvements to the login process since I was already touching the code. LMK if you run into any issues again.

[Jose Luis Hernando @jlhernando]

@stonetatara Found the bug. I've made a few fixes in the code. I'll push it tomorrow.

The script will allow you to get more than 1000 URLs if you create multiple GSC properties/paths for the same domain.

This has given me some ideas for future scripts so thank you.

[Jose Luis Hernando @jlhernando]

@stonetatara Hi! Yeah I hope I can take a look over the weekend and see if we can nail the issue