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 |
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 | ||
x | ||
Address | ||
City | ||
State | ||
PostalCode | ||
country | ||
Department | ||
Division | ||
Job Title | ||
Created Date | ||
Modified Date | ||
Alias | ||
Nickname | ||
isActive | ||
UserRoleId | ||
ProfileId | ||
UserType | ||
UserName |