Know a WooCommerce customer's value and risk before you talk

**Objective:** Build a complete account review for the customer with email `{customer-email}`, looking back `{lookback-days}` days (default 365).

**Step 1: Find the customer**

Call `woocommerce-get-customer` with `email` = `{customer-email}`. Keep `customer-id`, name, `created-date`, `role`, `paying-customer`, billing city, state and country. If nothing matches, the person may only have guest orders: say so and continue with the email-based reads below.

**Step 2: Pull their activity**

Work out the start date as today minus the lookback. Then call:

* `woocommerce-get-order` with `customer-email` and `created-date.from`. If a `customer-id` was found, also call it with `customer-id` and merge by `order-id`, because a registered customer can order under a different billing email.
* `woocommerce-get-order-line` with `customer-email` and `date-created.from`, for what they buy.
* `woocommerce-get-refund` with `customer-email` and `created-date.from`.
* `woocommerce-get-product-review` with `reviewer-email` = `{customer-email}`.
* `woocommerce-get-customer-download` with `customer-email`, only if any line looks like a digital product.

**Step 3: Work out the numbers**

Treat orders with status `completed`, `processing`, `on-hold` and `refunded` as sales. Exclude `pending`, `failed`, `cancelled` and `trash` orders from every total.

* Order count and value, split by status; average order value; first and last order date; days since the last order.
* Top 5 products by quantity, grouped by `line-sku` (fall back to `line-name`).
* Refunds: count, total, and refund rate as refunded amount / sales value.
* Reviews: count, average `rating`, any rated 2 or below.

**Step 4: Report**

1. Profile: name, email, customer id or "guest", registered since, location, role.
2. Summary table: orders, sales value, AOV, refunds, refund rate, net value, last order.
3. Orders table, newest first: number, date, status, total.
4. Top products.
5. Reviews and downloads (downloads with `downloads-remaining` 0 or a past `access-expires`).
6. Flags, each with the evidence: refund rate over 20%, two or more `failed` orders, orders stuck in `on-hold` or `pending`, low reviews, or no order in over 180 days.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any write tool: `woocommerce-add-order`, `woocommerce-update-order`, `woocommerce-add-order-note`, `woocommerce-send-order-details`, `woocommerce-add-refund`, `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-add-product`, `woocommerce-update-product`, `woocommerce-update-product-variation`, `woocommerce-add-coupon`, `woocommerce-update-coupon`.
* Pass `max-records` explicitly (500 unless stated otherwise). If a read returns exactly that many rows, say the result may be truncated and that totals are a lower bound.
* If the rows carry more than one `currency`, report each currency separately. Never add amounts across currencies.

**Validation:**

* If there is no customer record and no orders for the email, say so and stop.
* If `{lookback-days}` is empty or not a number, use 365.