Table: mailchimp_automation_email - Query Mailchimp Automation Emails using SQL
Mailchimp Automation is a feature within Mailchimp that allows marketers to create targeted emails that send when triggered by a specific date, event, or contact's activity. It provides a way to build and manage automated marketing campaigns, including the ability to send a series of emails to contacts who meet certain conditions. Mailchimp Automation helps users stay informed about the performance of their marketing campaigns and take appropriate actions when predefined conditions are met.
Table Usage Guide
The mailchimp_automation_email
table provides insights into automation emails within Mailchimp. As a marketing professional, explore email-specific details through this table, including the status, send time, and associated metadata. Utilize it to uncover information about emails, such as those with high engagement rates, the timing of emails, and the verification of send conditions.
Examples
Basic info
Explore the timing, status, and associated workflow of your automated emails within Mailchimp. This allows you to gain insights into your email marketing strategy's effectiveness and make necessary adjustments.
select id, content_type, create_time, emails_sent, position, send_time, start_time, status, workflow_idfrom mailchimp_automation_email;
select id, content_type, create_time, emails_sent, position, send_time, start_time, status, workflow_idfrom mailchimp_automation_email;
Get delay settings of an automation email
Explore the delay settings of an automated email to understand how long it waits before taking action. This can be useful in optimizing the timing of your email campaigns.
select id, delay ->> 'action' as delay_action, delay ->> 'amount' as delay_amount, delay ->> 'direction' as delay_direction, delay ->> 'type' as delay_typefrom mailchimp_automation_email;
select id, json_extract(delay, '$.action') as delay_action, json_extract(delay, '$.amount') as delay_amount, json_extract(delay, '$.direction') as delay_direction, json_extract(delay, '$.type') as delay_typefrom mailchimp_automation_email;
Get recipient settings of an automation email
Explore the specific settings of automated emails to understand the recipient details and segmentation conditions. This can be beneficial in tailoring your marketing strategies by analyzing the recipient's segmentation conditions and preferences.
select id, recipients ->> 'list_id' as recipient_list_id, recipients -> 'segment_options' ->> 'conditions' as recipient_segment_conditions, recipients -> 'segment_options' ->> 'match' as recipient_segment_match, recipients -> 'segment_options' ->> 'saved_segment_id' as saved_segment_idfrom mailchimp_automation_email;
select id, json_extract(recipients, '$.list_id') as recipient_list_id, json_extract(recipients, '$.segment_options.conditions') as recipient_segment_conditions, json_extract(recipients, '$.segment_options.match') as recipient_segment_match, json_extract(recipients, '$.segment_options.saved_segment_id') as saved_segment_idfrom mailchimp_automation_email;
Get settings of an automation email
Analyze the settings of an automated email to understand its various features such as authentication, auto posting on Facebook, auto footer, drag and drop functionality, Facebook comments, sender's name, inline CSS, reply-to address, subject line, and title.
select id, settings ->> 'authenticate' as authenticate, settings ->> 'auto_fb_post' as auto_fb_post, settings ->> 'auto_footer' as auto_footer, settings ->> 'auto_tweet' as auto_footer, settings ->> 'drag_and_drop' as drag_and_drop, settings ->> 'fb_comments' as fb_comments, settings ->> 'from_name' as from_name, settings ->> 'inline_css' as inline_css, settings ->> 'reply_to' as reply_to, settings ->> 'subject_line' as subject_line, settings ->> 'title' as titlefrom mailchimp_automation_email;
select id, json_extract(settings, '$.authenticate') as authenticate, json_extract(settings, '$.auto_fb_post') as auto_fb_post, json_extract(settings, '$.auto_footer') as auto_footer, json_extract(settings, '$.auto_tweet') as auto_footer, json_extract(settings, '$.drag_and_drop') as drag_and_drop, json_extract(settings, '$.fb_comments') as fb_comments, json_extract(settings, '$.from_name') as from_name, json_extract(settings, '$.inline_css') as inline_css, json_extract(settings, '$.reply_to') as reply_to, json_extract(settings, '$.subject_line') as subject_line, json_extract(settings, '$.title') as titlefrom mailchimp_automation_email;
Schema for mailchimp_automation_email
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
archive_url | text | The link to the campaign's archive version. | |
content_type | text | How the campaign's content is put together. | |
create_time | timestamp with time zone | The date and time the campaign was created in ISO 8601 format. | |
delay | jsonb | The delay settings for the automation email. | |
emails_sent | bigint | The total number of emails sent for the campaign. | |
id | text | = | The unique identifier for the automation. |
position | bigint | The position of an automation email in a workflow. | |
recipients | jsonb | List settings for the campaign. | |
report_summary | jsonb | A summary of opens and clicks for sent campaigns. | |
send_time | timestamp with time zone | The date and time a campaign was sent in ISO 8601 format. | |
settings | jsonb | Settings for the campaign including the email subject, from name, and from email address. | |
social_card | jsonb | The preview for the campaign, rendered by social networks like Facebook and Twitter. | |
start_time | timestamp with time zone | The date and time the campaign was started in ISO 8601 format. | |
status | text | The current status of the automation. | |
title | text | The title of the automation email. | |
tracking | jsonb | The tracking options for the automation. | |
trigger_settings | jsonb | Available triggers for AutomationEmail workflows. | |
workflow_id | text | = | A string that uniquely identifies an automation workflow. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- mailchimp
You can pass the configuration to the command with the --config
argument:
steampipe_export_mailchimp --config '<your_config>' mailchimp_automation_email