SPOTTER | Your Hubspot Helper

Tip

Quick fix for a common HubSpot headache.

Create a "Last Form Submission URL" Property

HubSpot tells you which form a contact submitted, but not which page they were on when they submitted it, and those aren't always the same thing.

A form embedded on five different landing pages looks identical in the contact record. To fix this, create a custom single-line text property called "Last Form Submission URL" and build a workflow that fires on any form submission, copying the "Page URL" submission property into that field.

Now every contact has a persistent, reportable field showing exactly where they last converted. This is particularly useful for understanding which pages are actually driving leads versus which ones just get traffic, and for routing or segmenting contacts based on the offer they responded to.

⚠️ Trap

Mistake to avoid before it causes chaos.

Calculated Properties Treat Blank as Blank, Not Zero

If any property feeding into a HubSpot calculated field is empty, the entire calculation returns null, not zero, not a partial value, null.

This means a contact missing even one input property gets a blank calculated field, which is functionally invisible to any filter or workflow logic checking for a number.

The trap is that it looks fine: your workflow is enrolled, your list is built, your score is configured.

But a percentage of your database is silently excluded from every downstream action because their calculated field never resolves.

Before relying on a calculated property for scoring or segmentation, audit how many contacts have blank values on each input property and decide whether to set a default value or use a separate workflow to fill gaps first.

🔄 Try

Something small to test or improve this week.

Connect Microsoft Clarity to HubSpot
Microsoft Clarity is a free behavioral analytics tool that gives you heatmaps and session recordings, and when you connect it to HubSpot, those recordings become a lot more useful.

The integration lets you pass HubSpot contact properties into Clarity as custom tags, which means you can filter session recordings by lifecycle stage, persona, lead score, or any other contact attribute.

It turns session recordings from a general UX tool into a sales and marketing diagnostic.

👋 Need a Spot?

Want help cleaning up your HubSpot portal or setting up something smarter?

Let’s talk about what hands-on help could look like for your team.

Email me here or DM me on Linkedin.

Keep Reading