logo-small
Features Prices
News 0
Latest News See All

Temporarily unavailable. Please come back later.

See All
Webinars 0
Upcoming Webinars See All
Upcoming Webinars

Sorry, we could not find any upcoming webinars.

See recorded webinars
Blog 0
Recent Posts See All

Temporarily unavailable. Please come back later.

See All
Eric Van Buskirk

New Tool Provides Advanced, Bulk Search of SEMrush Data

Eric Van Buskirk

As a former Senior Account Manager for SEMrush, I worked with dozens of people to integrate API. Individuals and companies that offer free tools bring new creative ways to access SEMrush data and are a critical part of growing the user community.

What’s been missing — and what I’m now providing for free — is a tool that does bulk query via form: drop in your bulk search terms and API, and GO!

The main benefit I find with form-based API for SEMrush is the API calls to the server are separated one at a time. The SEMrush API service is not built for hitting the server with 20 API requests at one time, and that can sometimes cause issues with the Google doc implementations.

It took me over a year to fully appreciate the importance of bulk queries for research with tools accessing publicly available data like SEMrush. In the end this is actually “multivariate analysis.”

If you’re not a data person, that term may sound as scary as a Wandering Brazilian Spider (in my mind, any creature that just wanders around is scary as hell, as I assume it can kill/poison anything it bumps into and is as fearless as a lion!). Some of the most complex statistics work is multivariate, but for working with SEMrush data, all we’re doing is looking for correlations and ideas based on comparing many variables to each other: not rocket science.

We are so used to imputing one term or variable in search engines and finding what’s related to it and it alone, we forget that it is far more effective to find many similar keywords, domains and URLs, and look at them side by side for actionable SEO, PPC and content strategy. If you decided to buy a stick-shift car, would you just look at reviews for one auto maker and model? If you know 10 car models you like, why not look at data on all 10 side by side and see what appears as the biggest advantages and disadvantages?

Drive Faster: Compare Keywords and URLs from Bulk Search

You can look for pages (URLs) that rank high for a term you want to win one at a time. Why not look at 30 of the best ranking pages with the tool I’ve launched? I found the top 10 ranking pages in a bulk search from results with a bulk search for the following keywords (don’t go all the way to 20).

  1. Samsung GalaxyS5
  2. Samsung S5
  3. Galaxy S5

If I ran a website that could actually rank on one of these three terms, like cnet.com, I would get the most precise data for judging ranking chances via the authority of the pages and domains ranking. I’d look at links to the pages I can compete with and get linking ideas from them.

If I want less competitive terms, I use the S5 phone as the main entity so I can look for everything related that may be more long tail or less competitive.

In either instance, I’d then look for other, co-occurring words which also rank for the URLs by putting the same pages mentioned above in a bulk search by URL. You’ll get a huge list of “related keywords” tailored exactly and precisely to your core idea/entity. The list will not be like the “related keyword” report in SEMrush. That report is OK for eyeballing, but generally it’s returning terms that have little to nothing to do with your main phrase. And, it doesn’t sort by how many times these words appear on webpages about your theme (that is, it doesn’t “score.”)

To create the below Google Network Graph of associations, I found about 20 unique top ranking pages from the bulk keyword search. Then I looked to see which other keywords ranked on Google SERP for those URLs. The yellow bubbles contain the number of times on our different pages the keywords co-appear. The blue bubbles contain keywords Google also ranked from the original winning URLs. I’ve filtered the graph so only the highest co-occurrences are visible. To view this properly, please be sure to change the number in the node box on the upper left to the total nodes, 455.

Connected to the #9 bubble, for example, is “the new Samsung galaxy s5,” showing that it is one of the most common related topics about the phone and giving you the common way it’s phrased. Now you know its strength of association to a Samsung Galaxy S5 in a ranked manner.

Of course, some keywords that come up are obvious. But the words that aren’t just iterations of the phone name show you other topics and what you might want to include in your post to be semantically related. Or you would use them for keyword research about separate pages.

How to Use the Bulk Search Tools

The fields are self-explanatory, but there are also instructions on the page. You can choose how many lines of results to return for each keyword, URL or Domain entered, a feature not offered in the free Google spreadsheet docs to my knowledge.

So, in the above example, we would enter the three search terms and set the limit for number of results at 10 each. That way, we also save our API credits since positions 10-20 for ranking pages are not nearly as powerful for finding related phrases.

When the search is done, there’s a download button so the data can be opened in a desktop application for CSVs. (Most of us don’t do our spreadsheet work inside Google graphs.) Go here to access the tool.

Bulk Keyword Tool

Has this tool helped you? Do you have any questions? Please let us know in the comments.

Eric Van Buskirk is the publisher of Tweet Philadelphia, a blog about the intersection of social and SEO, and a former SEMrush Senior Account Manager. Feel free to reach out to Eric via Twitter.

Comments

2000 symbols remain
Noname
Hi Eric, great post!

I actually tried the tool but it doesn't seem to be working :-(
Do you happen to know other tools where I can use SEMrush API to bulk pull the data?

I am particularly interested in pulling the top 10 ranking URLs for a large number of keywords.

Any help is appreciated.
Mike Isaac
Hey Tony! Thanks for reaching out and I love to hear you liked the post! However, I'm sorry to hear that you are experiencing issues with the tool. If you can please send me an email with what exactly isn't working for you, I can assist you further. My email is michael.isaac@semrush.com.

As for pulling bulk data for the top 10 ranking URLs for keywords, this can be done through our API. However, you would need to do an individual API call for each keyword. You would want to use this API call: https://www.semrush.com/api-an...

Also, if you would prefer not to do it individually, we do offer custom reports that would provide you this data. If this is something you would be interested in hearing more about, please let me know in your email and I can provide you with that information.

Thanks Tony and I look forward to hearing from you!
Have a Suggestion?