Case Study: MatahariMall achieves automated single-dashboard KPI monitoring and near-real-time ad control with OWOX BI

How to Monitor Multiple Business KPIs in a Single Dashboard

Mataharimall, an Indonesian fashion retailer, faced a fragmented data problem: gigabytes of web, app, ad cost and CRM order data were scattered across Google Sheets, and analysts needed about 30 custom metrics (ROAS on different attribution models, CPC, CTR, etc.). Manual report refreshing consumed roughly 4 business hours per day, so the company engaged OWOX (using OWOX BI and OWOX BI Pipeline) to centralize and automate their marketing reporting.

OWOX consolidated data into Google BigQuery (GA360 export for web, OWOX BI Pipeline for AppsFlyer and ad costs, and a custom CRM connector), built an ML Funnel-Based attribution model, and automated calculations with SQL and Apps Script plus Google Data Studio dashboards. The OWOX implementation produced a single automated dashboard, enabled near-real-time bid control, saved about 4 work hours daily, reduced human error, and revealed attribution mismatches (some campaigns had been over- or under-credited by up to 3x), improving marketing efficiency.

Mataharimall

Jennie Catherine

Digital Marketing Manager