Build a customer segment from order history

WooCommerceIntermediate~10 min

Before you start

WooCommerce enabled, with the order and customer read abilities turned on. No writes are involved.

Good targeting starts with a good list, and the raw material is your order history: who bought twice, who spent over a threshold, who only ever bought the one product and might come back for the rest. Pulling that by hand across orders and customers is the tedious part. This does the cross-referencing and hands you a clean segment. It is honest about where it stops: it builds the list, it does not send anything.

The prompt
Build me a customer segment. Read only, change nothing. I want [customers who
placed 2 or more orders in the last 6 months and spent over 200 total].
Work from the orders in that window, match them back to the customers behind
them, and pull each qualifying customer's name and email. Then give me the
finished segment as a plain-text table: name, email, order count, total spent,
and a one-line note on why each one qualified, so I can drop it straight into
my email tool. Do not contact anyone; just hand me the list.

Why this is safe to run

This is a partial recipe by design, and the honest boundary is worth stating plainly: it reads. It can list orders, list customers, and read a customer’s details to build the segment, and that is the end of what it does. There is no ability here to send an email, tag a customer, or push the list into another system, so the agent hands you the segment and the acting stays with you.

Because it is all reads, nothing on the store changes: no order, no customer, no record is touched. The one thing to keep in mind is that the list includes real customer emails, so treat the output the way you would any export of personal data. Every read runs against the capability of the user you bound the agent to and lands in the Activity Log.

Already connected? Skip the paste. Ask your agent for the “build a customer segment from order history” recipe, or just describe the segment you want, and it runs the same reads on your own store and hands you the list.

How it works

  1. List orders across the period and criteria you set.
  2. Cross-reference the customers behind those orders.
  3. Pull each matching customer's details to fill out the segment.
  4. Hand you the finished list (names, emails, why they qualified) as plain text you can export.

Questions

Does this email the segment or add it to a list somewhere?
No. There is no email-send or list ability here, so it cannot message anyone or push the segment into another tool. It builds the list and hands it to you, and you take it into your email or CRM yourself.
Can it change any of the customer or order records?
No. Every ability behind it is a read. It looks at orders and customers to assemble the list and writes nothing back.