/
/
Rank your top ecommerce customers and spot the lapsing ones
For sales and account teams who want top customers by revenue with lapsing ones flagged, just by asking their AI assistant.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Finding top customers means exporting and sorting
To see your top customers you export store data and sort it by revenue, then look up order dates to learn who has gone quiet. Lapsing customers slip through the sort.
Without PopdockAI
- Export customers and orders from the store data
- Sort by lifetime revenue in a spreadsheet
- Look up the last order date for each customer
- Work out order counts and averages by hand
With PopdockAI
- Customers above your revenue threshold read from ActiveCampaign
- Latest orders checked for the top 10
- Revenue, order count, average order value and last order shown
- Customers with no order in 180 days marked lapsing, and nothing is edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List the top ecommerce customers with revenue of at least {min-revenue-cents} cents (default 100000), optionally for one connection {connection-id}.
**Step 1: Pull customers**
Call `activecampaign-get-ecomcustomer` with `total-revenue-cents.min` = {min-revenue-cents} and `connection-id` = {connection-id} when given.
**Step 2: Add recent orders**
For the top 10 call `activecampaign-get-ecomorder` with `customer-id` and read the latest order dates.
**Step 3: Report**
Table: email, total revenue (in currency units, cents divided by 100), order count, average order value, last order date. Mark customers with no order in 180 days as lapsing.
**Rules & Guidelines:**
* Read-only job. Do NOT call any write tool: no add, update, delete, sync, move, duplicate or bulk tool, in particular `activecampaign-ecom-customer-update` and `activecampaign-ecom-customer-delete`. If the user asks for a change, tell them to use a write prompt instead.
* Never guess an id. Only use ids returned by a tool in this run. Report only what the tools returned; say so when a value is missing.
**Validation:**
* If a lookup returns no records, say so and stop rather than widening the search silently.
* If a name or email matches more than one record, list the matches (id and key fields) and ask which one to use before continuing.
Who it's for
One answer, three teams that use it
Sales reps
Reach out to valuable customers
See top customers by revenue and which of them have gone quiet.
List ActiveCampaign ecommerce customers with over 5,000 in revenue and mark the lapsing ones.
Account managers
Protect repeat revenue
Spot high value customers with no order in six months before they leave for good.
Which of our top ActiveCampaign ecommerce customers have not ordered in 180 days?
Ecommerce managers
Understand customer value
See order counts and average order value for one store connection.
Show top customers for connection 3 with at least 1,000 in revenue.
How it works
What PopdockAI does when you ask
You set a revenue threshold and your AI assistant ranks the customers and checks their latest orders. It only reads, so no customer or order changes.
Ask
You give a minimum revenue, or use the default, and optionally one store connection.
Pull
It reads the ecommerce customers above that revenue from ActiveCampaign.
Orders
For the top 10 it reads their latest order dates.
Report
A table shows revenue, orders, average order value and last order, with lapsing customers marked.
What PopdockAI provides
The tools behind the answer
Ready made tools for ActiveCampaign and one secure connection to your AI tool. No code, no exports.
activecampaign-get-ecomcustomer
activecampaign-get-ecomorder
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 your top customers and who is lapsing
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)
