Help for creative analysis skill
I need a solution for analyzing the week-over-week performance of creatives in order to identify top-performing creatives and derive insights for our creative strategy. Ideally, I would like to have an overview of creative performance that already includes a…
I need a solution for analyzing the week-over-week performance of creatives in order to identify top-performing creatives and derive insights for our creative strategy. Ideally, I would like to have an overview of creative performance that already includes a short explanation or interpretation of the results (e.g., why certain creatives performed better than others). The best-case scenario would be a workflow where I only receive a CSV file from the channel managers, and everything else happens automatically. Are there already any tools, software solutions, AI skills, or workflows that can handle this kind of automated creative performance analysis and generate strategic insights? Happy for any help. Greeting from Germany :)
Collected discussion
Are you interested in static / display creatives or videos also? (And for videos - ugc? Product demos/ motion graphics, rtc) And I assume you are interested in image analysis + KPis? (Hook rate/ vie throughs, etc) I am working on something like this but it’s not my main prio rn; happy to share what I have later on though.
Honestly, I think AI is great at summarizing the numbers, but I'd be careful trusting it to explain why a creative won. A CSV can tell you CTR, CPC, CPA, ROAS, etc., but it doesn't know that the hook was stronger or the UGC felt more authentic. If I were building this, I'd have AI do the repetitive work—flag winners/losers, compare week-over-week changes, spot trends, and generate a summary. Then I'd use those insights to make the creative decisions. A CSV → AI report → human review workflow sounds way more realistic than expecting AI to replace a creative strategist.
we built exactly this internally, so you don't necessarily need a tool. our setup: channel managers drop the weekly csv in a folder, a claude code skill reads it, compares every creative against account benchmarks (spend-weighted, not raw averages, otherwise one $50 test skews everything), flags fatigue when frequency climbs while ctr drops week over week, and writes a one-page report saying which angle/hook/format won and why. takes 2 minutes to run and replaced half a day of pivot tables. two honest notes from building it. the "why did this win" part is only as good as your naming convention. tag angle, hook and format in the ad name and the analysis gets 10x more useful. and if you'd rather buy than build, motion and foreplay both do creative reporting well, they're just overkill under ~50 active creatives imo. if you go the build route it's basically csv parsing plus a structured prompt, any dev on your team can stand it up in a week.