Hubspot: Companies

Description

• Each record represents a company in Hubspot.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
INTEGER	company_id	The ID of the company.
BOOLEAN	is_company_deleted	Boolean indicating whether a record has been deleted in Hubspot and/or inferred deleted in Hubspot by Fivetran; _fivetran_deleted and is_deleted fields are equivalent.
DATETIME	_fivetran_synced
STRING	company_name
STRING	description
DATETIME	created_date
STRING	industry
STRING	street_address
STRING	street_address_2
STRING	city
STRING	state
STRING	country
INTEGER	company_annual_revenue
INTEGER	count_engagement_notes	The total number of related note engagements.
INTEGER	count_engagement_tasks	The total number of related task engagements.
INTEGER	count_engagement_calls	The total number of related call engagements.
INTEGER	count_engagement_meetings	The total number of related meeting engagements.
INTEGER	count_engagement_emails	The total number of related email engagements.
INTEGER	count_engagement_incoming_emails	The total number of related incoming email engagements.
INTEGER	count_engagement_forwarded_emails	The total number of related forwarded email engagements.