Table: mailchimp_automation_queue - Query Mailchimp Automation Queues using SQL

Mailchimp Automation Queues are a feature of Mailchimp, a marketing automation platform and an email marketing service. These queues contain emails that are waiting to be sent or are in the process of being sent as part of an automation. Automations are a way to send targeted emails that are triggered by a specific date, event, or contact's activity.

Table Usage Guide

The mailchimp_automation_queue table provides insights into Mailchimp's automation queues. As a marketing professional or business owner, you can explore details about the queued emails in your Mailchimp automations, including their status, the time they are scheduled to send, and the email addresses they are being sent to. Utilize this table to monitor your email marketing campaigns, ensure your automations are working as expected, and identify any potential issues.

Important Notes

You must specify the email_id in the where clause to query this table.

Examples

Basic info

Analyze the settings to understand the details of queued emails in a specific Mailchimp automation. This can be used to pinpoint the specific locations where a particular email is scheduled to be sent, providing insights into your email marketing strategy.

select
  id,
  email_id,
  email_address,
  list_id,
  next_send,
  workflow_id
from
  mailchimp_automation_queue
where
  email_id = '123abc';

select
  id,
  email_id,
  email_address,
  list_id,
  next_send,
  workflow_id
from
  mailchimp_automation_queue
where
  email_id = '123abc';

Check if an email is automated to be sent in the next 3 days

Gauge whether an automated email is scheduled to be dispatched within the next three days. This can be beneficial for managing communications and ensuring timely delivery of important messages.

select
  id,
  email_id,
  email_address,
  list_id,
  next_send,
  workflow_id
from
  mailchimp_automation_queue
where
  email_id = '123abc'
  and next_send <= now() - interval '3' day;

select
  id,
  email_id,
  email_address,
  list_id,
  next_send,
  workflow_id
from
  mailchimp_automation_queue
where
  email_id = '123abc'
  and next_send <= datetime('now', '-3 day');

Schema for mailchimp_automation_queue

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
email_address	text		The list member's email address.
email_id	text	=	A string that uniquely identifies an email in an Automation workflow.
id	text	=	The unique identifier for the automation.
list_id	text		A string that uniquely identifies a list.
next_send	timestamp with time zone		The date and time of the next send for the workflow email in ISO 8601 format.
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_queue