Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Antoine Eripret Profile picture
@antoineripret
Jun 30, 2020 • 8 tweets • 3 min read • Read on X
Scrolly
¿Cómo hacer un mini keyword research usando los datos de la competencia?

Hoy te muestro cómo usar los autosuggest de los E-commerce más grandes de España para realizar tu estudio.

Ejemplo de funcionamiento con el GIF

⬇️⬇️
La idea viene de @natzir9 () que compartió lo que había echo durante el evento de #vamostalegon.

Lo he extendido agregando los principales E-commerce de España.

¿Cómo se obtienen los datos?
1. En general cuando hay un autosuggest, la web se nutre de datos enviados por una API que puedes consultar mediante una URL.

Casi siempre, el formato es JSON. Si sabes buscar, encontrarlo no es muy complicado. Image
2. Usando nodatanobusiness.com/importjson/, podemos usar una nueva fórmula, IMPORTJSON, para obtener estos datos en Sheets sin complicarnos la vida.
3. Detectando el pátron para cada web, podemos recuperar sus datos usando una palabra clave de entrada. Quitamos los duplicados entre las webs y obtenemos nuestro mini keyword-research con el volúmen usando la API de Keyword Surfer Image
Si buscáis un nuevo nicho, usar esta técnica como punto de partido es útil y permite ahorrar tiempo.

También os digo que algunos E-commerce tienen un cantidad de datos (como conversión por palabra de búsqueda) que podéis consultar sin problema que me flipa.
No tengo el archivo 100% acabado, así que no lo puedo compartir aún pero si os interesa, lo haré en algunos días con instrucciones de uso detalladas.
Update: hoja disponible para todas/os:

• • •

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

Antoine Eripret Profile picture
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
Antoine Eripret Profile picture
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
Antoine Eripret Profile picture
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
Antoine Eripret Profile picture
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
Antoine Eripret Profile picture
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
Antoine Eripret Profile picture
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!

Send Email!

:(