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

Prev Next

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