Hubspot: Email Campaigns

Description

• Each record represents an email campaign in Hubspot.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
INTEGER	app_id	The app ID.
STRING	app_name	The app name.
INTEGER	content_id	The ID of the content.
INTEGER	email_campaign_id	The ID of the email campaign.
STRING	email_campaign_name	The name of the email campaign.
INTEGER	num_included	The number of messages included as part of the email campaign.
INTEGER	num_queued	The number of messages queued as part of the email campaign.
INTEGER	email_campaign_sub_type	The email campaign sub-type.
STRING	email_campaign_subject	The subject of the email campaign.
STRING	email_campaign_type	The email campaign type.
INTEGER	total_bounces	The total number of bounce email events.
INTEGER	total_unique_bounces	The total number of unique email sends with a bounce email event.
INTEGER	total_clicks	The total number of click email events.
INTEGER	total_unique_clicks	The total number of unique email sends with a click email event.
INTEGER	total_deferrals	The total number of deferral email events.
INTEGER	total_unique_deferrals	The total number of unique email sends with a deferral email event.
INTEGER	total_deliveries	The total number of delivery email events.
INTEGER	total_unique_deliveries	The total number of unique email sends with a delivery email event.
INTEGER	total_drops	The total number of drop email events.
INTEGER	total_unique_drops	The total number of unique email sends with a drop email event.
INTEGER	total_forwards	The total number of forward email events.
INTEGER	total_unique_forwards	The total number of unique email sends with a forward email event.
INTEGER	total_opens	The total number of open email events.
INTEGER	total_unique_opens	The total number of unique email sends with a opens email event.
INTEGER	total_prints	The total number of print email events.
INTEGER	total_unique_prints	The total number of unique email sends with a print email event.
INTEGER	total_spam_reports	The total number of spam report email events.
INTEGER	total_unique_spam_reports	The total number of unique email sends with a spam report email event.
INTEGER	total_unsubscribes	The total number of unsubscribe email events.
INTEGER	total_unique_unsubscribes	The total number of unique email sends with a unsubscribe email event.