SEMrush to BigQuery Connector

No longer available to new RankTank Pro members

By David Krevitt from CIFL

To fully take advantage of your SEMrush API subscription, you’ll want to save your data – not lose it to the sands of time.

That means moving beyond the spreadsheet, and storing data in a database (like BigQuery).

Includes support for the SEMrush Free API Trial
(not required, adds extra metrics)

Subscribe to RankTank Pro!
Step 1:
Step 2:
Get the Pro Sheet SEO tool!
Subscribe and get access to this Google Sheet as well as many other Pro Sheet SEO tools!

No longer available to new RankTank Pro members from 31 December 2018

Current Version: 1

Not sure where to start your keyword research?

How it works?

This template comes pre-configured with our favorite 4 SEMrush API calls:

1. Domain Overview: Overall monthly traffic value and keyword count
2. Domain Keywords: List of keywords ranking 20 and above
3. Referring Domains: Top 100 referring domains to your site
4. Organic Competitors: Top 10 competing domains for your organic search keywords

The template also contains pre-configured BigQuery tables in which to store their results.

From BigQuery, you can analyze your heart out with SQL, or display your data in a Data Studio dashboard.

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.