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_createdfrom mailchimp_template;
select id, name, active, category, created_by, date_createdfrom 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_createdfrom mailchimp_templatewhere active;
select id, name, category, created_by, date_createdfrom mailchimp_templatewhere 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_createdfrom mailchimp_templatewhere drag_and_drop;
select id, name, active, category, created_by, date_createdfrom mailchimp_templatewhere 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_createdfrom mailchimp_templatewhere type = 'user';
select id, name, active, category, created_by, date_createdfrom mailchimp_templatewhere 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_titlefrom 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_titlefrom 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 countfrom mailchimp_templategroup by category;
select category, count(*) as countfrom mailchimp_templategroup by category;
Schema for mailchimp_template
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
active | boolean | Returns whether the template is still active. | |
category | text | If available, the category the template is listed in. | |
created_by | text | = | The login name for template's creator. |
date_created | timestamp with time zone | >, >=, <, <=, = | The date and time the template was created in ISO 8601 format. |
drag_and_drop | boolean | Whether the template uses the drag and drop editor. | |
folder_id | text | = | The id of the folder the template is currently in. |
id | bigint | = | The ID for the application. |
name | text | The name of the application. | |
responsive | boolean | Whether the template contains media queries to make it responsive. | |
share_url | text | The URL used for template sharing. | |
thumbnail | text | If available, the URL for a thumbnail of the template. | |
title | text | The title of the resource. | |
type | text | = | 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