HubSpot Import

How enriched data flows into HubSpot CRM.

Import Flow

Field Mapping

Company Properties

Baseloop Field	HubSpot Property	Type
company_name	`name`	String
website	`website`	String
linkedin_url	`linkedin_company_page`	String
employee_count	`numberofemployees`	Number
industry	`industry`	Dropdown
fit_score	`baseloop_fit_score`	Number
tier	`baseloop_tier`	Dropdown
campaign_id	`baseloop_campaign_id`	String

Contact Properties

Baseloop Field	HubSpot Property	Type
first_name	`firstname`	String
last_name	`lastname`	String
email	`email`	String
job_title	`jobtitle`	String
linkedin_url	`linkedin_profile`	String
phone	`phone`	String
verified_email	`email_verified`	Boolean

Duplicate Handling

Deduplication Rules

Entity	Match On	Action
Company	Domain/Website	Update if exists
Company	Name (fuzzy)	Flag for review
Contact	Email	Update if exists
Contact	LinkedIn URL	Update if exists

Round Robin Assignment

After import, contacts are assigned to BDRs:

Assignment Logic

Check company’s HQ country
Route to regional BDR pool
Round robin within pool
Set Contact Owner property
Copy to Company Owner if new company

Workflow Triggers

When data imports, these workflows fire:

Trigger	Workflow	Action
New company with Best Fit tier	Priority Alert	Slack notification
New contact with verified email	Sequence Enrollment Check	Check if eligible
High intent website visitor	High Intent Routing	Immediate assignment

Data Quality Issues

Known issues identified in audit:

Company name ≠ website domain → Flag for review
LinkedIn URL missing company name → Flag for review
Contact email domain ≠ company domain → Flag for review
Duplicate company names → Check for M&A

Hygiene Scripts (In Progress)

Check	Status	Script
Company name vs website mismatch	✅ Done	`company_website_check.py`
LinkedIn URL validation	✅ Done	`linkedin_url_check.py`
Email domain mismatch	🔄 WIP	`email_domain_check.py`
Duplicate detection	🔄 WIP	`duplicate_finder.py`

Import Volume

Period	Companies	Contacts	Source
Last 30 days	TBD	TBD	Baseloop
Last 90 days	TBD	TBD	Baseloop
All time	17,605	32,254	Baseloop