Get a daily read on which Meta ads to scale or pause

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, notify

AD_ACCOUNT, SHEET_ID, TARGET_CPA = "act_1234567890", "your-spreadsheet-id", 25

@on_trigger
def run(event):
    data = http.get(f"https://graph.facebook.com/v21.0/{AD_ACCOUNT}/insights",
                    params={"level": "ad", "date_preset": "yesterday", "access_token": credentials.connection("facebook", "work"),
                            "fields": "date_start,ad_name,spend,clicks,ctr,actions"}).json()["data"]
    rows = [[d["date_start"], d["ad_name"], float(d["spend"]), int(d["clicks"]), float(d["ctr"]),
             sum(int(a["value"]) for a in d.get("actions", []) if a["action_type"] == "purchase")] for d in data]
    if not rows:
        return {"ads": 0}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Ads!A:F", valueInputOption="USER_ENTERED",
                                          body={"values": rows}).execute()
    table = "\n".join(f"{r[1]}: spend {r[2]}, clicks {r[3]}, CTR {r[4]}%, purchases {r[5]}" for r in rows)
    advice = ai.generate(f"Target cost per purchase: {TARGET_CPA}. For each ad say scale, pause, fix or too early, with a reason:\n{table}",
                         max_output_tokens=700).text
    notify.email_me("Meta Ads: what to change today", advice)
    return {"ads": len(rows)}