/
/
Know who on your Drip list is a paying customer
For marketing and data teams who want Drip subscribers classed by Sage Intacct customer status, by asking their AI assistant.
On this page
Connector
Connect Drip, pick your AI tool and paste the prompt.
The problem
Marketing cannot tell customers from leads
Customer status lives in Sage Intacct, so marketing cannot see which Drip subscribers already pay. Matching by hand is slow, and names, phones and states drift apart unnoticed.
Without PopdockAI
- Export Drip subscribers
- Search Sage Intacct contacts for each email
- Check the linked customer's status
- Compare names and phones by eye
With PopdockAI
- Each email is found among Sage Intacct contacts
- Subscribers are classed as customer, inactive, contact or lead
- Name, phone and state differences are listed
- Duplicate emails are flagged and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Match Drip subscribers to Intacct customers by email and report who is already a customer, who is only a lead, and where the two systems disagree. Limit to subscribers tagged `{tag}` and created on or after `{created-since}` when those are given; by default check all subscribers, up to 200.
**Step 1: Read subscribers from Drip**
Call `drip-get-subscriber` with `max-records` 200, `tags.contains` set to the tag if one was given, and `created-date.from` set to the date if one was given. If exactly 200 come back, say the list was capped. If none come back, say so and stop.
**Step 2: Find each subscriber in Intacct**
For each subscriber email, call `intacct-get-contact` with `email` set to it. If a contact is found, take its company-name and call `intacct-get-customer` with `customer-name` set to it.
**Step 3: Classify**
* Customer: a contact matched and its company is an active Intacct customer.
* Inactive customer: a contact matched and the customer's status is not active.
* Contact without customer: a contact matched but its company-name matches no customer.
* Lead only: no Intacct contact has this email.
**Step 4: Compare the matched records**
For every matched pair, compare Drip first-name, last-name, phone-number and state with the Intacct contact's first-name, last-name, phone and state, and list each difference.
**Step 5: Report**
Counts per class, then one table per class: email, Drip name, lead-score, tags, Drip lifetime-value, and for matched rows the customer-name, customer-id and total-due. Finish with the field differences table.
**Rules & Guidelines:**
* `drip-get-subscriber` is on the drip server. `intacct-get-contact` and `intacct-get-customer` are on the intacct server.
* This prompt is read-only. Do not call `drip-update-subscriber`, `drip-add-subscriber-tag`, `intacct-update-contact`, `intacct-create-contact`, `intacct-create-customer` or any other write tool on either server. To turn a lead into a customer, point the user to the add-subscriber-as-customer prompt.
**Validation:**
* Compare emails case-insensitively, ignoring surrounding spaces.
* If several Intacct contacts share one email, list them all and flag the email as duplicated in Intacct.
* Compare phone numbers by digits only, and treat a two-letter state code and the full state name as the same value.Who it's for
One answer, three teams that use it
Marketing managers
Send the right message to each group
Split your list into customers, lapsed customers and leads before planning campaigns.
Which Drip subscribers tagged newsletter are inactive Sage Intacct customers?
Data analysts
Find records that disagree
Name, phone and state differences between the systems are listed for clean up.
Reconcile Drip subscribers with Sage Intacct and show where names or phone numbers differ.
Finance operations
Spot duplicate contacts in Sage Intacct
Emails shared by several Sage Intacct contacts are flagged so the customer file stays clean.
Which Drip subscriber emails match more than one Sage Intacct contact?
How it works
What PopdockAI does when you ask
You optionally give a tag or start date, and your AI assistant classes each Drip subscriber against Sage Intacct. It reports only.
01
Ask
You optionally give a tag or a start date.
02
Find
It reads Drip subscribers and finds each email among Sage Intacct contacts.
03
Classify
It classes each as customer, inactive customer, contact only or lead.
04
Report
You get the split and the name, phone and state differences.
What PopdockAI provides
The tools behind the answer
Ready made tools for Drip and one secure connection to your AI tool. No code, no exports.
drip-get-subscriber
sage-intacct-get-contact
sage-intacct-get-customer
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.
The outcome
Know who is a customer, lapsed customer or lead
Related use cases
More ways to put this data to work
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.

.webp)
