Antoine Eripret Profile picture
Dec 1, 2021 9 tweets 4 min read Read on X
💥Redirecciones entre archive.org y tu sitemap💥

He creado un Google Colab para que puedas acelerar la definición de redirecciones entre urls en archive.org y tu sitemap.

Es GRATIS y lo único que necesitas es una cuenta de Google.
Esta tarea suele ser necesaria en caso de una migración mal hecha. En este caso, tienes que implementar redirecciones entre el histórico (archive.org) y el actual (tu sitemap).

Otras fuentes pueden existir (GA, GSC, …) y las podría agregar si te pueden servir.
Ahora, esta tarea es un coñazo y muchas veces hay una similitud entre la estructura de las URLs del histórico y actuales.

Por lo tanto, podemos intentar acelerar esta tarea con una simple automatización.
Etapa 1: Accede a colab.research.google.com/drive/1LvUbdff… y haz un copia del documento
Etapa 2: rellena las variables

1. Tu dominio
2. La URL de tu sitemap (o sitemap index)
3. La similitud mínima que deseas para que dos URLs se consideren equivalentes

He puesto valores de ejemplo con un proyecto que conozco un poco para que puedas ver resultados.
La similitud (entre 0 y 100) usa el algoritmo TF-IDF. Suelo usar un valor entre 40 y 60 para tener resultados decentes, pero realmente depende del proyecto.

Si te interesa tener más detalles sobre el algoritmo, puedes mirar maartengr.github.io/PolyFuzz/tutor….
Etapa 3: Ejecuta el código usando el menú: Runtime > Run all

Como siempre, he agregado comentarios (en inglés) para que se entienda el código y la lógica.
Etapa 4: Analiza los resultados

Ten en cuenta que:

* Muchas URLs no aparecerán. Es normal porque hay mucha basura en archive.org y no siempre hay un equivalente decente en tu sitemap
* No se comprueban los códigos de estado actuales en ningún momento
Si lo deseas, puedes descargar la tabla completa.

Te aconsejo que hagas una revisión manual: la idea es ahorrar tiempo, no que el sistema te haga todo solo y que no tengas que comprobar nada 😅

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Antoine Eripret

Antoine Eripret Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @antoineripret

Apr 13, 2023
🤓 Google Sheets formulas every SEO should know 🤓

Let's go through the most common formulas you need to master to work quicker.

Most of them can also be used in Excel, but not all of them.
1. VLOOKUP

THE formula you have to master because it allows you to merge data from different tables. Very useful to combine Search Console and Analytics data, for instance.

You have to master it. Image
2. FILTER

I've explained everything about this formula in a separate thread:
Read 15 tweets
Apr 12, 2023
🛑 SEO tip: Never assume search intent 🛑

These three queries have the same search intent but, for some reason, Google thinks that "python playground" is different. Bing as well.

Should have I done it manually, I'd have created one URL to target these queries. Image
Funny to see how a website is ranking on both (supposed) intents, with two versions of the same functionality.

While others are just present on a part of the demand.

Be smart and look at SERP data before taking decisions! Image
PS: Screenshots from @keywordinsights
Read 4 tweets
Apr 11, 2023
🛣️ How to create an efficient SEO roadmap 🛣️

SEO theory is relatively easy, but pushing changes into production is harder. How many ideas have you got? How many will be live?

Let me explain how I manage to define & plan an SEO roadmap with other teams! Image
Foremost, it's important to keep track of all the ideas you have. A simple to-do list is enough.

A sort of brain dump to ensure that even if you can't implement them now, you never forget an idea that occurred to you. Image
When comes the planning phase (frequency depends on how the organization operates), take these ideas and:

* Create a brief summary (2-3 sentences)
* Assign an SEO priority
* Ask IT to assign a complexity

Based on these two criteria, you can define a prioritization. Image
Read 13 tweets
Apr 4, 2023
🚦 Find cannibalization at scale using GSC 🚦

Keyword cannibalization means that you have more than one content ranking. It's often a situation you want to avoid.

Easy to spot when you check a couple of URLs, but how to handle thousands of URLs?

Let me explain! Image
When you intend to spot a cannibalization, you can use an external tool such as @semrush.

Head to the Keyword Gap tool and introduce the two URLs you wish to compare.

Great if you don't have access to GSC data, for instance. Image
If you have access to GSC, you can achieve the same using first-party data.

* Filter on a specific query (you can also use a REGEX)
* Go to the "Pages" tab

You can see quickly see which URLs are ranking for this query. Easy, right? Image
Read 11 tweets
Mar 9, 2023
🕵️ How can you spy on a competitor's content strategy? 🕵️

Your strategy must never be a simple pale copy of what others are doing, but it's always a good idea to know what they are up to.

Let me show you, with a real example, how you can generate insights quickly. Image
Let's assume we're working in the travel industry and one of our competitors is Skyscanner.

We want to understand what they are doing on their blog and generate some insights based on the data we have at our disposal. Image
First step: get an exhaustive list of their URLs

This could be done through a crawl, but I'd rather get the list from a sitemap. Not always doable, but in this case, it was easy to find what I was looking for. Image
Read 11 tweets
Feb 7, 2023
🚨 New article: content rehydration and SEO 🚨

JavaScript SEO is not going away, and is often challenging.

If you want to know what is content hydration and how it can cause huge traffic drop, check my article or read the thread below

aeripret.com/content-rehydr… Image
Content rehydration is a process that occurs when a website, built with a JavaScript framework, such as Angular or React, dynamically updates the content on a page without requiring a full-page refresh.

Why using rehydration instead of relying only on SSR? It is faster!
What is the issue with content rehydration?

It will add a script to the raw response sent by your server with all the required code to make the application dynamic. Out-of-the-box, this script can easily represent more than 90% of the total HTML size. Image
Read 7 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(