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.

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.

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.