)
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’s calculated properties only support basic operations like addition and subtraction. You can’t create calculated fields that multiply activity counts by custom point values using HubSpot’s native functionality.
Here’s how to create the custom calculated fields HubSpot can’t deliver natively while maintaining full CRM integration.
Create advanced calculated fields using Coefficient
Coefficient creates a bridge between HubSpot and spreadsheet environments where complex calculations are possible. You can build the multiplication formulas HubSpot lacks, then export the results back as HubSpot custom properties.
How to make it work
Step 1. Extract your HubSpot engagement data.
Import activity data including calls, emails, meetings, and tasks with counts per contact or deal. Use Coefficient’s filtering to focus on specific date ranges or activity types relevant to your scoring system.
Step 2. Set up your point value matrix.
Create a reference table mapping each activity type to its point value. Structure it with activity names in column A and point values in column B for easy VLOOKUP references.
Step 3. Build multiplication formulas.
Use formulas like =VLOOKUP(activity_type, points_table, 2, FALSE) * activity_count to calculate weighted scores. Apply this across all activity types to generate comprehensive scoring.
Step 4. Create calculated field columns.
Generate new columns with weighted scores for each activity type, then sum them for total scores per contact or deal. Use conditional formatting to highlight high-value scores.
Step 5. Export to HubSpot custom properties.
Push the calculated weighted scores back to HubSpot as custom number properties. These appear and function like native HubSpot calculated fields in your CRM interface.
Step 6. Automate with scheduled exports.
Set up daily or weekly exports to keep HubSpot properties updated with fresh calculations. The custom calculated fields stay current without manual intervention.
Get the calculated fields HubSpot can’t provide
This method delivers true weighted activity scoring within your CRM system using the advanced calculations HubSpot lacks natively. Start building custom calculated fields that actually multiply activity counts by point values.
