SEMrush to BigQuery Connector
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).
(not required, adds extra metrics)
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.