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.

In short

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

Agent: Claude · Category: Marketing & growth

Steps in brief:

  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.

+3 more steps in the copyable prompt.

Who made it: Cody Schneider (X post, 8 Sep 2026) · source

Last updated · based on 336 use cases on agentsetups, each credited to its author.

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