Open navigation

About data blending

On the Supermetrics Hub, you can blend data from various data sources and use the blended data in your report. Learn more about the Hub.

Data blending makes it possible to join data from multiple Supermetrics data sources into one graph or table, without having to do manual data manipulation on the destination side, such as Looker Studio or Google Sheets.

If you're interested in the data blending feature, contact us.

In the first version of data blending, you can create blends between any of the following data sources: 

  • Facebook Ads
  • Google Ads 
  • Google Analytics
  • Google Analytics 4
  • Microsoft Advertising - Bing
  • Pinterest Ads 
  • LinkedIn Ads 
  • Twitter Ads 
  • TikTok Ads

The blends you've created can be used in Google Sheets, Looker Studio, Excel, and Query Manager (Supermetrics API).

Why use data blending

Combining data from different data sources can be tricky as field names vary between sources. For example, to measure total spend across all marketing channels for a specific campaign, in LinkedIn the field is called "Total spent" whereas Facebook names it "Cost". The differences in field names can make it difficult to merge data to create overview insights. 

With Supermetrics, you can create blends of your Supermetrics data sources, review blended fields in one view and use the blended data directly in your reports.

How does data blending work

Creating blends

Creating blends is easy in the Supermetrics Hub: 

  1. Click Create new blend.
  2. Select the data sources you want to blend.
  3. Configure accounts and connections.
  4. Review and name your new blend.
  5. Click Review field mapping.

Automated field mapping

The Supermetrics data blending feature maps data source fields automatically together and displays the mapping in a comprehensive manner, making it easy for you to get started and understand what's happening under the hood. When a field isn't applicable to a data source, that field is shown as "Not available". Editing or customizing field mapping isn't yet possible.

Using blends in destinations

Once you've created your blends, they will be instantly available for use in the destination of your choice. 

  1. Select the Data Blending connector.
  2. Select the blend you want to use in your report.
  3. Start building your reports!

If data blending isn't yet included in your license, please reach out to our sales team.

Did you find it helpful? Yes No

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