Our team worked closely with an agency based in Australia to develop a custom panel and analytics integration solution that streamlined the combination and visualization of data from multiple streaming services, including Shopify and Apple Music.

Together, we identified the primary goal of centralizing analytical data and displaying it on a minimalist dashboard that could be customized for playlists, songs, and artists. To achieve this, we utilized Google Sheets for data storage and collection, BigQuery for building data marts, and Google Looker Studio for visualization.

One key feature of our solution was the ability to customize the dashboard for specific needs, allowing users to quickly access the data they needed without being overwhelmed by irrelevant information. Through frequent communication and feedback sessions, we were able to refine the solution to meet the needs of the agency and its clients.