Workflows – using the Union block

close

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:

  1. Start by creating a Workflow, and pull data from Facebook and Google Ad accounts
  2. Add the Union block to your Workflow.
  3. Choose ‘Pull Data from Facebook Ads" as Dataset 1 and ‘Pull Data from Google Ads’ as Dataset 2.
  4. Add additional datasets, if needed

clipboard-2024-07-23-22-28-13-303Z.png

As a result, you should receive a new dataset, which you can expand by clicking on the ‘View’ button

clipboard-2024-07-23-22-28-29-642Z.png

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:

  1. Both of the columns are metrics. In this case, their type would be switched to ‘Decimal’
  2. 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.