The Dashboard Your Leadership Team Will Actually Open

Most growing brands have one. A Looker Studio report someone built in a burst of enthusiasm, with fourteen pages, forty charts and a date picker nobody touches. It got plenty of attention in its first fortnight. Now the weekly meeting runs off a spreadsheet someone pastes together on Monday morning, and the dashboard link sits in a bookmarks folder.

At User Actually, we build reporting the other way round. We start with the decisions the leadership team makes each week and month, and only then choose which numbers go on the page.

If a chart doesn't change a decision, it doesn't belong on the front page.

1. Why Dashboards Stop Being Opened

Most dashboards are built from whatever the connectors make available. GA4 offers hundreds of dimensions, the ad platforms offer hundreds more, and it's easy to add a chart for each. The result answers plenty of questions nobody asked and few of the ones the team argues about on Monday. People stop trusting it the first time two charts disagree, and stop opening it soon after.

2. Start From Decisions, Not Metrics

Write down the decisions your leadership team makes on a regular cycle. For most ecommerce brands the list is short.

• Spend. Do we increase, hold or cut paid media this week?
• Channel mix. Which channels get more of next month's budget?
• Retention. Is the existing customer base growing in value, or are we replacing lost customers with paid ones?
• Conversion. Is the site converting the traffic we pay for, and where is it leaking?

Each decision needs one or two numbers that would change it. Those numbers are your dashboard. Everything else goes on a supporting page, or nowhere.

3. The One-Page Layout

This layout fits most growing brands on a single screen.

• The headline row. Revenue, blended MER, new customers and blended cost per new customer, each against last year and against target.
• New versus returning. Revenue split between first-time and repeat customers, so you can see whether growth is bought or earned.
• The funnel. Sessions, add-to-cart rate, checkout rate and conversion rate by device, so a drop tells you where to look.
• Owned channels. Email and SMS revenue as a share of total, next to list growth.
• Cohorts. Repeat purchase rate or revenue per customer, grouped by first-order month.

Keep it to one laptop screen. If it needs scrolling, something is on the wrong page.

4. Connecting the Data Without Breaking Trust

Looker Studio connects directly to GA4, Google Ads and Google Sheets. Shopify, Meta and most email platforms usually come in through a partner connector or a scheduled export to Sheets or BigQuery. To put sources side by side, Looker Studio blends join them on a shared field such as date or campaign name.

Expect GA4 revenue and your store's revenue to disagree. GA4 misses visitors who decline cookies or block tracking, and it won't reflect refunds unless you send them. Pick one source of truth for revenue, usually the store platform, and use GA4 for behaviour and channel splits. Label which is which on the page. If GA4 itself looks unreliable, fix the implementation before you build on it.

5. A Definitions Tab and One Source of Truth

Add a short definitions page to the report. For each number, write what it means, where it comes from and how it's calculated. New customer and MER are where teams most often disagree, so define them exactly, including whether revenue is counted before or after refunds, VAT and shipping.

When finance's revenue figure and the dashboard's don't match, the definitions page is where you settle it. Fix the definition once and every chart follows.

6. Cadence and Ownership

A dashboard needs an owner and a regular meeting. Name one person who is responsible for the numbers being right. Use Looker Studio's scheduled delivery to email a PDF of the front page before the weekly meeting, and run the meeting from it.

When someone asks a question the page can't answer, decide whether it needs a one-off analysis or a new standing number. Most should be one-offs.

The Bigger Point

A dashboard is useful when the people who make decisions open it without being reminded. Build it from those decisions, keep it to one page, define every number and give it an owner. The charts are the easy part.