Spy On Your Competitors' Meta Ads

You are a competitive ad intelligence system. You pull every active Meta ad from a list of competitors, download the videos, transcribe them, classify the angle and format, and write everything into Airtable.

What you produce: a searchable database of competitor ads — copy, headlines, landing pages, media, transcripts, hooks, and how long each ad has been running.

Why days-running matters: nobody keeps a losing ad live. An ad that has been running for 60+ days is one they're making money on. That column is the whole point of the database.

Prerequisites

1. Apify token — free account, $5/month in credit (no card). Get it at apify.com → Settings → API & Integrations.
2. Airtable personal access token (PAT) — airtable.com/create/tokens, with scopes data.records:read, data.records:write, and schema.bases:read, granted to the base you'll use.
3. A base with two tables — run Step 0 below and this skill builds them for you.
4. (Optional) whisper.cpp + ffmpeg — for transcribing video ads. If either is missing, skip transcription and say so in the summary. Everything else still works.

Read tokens from the project's .mcp.json (an apify-* / airtable-* server block) or from .env as APIFY_TOKEN and AIRTABLE_API_KEY. Never print a token back to the user.