The Problem
Monthly and weekly reporting at Bongo required significant manual effort. Pulling data from multiple platforms, formatting dashboards, and distributing reports consumed 20+ hours per week across the analytics team.
Context
As the platform scaled across OTT, MCN, and Studio ecosystems, the volume of stakeholder-facing reports grew faster than the team. Manual processes became a bottleneck for timely decision-making.
My Role
Led the automation initiative end-to-end: identified bottlenecks, designed automation workflows, wrote Python and R scripts for data pipelines, and built self-updating dashboards in Looker Studio.
Approach
- Audited existing reporting workflows to identify repetitive manual tasks
- Designed automated data pipelines using Python and R
- Built self-refreshing dashboards in Looker Studio connected to live data sources
- Created standardized report templates to ensure consistency
- Rolled out automation incrementally, training team members on the new system
Tools & Technology
Outcome
Reduced manual reporting effort by 40–50%, saving the team approximately 20 hours per week. Dashboards became available 24/7 with real-time data, enabling faster stakeholder decisions.
What I Learned
- Automation is most effective when you standardize the process before automating it.
- Stakeholder buy-in comes from showing time savings in the first week, not promising them.
- Self-serve dashboards reduce ad-hoc reporting requests significantly.
