[object Object]

Calculated properties are the most underused feature in HubSpot. Workflows recompute on triggers and lag; calculated properties recompute on read, always fresh, always free. Here are seven patterns to start using them.

1. Days in current deal stage

Property: days_in_current_stage
Type: Number
Formula: TODAY() - hs_date_entered_current_stage

Surface this on every deal card. Reps self-correct stalled deals when they see “47 days” without you having to nag.

2. Deal velocity (size / days open)

Property: deal_velocity
Formula: amount / (TODAY() - createdate)

Sort the pipeline by velocity to find low-value deals eating rep cycles.

3. Engagement freshness score

Property: engagement_freshness
Formula: 100 - MIN(100, (TODAY() - notes_last_contacted) * 2)

Decays from 100 to zero over 50 days. Trigger workflows when this drops below 30.

4. Whitespace flag (existing customer, no recent deal)

Property: whitespace_flag
Type: Boolean
Formula: lifecyclestage == "customer" AND num_associated_deals_open == 0 AND days_since_last_engagement > 60

Pipe these into a CSM expansion queue.

5. ARR per employee (account-level fit)

Property: arr_per_employee
Formula: company.total_arr / company.numberofemployees

Identifies under-monetized accounts when this drops below your average.

6. Forecast confidence weighting

Property: weighted_amount
Formula: amount * deal_stage_probability * (1 - (days_overdue / 60))

Pipeline times stage probability times a freshness penalty. Sums to a far more honest forecast than raw weighted pipeline.

7. Composite lead score

Property: composite_score
Formula: (fit_score * 0.4) + (engagement_score * 0.4) + (intent_score * 0.2)

Decompose your single lead score into a weighted blend you can actually tune per quarter.

Two warnings

Calculated properties recompute on read but don’t backfill historical reporting. If you need to chart “average days_in_current_stage over time,” you also need a workflow that snapshots the value weekly.

Don’t nest more than three calculated properties. Performance and debuggability collapse fast.

What to do this week

Pick one pain (stalled deals, expansion misses, forecast confidence) and ship the matching calculated property. Surface it on the right rail card by Friday.

[object Object]
Share