Looker Studio · Supermetrics · BigQuery · remote, EU
Looker Studio reporting consultant for multi-market marketing data
I'm Mihael Turkalj. Through my own practice, MT-MEASUREMENT, a Croatian sole proprietorship with EU VAT ID HR18247511346, I build reporting systems in Looker Studio for brands and agencies, remotely on CET. At Omnicom Media Group I built and ran the reporting layer for a multi-brand FMCG client: more than a hundred dashboards a year, used directly by the client, in place of a manual spreadsheet-to-slides cycle.
- Available now
- Remote · CET
- Croatia (EU)
- EU VAT ID HR18247511346 · direct invoicing
01What I build
One data model across markets and brands
Supermetrics and native connectors pulling the platforms and markets into one model, with the same metric definitions for every brand, so a number means the same thing in every report.
Dashboards people use directly
Looker Studio on top of the model: one place, refreshed on its own, so nobody rebuilds the numbers by hand.
Paid media in one view
Google Ads, DV360, GA4 and other platform exports blended in one place.
KPI reporting
CPA, ROAS, CTR, conversion rate and pacing, defined once and reported the same way everywhere.
BigQuery and SQL
SQL on the GA4 BigQuery export when the interface is not enough.
The measurement underneath
A report is only as good as the conversions behind it, so GA4 and Google Tag Manager are checked first. More on the GA4 and GTM page.
02How I work
Audit the sources
Which platforms, markets and exports exist today, and where the numbers already disagree.
Agree the definitions
One set of metric definitions, written down and agreed before anything is built.
Build the model
The connectors and the data model first, then the dashboards on top.
Check against the source
Every report checked against the platforms it comes from before it is handed over.
Handover
Documented so your team can run it without me.
03Proof you can check
Multi-market reporting
At Omnicom Media Group: one data model for a multi-brand FMCG client, the same metric definitions for every brand and market, and more than a hundred Looker Studio dashboards a year used directly by the client.
A master's thesis on dashboards
My master's thesis at Algebra University was on dashboards for multi-channel analytics.
The Metrics Kitchen
A game from my web lab on how 35 Meta and Google Ads metrics are calculated, from their ingredients. Play it.
04Questions
Which data sources can you bring together?
Google Ads, DV360, GA4 and other platform exports, through Supermetrics and native connectors, and BigQuery where the GA4 export is needed.
Do you work with agencies?
Yes. I work as your subcontractor on a white-label basis, so the client relationship stays with you, or I contract directly with your client, whichever you prefer.
How do you invoice?
Through my own practice, MT-MEASUREMENT, a Croatian sole proprietorship with EU VAT ID HR18247511346, for an agreed scope and its deliverables.
How do we start?
Email me or book a 20-minute call. The first step is usually a look at the sources and reports you already have.
05Also
- GA4 & GTM consultingGA4 and Google Tag Manager consultant in Croatia, working remotely across the EU
- Consent Mode v2 for agenciesConsent Mode v2 and server-side tagging for agencies, remote across the EU
- Google Ads & DV360 freelanceFreelance Google Ads and DV360 specialist in Croatia
- Google Ads account auditGoogle Ads account audit, before anything changes
- Automation & AI toolsGoogle Ads automation: scripts, the Google Ads API and AI tools
- Web developmentWordPress, WooCommerce and custom websites, with the tracking built in
- The interactive pipelineTen stages, ten live 3D models: the whole measurement pipeline