Workflows – using the Union block
Imagine you want to build an ad report, combining Google Ads and Facebook Ads. Here's where Conduit's Union block comes into play – a feature that helps to merge the data from the different data sources
How It Works:
Start by creating a Workflow, and pull data from Facebook and Google Ad accounts
Add the Union block to your Workflow.
Choose ‘Pull Data from Facebook Ads" as Dataset 1 and ‘Pull Data from Google Ads’ as Dataset 2.
Add additional datasets, if needed
As a result, you should receive a new dataset, which you can expand by clicking on the ‘View’ button
In the screenshot above, we can see that the Country column was in both Google and Facebook datasets, so it would have the data for each row in the sheet
And, vice versa, the Campaign column presents only in the Facebook datasheet, hence it has no contents in the rows, related to Google Ads. For the cases, when the datasets from the Union block have a column with a same name, the data in the output file merges into one single column
The column may change its type, if:
Both of the columns are metrics. In this case, their type would be switched to ‘Decimal’
If the types don’t match. The data type in this case would be switched to ‘String’
If the type of the data within columns matches, no type changes will be made.
How It Works:
Start by creating a Workflow, and pull data from Facebook and Google Ad accounts
Add the Union block to your Workflow.
Choose ‘Pull Data from Facebook Ads" as Dataset 1 and ‘Pull Data from Google Ads’ as Dataset 2.
Add additional datasets, if needed
As a result, you should receive a new dataset, which you can expand by clicking on the ‘View’ button
In the screenshot above, we can see that the Country column was in both Google and Facebook datasets, so it would have the data for each row in the sheet
And, vice versa, the Campaign column presents only in the Facebook datasheet, hence it has no contents in the rows, related to Google Ads. For the cases, when the datasets from the Union block have a column with a same name, the data in the output file merges into one single column
Data Type Changes
The column may change its type, if:
Both of the columns are metrics. In this case, their type would be switched to ‘Decimal’
If the types don’t match. The data type in this case would be switched to ‘String’
If the type of the data within columns matches, no type changes will be made.
Updated on: 15/03/2024
Thank you!