turbot/mailchimp
steampipe plugin install mailchimp

Table: mailchimp_template - Query Mailchimp Templates using SQL

Mailchimp Templates are a resource within the Mailchimp platform that allows users to design and store email layouts for repeated use. They provide a centralized way to manage and customize the appearance of your emails, including their content, style, and layout. Mailchimp Templates help you maintain consistency in your email campaigns and save time by reusing designs.

Table Usage Guide

The mailchimp_template table provides insights into the templates within Mailchimp. As a Digital Marketing Specialist or Email Campaign Manager, explore template-specific details through this table, including design elements, settings, and associated metadata. Utilize it to manage and optimize your email campaigns, ensuring consistency and efficiency in your email marketing efforts.

Examples

Basic info

Explore which Mailchimp templates are active, who created them, and when they were created to better understand your email marketing efforts and strategies. This can help in assessing the effectiveness of different templates and their usage over time.

select
id,
name,
active,
category,
created_by,
date_created
from
mailchimp_template;
select
id,
name,
active,
category,
created_by,
date_created
from
mailchimp_template;

List active templates

Explore active templates to understand their origin and category. This can help in assessing which templates are currently in use and who created them, providing insights for potential updates or re-usage.

select
id,
name,
category,
created_by,
date_created
from
mailchimp_template
where
active;
select
id,
name,
category,
created_by,
date_created
from
mailchimp_template
where
active = 1;

List templates using drag and drop editor

Explore which email templates are created using the drag and drop editor in Mailchimp. This can help in identifying the templates that were quickly designed without the need for coding knowledge.

select
id,
name,
active,
category,
created_by,
date_created
from
mailchimp_template
where
drag_and_drop;
select
id,
name,
active,
category,
created_by,
date_created
from
mailchimp_template
where
drag_and_drop = 1;

List templates of type user

Explore which user-created templates are active within your Mailchimp account, providing a quick way to assess your personalized content and its creation details. This can be particularly useful for auditing your marketing efforts or identifying templates for future campaigns.

select
id,
name,
active,
category,
created_by,
date_created
from
mailchimp_template
where
type = 'user';
select
id,
name,
active,
category,
created_by,
date_created
from
mailchimp_template
where
type = 'user';

List templates in each folder

Explore which templates are organized in each folder in your Mailchimp account. This is useful for understanding your email marketing structure and identifying potential areas for reorganization or consolidation.

select
f.id as folder_id,
f.name as folder_name,
t.id as template_id,
t.title as template_title
from
mailchimp_template t
left join mailchimp_template_folder f on t.folder_id = f.id;
select
f.id as folder_id,
f.name as folder_name,
t.id as template_id,
t.title as template_title
from
mailchimp_template t
left join mailchimp_template_folder f on t.folder_id = f.id;

Get template count by category

Determine the areas in which different categories of Mailchimp templates are being used, allowing you to understand their popularity and usage frequency.

select
category,
count(*) as count
from
mailchimp_template
group by
category;
select
category,
count(*) as count
from
mailchimp_template
group by
category;

Schema for mailchimp_template

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The Mailchimp account ID.
activebooleanReturns whether the template is still active.
categorytextIf available, the category the template is listed in.
created_bytext=The login name for template's creator.
date_createdtimestamp with time zone>, >=, <, <=, =The date and time the template was created in ISO 8601 format.
drag_and_dropbooleanWhether the template uses the drag and drop editor.
folder_idtext=The id of the folder the template is currently in.
idbigint=The ID for the application.
nametextThe name of the application.
responsivebooleanWhether the template contains media queries to make it responsive.
share_urltextThe URL used for template sharing.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
thumbnailtextIf available, the URL for a thumbnail of the template.
titletextThe title of the resource.
typetext=The type of template.

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_template