Google Ads optimization is easy to deprioritize — there are always more urgent things, and the account keeps spending either way. This stack removes the friction. Pull keyword and campaign performance from the Google Ads API and Search Console, run it through a structured Claude budget reallocation prompt, and get a prioritized action list: what to pause, what to scale, which bid adjustments to make. Weekly cadence. Under 30 minutes from data pull to Slack summary.
The Stack
The Prompt
This stack is built around the Channel Budget Reallocation Prompt. Here's the abbreviated version — the full prompt with all variables and usage notes is on its own page.
You are a B2B paid search specialist reviewing a Google Ads account for weekly optimization. Review the campaign and keyword performance data below. Identify campaigns and keywords with CPL above the target threshold — flag for pause or bid reduction. Identify campaigns with strong pipeline contribution and remaining budget headroom — flag for scaling. Surface any search terms in broad or phrase match that are consuming spend without converting. Output a structured optimization brief with specific bid, budget, and keyword actions.[ ... continued — see full prompt ]
The Workflow
-
Pull Google Ads performance data
Export the past 14 days of campaign and keyword data from the Google Ads API or UI — spend, clicks, conversions, CPL, impression share by campaign type.
-
Pull Search Console query data
Export Search Console queries for the same period. Identify branded vs. non-branded split and any queries triggering spend with no conversion intent.
-
Combine into the prompt
Paste both data exports into the Channel Budget Reallocation prompt. Add your target CPL, monthly budget cap, and any manual notes about campaign priorities.
-
Review the optimization brief
Claude outputs a structured brief: campaigns to scale, campaigns to pause or reduce, keywords to add as negatives, and specific bid adjustment recommendations.
-
Implement and log
Apply the recommended changes in Google Ads. Log the actions and rationale in Sheets. Post a summary of changes made to Slack for stakeholder visibility.
What This Replaces
- Hours of manual keyword-level analysis that only happens when something breaks
- Gut-feel bid adjustments with no documented rationale for what changed and why
- Account reviews that happen quarterly instead of weekly because the process takes too long
Related Stacks
New stacks drop weekly.
Each one includes the tools, the Claude prompt, and the workflow logic. Free — built for in-house B2B demand gen managers.