First, indicate which source you'd like to use and the country your are interested in.
* If you choose Semrush, the extraction will cost you 10 credits per keyword.
* Not all countries are available in their APIs, therefore be sure to indicate one that is .
Then, load your CSV (UTF-8, with headers, commas-separated) file including your queries and indicate in which column they are.
In this example, I loaded the typical CSV exported from GSC.
Click on "Save your data".
It will allow the application to reuse your data during the STEP 2.
Launch the extraction.
It can take a while based on the number of keywords you have, but we are talking about <10s for 1.000 keywords. So pretty fast!
Download the file and enjoy your data.
Please note that the data are as good as the API you choose. They both have flaws and be aware of them when you analyze your file.
If you have any questions or issue, let me know here or via Github.
Be sure to follow me if these apps are useful: I'll be sharing other ones during the upcoming weeks.
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.