Workflows – creating a weekly Ad Spend report
Last updated
Last updated
Imagine you want to create a weekly report for tracking ad spend for different ad networks, listing them as rows
Add a "Pull Data" block, selecting Facebook Ads as the data source and connect it with the Add Column block. Then, apply the breakdown by Ad Network and the Spend (Cost) metric and the value as 'Facebook Ad Spend'. The result should look like this
Then, repeat the same steps for Google Ads
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
| Ad Network | Spend |
|---|---|
Facebook Ad Spend
3529.0783
Google Ad Spend
2411.43
