Home / Reporting
Tracking first.Then budget.
Ad platforms bid on the conversions you send them. I own what gets sent, then analyse it in SQL, Power BI and Looker Studio, so every channel’s number traces back to revenue.
One chain. No weak links.
Wrong tracking means wrong bidding, and every report built on it repeats the error. I own all three links, so the number you read is the number the platform bid on.
| Link | What I run | Proof |
|---|---|---|
| Measure it | Google Tag Manager, web and server-side. GA4 events, custom conversions and a data layer written to a plan, so every conversion reaches the platform with the right value. | Server-sideGTM and custom conversions, set up by me |
| Analyse it | SQL, Power BI, Looker Studio and Tableau. Channel, funnel and city-market analysis, ending in a plain-English call on what to change. | 5,000+products managed in SQL |
| Report it | One dashboard that joins the ad platforms, GA4 and store data. A weekly review anyone can read. No 30-slide decks. | 8+platforms in one view |
How I lay out a report.
My client dashboards are not mine to share, so this one runs on made-up data for a fictional store. It answers the four questions I answer every week: what happened, which channel did it, where shoppers drop out, and what to do next. Click a channel to filter it.
Sample data only. Every figure is generated, and none comes from a client or an employer. The same layout works in Looker Studio or Power BI with live data connected.
Built in the tool your team already uses.
The sample above is plain HTML, so it opens without a login. My live dashboards run in these tools.
| Tool | What I have built |
|---|---|
| Power BI | Lead cost, lead quality and landing-page dashboards for a renewable-energy business, reported to the CEO. City-market analysis that advised which cities a UK event series focused on next. Sales, traffic, email and ad-spend reports for ecommerce brands, used to pick cities, audiences, products and ads. |
| Looker Studio | Automated monthly reports that agency clients used in their review calls. One weekly view across 8+ ad platforms for stakeholders. A dashboard on Shopify, Google Analytics and ad data for my own store. |
| Tableau | Analysis and reporting alongside Power BI, across the same roles. |
| SQL | The queries behind the dashboards, plus inventory and vendor data for a 5,000+ product catalogue. |
What I track, and why.
Before I touch a tag, I write the plan: what to measure, what fires it, and where the number goes. This is the shape of it for a store or a lead site.
| Event | What triggers it | Where it is used |
|---|---|---|
purchase | A data layer event on the order confirmation page, carrying order value, currency and transaction ID | GA4 and Google Ads conversion. Real revenue, so ROAS is honest. |
generate_lead | A form submits successfully. A custom event, not a button click | Lead conversion in GA4 and Google Ads, so bidding learns from real enquiries. |
click_to_call and whatsapp_click | A click on a tel: or WhatsApp link | Counted as a conversion on lead sites where the phone is the main way to enquire. |
add_to_cart and begin_checkout | Ecommerce events pushed to the data layer | The funnel report, and retargeting audiences built on real shopper behaviour. |
Server-side container | The web container sends each event to a tagging server on a first-party endpoint | Cleaner data that survives ad blockers and browser limits, forwarded to GA4 and the ad platforms. |
Tools: GA4 · GTM (server-side) · SQL · Looker Studio · Power BI · Tableau · Search Console
Put me onyour numbers.
Email me the role or download my CV. You’ll hear back within one working day.
Or call 07440 639554, WhatsApp me, or message me on LinkedIn.