You can use Supermetrics custom fields together with the data blending feature to create flexible custom fields across multiple data sources, and then match them with each other using data blending. Learn more about data blending and how to create and manage blends.
To use custom fields together with data blending, first make sure that you have custom fields for the data sources you want to blend, and then configure the actual blend that will use the new custom field. This guide will walk you through each step to get your data blend set up.
Third-party custom fields
You can also use third-party custom fields in data blending. If you have, for example, created a custom conversion event in Google Analytics 4, you can use that custom field in your data blend in Supermetrics. See the list below for the availability of third-party custom fields.
- Adjust
- Adobe Analytics
- Adobe Analytics 2.0'
- AppsFlyer
- Facebook Ads
- Google Ad Manager
- Google Analytics 4
- Google Search Ads 360
- Hubspot
- Klaviyo
- Mailchimp
- Optimizely
- Pardot
- Piano Analytics (AT Internet)
- Salesforce
Use cases for custom fields and data blending
Take a look at this list of example problems that can be solved by using custom fields and data blending in tandem.
Problem:
I can measure ROI on Google Ads and Facebook Ads separately but don't have an easy way to see the ROI from all my ad spend together.
Solution using custom fields with data blending:
I can define an ROI custom field for each platform and blend them together, allowing me to see a unified view of ROI across all advertising channels.
Problem:
I track different kinds of engagement metrics across platforms—clicks on one, likes and shares on another. I want a unified way to measure engagement.
Solution using custom fields with data blending:
I can create a custom field that calculates a unified engagement score on each platform. Blending these custom fields allows me to see an aggregated engagement score for all my campaigns.
Problem:
I want to identify and tag high-value customers but each platform has its own set of metrics and data. I wish I could see this information unified across all platforms.
Solution using custom fields with data blending:
I can create a custom field that tags users as "High-Value" based on my criteria in each platform, then blend these fields to get an overarching view of high-value customers across platforms.
Problem:
My marketing campaigns don't align with standard calendar months. I want to analyze performance based on the specific dates that the campaigns ran.
Solution using custom fields with data blending:
I can use custom fields to mark the specific periods of each campaign in individual platforms. By blending these custom fields, I can easily analyze performance based on my custom time periods across multiple platforms.
Problem:
I have global campaigns running, and dealing with revenue in multiple currencies is a hassle. I want to see all my revenue data in a single currency for easier analysis.
Solution using custom fields with data blending:
I can use custom fields to convert the revenue data into a common currency within each platform. Blending these custom fields provides me with revenue data unified in a single currency.
Instructions
Step 1: Create new custom field
- On the the Supermetrics Hub, go to Transform → Custom fields.
- Click New custom field.
- Select the field type, data source, and type of transformation to apply to the custom field. You can use functions, lookups, and conditions in custom fields.
- Give your custom field a descriptive name.
- Click Create custom field.
You can see your custom field in the list of available custom fields.
Step 2: Create new data blend
- On the Supermetrics Hub, go to Transform → Data blending.
- Click Create new blend.
- Select the union or join type of blend and click Next step.
- Select the data source you created the custom field for.
- Select the accounts to use in the blend.
- Select the other data source and accounts you want to blend the data with.
- Click Add fields to select the fields to use in the blend for the data sources. Include your new custom field.
If you want to blend the custom field with fields from other data sources, add the field to blend with, and give the blended field a descriptive name. Click the pencil icon to change the display name of the field. - After selecting all fields to be included, click Next step.
- For a join blend: Select the join key for your blend and join type, and click Next step.
- Give your blend a name and an optional description.
- Click Create blend.
Step 3: Add a custom field to an existing blend
To add a custom field or replace a field with a custom field:
- On the Supermetrics Hub, go to Transform → Data blending.
- Select a blend to modify.
- If you want to remove a field, click the trashcan icon next to the field name.
- To add your custom field, click Add fields and start typing the name of your custom field, and select it when it appears. You can find all custom fields under the Custom fields heading.
- Click Add fields.
- Click Next step, and Save changes.
Your data blend with your custom field is now ready to use! Next, find your data blend in your destination and use it in your reporting.