/
/
Order counts and revenue by status from ActiveCampaign
For finance teams who want e-commerce orders summarised by status and currency by their AI assistant.
On this page
Connector
Connect ActiveCampaign, pick your AI tool and paste the prompt.
The problem
Monthly order revenue is rebuilt from exports
Finance rebuilds revenue by order status each month from store exports. Totals are in cents, currencies are mixed, and zero value or email less orders are easy to miss.
Without PopdockAI
- Export orders for the month
- Convert cents to currency units
- Group by status and currency in a spreadsheet
- Miss orders with a zero total or no email
With PopdockAI
- Orders for the period are read directly
- Counts and revenue are grouped by status and currency
- Cents are converted for you
- Odd values are flagged, and no order 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:** Summarise ecommerce orders placed between {from-date} and {to-date} (default last 30 days), optionally for customer email {email}.
**Step 1: Pull orders**
Call `activecampaign-get-ecomorder` with `order-date.from`, `order-date.to`, and `email` = {email} when given.
**Step 2: Aggregate**
Group by `state-code` and by currency. Total price is in cents; convert to currency units for display.
**Step 3: Report**
Order count and revenue per state and currency, average order value, the 5 largest orders, and any odd values (zero total, missing email).
**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-order-update` and `activecampaign-ecom-order-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
Finance teams
Close the month faster
Get order counts and revenue by status and currency without rebuilding them from exports.
Summarise ActiveCampaign orders for last month by status and currency.
E-commerce managers
See your biggest orders
List the five largest orders and the average order value for a period.
What were the five largest ActiveCampaign orders in the last 30 days?
Customer support
Review one customer's orders
Limit the review to a single email to answer a billing question.
Summarise orders for dana@northwindtraders.com in ActiveCampaign this year.
How it works
What PopdockAI does when you ask
You give a period and your AI assistant reads the orders from ActiveCampaign and does the grouping and conversion. It only reads and never changes an order.
Ask
You give a date range and, if you like, a customer email.
Pull
It reads the e-commerce orders for the period from ActiveCampaign.
Aggregate
It groups by order status and currency and converts cents to currency units.
Report
You get counts, revenue, average order value, the five largest and odd values.
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-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
Order revenue ready without the export
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)
