Michael Cohen
← All Work

95% faster. $5.8M in revenue impact.

Read the full case study →

Detailed write-up · Methods · Full outcome narrative

Tools & Methods

Power BIPower QueryM codePower AutomateExcelGoogle Ads APIMicrosoft Ads API

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.

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.

95% reduction in monthly data processing time · $5.8M in revenue driven in collaboration with marketing leadership · Financial close cut by 6.5 days per month

Working on something similar?

Every engagement starts with a conversation about where your finance or data function is breaking down. No intake forms, no pitch.

← Back to work