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.
On the Supermetrics Hub, you can select the data sources you want to blend, and use the blended data in your report. Learn more about the Hub.
If you're interested in the data blending feature, contact us.
The blends you've created can be used in all data destinations. See the instructions on how to use your blends in Google Sheets, Looker Studio, Excel, Power BI, and Query Manager (Supermetrics API), as well as data warehouse destinations.
Note that the data source must be available in the data destination you'd like to use the blend in. For example, if the data source included in the blend isn't available for Looker Studio, the blend you've created can't be used in Looker Studio.
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, configure 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 on the Supermetrics Hub:
- Click Create new blend.
- Select the data sources you want to blend.
- Configure accounts and connections to include.
- Select fields to include.
- Review and name your new blend.
Customizable 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.
If you want to edit the field mapping, select the blend to edit, and click the field you want to customize. If you want to add new fields to the blend, you can do so at the top of the page. When a field isn't applicable to a data source, that field is shown as dash - to skip the source.
Using blends in destinations
Once you've created your blends, they will be instantly available for use in the destination of your choice. See this support article for detailed instructions for each data destination.
- 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.
Learn more about data blending
We have a collection of support articles to help you get going with your data blends.