Hubspot: Email Sends

Description

• Each record represents a SENT email event.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
STRING	bcc_emails	The 'cc' field of the email message.
STRING	cc_emails	The 'bcc' field of the email message.
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.
INTEGER	bounces	The total number of bounce email events.
INTEGER	clicks	The total number of click email events.
INTEGER	deferrals	The total number of deferral email events.
INTEGER	deliveries	The total number of delivery email events.
INTEGER	drops	The total number of drop email events.
INTEGER	forwards	The total number of forward email events.
INTEGER	opens	The total number of open email events.
INTEGER	prints	The total number of print email events.
INTEGER	spam_reports	The total number of spam report email events.
BOOLEAN	was_bounced	Whether the email was bounced.
BOOLEAN	was_clicked	Whether the email was clicked.
BOOLEAN	was_deferred	Whether the email was deferred.
BOOLEAN	was_delivered	Whether the email was delivered.
BOOLEAN	was_forwarded	Whether the email was forwarded.
BOOLEAN	was_opened	Whether the email was opened.
BOOLEAN	was_printed	Whether the email was printed.
BOOLEAN	was_spam_reported	Whether the email was spam reported.
INTEGER	unsubscribes	The total number of unsubscribe email events.
BOOLEAN	was_unsubcribed	Whether the email was unsubcribed.