When you set up a Semrush Analytics transfer to a data warehouse destination, you don't need a separate transfer for each domain you want data for. Several of the tables in a Semrush Analytics transfer take a list of domains in one field, so you can cover multiple domains from a single transfer.
This article covers the Domain field, which appears on tables such as Domain overview history. The Domain vs. domain table works differently, as explained in the section below.
Before you begin
You need:
A Semrush Analytics data source account connected in Supermetrics.
A destination already set up for your transfer, such as a BigQuery destination.
Instructions
On the Supermetrics Hub, go to Data transfers under Manage.
Click Create new transfer.
Under Data source, click Select data source, then select Semrush Analytics.
Under Destination, click Select destination, then choose the destination for this transfer.
Click Next.
On the Configuration step, select the accounts you want to include under Accounts.
Under Tables, select a table group. The Standard table group includes domain-based tables such as Domain overview history and Domain vs. domain.
Set your refresh window, and configure Schedule and Alerts as needed.
Under Options, find the domain-based table you want to configure, such as Domain overview history.
In the Domain field, enter your domains separated by commas, with no space after each comma. For example:
domain1.com,domain2.com,domain3.comRepeat step 9 for the Domain field on any other domain-based table you selected, such as Domain organic search keywords or Domain paid search keywords.
Continue through the remaining setup steps, then save the transfer.
All domains you list in a Domain field are included in that table's data on every scheduled refresh, so you only need one transfer to cover all of them.
Note on using the Domain vs. domain table
The domain entries for the Domain vs. domain query type's domain entries contain 3 parts in the format <sign>|<type>|<domain>:
<sign>+: All keywords: View every keyword that the entered domains are ranking for in Google’s top 100.-: Keywords Unique to the first domain: See the keywords that the first domain ranks for, but the second does not rank for.*: Common keywords: View all the keywords that both domains have rankings for in Google’s top 100 results./: Unique keywords: View the keywords that are unique to each domain, and not shared by any of the other sites in the comparison.
<type>or: Organic keywordsad: Paid keywords
You can include up to 5 domains in a single sub-query, separated by the | character. If you want to add more than one sub-query to a single setup, you can use the , character to set up another one. See the following example:
*|or|domain1.com|*|or|domain2.com|*|or|domain3.com|*|or|domain4.com|*|or|domain5.com,*|or|domain6.com|*|or|domain7.com|*|or|domain8.com|*|or|domain9.com|*|or|domain10.com
Note that using multiple sub-queries can lead to discrepancies if the Domain name fields aren't used due to row merging. Using sub-queries with this report type is primarily meant to stitch queries together so you don't have to set up multiple queries. If you use sub-queries, use the Domain name fields in the transfer to avoid row merging discrepancies. You can also achieve the same result by setting up a separate Domain vs. domain query for each group.