Antoine Eripret Profile picture
SEO Lead @liligo - 🇫🇷 living in 🇪🇸 since 2016

Jan 21, 2022, 8 tweets

💥 Extract Search Volume in Bulk 💥

I've created a simple application to extract search volume easily, using Keyword Surfer (free) or Semrush (paid).

share.streamlit.io/antoineeripret… (built with @streamlit)

I'll explain how it works in this thread.

cc @DataChaz

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.

And if you are looking for an indexation checker, have a look at share.streamlit.io/antoineeripret… that I shared last week.

I explained (in spanish) how it works here:

Share this Scrolly Tale with your friends.

A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.

Keep scrolling