Small business · Workflow automation · Delivered on self-hosted n8n
Consolidating revenue across five ad networks
The problem
Revenue from five ad networks (AdMob, AdSense, Unity Ads, AdColony, AppLovin) had to be consolidated by hand every week — different formats, currencies, and identifiers per network. One cycle took half a day.
What we built
A scheduled workflow that normalizes all five exports, converts currency using each row's own date, overwrites restated figures instead of duplicating them, and flags any network that didn't report.
The result
The weekly reporting cycle went from about 4 hours of manual work to roughly 30 minutes of reviewing flagged items — around 3.5 hours recovered every week. Restatements are absorbed automatically instead of being corrected by hand a week later, and a network that fails to report is caught before the numbers are published rather than showing up as a bad week.