ODBC Driver for HubSpot

Build 23.0.8839


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.


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.


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'.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839