How AI Is Revolutionizing Ad Analysis
From Foxwell Founders Member Frederick Rode: How I Built an AI Creative Strategist | Insights from the Foxwell Meet-Up, Salt Lake City
Why It Matters
Manually tracking creative performance across every format and ad account doesn't scale. This system turns that grind into a single click, freeing strategists to spend their time on ideation and strategy instead of chasing data.
Frederick Rode built an AI Creative Strategist using Claude, Gemini, and Supabase to automate the manual grind of ad analysis
The system transcribes every Meta ad, tags hooks/angles/personas/awareness stages, and clusters what's actually working
It generates weekly creative reviews, grades ads by funnel stage, and surfaces gaps in the creative mix
Integrates with Claude Cowork and ClickUp to handle onboarding, research, and ticket creation automatically
Who This Is For
Creative strategists and agency owners managing multiple brands or ad accounts who are drowning in manual reporting and want a system that tells them what to make next, not just what happened last week.
At the Foxwell Founders Meet-Up in Salt Lake City, Frederick Rode took members behind the scenes on how he built his AI Creative Strategist. At its best, this tool is changing the way agencies think about creative strategy for performance ads. Keep reading as we break down what he shared, the tech he used, and how this approach is helping brands and agencies get sharper, move faster, and unlock way more creativity in their ad game.
Creative strategists today are juggling more ad formats, more data, and more pressure to figure out what’s working, and fast. Brands are running UGC, VSLs, founder videos, AI assets, lifestyle images, static graphics, carousels, and more. The amount of creative and performance data can be astronomical, and trying to keep up manually is nearly impossible.
Because of this, Frederick built an AI-powered system to handle all the creative strategy heavy lifting. Analyzing every ad, spotting patterns, and surfacing the insights that actually matter. He took his years of creative strategy SOPs, plugged them into AI platforms like Claude and Gemini, hooked up ad platform APIs, and used Supabase as the data backbone. The system transcribes every Meta ad, tags all the key stuff (hooks, angles, personas, awareness stages, visual openers, formats) and clusters what’s working. It finds the gaps, spits out new concepts, and even gives you a weekly creative strategy overview, grading ads by funnel stage and surfacing what’s trending. Then, with integrations like Claude Cowork and ClickUp, it runs research, helps onboard brands, creates tickets, and makes the whole workflow smoother. With this, strategists can finally focus on high-level creative work rather than just chasing data.
Let’s break down how this system works and what it means for creative strategists and performance marketers.
Real workflows, real tools, real operators and no theory. Subscribe to the newsletter and see what's actually working right now.
Automating Creative Analysis: How the AI Strategist Works
Forget digging through ad accounts and spreadsheets. Frederick’s AI strategist looks at every ad’s performance and creative data for you. Each ad gets transcribed, broken down into scenes, and tagged with all the details: persona, angle, awareness stage, visual opener, etc. All that data lives in Supabase (basically Google Sheets on steroids). That means Frederick and his clients can filter and cluster ads to pull analysis with a single click. You can instantly see which creative angles, hooks, or visual openers are crushing it and spot the gaps in your creative mix.
This automated analysis unlocks features such as weekly creative reviews, funnel stage comparisons, and a grading system that benchmarks each ad by where it sits in the funnel. The AI can even chat with all this data, so you can ask things like, 'What are my top hooks?' or 'Which visual openers are actually performing best?'
Strategic Benefits and Real-World Impact
Frederick rolled this system out for other agencies and brands, too, and the results are pretty wild. Teams are spending way less time on manual reporting and analysis, and way more time on creative work, ideation, and strategy. With solid SOPs in place, you actually get actionable data and not just another dashboard collecting dust.
The AI strategist helps you create and iterate on ad concepts by showing which personas, angles, and awareness stages are missing or really working. It spits out new concepts, tracks feedback, and lets strategists focus on refining ideas and scaling what’s working. Weekly reviews call out which funnel stages need fresh creative, and the system tells you exactly what to make next.
Integrating with Existing Workflows
Since the AI strategist plugs right into tools like Cloud Cowork and ClickUp, it slides into your existing workflow without a hitch. Approve a concept? It creates a ticket. Onboarding a new brand? It helps with research and setup. All of this helps you spend less time on logistics and more time solving creative problems for agencies and brands.
Final Thoughts: The Creative Strategist’s New Toolkit
Building this AI-powered system has totally changed how Frederick approaches creative strategy. Now he gets a bird’s-eye view of entire ad accounts, spots patterns you’d usually miss, and can move faster and more effectively. But the real win is that it frees up time for creative research, strategic thinking, and building campaigns that actually win.
Want access to the code and a step-by-step tutorial? Foxwell Founders Members get exclusive access to game-changing resources like this. Plus a front-row seat to the latest creative breakthroughs and agency-tested strategies. Not a member yet? This is just a taste of what you’re missing inside. Discover more and see why top creative strategists are joining.
Creative strategists don't grow in a vacuum. Get access to top-level strategists, SOPs, and a community built to sharpen your creative game at The Hive Haus.
Note: This blog was written by a human, but AI helped draft the outline and synthesize ideas.
