Workflows – creating a weekly Ad Spend report

Imagine you want to create a weekly report for tracking ad spend for different ad networks, listing them as rows

1. Add a "Pull Data" block, selecting Facebook Ads as the data source and connect it with the Add Column block. Then, apply breakdown by Ad Network and the Spend (Cost) metric and the value as 'Facebook Ad Spend'. The result should look like this
   

2. Then, repeat the same steps for Google Ads
   

3. Now, integrate a "Union" block, specifying FB and Google as dataset #1 and dataset #2, respectively
   

We're almost set. Let's run the workflow and view the output

Updated on: 15/03/2024