Google Ads Automation
Proprietary multi-account ad management tool
Overview
A Python-based CLI tool for managing Google Ads campaigns across multiple client accounts. Built as an internal agency automation system, it provides centralized reporting, budget monitoring, spend pacing analysis, and campaign management through a single MCC (Manager Account) architecture - with safety-first design that prevents accidental campaign changes.
The Challenge
Managing Google Ads across 20+ client accounts means constant context switching between dashboards, manual report compilation, and the ever-present risk of making changes to the wrong account. The Google Ads UI wasn't built for agency-scale operations - there's no unified view, no spend pacing alerts, and no safety net for bulk operations.
The Solution
We built a CLI tool powered by the Google Ads API with proper MCC hierarchy handling. It includes 20+ pre-built GAQL query templates covering campaign performance, budget utilization, conversion tracking, anomaly detection, and change history auditing. All write operations default to dry-run mode - pausing or enabling campaigns requires an explicit execute flag. The tool exports CSV reports for client deliverables and uses Rich for color-coded terminal output with real-time status visibility.
Tech Stack
Results
Multi-Account MCC
Manages 20+ client accounts from a single Manager Account with proper hierarchy handling
20+ GAQL Templates
Pre-built queries covering performance, budgets, conversions, anomaly detection, and audit trails
Safe by Default
All write operations run in dry-run mode - mutations require an explicit --execute flag
Structured Reporting
CSV exports, spend pacing analysis, and color-coded terminal output for instant campaign visibility
Related Service
AI-Powered PPC Management