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 is easy in the Supermetrics Hub:
- Click Create new blend.
- Select the data sources you want to blend.
- Configure accounts and connections.
- Review and name your new blend.
- 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.
- Select the Data Blending connector.
- Select the blend you want to use in your report.
- Start building your reports!
If data blending isn't yet included in your license, please reach out to our sales team.