Workflows – using the Join by Key block

The “Join by Key” block serves as the bridge between two datasets. Conduit processes each row in the primary dataset, seeking matches in the secondary dataset based on a specified key. Rows from the secondary dataset that don't find a match in the primary dataset are excluded from the final output.

This feature could be useful, when you trying to merge related data from different sources, such as Ad networks

Here's a practical example:

1. Start a Workflow by pulling data from Facebook Ads and Google Analytics accounts

2. Add the Join by Key block into your Workflow.

3. Set up the block by choosing the primary and secondary datasets. In our case, let's enrich our advertising data with insights from the analytics system.

4. Select "Demo Facebook" as the Primary dataset.

5. Choose "Demo Google Analytics" as the Secondary dataset.

Now, configure the key matching process. In our example, we aim to find values from Demo Google Analytics and incorporate them into rows of the primary dataset where Date and Ad Campaign values align.

Applying pro-data distribution for metrics

The Join by Key block in Conduit comes with an additional configuration - the "Apply pro-rata distribution for metrics" setting. This feature addresses scenarios where one row from a dataset corresponds to multiple rows in another dataset, potentially leading to an increase in metric values due to duplicated rows.

Here is an example:

Facebook Data

Google Analytics

As a result of joining, we should receive a dataset with three rows

As you can see, we encountered a duplication issue on January 1st, causing the total Clicks to increase from 26 to 37.
By activating this setting, we would achieve a different outcome.