Real-World Case Study

How a restaurant chain stopped guessing and started growing

A cloud kitchen operating on Zomato & Swiggy had no visibility into which outlet was profitable, which dishes were underperforming, or where ad spend was going.

The Problem

Orders data locked inside Zomato & Swiggy dashboards
No cross-platform view of revenue vs commissions
Ad spend tracked manually in spreadsheets
No dish-level profitability visibility
Owner spending 4+ hrs/week on manual data work
Unknown net margin despite ₹8–15 lakh monthly revenue

The Business

3 cloud kitchen outlets across Delhi NCR
4 brands: Outlet 1, Outlet 2, Outlet 3, Outlet 4
Active on Zomato Pro & Swiggy One with paid ads
200–400 orders/day across all outlets
Team of 2 managing operations + marketing

Phase 1 — Basic

Google Sheets Dashboard

A clean, shareable Google Sheet pulling CSV exports from both platforms. Weekly delivery every Monday.

Starting ₹2,500 / month

Phase 2 — Intermediate

Automated SQL Pipeline

Python ETL ingesting Zomato & Swiggy CSVs into SQL Server. Power BI dashboard refreshed daily.

Starting ₹10,000 / month

Phase 3 — Advanced

Full Automation + Alerts

Scheduled Python tasks, automated anomaly alerts, WhatsApp owner notifications — zero manual effort.

Starting ₹18,000 / month

4 hrsSaved per week on manual reporting

23%Reduction in ad wastage after ROAS tracking

3×Faster menu decisions with dish-level data

₹2,500Starting cost for basic dashboard

How a restaurant chain stopped guessing and started growing

The Problem

The Business

Want this for your restaurant?