The agency’s working layer
At TrendAgency I build the internal tools the team uses every day for European sports clients: a sales pipeline, a performance dashboard, a design tracker and tools around live content operations.
- Year
- 2026 to present
- Role
- Business Development Analyst, TrendAgency
- Scope
- Sales pipeline, social performance dashboard, Design Tracking System, highlights tracker, post-game article drafting prototype
- Stack
- Cloudflare Pages, Functions, D1 and Access, Google Sheets as the data layer, ECharts, Python, no frameworks



TrendAgency handles social media, design and video for European sports organizations, among them EuroLeague Basketball, BKT EuroCup and EuroLeague Women. I joined in August 2026 as a Business Development Analyst, with no process, tools or documentation to build on. I work independently: the agency asks for a project, and I take it from scope to launch and do the design and the video myself. The first thing I built was the sales pipeline.
The rest came from watching where time went. Monthly social numbers lived in a spreadsheet and were reported by hand, so I built a dashboard on top of the same sheet: five accounts across Instagram, X, TikTok and YouTube, season against season, with an A4 report builder for each project. Design output had no record, so I built the Design Tracking System: every piece logged by project, designer, type and format, with 145 automated checks run after every change. The old tracker had died because it asked for a second visit to each row; this one asks for one.
- Thumbnail16x9D1Delivered
- Story9x16D2Delivered
- Social post1x1D3Delivered
- Cover16x9D1Delivered
- Card setPrintD4Delivered
- Motion9x16D2Delivered
- Announcement1x1D3Delivered
- BrandingPrintD4Delivered
Every row asks for a second visit.
- Thumbnail16x9D1Delivered
- Story9x16D2Delivered
- Social post1x1D3Delivered
- Cover16x9D1Delivered
- Card setPrintD4Delivered
- Motion9x16D2Delivered
- Announcement1x1D3Delivered
- BrandingPrintD4Delivered
Filed once. One visit per row.
An illustration of the sentence above. Job types and formats from the tracker’s own lists; designers shown as D1 to D4.
Two tools sit closer to content operations. The HL Tracker records, game by game, when highlights are ready after the final buzzer and when they go live on YouTube; league staff can open it too. I also built an internal prototype that drafts a post-game article in house style from official game data, based on 407 published articles. A draft takes under a minute. Quotes stay as empty slots for an editor, and a checker flags player stats and scores that do not match the data.
Sample game from the tool’s local test data, times in UTC+2 as the tool shows them. Played back, 100 minutes take 12 seconds.
Together they are the tools the team uses every day.
Five accounts across Instagram, X, TikTok and YouTube, season against season, with an A4 report builder for each project.
Inside the agency · 2 of 5- Sales pipelineTemplate · no data
A sales pipeline built from scratch.
Pipeline
Today
- Social performance dashboardSample data
Five accounts across Instagram, X, TikTok and YouTube, season against season, with an A4 report builder for each project.
- Design Tracking SystemSample data
Every piece logged by project, designer, type and format, with 145 automated checks run after every change.
- HL TrackerSample data
Records, game by game, when highlights are ready after the final buzzer and when they go live on YouTube; league staff can open it too.
- Article drafting prototypeInternal prototype · no screen shown
Drafts a post-game article in house style from official game data, based on 407 published articles.
407published articles behind the drafting prototypeUnder a minutefor a draftQuotes stay as empty slots for an editor, and a checker flags player stats and scores that do not match the data.



Every screen here shows sample data, not client figures.
Working on something like this? Tell me what’s missing.
NextPlay