Get last week's profile stats every Monday

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

API = "https://api.sproutsocial.com/v1"

def sprout():
    h = {"Authorization": f"Bearer {credentials.secret('SPROUT_API_TOKEN')}"}
    cid = http.get(f"{API}/metadata/client", headers=h).json()["data"][0]["customer_id"]
    return h, cid

@on_trigger
def run(event):
    h, cid = sprout()
    profiles = http.get(f"{API}/{cid}/metadata/customer", headers=h).json()["data"]
    names = {p["customer_profile_id"]: f"{p['name']} ({p['network_type']})" for p in profiles}
    end = date.today() - timedelta(days=1)
    body = {"filters": [f"customer_profile_id.eq({','.join(map(str, names))})",
                        f"reporting_period.in({end - timedelta(days=6)}...{end})"],
            "metrics": ["impressions", "engagements", "net_follower_growth"]}
    rows = http.post(f"{API}/{cid}/analytics/profiles", json=body, headers=h).json()["data"]
    totals = {}
    for r in rows:
        t = totals.setdefault(r["dimensions"]["customer_profile_id"], {"impressions": 0, "engagements": 0, "net_follower_growth": 0})
        for k in t:
            t[k] += r["metrics"].get(k) or 0
    lines = [f"{names[p]}: {t['impressions']:,} impressions, {t['engagements']:,} engagements, {t['net_follower_growth']:+} followers"
             for p, t in totals.items()]
    notify.email_me("Sprout Social last week", "\n".join(lines))
    return {"profiles": len(lines)}