Build a Rank Tracker with a SERP API

CREATE TABLE IF NOT EXISTS positions (
  date    TEXT NOT NULL,   -- YYYY-MM-DD of the check
  keyword TEXT NOT NULL,
  country TEXT NOT NULL,   -- the country sent in the task body
  rank    INTEGER,         -- NULL when your domain is not in organic[]
  url     TEXT,            -- the matching result URL
  PRIMARY KEY (date, keyword, country)
);

import time, sqlite3, requests
H = {"Authorization": f"Bearer {KEY}"}
def track(kw, domain, country="US"):
    r = requests.post(f"{BASE}/v1/serp/google/organic/tasks", headers=H,
                      json={"q": kw, "country": country})
    if r.status_code != 202:          # 4xx/5xx: read the error body, do not poll
        raise RuntimeError(f"task not queued: {r.status_code} {r.text}")
    job = r.json()["job"]
    while job["status"] in ("queued", "running"):
        time.sleep(5)
        r = requests.get(f"{BASE}/v1/serp/tasks/{job['id']}", headers=H)
        r.raise_for_status()
        job = r.json()["job"]
    if job["status"] == "failed":
        return None, (job.get("error") or {}).get("retryable", False)
    hit = next((o for o in job["result"]["organic"] if domain in o["url"]), None)
    return (hit or {}).get("rank"), False

{"job":{"id":"<task_id>","kind":"google_organic","status":"failed","attempt_count":3,"max_attempts":3,
        "error":{"code":"<code>","message":"<message>","retryable":false}}}