An analytics system for an AdTech company
- Timeline
- MVP — 1 month
- in production 8+ years, since 2018
Task: bring 20+ advertising platforms into one system — reports by team and profit by campaign.
How it works
- 01Universal connectorsOne interface and one algorithm for registering a third-party system
- 02Rights and restrictionsRBAC: employees at different levels see and edit only their own data
- 03Analytics and reportingFlexible slices, exports and report configuration
- 04Realtime monitoringAvailability, rate limits and data volume
WHO USES IT — media buyers run campaigns · team leads watch budgets and team results · analysts produce the department’s consolidated reporting · management sees P&L and buying efficiency. Facebook Ads, target.vk.ru, TikTok Ads, Google Ads, Unity Ads, AppLovin, AppsFlyer, Adjust, Keitaro and 12 more platforms.
Particulars and difficulties
Different connection interfaces
At the low level: OAuth2, API keys, webhooks, custom integrations and a data format of its own on every platform
No clear brief
The platform design and the final interface were discussed with the client evolutionarily
Platform limits
Each has its own rate limits, user counts, licences and moderation
Precision of financial data
Working with money: the figures being reconciled must add up to the decimal
Results
- 30 → 500
- growth of the department’s headcount
- +300%
- department profit
- 20+
- advertising platforms
Fast onboarding
Media buyers work to the same metrics from their first days
Campaigns under control
The efficiency of each buyer’s setup is visible, and results compare across any slice
Stack
PHP · Symfony · MySQL · ClickHouse · React · Docker