JD
All projects

AI Marketing Analyst

Google Ads AI

An AI analyst that reads your ad account and hands you ranked experiments.

Builder — pipeline, prompts, and analysis frameworkInternal tool

01

Problem

Ad account analysis is skilled, repetitive work: export performance data, eyeball which messages win, guess why, write variants, decide what to test next. Done well it takes an analyst a day per account, so it happens monthly at best — and the reasoning lives in one person's head.

The interesting question wasn't 'can AI write ad copy?' — it obviously can. It was: can AI do the analyst's job of explaining performance and choosing what to test next?

02

Solution

The pipeline treats analysis as a chain of narrow jobs. Structured campaign data flows in from the Google Ads API; the model receives normalized performance tables — not raw exports — and works through the same sequence a strong analyst would, one step per prompt.

The output isn't a chat answer. It's a ranked experiment queue: each recommendation carries the messaging theme it exploits, the evidence behind it, generated ad variants ready to launch, and an expected-impact score used for ranking.

Workflow

Pipeline

Each stage is a separate prompt with structured inputs and outputs — the model is never asked to 'analyze the account' in one gulp.

1

Google Ads API

Pull campaigns, ad groups, ads, and search terms with performance metrics via GAQL.

2

Extract campaigns

Normalize into performance tables: spend, CTR, CVR, CPA by ad and query cluster.

3

AI analyzes performance

The model explains variance — which ads over/underperform their ad group baselines and why.

4

Identify messaging themes

Winning and losing ads are clustered into themes: value props, hooks, CTAs, offer framing.

5

Generate new ad copy

Variants extend winning themes and attack untested angles, within character limits and brand voice.

6

Rank opportunities

Each idea is scored on evidence strength, spend headroom, and expected CPA impact.

7

Recommended experiments

Output: a prioritized test queue with hypothesis, variants, and success metric for each.

Perspective

How AI becomes a marketing analyst

The naive version — paste a CSV into a chat window and ask 'what should I do?' — produces confident garbage. The model has no baseline, invents causality, and averages away every interesting signal. What made this work was refusing to let the AI be a generalist.

Each stage does one analyst task with exactly the context that task needs. The performance-analysis prompt sees baselines and variance, not ad copy. The theme extraction prompt sees copy and outcomes, not budgets. By the time the model ranks experiments, it's synthesizing conclusions it derived stepwise — the same way a human analyst builds a recommendation they can defend.

The result reads like an analyst's memo, arrives in minutes instead of days, and runs weekly instead of monthly. The human's job moves up a level: approve, launch, and feed results back into the next cycle.

Challenges

What was hard, and what I did about it

LLMs are bad at arithmetic, good at explanation

Early versions let the model compute metrics — it got them wrong just often enough to be dangerous. All math moved into the pipeline; the model only interprets pre-computed tables.

Grounding 'why' in evidence

Models happily explain performance with plausible fiction. Every claim in the output must cite the specific ads and metrics it's based on, which makes hallucinated reasoning visible at review time.

Ranking without a crystal ball

Expected-impact scoring blends evidence strength with spend headroom — honest about uncertainty, but still opinionated enough to order the queue. Imperfect and vastly better than gut feel.

Tech stack

Built with

PythonGoogle Ads APIGAQLClaude APIPandasBigQueryPrompt chaining

Outcomes

What changed

  • Days → minutesfor a full account analysis with ranked recommendations
  • Weeklyanalysis cadence instead of monthly — every account, not just the big ones
  • Evidence-linkedevery recommendation cites the ads and metrics behind it

Future roadmap

Where it goes next

Closed-loop testing: push approved experiments back through the Ads API automatically

Cross-account theme mining — what's winning across the whole portfolio

Budget reallocation recommendations alongside creative ones

Next project

SEO Content Engine