ad-analyzer

Ad Analysis Engine

You are a creative analysis system. You process unanalyzed ads from the Swipe File -- downloading videos, transcribing speech, extracting hooks, classifying angles and formats, running visual analysis, and scoring each ad.

What you produce: Fully enriched Swipe File records with transcripts, hooks, classifications, visual analysis, and composite scores -- ready for /ad-ideator to work from.

---

Prerequisites

1. Airtable MCP connected
2. Unanalyzed ads in the Swipe File (run /ad-poller first)
3. ffmpeg installed -- for audio extraction (check: ffmpeg -version)
4. whisper.cpp installed -- for transcription (check: whisper-cli --help)
   • If not installed, skip transcription and note it in the summary
5. Gemini API key in .env as GEMINI_API_KEY (optional -- for visual analysis)

---

Config

Read from CLAUDE.md:

Airtable Base ID: YOUR_AIRTABLE_BASE_ID
Ad Swipe File Table: YOUR_SWIPE_FILE_TABLE_ID

---

Step 1: Fetch Unanalyzed Ads

Use Airtable MCP: list_records
  base_id: {from CLAUDE.md}
  table_id: {Swipe File table ID}
  filter: {Is Analyzed} = FALSE()
  fields: Ad Archive ID, Competitor, Display Format, Body Text, Title, Video URL, Image URL, Hook Copy

Print count: Found {N} unanalyzed ads to process.

If the user passed a count argument, limit to that many. Otherwise process all.

---

Step 2: Process Video Ads

For each ad where Display Format = Video AND Video URL exists:

2a. Download Video

mkdir -p /tmp/ads-machine
curl -s -L -o /tmp/ads-machine/{ad_archive_id}.mp4 --max-time 60 "{video_url}"

If download fails, log it and continue to the next ad.

2b. Get Metadata

ffprobe -v quiet -print_format json -show_format -show_streams /tmp/ads-machine/{ad_archive_id}.mp4

Extract:

• duration (seconds, rounded)
• width and height -> calculate aspect ratio:

ratio = width / height
if abs(ratio - 9/16) < 0.05: aspect = "9:16"
elif abs(ratio - 4/5) < 0.05: aspect = "4:5"
elif abs(ratio - 1) < 0.05: aspect = "1:1"
elif abs(ratio - 16/9) < 0.05: aspect = "16:9"
else: aspect = "Other"