See also
Workflows
Workflows – using the Union block
Workflows – using the Transpose block
Workflows – adding new columns
Workflows – using the Join by Key block
Tags
solution
marketing
30 May 2024 09:55 PM
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