GrowthMad

Looker Studio dashboards people open more than once.

Looker Studio dashboards built on clean, reconciled sources and designed around the questions your team asks every month.

Ask about this What’s involved

Based in Perth. Delivered remotely across Australia and overseas.

Most dashboards die within weeks. They show everything, answer nothing in particular and disagree with the finance report, so people go back to asking for a spreadsheet.

The ones that survive are built from the other end. I start with who reads it and which decision it informs, get the sources to agree with each other, and then design the fewest pages that do the job, including one that a director can read in a minute.

This is for you if

  • Monthly reporting is assembled by hand from five logins.
  • Your current dashboard exists and nobody uses it.
  • You need ad spend, website and CRM results in one view.
  • You’re an agency that wants dependable client reporting.

How the work runs.

  1. Questions

    Who reads the report, how often, and what they do with it.

  2. Sources

    Connecting ad platforms, analytics, CRM and sales data, and reconciling where they differ.

  3. Model

    A tidy data layer, in BigQuery where volume or blending calls for it.

  4. Design

    Pages laid out for reading, with definitions on the page.

  5. Handover

    Training for your team and notes on maintaining it.

Deliverables

What you end up with

  • Looker Studio dashboard
  • Connected and documented data sources
  • One-page executive view
  • Metric definitions
  • Training session

Where AI comes in

Faster, with a person checking

AI writes and checks the queries behind a dashboard faster than I can type them, and can produce a plain-English monthly summary from the data for a person to review.

How I use AI

Tools I work in

  • Looker Studio
  • BigQuery
  • Google Analytics 4
  • Google Sheets

Fair things to ask.

Something else? Ask me directly.

Why Looker Studio?

It’s free, it connects to most marketing tools and your team probably has access already. I’ll work in another tool if you’ve standardised on one.

Can it include CRM or sales data?

Usually, and it should. A dashboard that stops at the lead leaves out the part you care about.

Do you only build in Looker Studio?

Mostly. It’s free, it connects to the Google tools most businesses use, and your team can edit it. As a Looker Studio expert I’ll say when it isn’t the right tool. Marketing dashboard services can sit on BigQuery where the data is too large or too messy to connect directly.

Data

Measurement plans

A marketing measurement plan that starts from the decisions your business needs to make and works back to events, parameters and reports. Readable by marketers, buildable by developers.

Read more

Data

Marketing automation and AI workflows

Marketing automation built with low-code tools and AI: small systems that take repetitive work off your team and connect the tools you already have. Built with checks, documented and handed over.

Read more

Data

Marketing mix modelling

Marketing mix modelling with Google’s open-source Meridian. A statistical view of what each channel adds, including the ones nobody clicks on, and where the next dollar should go.

Read more

All data services

Something driving you mad?

Tell me what’s going on. I’ll come back with questions or a scoped proposal, and I’ll say so if I’m not the right person for it.

Get in touch