6sense CRM (HubSpot) Onboarding Minimum Data Requirements for Predictive Package

This guide clarifies the minimum data required from your CRM system to support 6sense functionalities. It outlines the standard tables and fields that we typically synchronize via the API.

The 6sense integration with HubSpot requires users to have Super Admin privileges and it is a mandatory requirement for HubSpot CRM/MAP integration. 6sense will be granted Read/Write permissions to all objects below. During onboarding, you can work with your assigned Product Consultant to filter out data records/properties that should not be considered for modeling.

Standard Fields

Table: Companies

Property Name	Description	Required Field
hs_object_id	primary key id	x
name		x
address
city
state
zip
industry
primary_sub_industry
website		x
numberofemployees
createdate		x
hs_lastmodifieddate		x
country		x
annualrevenue
hs_last_sales_activity_date
hubspot_owner_id		x

Table: Contacts

Property Name	Description	Required Field
hs_object_id		x
email	primary key id	x
firstname		x
lastname		x
phone
mobilephone
address
city
state
zip
country		x
annualrevenue
industry
sub_industry
department
numberofemployees
job_function		x
jobtitle		x
createdate		x
lastmodifieddate		x
leadsource		x
role		x
website		x
sic_code
vid		x
hs_lifecyclestage_marketingqualifiedlead_date

Table: Deals

Property Name	Description	Required Field
hs_object_id		x
dealname		x
label		x
amount		x
hs_is_closed		x
hs_is_closed_won		x
closedate		x
createdate		x
hs_lastmodifieddate		x
dealtype		x
deal_currency_code		x

Table: Deals and Company Relation

Reference HubSpot API documentation about associations.

Property Name	Description	Required Field
fromObjectId	Deal hs_object_id	x
toObjectId	Company hs_object_id	x

Table: Deals and Contact Relation

Property Name	Description	Required Field
fromObjectId	Deal hs_object_id	x
toObjectId	Contact hs_object_id	x

Table: Pipeline Stages

Property Name	Description	Required Field
id		x
label		x

Table: Forms

Property Name	Description	Required Field
name		x
id		x

Table: Activities

Property Name	Required Field
ID	x
Created_date	x
Subject	x
ContactID	x
UserID
OwnerID
CompanyID	x
Status
Metadata__priority	x
Metadata__body	x
Metadata__tasktype	x
Engagement__type	x
Metadata__tasktype	x
Metadata__status	x
Metadata__subject	x
Changes__changetype	x
Metadata_meeting_length
Activity_type	x

Table: Campaigns

Property Name	Description	Required Field
id		x
name		x
type		x
subject		x
scheduledat		x
lastprocessingstatechageat		x

Table: Owners

Field Name	Description	Required Field
id	unique identifier	x
First Name		x
Last Name		x
Phone
Mobile Phone
Email		x
Address
City
State
PostalCode
country
Department
Division
Job Title
Created Date
Modified Date
Alias
Nickname
isActive
UserRoleId
ProfileId
UserType
UserName