A Python pipeline pulls creative assets and copy from Meta, Google, and TikTok. For video, it samples frames with ffmpeg. Claude Sonnet 4.6 (vision) reads the image, the sampled frames, and the ad copy, and tags each creative into a structured taxonomy: format, aspect, hook type in the first seconds, UGC versus studio, on-screen text, product shown, offer, and claim. Those attributes become a creative dimension in BigQuery and are joined via dbt to the first-party attribution data and the contribution-margin model. A Lightdash dashboard surfaces which attributes drive the lowest-CAC, highest-margin new customers, and Claude Opus 4.8 turns the standout patterns into concrete creative briefs for the next round.
It joins directly to the attribution and margin warehouse, so creative is judged on profitable new customers rather than engagement.