A federal flower-delivery e-commerce (25M ₽ monthly turnover, 30K orders/month) ran 500+ ad campaigns tracked by hand in spreadsheets: slow filtering, daily manual exports, and last-click attribution that once hid a 3,000,000 ₽ pricing error behind phantom profits.
E-commerce & Retail
Russkiy Buket — BI Dashboards for 500+ Ad Campaigns
From 5,000-row spreadsheets to auto-refreshing Power BI dashboards — including catching a 3-million-ruble attribution error.
500+
Campaigns under management
+29%
Profit growth (YoY)
+42%
Orders via performance channels
3M ₽
Attribution error caught
The challenge
The approach
A full BI pipeline: CRM and ad-platform data flowing through cloud storage into Power BI with 2-hour refresh cycles. Dashboards compute target CPO per city from real margins, manage conversion-rate targets per channel, compare periods campaign-by-campaign, and support dynamic pricing agreements — with dynamic campaign labels passed through CRM down to individual keys.
The results
Reporting that took specialists hours became continuous; peak-season bid management (Feb 14, March 8) became manageable in near-real-time; and the client’s growth held: profit +29% and performance-channel orders +42% year-over-year, market-leading click and lead costs among the category’s top 10.
