Table: mailchimp_store - Query Mailchimp Stores using SQL

Mailchimp Stores is a resource within the Mailchimp service that allows users to connect their online store to Mailchimp. Once connected, users can create targeted campaigns, automate helpful product follow-ups, and send back-in-stock messaging. It provides a centralized way to manage and monitor the performance of your online store.

Table Usage Guide

The mailchimp_store table provides insights into the stores connected within Mailchimp. As an e-commerce manager or digital marketer, explore store-specific details through this table, including the store name, currency code, domain, and primary locale. Utilize it to manage and monitor the performance of your online store, enabling targeted campaigns and effective product follow-ups.

Examples

Basic info

Explore the fundamental information related to your online store, such as its creation date, domain, platform, and primary locale. This can help you gain insights into your store's operational details and understand its configuration better.

select
  id,
  name,
  created_at,
  currency_code,
  domain,
  money_format,
  platform,
  primary_locale
from
  mailchimp_store;

select
  id,
  name,
  created_at,
  currency_code,
  domain,
  money_format,
  platform,
  primary_locale
from
  mailchimp_store;

Get contact info of each store

Explore which stores you have contact information for, allowing you to reach out for business communications or updates. This can be particularly beneficial when managing customer relationships or conducting marketing outreach.

select
  id,
  name,
  email_address,
  phone,
  address,
  timezone
from
  mailchimp_store;

select
  id,
  name,
  email_address,
  phone,
  address,
  timezone
from
  mailchimp_store;

Get details of the audience associated with each store

Explore the relationship between different stores and their associated audiences. This can help in understanding the reach of each store and strategizing marketing efforts accordingly.

select
  s.id as store_id,
  s.name as store_name,
  l.id as list_id,
  l.name as list_name,
  l.date_created as list_date_created,
  l.visibility as list_visibility
from
  mailchimp_store s,
  mailchimp_list l
where
  s.list_id = l.id;

select
  s.id as store_id,
  s.name as store_name,
  l.id as list_id,
  l.name as list_name,
  l.date_created as list_date_created,
  l.visibility as list_visibility
from
  mailchimp_store s,
  mailchimp_list l
where
  s.list_id = l.id;

List stores created in the last 30 days

Discover the segments that have recently added stores in the past 30 days. This is particularly useful for tracking growth and understanding recent market activity.

select
  id,
  name,
  created_at,
  currency_code,
  domain,
  money_format,
  platform,
  primary_locale
from
  mailchimp_store
where
  created_at >= now() - interval '30' day;

select
  id,
  name,
  created_at,
  currency_code,
  domain,
  money_format,
  platform,
  primary_locale
from
  mailchimp_store
where
  created_at >= datetime('now', '-30 day');

List stores which haven't been updated in the last 10 days

Explore which stores have not been updated recently to identify potential areas for review or maintenance. This is useful for ensuring your store information is current and accurate, which can enhance customer experience and business operations.

select
  id,
  name,
  created_at,
  currency_code,
  domain,
  money_format,
  platform,
  primary_locale
from
  mailchimp_store
where
  updated_at <= now() - interval '10' day;

select
  id,
  name,
  created_at,
  currency_code,
  domain,
  money_format,
  platform,
  primary_locale
from
  mailchimp_store
where
  updated_at <= datetime('now', '-10 day');

Schema for mailchimp_store

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
address	jsonb		The store address.
created_at	timestamp with time zone		The date and time the store was created in ISO 8601 format.
currency_code	text		The three-letter ISO 4217 code for the currency that the store accepts.
domain	text		The store domain. The store domain must be unique within a user account.
email_address	text		The email address for the store.
id	text	=	The unique identifier for the store.
list_id	text		The unique identifier for the list that's associated with the store.
money_format	text		The currency format for the store.
name	text		The name of the store.
phone	text		The store phone number.
platform	text		The e-commerce platform of the store.
primary_locale	text		The primary locale for the store.
timezone	text		The timezone for the store.
title	text		The title of the resource.
updated_at	timestamp with time zone		The date and time the store was last updated in ISO 8601 format.

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_store