Connectors

/

Mailchimp

/

Mailchimp audience health check
Report

Know if your Mailchimp audience is growing or going cold

For marketing teams who want a clear verdict on an audience's health with specific fixes, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Mailchimp audience health check
How healthy is our Newsletter audience in Mailchimp over the last 6 months?
Verdict: Watch. The Newsletter audience lost members two months running. - Members: 12,480, rating 3, 24 percent average open rate - Net change: down 140 in August and 95 in September - Bounces: hard bounces at 2.6 percent of last month's sends - Pending: 310 contacts never confirmed First fix: clean the bouncing addresses before the next send. Want the monthly growth table?
Mailchimp
Sample figures. Your results come from your own account.
mailchimp-get-list
mailchimp-get-list-growth
mailchimp-get-list-activity
mailchimp-get-list-member
mailchimp-get-segment

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

Connect Mailchimp, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

An audience going cold before anyone notices

A Mailchimp audience can shrink or go cold for months, because growth, churn, bounces and pending confirmations each sit on a different report. By the time open rates drop, the list has already lost much of its value.

Without PopdockAI

  • Open growth, activity and bounce reports one by one
  • Work out net loss month by month
  • Check pending contacts and empty segments
  • Notice the decline only when open rates fall

With PopdockAI

  • Rating, rates, growth, sends, bounces and pending contacts are read
  • Net loss, rising cleaned addresses and bounce levels are weighed
  • You get a healthy, watch or at risk verdict with fixes
  • No member addresses are listed and nothing changes

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Assess the health of the Mailchimp audience `{list-name}` over the last {months} months (default 6), give a verdict of Healthy, Watch or At risk, and recommend what to do.

**Step 1: Resolve the audience**

Call `mailchimp-get-list` with `name` set to the audience name. If nothing matches, retry with `name.contains`. If more than one audience matches, list them and stop. Keep its list-id, number-of-members, list-rating, average-open-rate, average-click-rate, last-sent-date and members-added-since-last-send.

**Step 2: Growth and churn**

Call `mailchimp-get-list-growth` with `list-id`. For each month in the window, show subscribed, unsubscribed, cleaned and the net change (subscribed minus unsubscribed minus cleaned).

**Step 3: Recent activity**

Call `mailchimp-get-list-activity` with `list-id` and `activity-date.from` set to 30 days ago. Total the emails sent, hard and soft bounces, subscribes and unsubscribes.

**Step 4: Unconfirmed contacts**

Call `mailchimp-get-list-member` with `list-name` set to the audience, `status` set to `pending` and `max-records` set to 100. Report the count, or "at least 100" if the limit is reached.

**Step 5: Segments and tags**

Call `mailchimp-get-segment` with `list-id`. List each segment or tag with its type and member-count, and flag any with no members.

**Step 6: Report**

* The verdict and a one-sentence reason.
* Key numbers: members, list rating, average open and click rate, last-sent-date.
* The month-by-month growth table.
* Issues found, most serious first.
* 2 to 4 recommendations, each tied to an issue.

Signals to weigh:

* Net change negative for 2 or more months in a row: the audience is shrinking.
* Cleaned rising month on month: address quality is falling.
* last-sent-date more than 90 days ago: the audience is going cold, and the next send will bounce more than usual.
* Hard bounces above 2% of emails sent in the last 30 days.
* A large pending count: double opt-in confirmations are not being completed.

**Rules & Guidelines:**

* Read only. Do not call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-update-product`, `mailchimp-update-order`, `mailchimp-replicate-campaign`, `mailchimp-start-automation` or `mailchimp-pause-automation`.
* Rates are returned as fractions (0.25 means 25%). Show them as percentages.
* Do not list individual members' email addresses.

**Validation:**

* If growth history is empty, the audience is probably new. Report what is available and say so.
* If the audience has sent nothing in the last 30 days, say so rather than reporting zero rates as poor performance.

Who it's for

One answer, three teams that use it

Email marketers

Catch list decay before your next send

See net loss, rising bounces and stale sends in one verdict, with specific fixes to act on.

Is our Customers audience in Mailchimp healthy over the last 12 months?

Marketing managers

Report audience health in one answer

Get a healthy, watch or at risk verdict with reasons you can share with the team.

Give me a health check of the Prospects audience in Mailchimp for the last quarter.

Deliverability specialists

Spot bounce and churn problems early

Hard bounces over 2 percent and rising cleaned addresses are flagged before they hurt deliverability.

Are bounces or cleaned addresses rising in our Mailchimp Newsletter audience over the last 6 months?

How it works

What PopdockAI does when you ask

You name the audience and how many months to look back, and your AI assistant reads every health signal in one pass. It only reads and recommends.

01

Ask

You name the audience and how many months to look back.

Your AI tool

02

Read

It reads the rating, rates, monthly growth, recent sends, bounces and pending contacts.

mailchimp-get-list
mailchimp-get-list-growth
mailchimp-get-list-activity
mailchimp-get-list-member
mailchimp-get-segment

03

Weigh

It checks for net loss, rising cleaned addresses, no recent send and high bounces.

No items found.

04

Report

You get a verdict and 2 to 4 recommendations, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Mailchimp and one secure connection to your AI tool. No code, no exports.

get-data

mailchimp-get-list

Returns Mailchimp lists (audiences) with member counts, open and click rates, and recent campaign activity.
get-data

mailchimp-get-list-growth

Returns month-by-month growth history for each Mailchimp audience: new subscribers, unsubscribes, cleaned and imported members.
get-data

mailchimp-get-list-activity

Returns daily activity totals for each Mailchimp audience: emails sent, opens, clicks, bounces, subscribes and unsubscribes.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
get-data

mailchimp-get-segment

Returns the segments and tags defined on Mailchimp audiences, with their type, conditions and member counts.
Read only.Nothing in Mailchimp Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Know whether your audience is growing or decaying

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation