See also

Tags

solution ecommerce marketing sales
18 Jun 2024 03:25 PM

Display Net Sales on a Dashboard by Subtracting Ad Spend from Total Sales

Begin by creating a workflow
Set up a new Workflow and name it 'Sales after Ad Spend'

clipboard-2024-06-18-15-22-22-930Z.png

Aggregate Ad Spend across Ad Networks

Start with summing up the Ad Spend from all advertising networks. For the first network, Facebook, use the "Pull Data" building block.

In this block, specify the integration name, select the business accounts (option to select all), and rename the building block to 'raw_facebook.'
clipboard-2024-06-18-15-22-27-218Z.png

Focus on Ad Spend Only

Since we are interested only in the total ad spend, add the "Create Report" building block and rename it to "total_facebook."
clipboard-2024-06-18-15-22-31-478Z.png

To remove all dimensions, open the breakdown list and click "Clear all," leaving the dimensions list empty.