2023AVADA 360
Internal tools for the agency team
Daily operations depended on spreadsheets, copy-pasting between systems and knowledge that only existed inside each person’s head.
Context
Inside the agency, every project came with repeated operational work: reporting progress, uploading content, checking campaign status and moving data from one tool to another. All of it was done by hand, and each person did it their own way.
What I did
- Internal dashboards that gather on one screen what used to require opening five: status of sites, campaigns and team tasks.
- Content importers and loaders for the high-frequency tasks: what used to be an afternoon of copy-pasting became a form and a button.
- Integrations between the existing tools via APIs and webhooks, so data travels on its own instead of being exported to Excel.
- Documentation for every tool: the goal was that anyone on the team could use them — and maintain them — without depending on me.
Outcome
The repetitive tasks of daily operations were visibly reduced and, more importantly, standardized: the process no longer changes depending on who runs it. The tools are still in daily use inside the agency.