.avif)
I just added the ability to see when a phone number on a contact was last checked if it was live. This is through a custom datetime property called Last HLR Query.
This is part of a series of features I'm releasing to help users maintain visibility over their data hygiene efforts over time, because data quality isn't just about cleaning your database once.
• Automatic Timestamp Updates: Every time a phone number is verified in a contact workflow, Clean Dial updates the last_hlr_query property with a timestamp
• Zero Performance Impact: The update happens asynchronously in the background, so your validation workflows run at full speed
• Organized Data: Properties are grouped under "Clean Dial Properties" for easy management
Currently this feature is only for Contact records, but if you'd find it useful on another standard object, let me know at contact@daeda.tech
Head to CRM > Contacts > select a Contact > go to Key Information > Actions > Customise Properties > search for Last HLR Query under Clean Dial.
For new users
Simply install Clean Dial here.
The "Last HLR Query" property will be created automatically during setup and will start tracking live or dead numbers immediately from workflows youset up.
For existing users
If you installed before 01/12/25 then please reinstall as you'll need to accept some new scopes e.g. read/write to contacts.
Otherwise no action needed! The next time you run a HLR Lookup workflow on a contact record, the custom property will be created automatically and the timestamp will be recorded.
Prove ROI on Data Quality Initiatives
Marketing and sales operations teams often struggle to demonstrate the value of data cleaning efforts. With timestamped records, you can now:
• Show exactly how many contacts had live phone numbers in the last 30/60/90 days
• Create reports tracking data quality improvements over time
• Justify budget allocation for data hygiene tools
Compliance and Audit Trails
For industries with strict data governance requirements, having a complete audit trail of phone live/dead activities is invaluable:
• Document when customer contact information was last verified
• Support compliance reviews with timestamped records
• Demonstrate due diligence in maintaining accurate customer data
Smarter Workflow Automation
Use the "Last HLR Query" property to build intelligent HubSpot workflows:
• Re-validation Triggers: Automatically re-verify phone numbers that haven't been checked in 6+ months
• Data Quality Scoring: Include live check recency in your lead scoring models
• Segmentation: Create targeted lists based on when contacts were last verified
• Quality Gates: Prevent contacts from progressing through your funnel until their phone number is confirmed as live
Better Contact Management
Sales teams benefit from knowing which contact records have fresh, live data:
• Prioritize outreach to contacts with recently live phone numbers
• Identify stale contact records that need updating
• Build confidence in your contact database
Create a workflow that:
1. Enrolls contacts where "Last HLR Query" is older than 180 days (or your preferred interval)
2. Re-verifies the phone number using Clean Dial's HLR Lookup action
3. Ensures your database stays fresh automatically
1. Create custom reports showing:
• Percentage of live contacts in the last 90 days
• Trend of verification activity over time
• Breakdown by contact lifecycle stage or other segmentation
2. Include in Onboarding Processes
Add phone live checks to your contact onboarding workflows to ensure every new contact gets timestamped from the start.
---
About Clean Dial
Clean Dial is two HubSpot workflow actions that look up HLR and format phone numbers across 200+ countries. With features like checking a number is callable, VoIP detection, line type identification, and carrier information, Clean Dial helps businesses maintain clean, accurate contact data for better sales and marketing outcomes.
.png)
.svg)
.avif)
