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.

Tracking, analysis and reporting: what I run in each, and one proof point
LinkWhat I runProof
Measure itGoogle 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 itSQL, 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 itOne 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.

Dashboard tools and what I have built in each
ToolWhat I have built
Power BILead 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 StudioAutomated 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.
TableauAnalysis and reporting alongside Power BI, across the same roles.
SQLThe 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.

Example events, what triggers them in Google Tag Manager, and where they are used
EventWhat triggers itWhere it is used
purchaseA data layer event on the order confirmation page, carrying order value, currency and transaction IDGA4 and Google Ads conversion. Real revenue, so ROAS is honest.
generate_leadA form submits successfully. A custom event, not a button clickLead conversion in GA4 and Google Ads, so bidding learns from real enquiries.
click_to_call and whatsapp_clickA click on a tel: or WhatsApp linkCounted as a conversion on lead sites where the phone is the main way to enquire.
add_to_cart and begin_checkoutEcommerce events pushed to the data layerThe funnel report, and retargeting audiences built on real shopper behaviour.
Server-side containerThe web container sends each event to a tagging server on a first-party endpointCleaner 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.