Open navigation

Semrush Analytics and Semrush Projects: Query setup guide

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:

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” .



Special requirements for queries using the Domain query type

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

Google Sheets Looker Studio Excel Data Integrations
  1. Authenticate the data source in Google Sheets. 
  2. Select Metrics
  3. 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.
  4. Click Get Data to Table to create your query and pull your data.


Advanced options for Google Sheets

  1. You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
  2. 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.


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.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.