We’re a fast-growing D2C brand building a centralized founder dashboard to consolidate sales, marketing, traffic, and retention into a single decision-making view.
This is a one-time freelance project focused on building a structured, automated system using Google Sheets + Excel (no paid BI tools, no backend server).
Tech Stack Preference
• Google Sheets
• Google Apps Script (for automation, if required)
• Excel uploads from Drive
1. Sales & Revenue Dashboard
Data Sources: Shopify sales, Amazon Seller Central, MIS Excel - monthly
Required KPIs: MTD revenue & units, YTD revenue & units, Month-wise revenue trend graph, Target vs Achieved (%), AOV, Unit economics (from MIS)
2. Product-Wise Distribution
Required: SKU-wise revenue contribution, State-wise sales distribution, City-wise distribution
3. Marketing (Inorganic)
Data Sources: Meta Ads, Google Ads export, Amazon Ads
Required KPIs: Stats available from the export
4. Marketing (Organic)
Data Sources: YouTube analytics export, Instagram organic data (manual export or API if feasible)
Required: Monthly growth in followers, Reach, Engagement rate, Content performance tracking
5. Website Traffic & SEO
Data Sources: Google Analytics export, Google Search Console export
Required: Traffic trend, Source breakdown, Conversion rate, SEO keyword performance (is possible)
6. Retention & Cohort Analysis
Using Shopify order data: Repeat purchase rate, Cohort analysis , LTV estimate, Purchase frequency
• Monthly Excel uploads auto-update dashboard
• Structured Drive folder system
• Clean KPI dashboard with charts + summary cards
• Documentation explaining file structure & update process
• No backend server