Articles on: Workflows

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

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

Was this article helpful?

Share your feedback


Thank you!