Table: mailchimp_template_folder - Query Mailchimp Template Folders using SQL

Mailchimp Template Folders are a feature within Mailchimp that allows users to organize and manage their campaign templates. These folders help in maintaining a structured and easily navigable template library. They are particularly beneficial for users with a large number of templates, enabling them to categorize templates based on various criteria such as campaign type, design, content, and more.

Table Usage Guide

The mailchimp_template_folder table provides insights into the template folders in Mailchimp. If you are a marketing professional or a campaign manager, this table is extremely beneficial for you as it allows you to explore details about your template folders, including their names, creation dates, and associated templates. Utilize this table to manage and organize your campaign templates more effectively and efficiently.

Examples

Basic info

Explore which Mailchimp template folders have the highest count to optimize your email marketing efforts. This can help in identifying popular templates and strategizing your marketing campaigns accordingly.

select
  id,
  name,
  count
from
  mailchimp_template_folder;

select
  id,
  name,
  count
from
  mailchimp_template_folder;

List templates in each folder

Explore which templates are associated with each folder in your Mailchimp account. This is useful for organizing and managing your email marketing campaigns.

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;

Schema for mailchimp_template_folder

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Mailchimp account ID.
count	bigint		The number of templates in the folder.
id	text		A string that uniquely identifies this template folder.
name	text		The name of the folder.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The title of the resource.

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_folder