Marketing Analytics Projects in IndiaMarketing Analytics Projects in IndiaThe objective of this project was to scale revenue for a Shopify-based eCommerce brand while maintaining a healthy conversion rate and average order value. I managed end-to-end performance marketing, focusing on traffic quality, funnel optimization, and data-driven ad scaling.
Through structured campaign testing, audience segmentation, and conversion rate optimization, the store achieved $175,459.31 in total sales within 30 days. Traffic increased to 76,029 online store sessions, resulting in 1,412 total orders, a 1.76% conversion rate, and a strong $106.19 average order value. Sales, Customer & Marketing Analytics in Power BI
I built a complete 3-page Power BI dashboard to analyze Sales performance, Customer behavior, and Marketing ROIโall in one place.
๐ Sales Overview
Revenue trends & top product categories
Total Sales, Orders & Average Order Value
Region-wise and payment method analysis
๐ฅ Customer Insights
New vs Returning customers
Customer Lifetime Value (LTV) by region
Purchase frequency & repeat behavior using DAX
๐ Marketing Performance
Spend vs Revenue across Paid Ads, Social, Referral, Influencer/UGC, Email & Offline
Clear ROI comparison to identify winning and underperforming channels
๐ Tools Used: Power BI, SQL, DAX, CSV
๐ก Outcome:
This project shows how combining Sales, Customer, and Marketing data helps businesses make faster, smarter decisions.