Semrush Analytics report building guide

Prev Next

Use the Semrush Analytics connector to report your keyword visibility, CPC, and search volume. Pull data to any destination and create historical reports to see how your search volumes have developed over time and how your CPC has changed with that.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Query types

To get the data you need, select the correct query type. Semrush Analytics supports 5 main types of queries — Domain, Keyword, URLs, Display Ads, and Backlinks — for a total of 35 different query types. You may need to browse through the options to find which has the metrics and dimensions you need. Our connector uses the same structure and names as the Semrush Analytics API reports, so you can use their API documentation to explore the full range.

Note

Some of the data provided by Semrush Analytics doesn’t have any historical data available.

Semrush Analytics has a unique way of handling date settings. See How to use the Semrush Analytics display date setting in Supermetrics.

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 used, 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.

Note

If you need to use multiple query types in your Looker Studio report, you will need to create separate connectors for each query type. Learn more about query types in Looker Studio.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Track organic traffic over time

See how organic traffic to your domain has evolved month by month — useful for identifying long-term trends in search visibility and measuring the impact of SEO activity over time.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Domain overview history

Domain

Enter the domain to analyze

Metrics

Organic traffic

Dimensions

Year & month

Suggested visualization

Table

Understanding the data

  • Organic traffic: The estimated traffic brought to a website via Google's top 20 organic search results.

  • Year & month: Splits results by month so you can track organic traffic trends over time.

Analyze keyword search volume and CPC

See the organic keywords your domain ranks for alongside their average monthly search volume and cost per click — useful for identifying high-value keywords and informing both SEO and paid search strategy.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Domain organic search keywords

Domain

Enter the domain to analyze

Metrics

CPC, Search volume

Dimensions

Keyword, Position

Suggested visualization

Table

Understanding the data

  • CPC: The average price in US dollars advertisers pay for a user's click on an ad containing the keyword in Google Ads.

  • Search volume: The average number of times users searched for a given keyword per month, calculated over the last 12 months.

  • Keyword: The organic search keyword the domain ranks for.

  • Position: The domain's ranking position for the keyword in Google search results.

Check domain authority score

See the authority score of your domain or URL — useful for benchmarking your domain's overall SEO strength and comparing it against competitors.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Backlinks overview

Target

Enter the domain or URL to analyze

Metrics

Authority score

Dimensions

Requested object

Suggested visualization

Table or bar chart

Understanding the data

  • Authority score: A measure of the overall quality and SEO influence of a domain or URL, based on the number of backlinks, referring domains, organic search traffic, and other data.

  • Requested object: The domain or URL that was analyzed, used to compare authority scores across multiple targets.

Troubleshooting

If you come across an error stating that your API units balance is zero, your Semrush account has run out of API units and can’t make further queries until more units are added. You can purchase additional units on the Semrush website — note that it may take some time for the units to update in your account after purchase.

More resources

See the Supermetrics blog for tips on competitor benchmarking.

You might also be interested in: