Spark Google Ads Optimization

Complete Setup & Implementation Guide (Mac)

Tulsa's Fastest Home Buyers - Customer ID: 3718377312

⚠️ PREREQUISITE: Paid Claude Account Required

Before starting this setup, you must have a paid Claude Pro or Team subscription.

Why? The free Claude plan does not support MCP servers, which are required to connect to Google Ads.

Get Claude Pro: https://claude.ai/upgrade ($20/month)

⚠️ Do not proceed without a paid account - the MCP server will not work on the free plan.
⏱️ Estimated Time: 45-60 minutes to complete setup
📅 Baseline Date: January 29, 2026
💰 Potential Savings: ~$1,200/month in wasted ad spend

📦 Download Required Files

Download the complete package with all scripts, documentation, and MCP server files.

⬇️ Download Spark Google Ads Package

Package includes: Analysis scripts, MCP server, documentation, and implementation guides

📋 The Golden Workflow (Memorize This!)

Every time you want to work on this project, follow these 3 steps:

1. Open Terminal (Cmd + Space → "Terminal")
2. cd ~/Spark_Googleadwords
3. claude

This keeps everything organized and ensures Claude can access your project files.

1

Download & Extract Package

Download the Package

Click the download button above to get the complete Spark Google Ads package.

Extract to Your Home Directory

Open Terminal (press Cmd + Space, type "Terminal", press Enter)

Extract the package to your home directory:

# Navigate to your Downloads folder
cd ~/Downloads

# Extract the zip file
unzip Spark_GoogleAds_Package.zip

# Move it to your home directory
mv Spark_Googleadwords ~/

# Navigate to the project folder
cd ~/Spark_Googleadwords
✅ Success: You now have all project files in ~/Spark_Googleadwords

Verify Files

Check that you have all the required files:

ls ~/Spark_Googleadwords

You should see:

  • README.md
  • RECOMMENDATIONS.md
  • BENCHMARK-2026-01-29.md
  • QUICK-START.md
  • 6month-analysis.js
  • keyword-analysis.js
  • conversion-analysis.js
  • ad-copy-analysis.js
  • mcp-server/ (folder)
2

Install Claude Code

Prerequisites

  • macOS (you're on a Mac)
  • Node.js installed (run node --version to check)
  • Internet connection
💡 Don't have Node.js? Download from https://nodejs.org (choose LTS version)

Install Claude Code

In Terminal, run:

npm install -g @anthropic-ai/claude-code

Wait for installation (takes 1-2 minutes).

Verify Installation

claude --version
✅ Success: You should see a version number like "1.x.x"
3

Get Your Google Ads API Credentials

⚠️ Important: This step is complex! Your manager will walk you through this on Zoom. Claude Code can also help guide you through the process once it's set up.
📋 What You Need: You need your OWN Google Ads API credentials to connect Claude Code to the Google Ads account.

Required Credentials (4 items)

To connect Claude Code to Google Ads, you need these 4 credentials:

  1. Client ID - OAuth2 client ID (from Google Cloud Console)
  2. Client Secret - OAuth2 client secret (from Google Cloud Console)
  3. Developer Token - Google Ads API developer token (from Google Ads)
  4. Refresh Token - OAuth2 refresh token (generated via OAuth flow)

How to Get Credentials

During Your Zoom Call

Your manager will help you:

  • Either: Provide you with pre-generated credentials (fastest)
  • Or: Walk you through generating them in Google Cloud Console

💡 Tip: Use the CREDENTIALS-TEMPLATE.txt file (in the package) to keep track of your credentials as you get them.

Need to Generate Them Yourself Later?

Don't worry! Once Claude Code is set up, you can ask Claude:

Ask Claude: Help me generate Google Ads API credentials. I need to create OAuth2 credentials in Google Cloud Console and get a developer token. Walk me through the process step-by-step.

Claude will guide you through the entire process!

Spark Account Information

Account Name: Tulsa's Fastest Home Buyers

Customer ID: 3718377312

You'll use this Customer ID in your configuration in Step 4.

✅ Once You Have Credentials: Write them down or save them in CREDENTIALS-TEMPLATE.txt. You'll need them in the next step!
4

Setup Google Ads MCP Server

💡 Good News: Claude Code will handle all the technical setup for you! You just need to paste a simple prompt and provide your credentials.

What is an MCP Server?

MCP (Model Context Protocol) servers allow Claude Code to connect to external services like Google Ads. Think of it as a bridge that lets Claude read and modify your Google Ads account.

Start Claude Code

First, make sure you're in the right folder and start Claude Code:

cd ~/Spark_Googleadwords
claude

Fill In Your Credentials

Enter your credentials from Step 3 below, then copy the auto-generated prompt:

📋 Customer ID: 3718377312 (Already set - no need to change)

Copy This Prompt to Give to Claude

After filling in your credentials above, click the copy button below:

I have my Google Ads API credentials. Help me set up the MCP server.

My credentials:
- Client ID: [YOUR_CLIENT_ID]
- Client Secret: [YOUR_CLIENT_SECRET]
- Developer Token: [YOUR_DEVELOPER_TOKEN]
- Refresh Token: [YOUR_REFRESH_TOKEN]
- Customer ID: 3718377312

I need to:
1. Install the MCP server dependencies (in ~/Spark_Googleadwords/mcp-server)
2. Create the Claude config file at ~/Library/Application Support/Claude/claude_desktop_config.json
3. Configure it with my credentials

Walk me through each step.

What Claude Will Do

Claude will automatically:

  • Install all required Node.js packages
  • Create the configuration file in the correct location
  • Set up your credentials securely
  • Test the connection to make sure it works
✅ Success: Once Claude completes the setup, your MCP server will be ready to connect to Google Ads!

After Setup is Complete

Claude will tell you to restart Claude Code. Exit and restart:

# Type "exit" in Claude Code, then:
cd ~/Spark_Googleadwords
claude
5

Restart Claude Code

📋 Quick Reminder: After MCP server setup, you need to restart Claude Code for the changes to take effect.

Restart Claude Code

Exit Claude Code and start it again from your project folder:

# In Claude Code, type:
exit

# Then restart from your project folder:
cd ~/Spark_Googleadwords
claude
✅ Remember: Always start Claude Code from ~/Spark_Googleadwords so Claude can access all your project files!
6

Verify MCP Server Connection

Before making changes, verify Claude can connect to Google Ads:

Prompt: Check if the Google Ads MCP server is connected. If it is, show me how many active campaigns are in the account.
✅ What to expect: Claude should return campaign data from the Spark account. If successful, you're ready to start optimizing!
⚠️ Troubleshooting: If you get an error:
  1. Exit Claude Code (type "exit")
  2. Verify config file: cat ~/Library/Application\ Support/Claude/claude_desktop_config.json
  3. Check that username and credentials are correct
  4. Restart Claude Code: cd ~/Spark_Googleadwords && claude
7

Review Current Account Status

📊 Baseline Metrics (January 29, 2026):
Metric Current Value Status
Total Keywords 256 ⚠️ Only 32 converting
Wasted Keywords 224 (87%) ⚠️ Need to pause
6-Month Spend $33,130
Overall CTR 1.61% ⚠️ Below 3-5% target
Conversion Values $0-$1 ⚠️ Broken tracking
Monthly Waste ~$1,200 ⚠️ Opportunity!

Read the Documentation

Ask Claude to read the project documentation:

Prompt 1: Read the BENCHMARK-2026-01-29.md file and summarize the current account status
Prompt 2: Read the RECOMMENDATIONS.md file and tell me what the Week 1 Quick Wins are
8

Implement Week 1 Quick Wins

⚠️ IMPORTANT: These changes will modify the live Google Ads account. Make sure you have approval before proceeding. These optimizations are expected to save ~$1,200/month.

Task 1: Identify Keywords to Pause

Prompt: Run the keyword-analysis.js script and show me all keywords with zero conversions in the last 6 months that have spent more than $50.

Task 2: Pause Non-Converting Keywords

Prompt: Using the MCP server, pause all keywords that have zero conversions and have spent more than $50. Show me the list before you pause them so I can confirm.

Expected result: ~220+ keywords paused, freeing up ~$1,200/month

Task 3: Fix Conversion Value Tracking

Prompt: Using the MCP server, update the conversion values to $500 for all conversion actions. This represents the average value of a property buyer lead.

Why this matters: Google's Smart Bidding uses conversion values to optimize. Setting accurate values will improve bidding performance by 20-30%.

Task 4: Add Negative Keywords

Prompt: Add the following negative keywords to the Tulsa-Search campaign to prevent wasting money on irrelevant searches: jobs, careers, reviews, franchise, license, scam, complaints, how to

Task 5: Increase Bids on Top Performers

Prompt: Based on the RECOMMENDATIONS.md file, increase bids by 30% on these top-performing keywords: "companies that buy houses", "sell my house asap", "we buy houses tulsa ok"
9

Verify Changes & Create Report

Verify Implementation

Prompt 1: Run the keyword-analysis.js script again and show me the new summary. How many keywords are active now?
Prompt 2: Run the conversion-analysis.js script and confirm the conversion values are now set to $500

Create Implementation Report

Prompt 3: Create a file called IMPLEMENTATION-REPORT-2026-01-29.md that documents: 1) What changes were made today, 2) How many keywords were paused, 3) The new conversion values, 4) Which negative keywords were added, 5) Which bids were increased and by how much, 6) Expected results in 30 days
10

Monitor & Follow Up

Expected Improvements (30 Days)

Metric Current Target (30 days) Improvement
Cost per Conversion $205 $155 -24%
Monthly Conversions 25 35 +40%
Phone Calls/Month 12 18 +50%
Overall CTR 1.61% 2.5%+ +55%

Weekly Check-In (Day 7)

Prompt: It's been 7 days since we implemented the Quick Wins. Run the keyword-analysis.js and 6month-analysis.js scripts and compare the last 7 days to the previous 7 days. Are we seeing improvement?

30-Day Performance Review

Prompt: It's been 30 days since implementation. Create a comprehensive performance report comparing: Cost per conversion, Total conversions, Phone calls, Overall CTR, Total spend. Compare to the BENCHMARK-2026-01-29.md file and tell me if we hit our targets.

📚 Additional Resources

For detailed information, refer to these files in your downloaded package:

Need Help? Contact your manager or refer to the documentation files

Spark Google Ads Optimization Project | Created: January 29, 2026
Account: Tulsa's Fastest Home Buyers (Customer ID: 3718377312)