EmailCampaigns
Email campaigns in HubSpot allow you to keep track of email marketing campaigns.
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 | The Id of the email campaign. | |
| AppName | String | The name of the app associated with the email campaign. | |
| AppId | Long | The Id of the app associated with the email campaign. | |
| LastUpdatedTime | Datetime | When the email campaign was lasted updated. | |
| Name | String | The name of the campaign. | |
| ContentId | Long | The ContentId of the email campaign. | |
| NumberBounced | Long | The number bounced. | |
| NumberClick | Long | The number of clicks. | |
| NumberDeferred | Long | The number deferred. | |
| NumberDelivered | Long | The number delivered. | |
| NumberDropped | Long | The number dropped. | |
| NumberIncluded | Long | The number included. | |
| NumberMTADropped | Long | The number mta dropped. | |
| NumberOpen | Long | The number open. | |
| NumberProcessed | Long | The number processed. | |
| NumberQueued | Long | The number queued. | |
| NumberSent | Long | The number sent. | |
| NumberStatusChanged | Long | The number where the status was changed. | |
| NumberUnsubscribed | Long | The number unsubscribed. | |
| ProcessingState | String | The processing state of the email campaign. | |
| Type | String | The type of email campaign. | |
| SubType | String | The subtype of the email campaign. | |
| Subject | String | The subject of the email campaign. | |
| LastProcessingStartedAt | Datetime | Last date the email campaign last began processing at. | |
| LastProcessingFinishedAt | Datetime | When the email campaign last finished processing at. | |
| LastProcessingStateChangeAt | Datetime | The last time the email campaign's processing state changed. | |
| ExtraUrlParameters | String | An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. |