)
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 calculated properties often fail to appear in Google Data Studio connectors due to API limitations and property type restrictions. These missing properties can break your most important reports and dashboards.
Here’s how to access all HubSpot property types, including calculated fields that other connectors miss, and even recreate calculations for more flexibility.
Access all calculated properties without restrictions using Coefficient
CoefficientHubSpotsolves this by providing complete access to allproperty types, including calculated fields that other connectors miss. You can import calculated values from HubSpot and create additional calculations in Google Sheets for enhanced flexibility.
How to make it work
Step 1. Import all calculated properties from HubSpot.
Select your HubSpot object (Contacts, Companies, Deals) and scroll through field selection to find all calculated properties. They appear alongside standard properties without restrictions. Choose specific calculated fields needed for your reports, including score properties, rolled-up properties, and equation-based fields.
Step 2. Enhance with additional spreadsheet calculations.
Import the calculated values from HubSpot, then create additional calculations in Google Sheets for more flexibility. Combine HubSpot calculations with spreadsheet formulas and build more complex calculated metrics unavailable in HubSpot itself.
Step 3. Handle calculation timing and updates.
Some calculated properties update asynchronously in HubSpot, so schedule imports after typical calculation completion times. Use Coefficient’s Snapshots feature to track calculation changes over time and monitor how calculated values evolve.
Step 4. Recreate calculations for maximum flexibility.
If a calculated property has issues, recreate it using source data in Google Sheets. Use Google Sheets formulas for more flexibility than HubSpot’s calculation engine and create new calculated fields impossible in HubSpot’s native system.
Never miss important calculated data again
Start accessingThis approach ensures all your HubSpot metrics visualization needs are met, including complex calculated properties that form the backbone of advanced reports and dashboards. You get more flexibility than HubSpot’s native calculations.all your calculated properties today.
