EmailCampaigns
Provides details about email marketing campaigns managed within HubSpot, supporting campaign tracking and analysis.
Table Specific Information
Email campaigns in HubSpot represent email marketing campaigns you may send to many different contacts.
SELECT
Email campaign data can only be retrieved from HubSpot via a direct request for a specific HubSpot id. To retrieve all campaigns, first all campaign ids must be retrieved. Then one request for individual campaign data at a time must be submitted. These requests are done automatically, but because of the number of individual requests made for data, this can cause for slow response times.
When selecting email campaigns, may be filtered by the Id. For example:
SELECT * FROM EmailCampaigns WHERE Id = '123456789'
The LastUpdatedTime will not normally be return with a value. It will only come back when specifying WHERE LastUpdatedTime > 'value'. This will trigger a request to HubSpot for recently modified EmailCampaigns. However, be aware that HubSpot only provides a way to retrieve recently modified EmailCampaigns. Not all campaigns that match the criteria may be returned.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier assigned to the email campaign. | |
| AppName | String | Name of the application associated with the email campaign. | |
| AppId | Long | Unique identifier of the application linked to the email campaign. | |
| LastUpdatedTime | Datetime | Timestamp indicating when the email campaign was last updated. | |
| Name | String | Name assigned to the email campaign. | |
| ContentId | Long | Unique content identifier for the email campaign. | |
| NumberBounced | Long | Total number of bounced emails in the campaign. | |
| NumberClick | Long | Total number of clicks recorded in the campaign. | |
| NumberDeferred | Long | Total number of deferred emails in the campaign. | |
| NumberDelivered | Long | Total number of emails successfully delivered in the campaign. | |
| NumberDropped | Long | Total number of dropped emails in the campaign. | |
| NumberIncluded | Long | Total number of emails included in the campaign. | |
| NumberMTADropped | Long | Total number of emails dropped by the message transfer agent (MTA) in the campaign. | |
| NumberOpen | Long | Total number of opened emails in the campaign. | |
| NumberProcessed | Long | Total number of emails processed in the campaign. | |
| NumberQueued | Long | Total number of queued emails in the campaign. | |
| NumberSent | Long | Total number of emails sent in the campaign. | |
| NumberStatusChanged | Long | Total number of emails where the status changed during the campaign. | |
| NumberUnsubscribed | Long | Total number of recipients who unsubscribed during the campaign. | |
| ProcessingState | String | Current processing state of the email campaign. | |
| Type | String | Type of the email campaign, such as regular or automated. | |
| SubType | String | Subtype providing additional classification of the email campaign. | |
| Subject | String | Subject line used in the email campaign. | |
| LastProcessingStartedAt | Datetime | Timestamp when the campaign last began processing. | |
| LastProcessingFinishedAt | Datetime | Timestamp when the campaign last finished processing. | |
| LastProcessingStateChangeAt | Datetime | Timestamp of the last change in the processing state of the email campaign. | |
| ExtraUrlParameters | String | Optional input-only property for specifying additional query parameters. Format: 'param1=value1, param2=value2, param3=value3'. |