Sort customers into champions, loyal, at-risk and lost

from collections import defaultdict
from datetime import datetime
from clickruntime import on_trigger, credentials, http, notify

STORE = "https://yourstore.com/wp-json/wc/v3"

@on_trigger
def run(event):
    auth = (credentials.secret("WC_CONSUMER_KEY"), credentials.secret("WC_CONSUMER_SECRET"))
    stats = defaultdict(lambda: {"last": None, "orders": 0, "spent": 0.0})
    page = 1
    while True:
        orders = http.get(f"{STORE}/orders", auth=auth,
                          params={"status": "completed", "per_page": 100, "page": page}).json()
        for o in orders:
            s = stats[o["billing"]["email"]]
            created = datetime.fromisoformat(o["date_created"])
            s["last"] = max(s["last"] or created, created)
            s["orders"] += 1
            s["spent"] += float(o["total"])
        if len(orders) < 100:
            break
        page += 1
    now, groups = datetime.now(), defaultdict(list)
    for email, s in stats.items():
        days = (now - s["last"]).days
        seg = ("champions" if days <= 30 and s["orders"] >= 3 else "loyal" if days <= 90
               else "at-risk" if days <= 180 else "lost")
        groups[seg].append(f"  {email}: {s['orders']} orders, ${s['spent']:,.2f}, last {days}d ago")
    body = "\n".join(f"{seg.upper()} ({len(groups[seg])})\n" + "\n".join(groups[seg])
                     for seg in ("champions", "loyal", "at-risk", "lost"))
    notify.email_me("Monthly customer segments", body)
    return {seg: len(v) for seg, v in groups.items()}