/
/
Find the HubSpot contact data that breaks your reports
For operations teams who want missing owners, duplicates and backwards lifecycle stages found, by asking their AI assistant.
On this page
Connector
Connect HubSpot, pick your AI tool and paste the prompt.
The problem
Bad contact data quietly breaks reporting and routing
Missing owners, contacts with no company, duplicate emails and lifecycle stages that slipped backwards quietly break reporting and routing. Finding them in HubSpot means several filtered views and checking property history by hand.
Without PopdockAI
- Build a filtered view for each missing field
- Export contacts to find duplicate emails
- Check property history for backward stage moves
- Count the share affected by hand
With PopdockAI
- Each contact is checked for missing fields and unlinked companies
- Duplicate emails are grouped with every record id
- Backward lifecycle stage changes are traced with when and why
- Counts and samples per issue, with nothing merged or edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Audit HubSpot contacts created since `{created-since}` (default 90 days ago), at lifecycle stage `{lifecycle-stage}` (default all), for gaps and inconsistencies.
**Step 1: Contacts**
Call `hubspot-get-contacts` with `create-date.from` = the start date, plus `lifecycle-stage` when given, with a high `max-records`.
**Step 2: Check each contact**
* Missing email, phone number, contact owner, company name or company ID.
* Has a company name but no company ID (not associated to a company record).
* Duplicate email addresses (compare case-insensitively).
* No last activity date.
**Step 3: Lifecycle regressions**
Call `hubspot-get-contact-property-history` with `property-name` = lifecycle stage (use `property-label.contains` = "Lifecycle" if the internal name does not match) and `changed.from` = the start date. Flag changes that move backwards in the order subscriber, lead, marketing qualified lead, sales qualified lead, opportunity, customer, evangelist, and note the `source-type` of each.
**Step 4: Report**
* Counts per issue with the share of contacts affected.
* A table per issue (up to 25 rows each): name, email, owner, create date.
* Duplicate groups with every record-id in each group.
* Lifecycle regressions: contact, from, to, when, source.
**Rules & Guidelines:**
* This prompt is read-only. Do NOT call any write tool: `hubspot-add-contact`, `hubspot-add-company`, `hubspot-add-deal`, `hubspot-add-ticket`, `hubspot-update-contact`, `hubspot-update-company`, `hubspot-update-deal`, `hubspot-update-ticket`, `hubspot-add-contact-note`, `hubspot-add-company-note`, `hubspot-add-deal-note`, `hubspot-add-ticket-note`.
* Do not merge, edit or delete contacts; this is an audit.
**Validation:**
* If no contacts match, say so.
* If contacts hit `max-records`, say the audit covers a sample.Who it's for
One answer, three teams that use it
CRM administrators
Find what to fix first
See counts and the share of contacts affected by each problem, so clean up starts where it matters.
Audit HubSpot contacts created since January for missing owners, companies and duplicate emails.
Marketing operations
Fix routing before leads go missing
Contacts with no owner or no linked company are found before routing sends them nowhere.
Which HubSpot leads created in the last 60 days have no owner or no linked company?
Revenue operations
Explain odd funnel numbers
Lifecycle stages that moved backwards are traced, with when and what caused the change.
Find HubSpot contacts whose lifecycle stage moved backwards this year, and what caused it.
How it works
What PopdockAI does when you ask
You pick a created since date and your AI assistant checks every matching HubSpot contact for data problems. You get counts and samples, and nothing is edited.
01
Ask
You pick a created-since date and optionally a lifecycle stage.
02
Check
It checks each contact for missing fields, unlinked companies, duplicates and no activity.
03
Trace
It finds lifecycle stages that moved backwards, with when and why.
04
Report
You get counts, sample tables and duplicate record IDs, and nothing is edited.
What PopdockAI provides
The tools behind the answer
Ready made tools for HubSpot and one secure connection to your AI tool. No code, no exports.
hubspot-get-contacts
hubspot-get-contact-property-history
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
A prioritised list of contact data problems
Related use cases
More ways to put this data to work
HubSpot contact activity timeline
Ask your AI for a HubSpot contact activity timeline and it merges emails, calls, meetings, notes, forms, field changes and tasks into one dated view.
Learn More
Add a new HubSpot contact
Ask your AI to add a contact to HubSpot and it checks the email for duplicates, matches the company by name and domain, and saves only after you confirm.
Learn More
Add HubSpot list members to a Constant Contact list
Ask your AI to add HubSpot list members to a Constant Contact list and it finds who is missing, excludes anyone opted out, and adds people only after you confirm.
Learn More
Add HubSpot list members to a Mailchimp audience
Ask your AI to add HubSpot list members to a Mailchimp audience and it skips opt-outs and existing members, then adds the rest as pending after you confirm.
Learn More
Check a HubSpot contact's email consent
Ask your AI whether a HubSpot contact can receive marketing email and it checks subscriptions, lists and delivery history for a verdict with dated evidence.
Learn More
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.