Hubspot: Deals

Description

• Each record represents a deal in Hubspot.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
STRING	deal_name	The name you have given this deal.
DATETIME	closed_date	The day the deal is expected to close, or was closed.
DATETIME	created_date	The date the deal was created. This property is set automatically by HubSpot.
BOOLEAN	is_deal_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	Timestamp of when Fivetran synced a record.
INTEGER	deal_id	The ID of the deal
STRING	deal_pipeline_id	The ID of the deal's pipeline.
STRING	deal_pipeline_stage_id	The ID of the deal's pipeline stage.
INTEGER	owner_id	The ID of the deal's owner.
INTEGER	portal_id	The hub ID.
STRING	description	A brief description of the deal.
INTEGER	amount	The total value of the deal in the deal's currency.
BOOLEAN	is_deal_pipeline_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.
STRING	pipeline_label	The label of the deal's pipeline.
BOOLEAN	is_pipeline_active	Boolean indicating if the pipeline is active.
BOOLEAN	is_deal_pipeline_stage_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.
STRING	deal_pipeline_created_at	A timestamp representing when the deal_pipeline was created.
STRING	deal_pipeline_updated_at	A timestamp representing when the deal_pipeline was updated.
STRING	pipeline_stage_label	The label of the deal's pipeline stage.
STRING	owner_email_address	The email address of the deal's owner.
STRING	owner_full_name	The full name of the deal's owner.
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.