Tutorial module
Marketing Analyst 101
Go from zero to a working marketing analyst that pulls Google Ads, Klaviyo, and GA4 into DuckDB - then lets an AI agent answer real attribution and CAC questions. The AI agent is the coder - every step is a plain-English prompt.
What
- Pull Google Ads, Klaviyo, and GA4 into a single local DuckDB database
- Build staging + reports layers so the AI agent has a unified cross-channel surface
- Answer real attribution questions - blended CAC, ROAS by channel, paid-vs-owned overlap
How
- Bruin CLI scaffolds the pipeline; ingestr connectors handle the data pulls
- Bruin MCP gives Claude Code, Cursor, or Codex direct query access to your database
- Pipeline-scoped
AGENTS.md+bruin ai enhanceteach the agent your domain - no SQL or Python by hand
Learn the modern-marketing-analyst stack in one sitting: pull ad spend, email campaign engagement, and web analytics into a single local database, then ask an AI agent the attribution and CAC questions your team is usually stuck guessing at. Everything runs on your laptop. The AI agent does the typing - you prompt it in plain English and approve what it does.
The stack you'll build
- Google Ads - campaigns, clicks, cost, conversions
- Klaviyo - email sends, opens, clicks, unsubscribes
- Google Analytics 4 (GA4) - sessions, users, conversions, source/medium
- DuckDB - local database, no cloud account needed
- Bruin CLI + MCP - your AI agent's hands and eyes into the data
What you'll be able to do by the end
- See blended CAC by channel across paid, owned (email), and organic
- Trace a Google Ads click → email signup → GA4 purchase without a fancy BI tool
- Ask natural-language questions like "which ad campaigns drove high-LTV customers?" and get SQL-backed answers
Who this is for Marketers, founders, and growth operators who don't code but are tired of waiting on a data team for every question. If you can install an app and log into your ad accounts, you have the prerequisites.
Before you start
- An AI coding tool - Claude Code, Cursor, or Codex (the agent does the typing)
- Bruin CLI - the agent installs this for you in Step 1
- Access to a Google Ads, Klaviyo, and Google Analytics 4 account (or use the sandbox accounts in Step 3)
- 1Set Up Your Workspace8 min
- 2Scaffold Your Project5 min
- 3Ingest Google Ads, Klaviyo, and GA414 min
- 4Build Staging + Report Layers12 min
- 5Teach the AI Your Domain10 min
- 6Ask the Real Marketing Question8 min
Resources
Get help & contribute