Case Study: boodmo (India's largest online auto-parts marketplace) achieves LTV & CAC-driven cohort analysis to evaluate customer acquisition channels with OWOX BI Pipeline

How to Evaluate Customer Acquisition Channels Using Cohort Analysis

boodmo, India's largest online marketplace for auto parts, needed a single system to calculate customer LTV and compare cohort performance across acquisition channels — data that Google Analytics alone couldn’t provide because margins, order completion rates and up-to-date order status live in their CRM. To solve this, boodmo partnered with OWOX and used OWOX BI Pipeline to consolidate advertising, behavior and CRM data into Google BigQuery so they could run accurate cohort analyses.

OWOX implemented a pipeline that streams unsampled website and ad cost data into BigQuery (near real-time, typically within 5 minutes), where boodmo’s analysts build monthly cohorts and calculate LTV, CAC and repeat-purchase metrics; results are pushed to automated Google Sheets reports via Apps Script. With OWOX’s solution, boodmo gained a fully automated way to evaluate channel performance and payback by cohort, identify unprofitable channels (LTV < CAC), optimize acquisition spend, and tailor remarketing to increase customer LTV.

boodmo