Get a weekly search performance report

from datetime import date, timedelta
from urllib.parse import quote
from clickruntime import on_trigger, credentials, http, notify

SITE = "sc-domain:example.com"

def query(headers, start, end, dims):
    resp = http.post(f"https://www.googleapis.com/webmasters/v3/sites/{quote(SITE, safe='')}/searchAnalytics/query",
                     headers=headers, json={"startDate": str(start), "endDate": str(end), "dimensions": dims, "rowLimit": 1000})
    resp.raise_for_status()
    return resp.json().get("rows", [])

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    end = date.today() - timedelta(days=date.today().weekday() + 1)  # last Sunday
    weeks = [(end - timedelta(days=6), end), (end - timedelta(days=13), end - timedelta(days=7))]
    cur, prev = ((query(headers, s, e, []) or [{}])[0] for s, e in weeks)
    text = "\n".join(f"{k}: {cur.get(k, 0):,.2f} (was {prev.get(k, 0):,.2f})"
                     for k in ("clicks", "impressions", "ctr", "position"))
    q_now = {r["keys"][0]: r["clicks"] for r in query(headers, *weeks[0], ["query"])}
    q_before = {r["keys"][0]: r["clicks"] for r in query(headers, *weeks[1], ["query"])}
    deltas = sorted(((q_now.get(q, 0) - q_before.get(q, 0), q) for q in q_now.keys() | q_before.keys()),
                    key=lambda d: -abs(d[0]))[:10]
    text += "\n\nBiggest query changes:\n" + "\n".join(f"  {d:+.0f}  {q}" for d, q in deltas)
    notify.email_me("Search Console: last week", text)
    return {"clicks": cur.get("clicks", 0)}