SEO API Starter Template

By David Krevitt from CIFL

SEO data aggregation from Ahrefs, Google Search Console, Majestic, Moz and SEMrush APIs has never been simpler.

Power up your agency’s data analysis process, one tab at a time.

This template comes pre-configured with API calls for 4 services:

1. Google Search Console
2. Majestic
3. Moz
4. SEMrush (both Keywords and Domain History)

If you’d ever like to add new APIs, log them in the ‘Data Sources’ tab.

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!

Current Version: 1

Not sure where to start your keyword research?

How it works?

The traditional way to use data from these services is through their dashboard (here’s Google Search Console for example):

It’s got some pretty pictures there, but if we’re looking to do real analysis we’ll want to access the raw data.

Then we can look at trends for specific target keywords + pages, and mash up that raw data with data from other services (like Google Analytics traffic + conversions, or Majestic backlinks).

If we want raw data from a tool like Majestic, there are only two ways to get it: the Slow Way and the Fast Way.

The Slow Way means pulling data manually from the tool’s dashboard via CSV exports.

The Fast Way means pulling data via the tool’s API (Application Programming Interfaces) into some form of database (whether that’s Google Sheets or a ‘real’ SQL-style database like Google BigQuery).

If you’re ready to dive right into SEO APIs, grab this Sheets template. It comes pre-loaded with API connectors and BigQuery configuration for APIs like Google Search Console, Majestic, Moz and SEMrush.

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.