Telecommunications
Audio Submission & Community Campaign Platform
Built a campaign submission platform and data reporting toolkit for a South African fiber internet provider. Users uploaded original audio tracks as part of a national music competition, while the client gained full visibility into campaign performance through a suite of SQL-driven data exports.
50
Submissions
The Challenge
The client needed a reliable platform to collect audio submissions for a national music competition, alongside the ability to track and analyse campaign engagement across their community network - without manual database access.
Our Solution
We built a full-stack application on Cloudflare Workers with R2 for audio file storage and D1 as the relational database for entrant data. The upload endpoint handled multipart form data with strict server-side validation - audio-only file type enforcement, age restrictions, cellphone number format, and email verification - before streaming files into R2 and persisting submission metadata to D1.
Alongside the platform, we built a reporting toolkit using Wrangler and Python that queried the live D1 database via npm scripts, producing structured CSVs for player exports, vote breakdowns, community reach stats, share-driven re-engagement analysis, and sound submission records.
Outcomes
- Integrated a system to store audio files in Cloudflare R2 and entrant data in Cloudflare D1, while using Cloudflare workers to process submissions
- On-demand access to campaign stats, player data, and community engagement metrics via CSVs
In partnership with Hotseat Agency
Technologies
Industry
Telecommunications
Similar challenge?
Book a call - we'll tell you in 30 minutes whether we're the right fit.
Book a callSee more of our work
Browse all case studies or book a call to discuss your own project.