Open navigation

How to blend data from multiple accounts in Looker Studio

In Looker Studio, you can use the native data blending functionality with Supermetrics data sources to combine data from multiple data source accounts. 


Because data blending is a native feature in Looker Studio, Supermetrics can't help with troubleshooting if there are issues.

In this example, we're looking to combine data from the "ABC" and "DEF" data source accounts in TikTok using the TikTok Organic data source connector.


Step 1: Create data sources for accounts

  1. In Looker Studio, create a data source for each account you want to connect. This means adding the same data source to Looker Studio multiple times and selecting a different data source account for each.
  2. After you've created the data sources, rename them to tell them apart. For example, the TikTok Organic - ABC data source uses data from the ABC account, and the TikTok Organic - DEF data source uses data from the DEF account.
    To change the name of the data source, click the pencil icon to edit the data source, click the data source name, and type in a new name.
  3. If your data source uses query types, we recommend that you include the query type name in the data source name, such as TikTok Organic - ABC - Profile overview to easily tell which data source is which. If you need to use multiple query types with the same data source, you need to create multiple data sources to pull data. See our support article about working with query types in Looker Studio.

Step 2: Create blend

Below is an example of how to create a data blend in Looker Studio.

  1. Go to ResourceManage blends or click the data source name in the sidebar. 
  2. Click Add a blend.
  3. Select the data sources you just created.
  4. Name your tables in a way that makes it easy to find the tables in the blend details.
  5. Select the dimensions and metrics to include in the blend.
  6. Click Configure join between the tables. For the join operator, select one that suits your use case. See Google's instructions about how blends and join operators work.
  7. In the Data source name, give your blend a name. If you want to hide the blend details, check the Hide repeated join fields checkbox.
  8. Click Save, and close the Blend data pane. Your blend is added to the list of data sources.

Did you find it helpful? Yes No

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