Whiteleads
Marketing analytics for a performance team
One analytics system for financial performance, traffic quality and campaigns that need attention.
Data from advertising accounts and attribution platforms is collected automatically, processed and brought into one analytics system.
- Financials and KPIs in one place
- Issues are visible at a glance
- Actuals against plan update automatically
Screenshot data has been anonymised. Click the image to view it in full.
Previously, data lived in separate systems
Spend, events and traffic quality data came from different places and did not add up to a single view.
- Advertising spend comes from several sources.
- Events and traffic quality come from attribution platforms that track installs and events.
- KPIs vary by offer: each product has its own targets.
- Reports need regular preparation.
- Managers and media buyers struggle to see the overall picture quickly.
- Advertising accounts
- Attribution platforms
- Manual data sources
A single analytics system
The system automatically imports, normalises and combines data, builds data marts and delivers ready-to-use analytics in BI.
- Sourcesdata sources
- ETLingestion and processing
- DWHdata warehouse
- Data martsdata marts
- BIdashboards
How the system works
Five layers, from sources to BI. Open the diagram to view it in full.
Scroll through the diagram →
Click the image to view it in full.
- Sources
- trackers, spend and manual data
- Ingestion and normalisation
- validation and mapping
- Data warehouse
- one shared database
- Data marts
- financials, KPIs and actuals against plan
- BI
- reports for managers and media buyers
The financial picture
Revenue, costs, profit, ROI, progress against plan and KPI performance are available on one screen. Managers no longer need to piece the picture together manually.
A cropped preview is shown. Click to view the full image.
Click the image to view it in full.
What needs attention now
The system highlights campaigns with financial losses and KPI deviations.
A cropped preview is shown. Click to view the full image.
Click the image to view it in full.
Where money is being lost
Loss-making campaigns with negative ROI.
Where KPIs are off target
Campaigns outside the acceptable thresholds.
Volume is not the only measure
Traffic placements are assessed by both volume and quality, helping the team avoid scaling sources that deliver more traffic but weaken KPIs.
A cropped preview is shown. Click to view the full image.
Click the image to view it in full.
Plan and actuals together
The system shows cumulative results, progress against plan and performance by offer.
A cropped preview is shown. Click to view the full image.
Click the image to view it in full.
What changed
- Data from different sources is brought into one system
- Metrics and KPIs update automatically
- Problem campaigns are highlighted separately
- Media buyers and managers share the same view
- Actuals against plan no longer need manual compilation
Python · ClickHouse · PostgreSQL · DataLens · Google Sheets
ETL · DWH · Data marts · BI
Have a similar challenge?
If your data lives in several systems and reports need manual compilation, we can start by reviewing the current process.
First consultation — free · 30 minutes
We will reply within one business day.
No access to live systems is needed to start. A description of the process or an anonymised example is enough.