Share weekly Business Profile results in Slack

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

LOCATION = "accounts/1234567890/locations/9876543210"
METRICS = ["BUSINESS_IMPRESSIONS_MOBILE_MAPS", "BUSINESS_IMPRESSIONS_MOBILE_SEARCH", "CALL_CLICKS", "BUSINESS_DIRECTION_REQUESTS"]
STARS = {"ONE": 1, "TWO": 2, "THREE": 3, "FOUR": 4, "FIVE": 5}

@on_trigger
def run(event):
    auth = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    end, start = date.today() - timedelta(days=1), date.today() - timedelta(days=7)
    params = [("dailyMetrics", m) for m in METRICS] + [(f"dailyRange.{k}Date.{p}", getattr(d, p)) for k, d in
              (("start", start), ("end", end)) for p in ("year", "month", "day")]
    data = http.get(f"https://businessprofileperformance.googleapis.com/v1/{LOCATION.split('/', 2)[2]}:fetchMultiDailyMetricsTimeSeries",
                    params=params, headers=auth).json()
    totals = {s["dailyMetric"]: sum(int(v.get("value", 0)) for v in s["timeSeries"].get("datedValues", []))
              for s in data["multiDailyMetricTimeSeries"][0]["dailyMetricTimeSeries"]}
    reviews = http.get(f"https://mybusiness.googleapis.com/v4/{LOCATION}/reviews", headers=auth).json().get("reviews", [])
    week = [r for r in reviews if r["createTime"][:10] >= start.isoformat()]
    stars = [STARS[r["starRating"]] for r in week]
    facts = (f"Calls {totals.get('CALL_CLICKS', 0)}, directions {totals.get('BUSINESS_DIRECTION_REQUESTS', 0)}, views "
             f"{totals.get('BUSINESS_IMPRESSIONS_MOBILE_MAPS', 0) + totals.get('BUSINESS_IMPRESSIONS_MOBILE_SEARCH', 0)}, "
             f"{len(week)} new reviews" + (f" (avg {sum(stars) / len(stars):.1f}★)" if stars else ""))
    summary = ai.generate(f"Summarise this week for a local business team in two sentences. Numbers: {facts}. "
                          f"Review texts: {[r.get('comment', '')[:300] for r in week]}", max_output_tokens=150).text
    notify.slack(f"*Google profile, week of {start}*\n{facts}\n{summary}", channel="#marketing")
    return {"facts": facts}