Coolblue Automates Weekly Commercial Reporting with Rollstack

The Challenge: Reporting Volume, Pipeline Fragility, and Resource Drain

Coolblue, a leading consumer electronics and appliances company operating across the Netherlands, Belgium and Germany faced a massive volume challenge in their weekly and monthly reporting. With distinct commercial teams for product groups ranging from washing machines to mobile phones, the demand for granular, data-driven insights to inform the business teams was high.

Initially, the team attempted to solve the "last mile" problem by building an internal solution with the support of an agency— a custom Python script designed to push data from Looker into Google Slides. However, this internal tool quickly became a liability rather than an asset.

• Maintenance Nightmares: The home built solution was fragile; if a visualization changed by a single pixel or a BI tool API updated, the entire reporting workflow broke.
• Volume Failures: The system could not handle the parallelism required to generate 300+ unique slides in a short window, frequently timing out and failing to render.
• Resource Drain: Highly skilled data analysts spent three days a week debugging code and manually fixing formatting errors instead of analyzing commercial performance.

The Solution: Connecting Looker to Google Slides with Rollstack

Coolblue replaced their unstable internal scripts with Rollstack, an enterprise-ready data delivery platform. Rollstack connects directly to Coolblue’s Looker instance, allowing them to automate the creation and distribution of heavy weekly slide decks without the maintenance burden.

The transition allowed Coolblue to move from a fragile, code-heavy process to an automated, user-friendly workflow.

• Intuitive Adoption: Rollstack was so user-friendly that the team required no internal training documentation; they simply connected their accounts and began automating immediately.
• Standardization at Scale: Coolblue utilized Rollstack to create standardized reporting templates across diverse product groups (e.g., Kitchen Appliances vs. Televisions), ensuring every category manager received a consistent view of their business.
• Reliable Automation: Rollstack handled the queuing, rendering, and distribution of massive 300-slide decks on a set schedule, eliminating the timeouts associated with their previous script.

The Impact: From Tactical Work to Essential Business Partners

By automating the "last mile," Rollstack fundamentally changed the daily lives of Coolblue’s analysts. The team effectively reclaimed three days of work per week, shifting their role from data logistics to strategic advisory.

The impact went beyond time savings—it directly influenced the company's bottom line.

• Strategic Agility: Because reports are now generated automatically analysts spend the week digging into the "why" behind the numbers rather than compiling them.
• Direct Margin Impact: In one specific instance, the automated reporting highlighted a spike in return rates for large-screen televisions. Because this insight was delivered in a timely fashion, the category manager identified the root cause and was able to quickly implement a long-term revenue saving solution.
• Operational Peace of Mind: The data leadership team no longer needs to troubleshoot on Monday mornings; the reliability of Rollstack ensures stakeholders have their insights in their inbox before they finish their first coffee.