Analyze repeat-purchase rate and your best customers

WooCommerceIntermediate~10 min

Before you start

A connected store with the WooCommerce integration enabled and its read abilities on.

Repeat-purchase rate is one of the few numbers that actually tells you whether the store is building something or just renting attention, and WooCommerce does not put it on a screen. Working it out by hand means exporting orders, deduping by customer, and counting who came back. This hands that arithmetic to the agent. It reads the orders and the customer list, does the counting, and tells you the rate plus who your best customers are.

The prompt
Work out my repeat-purchase rate. Read only, no changes. Pull the customer list
with each one's order count and total spent, and read the orders across [the
last 6 months]. Tell me how many customers placed more than one order and what
share of buyers that is, then rank my top [15] customers by total spent. While
you are in there, pull the best sellers for [that same window] so I can see
what the repeat buyers are actually coming back for. Put the repeat rate at the
top and the customer table underneath.

Why this is safe to run

This is three reads stitched into an analysis: the customer list, the orders, and the top-sellers report. None of them can create, edit, or delete a customer or an order, because every write in WooCommerce is a separate ability this recipe never calls. The customer list does return email addresses under the Integrations security disclaimer, so the readout is customer data and worth handling like any other export, but the agent cannot change a thing while it reads.

Already connected? Skip the paste. Ask your agent for the “repeat-purchase rate and best customers” recipe, or just ask it who your repeat buyers are, and it runs the same reads on your own store.

How it works

  1. List customers with their order count and total spent.
  2. Read orders across the window you name to see who bought more than once.
  3. Work out how many customers came back for a second order, and the share that did.
  4. Rank your top spenders and note what the best sellers were over the same period.
  5. Hand you a short readout with the rate up top and the customer list below.

Questions

Does this change any customer records?
No. Listing customers, listing orders, and reading the top-sellers report are all reads. It calculates from what is already there and writes nothing.
Will it show me customer email addresses?
The customer list includes email, returned under the Integrations security disclaimer, so treat the readout as you would any export of customer data. It never returns passwords or logins.