Small business Workflow automation · 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, each network with its own formats, currencies, and identifiers. 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, recovering around 3.5 hours 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.