See also

Tags

template
26 Jul 2024 10:42 PM

Ad Networks ROAS (Dashboard)

This template generates a dashboard that displays expenses from two advertising platforms and income from Shopify.

It also calculates the ROAS for both campaigns and platforms.
clipboard-2024-07-26-22-24-01-051Z.png

How to Use the Template

  1. Connect Your Accounts: Link your Google Ads, Facebook, and Shopify accounts.
  2. Set Up the Data Source: The dashboard relies on the Ad network ROAS workflow as a data source. Begin by creating this workflow that calculates ROAS.
  3. Create the Dashboard: Once the workflow is in place, you can proceed to create the dashboard.
  4. Link Widgets to Data Sources: Open the properties of each widget and select the appropriate data sources to link them.

clipboard-2024-07-26-22-37-42-623Z.png

  1. Widget "Facebook Spend" requires a data source from Facebook Ads.
  2. Widget "Google Ads Spend" requires a data source from Google Ads.
  3. Widget "Shopify Gross Sales" requires a data source from Shopify Orders.
  4. Widget "Ad networks ROAS" requires a data source from the "Ad networks ROAS" workflow, select the "roas_by_platfrom" dataset.
  5. Widget "Ad campaigns ROAS" requires a data source from the "Ad networks ROAS" workflow, select the "roas_by_campaign" dataset.
Create Dashboard