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
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
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
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
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 |
Updated on: 15/03/2024
Thank you!