Gurugram D2C home-decor brand, Shopify, Meta and Google Ads, Shiprocket, Zoho Books, weekly reports built in Excel
Week 1Metric definitionsAgree definitions of net revenue, contribution margin, blended CAC and RTOMetric dictionary signed by founder and finance
Weeks 1–2Source auditCheck GA4, pixels, Shopify, Shiprocket and Zoho Books for data quality and API access; common gap: RTO orders never marked returned in ShopifyList of tracking fixes before modelling
Weeks 2–4PipelinesConnectors into BigQuery (Airbyte or Fivetran plus the GA4 export) on daily schedulesRaw data landing daily
Weeks 3–5Modellingdbt models joining orders, returns, spend and costs, with unique, not_null and relationships tests on key fieldsTrusted tables for every metric
Weeks 5–6DashboardsLooker Studio pages for founder, marketing and operations, with filtersThree role-based dashboards
Week 6Access and alertsRole-based access, no personal data in dashboards, anomaly alertsSecure, monitored reporting
Week 7HandoverDocumentation, training, ownership of modelsIn-house analysts maintain and extend it
Where it starts₹30 lakh/month ad spend, Meta-reported ROAS higher than finance sees, 22% RTO on COD, two analysts spend 2 days a week on reports
Where it endsThe brand sees margin-level performance daily instead of in weekly Excel. Weekly they watch blended CAC, contribution margin after RTO and RTO rate by pin code.