Case 02
Acervo
A spreadsheet nobody could read became a web app that takes a few steps. Built in about three days for an advertising agency team.
- Client
- Advertising agencyConfidential · team of 13 · 2026
- Role
- Audit, product, UI and buildFrom the audit to deploy
- Deliverables
- Internal web app and public demoPhoto bank, status filters, usage rules and report
- Tools
- Claude Code, Supabase and VercelCode, database and publishing
Demofictional brand, photos and people
The problem
The same photos kept coming back.
An agency account had a bank of 103 photos from a photo shoot, used by five art directors in the monthly pieces. Tracking lived in a spreadsheet that had to be updated after every use and that nobody could read. So the same photos kept coming back while others were never used.
Decision 01
Audit before design.
Before designing any screen, I needed to know what had already been used. With AI, I went through 64 pieces one by one, slide by slide. Of the 103 photos, 60 had never been used.
Decision 02
Three states per photo.
Nobody wants to count. Each photo shows one of three states: never used, used or heavily used. One click filters the bank, and the designer sees at once what is still available.
Filternever used
Decision 03
The rule where you need it.
Every photo shoot comes with usage rules, like which models can appear in which themes. In Acervo, the warning sits on the photo itself, right when you choose it.
Photo detailusage rule
Decision 04
A report for the people who answer to the client.
The coordinators need to tell the client how many photos were used and how many are left. The report shows uses per month, pieces and the most used photos, without opening a spreadsheet.
Report
Light mode
Live demo
Try it.
This is the real app, with a fictional brand, photos and people. Filter, open a photo, mark a few and register a use. Everything resets when the page reloads.
How AI came in
From spreadsheet to app in about three days.
AI helped with the audit and wrote the code. I defined what the app had to solve, designed the interface and the rules, and checked every number. It went from a single file for one person to a web app for a team of 13.
What changed
A confusing task became a few steps.
The designers check the Acervo every week before choosing a photo. The coordinators answer the client without opening a spreadsheet.
Next case
Juliana Lino Arq.