)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot tracks your conversions but not ad spend, while Google Ads shows costs but not CRM revenue. This makes calculating true campaign ROI impossible within either platform alone.
Here’s how to connect both data sources for comprehensive ROI analysis that updates automatically and shows you exactly which campaigns are profitable.
Calculate true campaign ROI using Coefficient
HubSpotCoefficientThe challenge is thatlacks native Google Ads cost integration, so you can’t see cost per closed deal or campaign ROI in your CRM reports.bridges this gap by connecting both platforms and enabling real-time ROI calculations in your spreadsheets.
You’ll get dynamic ROI dashboards, cost per closed deal metrics, and automated alerts when campaign performance drops below your targets.
How to make it work
Step 1. Connect both data sources.
HubSpotAdd Google Ads andconnections in Coefficient’s sidebar. Both connections update automatically, so your ROI calculations stay current without manual data exports.
Step 2. Import Google Ads cost data.
Select the Campaigns report with fields: Campaign Name, Cost, Clicks, and Impressions. Filter by the same date range as your HubSpot deal analysis and schedule daily refresh to maintain current spend data.
Step 3. Import HubSpot revenue data.
Import Deals with Deal Name, Amount, Close Date, Original Source Detail, and Campaign properties. Filter for Closed Won deals where Original Source equals Paid Search, including any custom campaign tracking properties you’ve set up.
Step 4. Create ROI calculations.
Build formulas for Campaign ROI = (Revenue – Cost) / Cost × 100, Cost Per Closed Deal = Total Cost / Count of Closed Deals, and Revenue Per Click = Total Revenue / Total Clicks. Use SUMIF formulas to match campaigns across both datasets.
Step 5. Build your ROI dashboard.
Create pivot tables showing ROI by campaign, ad group, and time period. Build charts visualizing cost vs revenue trends and apply conditional formatting to highlight profitable campaigns. Set up Slack alerts when campaign ROI drops below your target threshold.
Get real-time ROI visibility
Start connectingThis integrated approach provides ROI insights impossible with either platform alone, enabling data-driven budget allocation decisions.your Google Ads and HubSpot data today.
