Connectors

/

Rillet

/

Find Rillet customers missing from a Mailchimp audience
Report
Cross-Connector

See how well your Mailchimp audience covers Rillet customers

For marketers who want to know which Rillet customer emails are missing from a Mailchimp audience, and which are unsubscribed or pending.

Try PopdockAI free
Get a live demo
Find Rillet customers missing from a Mailchimp audience
Which Rillet customers are missing from our Customers audience in Mailchimp?
Of 214 Rillet customer emails, 29 are not in the Customers audience. - Missing: 29, including ap@fabrikam.com - Unsubscribed or cleaned: 12 - Awaiting opt-in: 5 Want the list of missing emails?
Rillet
Sample figures. Your results come from your own account.
mailchimp-get-list
rillet-get-customer-emails
mailchimp-get-list-member

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

The problem

You cannot tell how much of your customer base your audience covers

Knowing how well a Mailchimp audience covers your customers means lining up every Rillet customer email against it. By hand it is slow, case differences hide matches, and unsubscribed or pending members get lumped in with everyone else.

Without PopdockAI

  • Export Rillet customer emails and audience members
  • Clean case and spacing so matches line up
  • Sort out unsubscribed, cleaned and pending members
  • Guess whether the export was complete

With PopdockAI

  • Every customer email and the full membership read in one pass
  • Addresses matched regardless of case or spacing
  • Missing, unsubscribed, cleaned and pending listed apart
  • A clear note when the comparison is partial, and nobody added

The prompt

Use this prompt

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

Prompt
**Objective:** Show how well the Mailchimp audience `{list-name}` covers the contacts on Rillet customers, and list the gaps.

**Step 1: Confirm the audience**

Call `mailchimp-get-list` with `name.contains` set to `{list-name}`. If exactly one audience matches, note its `name`, `list-id` and `number-of-members`. If several match, list them and stop so the user can choose; if none match, say so and stop.

**Step 2: Read both sides in full**

* Call `rillet-get-customer-emails` (no filters) to get every Rillet customer email with its `customer-id` and `name`.
* Call `mailchimp-get-list-member` with `list-name` set to the confirmed audience name and `max-records` large enough to cover `number-of-members` from Step 1. Keep `email`, `status` and `last-changed-date`.

Do not call the member tool once per email; compare the two sets in memory. Match emails case-insensitively after trimming spaces. A Rillet customer can have several emails (`email-type`), and one email can appear on more than one Rillet customer: keep every pairing and say so in the report.

**Step 3: Report**

1. Totals: Rillet customer emails, audience members, and how many Rillet emails are in the audience.
2. **Missing from the audience:** Rillet emails with no member row. Table: email, Rillet customer name, `customer-id`.
3. **In the audience but not reachable:** members whose `status` is unsubscribed or cleaned. Table: email, customer name, status, `last-changed-date`.
4. **Pending:** members still awaiting opt-in.
5. Optional one line: how many audience members are not on any Rillet customer (count only, do not list them).

**Rules & Guidelines:**

* Tools named mailchimp- come from the mailchimp MCP server; tools named rillet- come from the rillet MCP server. If a tool from either server is missing, stop and say which server is not connected rather than working around it.
* The only key shared by the two systems is the email address. Mailchimp `customer-id` values (e-commerce store customers) are NOT Rillet customer ids; never pass one system's id into the other.
* Read-only. Do not call any Mailchimp tool whose name starts with mailchimp-add-, mailchimp-update-, mailchimp-start-, mailchimp-pause- or mailchimp-replicate-, and do not call any Rillet tool whose name starts with rillet-add-, rillet-update-, rillet-apply-, rillet-unapply-, rillet-record-, rillet-set- or rillet-setup-. In particular never call `mailchimp-add-list-member`, `mailchimp-update-list-member` or `mailchimp-add-segment-member` from this prompt.
* This prompt only reports. Adding people is a separate prompt (`add-customers-to-audience`), and unsubscribed or cleaned contacts must never be re-added.

**Validation:**

* If `rillet-get-customer-emails` returns nothing, say there are no customer emails in Rillet and stop.
* If the member read returns fewer rows than `number-of-members`, say the comparison is partial and how many rows were read.

Who it's for

One answer, three teams that use it

Email marketers

Size the gap before an import

See how many customers are missing and who cannot be reached before you plan an import.

How many Rillet customers are not in our Newsletter audience in Mailchimp?

Campaign managers

Know your real reach to customers

Unsubscribed, cleaned and pending members are counted apart, so your reach number is honest.

Of our Rillet customers, how many are unsubscribed or cleaned in the Customers audience?

Marketing operations

Audit audience coverage regularly

A repeatable comparison of the billing base against your audience, with a warning when it is partial.

Compare all Rillet customer emails with our Mailchimp Product news audience and list the missing ones.

How it works

What PopdockAI does when you ask

You name the audience and your AI assistant compares it with every Rillet customer email. It reports only and never adds anyone.

01

Ask

You name the Mailchimp audience.

Your AI tool

02

Read

It reads every Rillet customer email and the full membership.

mailchimp-get-list
rillet-get-customer-emails
mailchimp-get-list-member

03

Report

You get totals, missing emails and unsubscribed, cleaned or pending members.

No items found.

04

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Rillet 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

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
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.
Read only.Nothing in Rillet 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 exactly which customers your audience misses

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