AutomationEmails
A summary of the emails in an automation workflow.
テーブル固有の情報
AutomationEmails では、SELECT がサポートされています。
Select
SELECT * FROM AutomationEmails
Columns
Name | Type | Description |
Id [KEY] | String | A string that uniquely identifies the automation email. |
WorkflowId [KEY] | String | A string that uniquely identifies an automation workflow. |
Position | Integer | |
Delay_Amount | Integer | The delay amount for an automation email. |
Delay_Type | String | The type of delay for an automation email. |
Delay_Direction | String | Whether the delay settings describe before or after the delay action of an automation email. |
Delay_Action | String | The action that triggers the delay of an automation emails. |
CreateTime | Datetime | The date and time the campaign was created. |
StartTime | Datetime | The date and time the campaign was started. |
ArchiveUrl | String | The link to the campaign's archive version. |
Status | String | The current status of the campaign ('save', 'paused', 'sending'). |
EmailsSent | Integer | The total number of emails sent for this campaign. |
SendTime | Datetime | The time and date a campaign was sent. |
ContentType | String | How the campaign's content is put together ('template', 'drag_and_drop', 'html', 'url'). |
Recipients_ListId | String | The id of the list. |
Recipients_SegmentOpts | String | Segment options. |
Settings_SubjectLine | String | The subject line for the campaign. |
Settings_Title | String | The title of the campaign. |
Settings_FromName | String | The 'from' name on the campaign (not an email address). |
Settings_ReplyTo | String | The reply-to email address for the campaign. |
Settings_Authenticate | Boolean | Whether or not the campaign was authenticated by MailChimp. Defaults to 'true'. |
Settings_AutoFooter | Boolean | Automatically append MailChimp's default footer to the campaign. |
Settings_InlineCss | Boolean | Automatically inline the CSS included with the campaign content. |
Settings_AutoTweet | Boolean | Automatically tweet a link to the campaign archive page when the campaign is sent. |
Settings_AutoFbPost | String | An array of Facebook page ids (integers) to auto-post to. |
Settings_FbComments | Boolean | Allows Facebook comments on the campaign (also force-enables the Campaign Archive toolbar). Defaults to 'true'. |
Settings_TemplateId | Integer | The id for the template used in this campaign. |
Settings_DragAndDrop | Boolean | Whether the campaign uses the drag-and-drop editor. |
Tracking_Opens | Boolean | Whether to track opens. Defaults to 'true'. |
Tracking_HtmlClicks | Boolean | Whether to track clicks in the HTML version of the campaign. Defaults to 'true'. |
Tracking_TextClicks | Boolean | Whether to track clicks in the plain-text version of the campaign. Defaults to 'true'. |
Tracking_GoalTracking | Boolean | Whether to enable Goal racking. For more information, see this Knowledge Base article: http://eepurl.com/GPMdH |
Tracking_Ecomm360 | Boolean | Whether to enable eCommerce360 tracking. |
Tracking_GoogleAnalytics | String | The custom slug for Google Analytics tracking (max of 50 bytes). |
Tracking_Clicktale | String | The custom slug for ClickTale Analytics tracking (max of 50 bytes). |
Tracking_Salesforce | String | Salesforce tracking options for a campaign. Must be using MailChimp's built-in Salesforce integration. |
Tracking_Highrise | String | Highrise tracking options for a campaign. Must be using MailChimp's built-in Highrise integration. |
Tracking_Capsule | String | Capsule tracking option sfor a campaign. Must be using MailChimp's built-in Capsule integration. |
SocialCard_ImageUrl | String | The url for the header image for the card. |
SocialCard_Description | String | A short summary of the campaign to display. |
SocialCard_Title | String | The title for the card. Typically the subject line of the campaign. |
TriggerSettings_Runtime | String | The advanced scheduling options for an automation email. |
ReportSummary | String | For sent campaigns, a summary of opens, clicks, and unsubscribes. |