The same work every month
Export, paste data and fix formats for every client. That is time the team could spend elsewhere.
MARKETING DATA / SYSTEMS
Your client reporting should not restart every month.
I build measurement and reporting systems so agencies can deliver without relying on whoever owns the spreadsheet.
Clients I have worked with:
The cost of building reports by hand.
When every report starts from scratch, errors and waiting become part of the job.
Numbers that do not add up
Ads says one thing and the client's console says another. Before discussing results, someone has to decide which number counts.
Every client adds work
A new client means another workbook, another template and more hours from your analyst.
Four weeks, one reporting system.
In four weeks we sort the sources, define the metrics and leave the system behind your reports working.
- 01
Week 1 · Audit
We review the sources and reports, then note where they differ.
- 02
Week 2 · Model & design
We define the metrics and sketch the dashboards before building them.
- 03
Week 3 · Build
We work on the warehouse, transformations and first dashboards.
- 04
Week 4 · Handover
We automate, document and leave the team ready to run it.
What is included
- A documented data model
- Looker Studio dashboards
- Automated delivery
- Handover docs
Good fit
- You report for 5+ clients
- You already use (or want) Looker Studio
- Numbers never quite match up
- You want to stop firefighting every report
Not a fit if
- You want a free single-channel dashboard
- You are a team of one after a one-off report
- You want to replace the team, not improve how it works
Reporting for growth, ecommerce and SEO agencies.
For teams reporting across several clients that need the same logic in every delivery.
- 6+years in marketing analytics
- 15-20concurrent accounts at Notebook Agency
- 10+clients in Torices reporting systems
- 20+freelance dashboards delivered
Measurement wired into every SEO report
A measurement and reporting system for B2B/SaaS clients, with page data inside every report.
View case
Organic and paid reporting, side by side
A report series that puts organic and paid traffic side by side, with the sources checked.
View case
Ecommerce dashboards for LATAM clients
Dashboards with the metrics their clients need: ROAS, paid revenue, spend and top products.
View case
Who I am
About
I work between marketing and data. My focus is digital analytics and the systems behind it: measurement you can trust, reporting the team can maintain and data people can use without relying on one person.
- Based in
- Lima, Peru
- Languages
- Spanish · English
- Focus
- Marketing analytics & data
Under the hood of the reporting.
Data lives in BigQuery, gets shaped with SQL and reaches the dashboards through Looker Studio.
- Python
- SQL
- Dataform
- Google Cloud
- Apps Script
- Looker Studio
Frequently asked questions.
01Do you replace our tools?
No. If you already use Looker Studio, we build on it. BigQuery and Apps Script stay behind it.
02How long until the first dashboard?
The first client dashboard arrives during the sprint, usually in week 3.
03Do you work with the connectors we already use?
Usually. Google sources connect natively. Other platforms can come through APIs into the warehouse.
04What do you need from us?
Read access to the sources and 30 minutes a week with whoever owns reporting today.
05What happens after the sprint?
The system stays documented and automated. You can request changes later, or your team can run it.
Bring a report that takes too long.
In 20 minutes we can see where the work gets stuck and what to automate first.
Available in English and Spanish.