)
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.”
Accurate Google Ads ROI analysis requires specific HubSpot properties that connect campaign data to closed revenue, but identifying the right fields can be challenging without clear guidance.
You’ll learn exactly which deal, contact, and campaign properties to export for comprehensive revenue attribution and ROI calculation in your visualization tools.
Export essential HubSpot properties for campaign ROI tracking using Coefficient
CoefficientHubSpot‘s field selection interface makes it easy to identify and export the criticalproperties needed for comprehensive Google Ads campaign ROI analysis. You can select specific properties during import setup and create custom property groups for different analysis types.
This targeted approach ensures you capture only Google Ads-attributed revenue while maintaining granular campaign tracking for accurate ROI calculations.
How to make it work
Step 1. Export essential deal properties for revenue tracking.
Import deal records with Amount, Close Date, Deal Stage, and Pipeline properties for basic revenue calculations. Include Original Source and Source Drill-downs to identify Google Ads traffic. Most importantly, export custom UTM properties including utm_campaign, utm_medium, utm_source, utm_content, and utm_term for granular campaign attribution.
Step 2. Include contact properties for attribution analysis.
Pull contact data including First Conversion Date, Original Source Data, and Recent Conversion Information to understand the customer journey. Export custom campaign ID fields and Lifecycle Stage Transitions to build multi-touch attribution models that track how contacts progress from ads to revenue.
Step 3. Use advanced filtering for Google Ads focus.
Apply Coefficient’s filtering capabilities to pull only deals with Google Ads attribution. Use filters like “Original Source contains ‘Google Ads'” or “UTM Medium equals ‘cpc'” to focus on paid search traffic. Set up dynamic filters that reference cells containing specific campaign IDs for flexible analysis.
Step 4. Set up ROI calculation framework.
Import associated company data for account-based campaign analysis. Include calculated properties like Customer Lifetime Value if available in HubSpot. Export deal-to-contact associations to enable multi-touch attribution modeling and campaign ROI calculations across the entire customer journey.
Build more accurate campaign ROI reports
Start exportingThe right property selection is crucial for meaningful Google Ads ROI analysis. With targeted data exports and flexible filtering, you can create comprehensive attribution models that accurately connect ad spend to closed revenue.the right HubSpot data for better campaign ROI tracking today.
