Hubspot: Email Event Dropped

Description

• Each record represents a DROPPED email event.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
STRING	bcc_emails	The 'bcc' field of the email message.
STRING	cc_emails	The 'cc' field of the email message.
STRING	drop_message	The raw message describing why the email message was dropped. This will usually provide additional details beyond 'dropReason'.
STRING	drop_reason	The reason why the email message was dropped. See below for the possible values.
STRING	from_email	The 'from' field of the email message.
STRING	event_id	The ID of the event.
STRING	reply_to_email	The 'reply-to' field of the email message.
STRING	email_subject	The subject line of the email message.
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.