Hubspot: Email Event Status Change

Description

• Each record represents a STATUS_CHANGE email event in Hubspot.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
INTEGER	is_bounced	A HubSpot employee explicitly initiated the status change to block messages to the recipient. (Note this usage has been deprecated in favor of dropping messages with a 'dropReason' of BLOCKED_ADDRESS.)
STRING	event_id	The ID of the event.
STRING	subscription_status	The recipient's portal subscription status. Note that if this is 'UNSUBSCRIBED', the property 'subscriptions' is not necessarily an empty array, nor are all subscriptions contained in it necessarily going to have their statuses set to 'UNSUBSCRIBED'.)
INTEGER	requested_by_email	The email address of the person requesting the change on behalf of the recipient. If not applicable, this property is omitted.
STRING	change_source	The source of the subscription change.
STRING	subscriptions	An array of JSON objects representing the status of subscriptions for the recipient. Each JSON subscription object is comprised of the properties: 'id', 'status'.
DATETIME	created_timestamp	The created timestamp of the event.
INTEGER	email_campaign_id	The ID of the related email campaign.
STRING	recipient_email_address	The email address of the contact related to the event.
DATETIME	email_send_timestamp	The timestamp of the SENT event related to this event.
STRING	email_send_id	The event ID which uniquely identifies the email message's SENT event. If not applicable, this property is omitted.
INTEGER	contact_id	The ID of the related contact.
BOOLEAN	is_contact_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.