Combining Google Search Console, GA4, and DataForSEO in One Python Pipeline

If you're running SEO for a content site, your data lives in three places: Google Search Console has your rankings and impressions, GA4 has your traffic and engagement, and a third-party tool like DataForSEO has competitor positions and keyword difficulty. Checking each dashboard separately wastes time and misses the connections between them. I built a Python pipeline that pulls from all three APIs, merges the data into a single DataFrame, and scores every keyword by opportunity. This runs on Shatranj Live , a chess analytics platform where I publish 40+ SEO-optimized articles. Here's how it works. Architecture Overview ┌──────────────────┐ ┌──────────────┐ ┌───────────────┐ │ Google Search │ │ GA4 │ │ DataForSEO │ │ Console │ │ (via API) │ │ (via API) │ │ │ │ │ │ │ │ - Rankings │ │ - Sessions │ │ - SERP data │ │ - Impressions │ │ - Bounce │ │ - KD scores │ │ - CTR │ │ - Duration │ │ - Competitor │ │ - Clicks │ │ - Events │ │ positions │ └────────┬─────────┘ └──────┬───────┘ └───────┬─