Audit your Facebook ads agency with a data warehouse

Put ads, PostHog and CRM data in a warehouse, have a vision model analyse creatives, then let Claude Code find what works.

by Cody Schneider8 Sep 2026

Prompt for your agent

Goal: Audit my ads agency’s work using my own data.
Setup: agents used in source: Claude; tools/MCPs stated: PostHog, S3, Facebook Ads API.
Steps:
1. Get your ads, PostHog and CRM data into a data warehouse.
2. Give Claude Code access to the warehouse and an S3 bucket for storage.
3. Pull all ad creative and its conversion data.
4. Have a vision model analyse the creative, ad text and landing pages, and build a database from it.
5. Have Claude Code analyse that database to find what is and isn’t working.
6. Optionally give it a Facebook Ads API key to modify campaigns based on the analysis.
Rules: ask me before anything irreversible (sending, posting, paying, deleting); don’t invent data, results or tools I haven’t given you; tell me what you couldn’t verify.
Based on: Cody Schneider — https://x.com/codyschneider/status/2097369443344994336

Steps are from the source. Includes a “Based on” credit line.

I tried this

Tell the next builder. One anonymous answer each; click again to undo.

Agents, models and tools only what the source states

Agents
Claude
Tools
  • PostHog
  • S3
  • Facebook Ads API

Sources & credit