Ahrefs

Build me a daily rank tracker and site auditor for my own domain, the one slice of Ahrefs worth building solo. Requirements: - Python + httpx. Keywords live in keywords.txt, up to 50 terms; fetch positions from a SERP API (Serper.dev or SerpAPI, key in .env, free tiers cover a small list). Do not scrape Google directly, that just gets blocked. - Store keyword, position, ranking URL, and date in SQLite; run daily from cron. - A localhost dashboard (Flask + Chart.js): a sparkline per keyword and a biggest-movers-this-week list. - A technical audit crawler for my domain: follow internal links, flag broken links, missing or duplicate titles and descriptions, redirect chains, and pages under 200 words; write findings to audit.md. - Pull clicks and impressions per query from the Google Search Console API and show them beside the rank data. Warn me in the README: budget an hour for the Google Cloud console OAuth setup, it is the painful step. - Local only, no accounts, no telemetry. - Out of scope: backlink data, keyword volume and difficulty, and competitor research. Do not try to fake these by scraping; that dataset is the subscription. - README: API key setup, the Search Console connection steps, and a plain statement that Ahrefs is a proprietary web index and this replaces the dashboard, not the data.