SarantiumBetween Finance & Data
← All engagements

Government Services · E-Commerce

95% faster. $5.8M in revenue impact.

An online vehicle registration platform had scattered data across ad platforms, operations, and finance with no unified view. Over two years we rebuilt the data layer piece by piece — reconciliation, ROAS tracking, chargeback analysis, and performance dashboards.

Read the full case study

Detailed write-up · Methods · Full outcome narrative

Tools & methods

Power BIPower QueryM codePower AutomateExcelGoogle Ads APIMicrosoft Ads API

Challenge

The team was exporting everything to Excel, doing accounting outside the system, and journaling entries back in. Ad spend ran across five platforms with no unified view. They assumed it was a QuickBooks problem. It was a data architecture problem.

Approach

Rebuilt the financial and operational data layer across five projects: automated merchant reconciliation, unified ROAS dashboard tying ad spend to completed transactions, chargeback tracking system, call center performance dashboards, and order-to-cash process mapping.

Results

Working on something similar?

Schedule a Call