If you're running paid campaigns and want to measure Return on Ad Spend (ROAS), you’ll need to pull in both ad revenue and ad spend—which often come from different platforms.
In this example, the Revenue is stored in HubSpot CRM and the Dd Cost comes from Google Ads. Using Metric Builder and Data Calculations, you can combine these two to calculate ROAS directly in Databox.
Create a Custom Metric to pull ad revenue from HubSpot CRM
Open the Metric Builder page and select HubSpot CRM as the Data Source.
Set the Metric to Amount.
Set the Date field to Date Entered "Closed Won".
Add a Filter for:
Original traffic source = PAID_SEARCH
Save the metric.
Find the Cost metric from Google Ads
You can either use a pre-built metric for Cost or create a custom one if you need specific filtering.
To create a custom metric:
Open the Metric Builder page and select Google Ads as the Data Source.
Set the Resource to Ad.
Set the Metric to Cost.
Optionally, add any filters based on a specific campaign, ad group, etc.
Calculate ROAS using Data Calculations
Once both metrics are set up, navigate to the Data Calculations page and create a new calculated metric.
Divide the Ad Revenue metric from HubSpot CRM with the Cost metric from Google Ads.
This will return your ROAS (Return on Ad Spend) as a single metric, showing how much revenue you're earning for each dollar spent on ads.
Also, check out: How to combine data from multiple HubSpot accounts.