What is Data Blending?

Data from different sources that share a common dimension, can be blended together into a widget of a Clarisights report. 

For example:
Say there are two data sources - Google Ads and Facebook Ads and both have a common dimension Country .
Data from Google Ads

1 - The rows corresponding to United States  from Google Ads

Data from Facebook ads

2 - The rows corresponding to United States  from Facebook Ads
3 - The rows corresponding to Australia   from Facebook Ads

Data after blending (Country broken down by Ad Channels)

Explanation of the images above according to the 1 to 4 is as follows:

1 and 2 - The rows corresponding to United States  from Google Ads and Facebook Ads are blended together as seen in the image 3.

3 - As the row corresponding to Australia  is only available Facebook, hence in the blended data also contains the data of Facebook ads only.

4 - The aggregate of blended data across both the data source - Google Ads and Facebook Ads.

Few more details of the images above:

  • Ad Spend  is a custom metric which is equal to sum of spends from Google Ads and Facebook Ads.

  • Ad Revenue  is custom metric equal total revenue generated from the ads served.

  • Ad RoAS   is the metric for Return on Ad Spend i.e. Ad Revenue  / Ad Spend  . 

Advantages of Data Blending:

  1. Any data sources can be blended together on the common dimensions they share with each other. 

  2. Both custom dimensions and standard dimensions can be used for blending. 

  3. There is no limitation on the number of data sources that can be blended in a widget or report.

To successfully blend data in Clarisights, you need to create common custom dimensions in different data sources. Here's a help article on how to create custom dimensions.

Did this answer your question?