---
title: "How to add multiple domains to one Semrush Analytics data warehouse transfer"
slug: "how-to-add-multiple-domains-to-one-semrush-analytics-transfer"
description: "Learn how to send data for multiple domains in a single Semrush Analytics transfer, instead of creating a separate transfer for each domain."
updated: 2026-09-16T12:14:03Z
published: 2026-09-16T12:14:03Z
canonical: "docs.supermetrics.com/how-to-add-multiple-domains-to-one-semrush-analytics-transfer"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to add multiple domains to one Semrush Analytics data warehouse transfer

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](/docs/how-to-add-multiple-domains-to-one-semrush-analytics-transfer#note-on-the-domain-vs-domain-table).

## 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

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Data transfers** under **Manage**.
2. Click **Create new transfer**.
3. Under **Data source**, click **Select data source**, then select **Semrush Analytics**.
4. Under **Destination**, click **Select destination**, then choose the destination for this transfer.
5. Click **Next**.
6. On the Configuration step, select the accounts you want to include under **Accounts**.
7. Under **Tables**, select a table group. The Standard table group includes domain-based tables such as **Domain overview history** and **Domain vs. domain**.
8. Set your refresh window, and configure **Schedule** and **Alerts** as needed.
9. Under **Options**, find the domain-based table you want to configure, such as **Domain overview history**.
10. In the **Domain** field, enter your domains separated by commas, with no space after each comma. For example: `domain1.com,domain2.com,domain3.com`
11. Repeat 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**.
12. 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 keywords
  - `ad`: 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.

## More resources

- [Semrush Analytics connection guide](/v1/docs/semrush-analytics-connection-guide)
- [Semrush Analytics metrics and dimensions](/v1/docs/semrush-analytics-fields)
- [Semrush Analytics data warehouse table groups](/v1/docs/semrush-analytics-data-warehouse-table-groups)