Once you’ve authenticated your connection to Semrush Analytics and Semrush Projects, you’re ready to create your first query.
This guide will walk you through Semrush Analytics and Semrush Projects query setup for Google Sheets, Looker Studio (formerly Data Studio), and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.
Before you begin
To connect Supermetrics to Semrush Analytics and Semrush Projects, you need:
- An API account with Semrush and a Semrush subscription for API request units. Supermetrics does not include this. Learn more about Semrush accounts and API request units.
- Each API call has a cost, and the cost of requests is measured in API units. Units are determined by the type of report or request retrieved from the Semrush API, and fetching historical data requires more units than live data.
Here’s an example of sufficient user permissions:
Available fields
Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the Semrush Analytics. For Semrush Projects navigate to the sidebar on the ledt.
- Field label is the name that appears in the sidebar.
- Metrics can be found under type - “met”.
- Dimensions can be found under type - “dim” .
In Semrush, the "Domain Vs. Domain" query type requires that a specific formatting be used in the Domains. If this isn't use, queries won't return data.
Format your Domain queries like this, with each additional domain you want to compare separated by a | character:
<sign>|<type>|<domain>
You can use the these values for the <sign> parameter:
- + : Returns every keyword that the entered domains are ranking for in Google's top 100.
- - : Returns keywords that are unique to the first domain listed. You can view the keywords that the first domain ranks for, but the second does not rank for
- * : Returns keywords that are unique to each domain, not shared by any of the other domains listed.
You can use these values for the <type> parameter:
- or : For organic keywords
- ad: For paid keywords
The <domain> parameter will be the base domain for the site you want to compare, like supermetrics.com or ebay.com.
Here's an example that compares ebay.com to imdb.com, looking for the organic keywords that are unique to each of the two domains listed:
*|or|ebay.com|*|or|imdb.com
Please note that you can only compare up to 5 domains at a time.
Instructions
- Authenticate the data source in Google Sheets.
- Select Metrics.
- Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
- Click Get Data to Table to create your query and pull your data.
Advanced options for Google Sheets
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query.
- Replace blank metric values with zeros.
- Combine new results with old.
- Format results for Looker Studio (to import data from Google Sheets to Looker Studio).
- No header row.
- Highlight values with colours (green, red, etc.).
- Advanced settings.
- Authenticate the data source in Looker Studio.
- Under Dimension, select Dimensions.
- Under Metric, select Metrics.
- Select how to sort the data.
- Select the Date range from the auto or custom options. If you choose a custom date range, click the arrow on the top-right hand side. Under a specific period, select a Start Date and End Date.
Advanced options for Looker Studio
You can filter your data by selecting the field, condition, and value to filter by. Learn more about using filters.
- Authenticate the data source in Excel.
- Select Metrics.
- Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
- Click Get data to create your query and pull your data.
Advanced options for Excel
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query. Learn more about Supermetrics advanced settings in Excel.
Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up data warehouse and cloud storage products (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up Supermetrics API
Troubleshooting
API unit balance
If you encounter an error that says your API units balance is zero, your Semrush account has run out of API units. It won't be able to make more queries until more units are added to it. You can purchase more units on Semrush's site — you might have to wait some time after doing this for the units to update in your account.
Display date field issues
The "Display date" field requires specific conditions. Learn more about how to use it.
Incompatible fields and quotas
If you see an error about metrics and dimensions not fetching together, or fields being incompatible, follow these steps to fix the issue.
If you see errors relating to quotas, or “daily query quotas”, read this guide.