A seven-tab analytics workbook for organizing SoundCloud performance data and evaluating changes around releases and Amplify activity.
AnalyticsDashboard DesignExcel
Privacy-safe demonstration data shown.
What I built
I built a seven-tab Excel workbook that turns recurring SoundCloud snapshots into a structured analytics workflow. It includes Track Setup, Daily Tracker, Amplify Events, Latest Metrics, Daily Summary, Dashboard, and How To Use tabs.
Problem
SoundCloud data can be difficult to compare across tracks and promotional windows. The tracker keeps daily inputs, promotion timing, and calculated performance measures in one place so changes are easier to review.
Main features
Daily logging
Amplify event tracking
Formulas for organic plays, daily gains, Boost and organic share, engagement rate, repeat rate, and follower conversion
Summary tables and dashboard
Usage guide, input validation, and frozen headers
Technologies
Microsoft Excel (.xlsx), JavaScript, @oai/artifact-tool, spreadsheet formulas, and data validation.
