Session Overview

Sam is live on Google Ads with three campaigns (Car Accidents English, Brand Protection, Spanish PI) and wants Claude to be able to directly make changes to campaigns via the Google Ads API, rather than giving Sam manual instructions. The prior session (see "SAIL Google Ads Deep Optimization" entry) had already migrated the Spanish campaign from 16 exact match to 23 broad match keywords with protective negatives, built out paste-ready negative keyword lists, and identified the need for tighter geo targeting and conversion action cleanup.

This session focused on: (1) extending Sam's forked google_ads_mcp with write tools so Claude can mutate campaign settings directly, (2) fixing expired OAuth credentials, (3) generating a fresh refresh token, (4) wiring the MCP into Claude Code, and (5) reorganizing the repo folder structure on Sam's Mac.

What Was Accomplished

1. New OAuth Credentials Stored in Notion

Sam uploaded a new OAuth client secret JSON from Google Cloud project lunar-arc-493119-a6. These were added to the Notion "A - Passwords" page (dc6e22b8-4666-4fa0-a9c5-e3c5fe4d6c1f) under the Google Ads section, labeled as the secondary/alt set. The primary credentials remain from project-claude-489923.

2. Six New Write Tools Built for google_ads_mcp

Created ads_mcp/tools/mutate.py with 6 tools:

  1. update_campaign_geo_targets: Add/remove location targets using geo target constant IDs.
  2. lookup_geo_targets: Search for geo target constant IDs by location name or zip code.
  3. list_campaign_geo_targets: List all current geo targets for a campaign.
  4. set_conversion_action_primary: Set a conversion action as primary (biddable) or secondary.
  5. update_call_duration_seconds: Update minimum call duration for phone call conversions.
  6. list_conversion_actions: List all conversion actions with current settings.

3. Stdio Server Entry Point Created

Created ads_mcp/server_stdio.py for Claude Code integration via stdio transport. Original HTTP server left intact.

4. Expired Refresh Token Fixed

Old token was expired/revoked. Created generate_refresh_token.py utility. Sam logged in with aguiarlawmarketing@gmail.com. New token saved to google-ads.yaml and Notion. Sam also added aguiarlawmarketing@gmail.com as a test user in the OAuth consent screen for project-claude-489923.

5. Credentials Verified Working

All modules loaded, get_ads_client() succeeded.