Skip to content

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.

Eight jobs, one week Visits per row
The old trackerVisits 16
  • Thumbnail16x9D1Delivered
  • Story9x16D2Delivered
  • Social post1x1D3Delivered
  • Cover16x9D1Delivered
  • Card setPrintD4Delivered
  • Motion9x16D2Delivered
  • Announcement1x1D3Delivered
  • BrandingPrintD4Delivered

Every row asks for a second visit.

Design Tracking SystemVisits 8
  • 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.

Final buzzer → highlights → YouTube One game, two screens
Agency desk
Besiktas · OlympiacosRound 8 · tip-off 19:30
Final buzzer--:--
Highlights ready--:--
On YouTube--:--
The page EuroLeague staff open
Besiktas · OlympiacosIn play
Final buzzer--:-- 
Highlights--:-- 
YouTube--:-- 

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.

The working layer Five tools
Inside the agency
Closer to content operations
Social performance dashboardSample data

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
  1. Sales pipelineTemplate · no data

    A sales pipeline built from scratch.

    PipelineThe header of the sales pipeline sheet: status, organization, country, sport, contact, title, email, phone, opportunity, stage, source
    TodayThe header of the Today tab: read only, fills itself from the pipeline; overdue, past their date, deal with these first
  2. Social performance dashboardSample data

    Five accounts across Instagram, X, TikTok and YouTube, season against season, with an A4 report builder for each project.

    The social performance dashboard: projects and platforms on the left, the latest month and the project standings
  3. Design Tracking SystemSample data

    Every piece logged by project, designer, type and format, with 145 automated checks run after every change.

    The Design Tracking System report: output by type, project share and output over time
  4. 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.

    The HL Tracker: live games with final buzzer, highlights and YouTube times, and the season so far
  5. 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 prototype
    Under a minutefor a draft

    Quotes stay as empty slots for an editor, and a checker flags player stats and scores that do not match the data.

5accounts across 4 platforms on one dashboard
145automated checks after every change to the design tracker
407published articles behind the drafting prototype, drafts in under a minute
Dashboard · sample data
The Design Tracking System report
Design Tracking System · sample data
The HL Tracker’s public page
HL Tracker · sample data

Every screen here shows sample data, not client figures.

Working on something like this? Tell me what’s missing.

NextPlay