Get a weekly support volume and CSAT report

import time
from clickruntime import on_trigger, http, credentials, notify

def intercom(method, path, **kw):
    r = http.request(method, f"https://api.intercom.io{path}", headers={
        "Authorization": f"Bearer {credentials.secret('INTERCOM_TOKEN')}", "Intercom-Version": "2.11"}, **kw)
    r.raise_for_status()
    return r.json()

def week(start, end):
    q = {"operator": "AND", "value": [{"field": "created_at", "operator": ">", "value": start},
                                      {"field": "created_at", "operator": "<", "value": end}]}
    convos, page = [], {"per_page": 150}
    while True:
        r = intercom("POST", "/conversations/search", json={"query": q, "pagination": page})
        convos += r["conversations"]
        nxt = (r.get("pages") or {}).get("next")
        if not nxt:
            break
        page = {"per_page": 150, "starting_after": nxt["starting_after"]}
    ratings = [c["conversation_rating"]["rating"] for c in convos if (c.get("conversation_rating") or {}).get("rating")]
    closed = sum(1 for c in convos if c["state"] == "closed")
    return len(convos), closed, (sum(ratings) / len(ratings) if ratings else 0)

@on_trigger
def run(event):
    now = int(time.time())
    this, prev = week(now - 7 * 86400, now), week(now - 14 * 86400, now - 7 * 86400)
    lines = [f"{label}: {a:.1f} (prev {b:.1f})" if label == "Avg rating" else f"{label}: {a} (prev {b})"
             for label, a, b in zip(["Opened", "Closed", "Avg rating"], this, prev)]
    notify.email_me("Intercom last week", "\n".join(lines))
    return {"opened": this[0]}