Case · Agency
A unified dashboard for Sklik, Meta and Google Ads.
Real-time data for clients 24/7. The client doesn't wait for Monday reporting.
Model case: we assume the company looks like this and show how much it would yield.
- Model case
- Sklik API
- Supabase
- Lovable
Starting point
Sklik data and CSV hell
Sklik's data interface (Drak) is quirky and has its own logic. Cross-channel reports mean downloading CSV files by hand and merging them in Excel. Account managers spend hours pasting data instead of optimising.
- Before
CSV hell
MANUAL REPORTING
- After
A live overview with real-time data
UNIFIED DATA
What we would build
The data's journey
From the ad platforms to a single overview.
- 01
Pulling data
Make pulls data from Sklik, Meta and Google
- 02
Unification
Unifying the metrics (spend, impressions, clicks) in a database
- 03
Dashboard
A client dashboard in Lovable
- 04
Access
A secure login for every client
- Make · Integration platform
- Supabase · Backend and database
- Lovable · Building the app
- Marketing APIs · Sklik, Meta, Google
Rollout steps
How the rollout would go.
- 01
DAY 01
Connecting the sources
Connecting to the ad platforms.
- 02
DAY 05
Unifying the data
Unifying the data in Supabase.
supabase.from('ads').upsert(...)
- 03
DAY 11
Client dashboard
Designing the dashboard and charts.
Model assumptions
Where the result comes from.
We take a typical company from the sector and the situation from the brief, add labelled assumptions and calculate the result. If the inputs change, so does the result, so you can recalculate it for your own company.
Model company
A model advertising agency with 10 clients. Every month CSV files from Sklik, Meta and Google are downloaded by hand and stitched together in Excel.
Inputs
- Clients with reporting (assumption)
- 10
- Ad channels
- Sklik, Meta, Google Ads
- Manual report per client per month (assumption)
- 3 h
- With the live overview: check per client (assumption)
- 30 min
- Labor rate (assumption)
- 24 EUR / h
Calculation step by step
- 01
Manual reports per month
10 × 3 h= 30 h
- 02
With the live overview per month
10 × 30 min= 300 min (5 h)
- 03
Time saved per month
30 h − 5 h= 25 h
- 04
Value of the saved time per month
25 h × 24 EUR= 600 EUR
This is a gross saving of time and money. We include the cost of rollout and running only where it is visible in the calculation.
Model results
What would change after rollout.
- Model case
−25 h / month
Reports for 10 clients: 30 h → 5 h. The account manager stops stitching reports
Time
- Model case
600 EUR / month
25 h × 24 EUR
Cost of time
Your numbers belong in the model, not ours. The calculator shows where to start, and we work out the real values on your data.
Start here
15 minutes is enough for you to know whether it makes sense.
You tell us what is bothering you. We tell you whether we can help, roughly what it costs and where I would start in your place. No presentation.
- jakub@transformuj.ai
- Phone
- +420 773 070 090
- Address
- Legerova 1820/39, Praha 2