ODBC Driver for Mailchimp

Build 26.0.9770

AutomationEmails

Returns a summary of the emails in an automation workflow.

Table-Specific Information

Select

The driver uses the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

ColumnSupported Operators
WorkflowId=

For example, the following query is processed server-side: 

SELECT * FROM AutomationEmails WHERE WorkflowId = '1245'

Update

The WorkflowId and Id columns are required in the WHERE clause for UPDATE operations. Updatable columns include Delay_Amount, Delay_Type, Delay_Direction, Delay_Action, Settings_SubjectLine, Settings_Title, Settings_FromName, Settings_ReplyTo, and Settings_PreviewText. 

UPDATE AutomationEmails SET Settings_SubjectLine = 'Welcome!', Settings_FromName = 'My Store' WHERE WorkflowId = 'b0a1c4d2e3' AND Id = 'f5g6h7i8j9'

Delete

The following is an example of a DELETE operation: 
DELETE FROM AutomationEmails WHERE WorkflowId = 'b0a1c4d2e3' AND Id = 'f5g6h7i8j9'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A string that uniquely identifies the automation email.

WorkflowId [KEY] String True

A string that uniquely identifies an automation workflow.

Position Integer True

The position of the email within the automation workflow sequence.

Delay_Amount Integer False

The delay amount for an automation email.

Delay_Type String False

The type of delay for an automation email.

Delay_Direction String False

The direction of the delay, indicating whether it occurs before or after the delay action of an automation email.

Delay_Action String False

The action that triggers the delay of an automation email.

CreateTime Datetime True

The date and time the campaign was created.

StartTime Datetime True

The date and time the campaign was started.

ArchiveUrl String True

The link to the campaign's archive version.

Status String True

The current status of the campaign ('save', 'paused', 'sending').

EmailsSent Integer True

The total number of emails sent for this campaign.

SendTime Datetime True

The date and time a campaign was sent.

ContentType String True

How the campaign's content is put together ('template', 'drag_and_drop', 'html', 'url').

Recipients_ListId String True

Lists.Id

The Id of the list associated with this automation email.

Recipients_SegmentOpts String True

The segmentation options for the recipients of this automation email.

Settings_SubjectLine String False

The subject line for the campaign.

Settings_Title String False

The title of the campaign.

Settings_FromName String False

The 'from' name on the campaign (not an email address).

Settings_ReplyTo String False

The reply-to email address for the campaign.

Settings_Authenticate Boolean True

Indicates whether the campaign was authenticated by Mailchimp. Defaults to 'true'.

Settings_AutoFooter Boolean True

Indicates whether Mailchimp's default footer is automatically appended to the campaign.

Settings_InlineCss Boolean True

Indicates whether the CSS included with the campaign content is automatically inlined.

Settings_AutoTweet Boolean True

Indicates whether a link to the campaign archive page is automatically tweeted when the campaign is sent.

Settings_AutoFbPost String True

An array of Facebook page Ids (integers) to auto-post to.

Settings_FbComments Boolean True

Indicates whether Facebook comments are enabled on the campaign, which also force-enables the Campaign Archive toolbar. Defaults to 'true'.

Settings_TemplateId Integer True

Templates.Id

The Id of the template used in this campaign.

Settings_DragAndDrop Boolean True

Indicates whether the campaign uses the drag-and-drop editor.

Tracking_Opens Boolean True

Indicates whether opens are tracked. Defaults to 'true'.

Tracking_HtmlClicks Boolean True

Indicates whether clicks in the HTML version of the campaign are tracked. Defaults to 'true'.

Tracking_TextClicks Boolean True

Indicates whether clicks in the plain-text version of the campaign are tracked. Defaults to 'true'.

Tracking_GoalTracking Boolean True

Indicates whether Goal Tracking is enabled. For more information, see the Mailchimp Knowledge Base article at http://eepurl.com/GPMdH.

Tracking_Ecomm360 Boolean True

Indicates whether eCommerce360 tracking is enabled.

Tracking_GoogleAnalytics String True

The custom slug for Google Analytics tracking (max of 50 bytes).

Tracking_Clicktale String True

The custom slug for ClickTale Analytics tracking (max of 50 bytes).

Tracking_Salesforce String True

Salesforce tracking options for a campaign. Must be using MailChimp's built-in Salesforce integration.

Tracking_Capsule String True

Capsule tracking option sfor a campaign. Must be using MailChimp's built-in Capsule integration.

SocialCard_ImageUrl String True

The URL for the header image for the social card.

SocialCard_Description String True

A short summary of the campaign to display.

SocialCard_Title String True

The title for the card. Typically the subject line of the campaign.

TriggerSettings_Runtime String True

The advanced scheduling options for an automation email.

ReportSummary String True

For sent campaigns, a summary of opens, clicks, and unsubscribes.

WebId Integer True

The ID used in the Mailchimp web application. View this campaign in your Mailchimp account at https://{dc}.admin.mailchimp.com/campaigns/show/?id={web_id}.

TriggerSettings_WorkflowType String True

The type of Automation workflow.

The allowed values are abandonedBrowse, abandonedCart, api, bestCustomers, categoryFollowup, dateAdded, emailFollowup, emailSeries, groupAdd, groupRemove, mandrill, productFollowup, purchaseFollowup, recurringEvent, specialEvent, visitUrl, welcomeSeries.

TriggerSettings_WorkflowTitle String True

The title of the workflow type.

TriggerSettings_WorkflowEmailsCount Integer True

The number of emails in the Automation workflow.

Delay_ActionDescription String True

The user-friendly description of the action that triggers an Automation email.

Delay_FullDescription String True

The user-friendly description of the delay and trigger action settings for an Automation email.

NeedsBlockRefresh Boolean True

Indicates whether the automation email needs its blocks refreshed by opening the web-based campaign editor.

HasLogoMergeTag Boolean True

Indicates whether the campaign contains the |BRAND:LOGO| merge tag.

Recipients_ListIsActive Boolean True

Indicates whether the list associated with this automation email is active. A value of false indicates the list is deleted or disabled.

Recipients_ListName String True

The name of the list.

Recipients_RecipientCount Integer True

Count of the recipients on the associated list. Formatted as an integer.

Recipients_SegmentText String True

A description of the segment used for the campaign. Formatted as a string marked up with HTML.

Settings_PreviewText String False

The preview text for the campaign.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770