Find BigCommerce buyers who are missing from Drip

**Objective:** Find customers who ordered in the last `{lookback-days}` days (default 90) with at least `{min-order-total}` in order value (default 0) and are not subscribers in Drip.

**Step 1: Get recent orders**

Call `bigcommerce-get-order` (bigcommerce server) with `date-created.from` set to the start of the window and `total-including-tax.min` set to `{min-order-total}` when it is above 0. Group the orders by `customer-id` and total `total-including-tax` per customer. Ignore orders with a `customer-id` of 0 (guest checkouts) but count them.

**Step 2: Get the customers**

For each distinct customer id call `bigcommerce-get-customer` (bigcommerce server) with `id`. Keep `email`, name and `company`.

**Step 3: Look each one up in Drip**

Call `drip-get-subscriber` (drip server) with `email` set to the customer's email. Record whether a person came back and its `status`.

**Step 4: Report**

A table of the customers with no Drip subscriber: name, email, order count, total spend, latest order date, sorted by total spend descending. Then a count of customers checked, customers found in Drip, guest orders skipped, and customers with no email.

**Rules & Guidelines:**

* `bigcommerce-get-customer`, `bigcommerce-get-order`, `bigcommerce-get-subscriber` are on the bigcommerce server. `drip-get-subscriber`, `drip-get-campaign-subscriber` are on the drip server.
* This prompt only reads. Never call any `bigcommerce-customer-add`, `bigcommerce-customer-update`, `bigcommerce-subscriber-add` or other bigcommerce add, update or delete tool, and never call `drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-unsubscribe-subscriber` or any other Drip write tool.
* Match people across the two systems on email address, compared case-insensitively after trimming spaces. Drip `person-id` and BigCommerce `id` are unrelated and must not be compared.
* If the user supplied a Drip account, pass it as `company` on every Drip call; otherwise omit `company`.

**Validation:**

* If no orders come back in the window, say so and stop.
* Check at most 50 customers; if there are more, take the highest spenders and say how many were left out.
* A customer with no email cannot be matched; list them separately.