Build a Marketing Dashboard Around One North-Star Metric and Five Inputs

You get a one-page marketing dashboard with a north-star metric, five input metrics with definitions, sources, triggers and actions, plus a weekly report template.

Prompt

Prompt
Act as a marketing analytics lead who builds simple dashboards for small teams.

Your job: design a marketing dashboard and a weekly reporting template built around one north-star metric and exactly five input metrics.

Before you start, ask me these questions in one message, numbered, then wait for my answers:
1. What does the business sell, and to whom?
2. What is the main marketing goal for the next quarter?
3. Which channels and tools do you use now (for example Google Analytics, Shopify, HubSpot, ad platforms)?
4. Who reads the weekly report, and how much time do they give it?

Rules:
- Track one north-star metric and no more than five inputs; give one line on how each input moves the north star.
- Every metric gets a plain-language definition with a formula, a named data source, and a weekly target.
- Every metric gets a specific drop trigger (for example "15% below its 4-week average") and the first action the team takes when it fires.
- The weekly report fits on one screen, with no more than 150 words of commentary.
- Do not invent industry benchmarks; label targets as starting guesses to revise after 4 weeks of data.

Output format:
1. North-star metric: name, definition, why it matters.
2. Table: Input metric | Definition and formula | Data source | Weekly target | Drop trigger | Action when triggered
3. Weekly report template with copy-ready headings.
4. One line on data gaps or tracking risks you see.

Example output

At a glanceFive input metrics: weekly target vs drop triggerNorth star: active paid subscriptions
ItemWeekly targetDrop trigger
Qualified sessions3,20015% below 4-week avg
Product page to cart rate9%Below 7% two weeks running
Checkout conversion55%Below 48%
Email list growth+180Below +100
Weekly cancellationsUnder 2.0%Above 2.8%

Example for: a small online coffee subscription shop on Shopify, goal of growing paid subscribers this quarter, report read by the founder in 5 minutes.

1. North-Star Metric

Active paid subscriptions = subscriptions billed in the last 30 days and not cancelled. Source: Shopify Subscriptions report. It reflects both new growth and retention, which together drive revenue.

2. Input Metrics

Input metricDefinition and formulaData sourceWeekly targetDrop triggerAction when triggered
Qualified sessionsSessions from organic, email and paid, excluding bounces under 10 secGoogle Analytics 43,20015% below 4-week avgCheck ad spend pacing and top landing pages for errors
Product page to cart rateAdd-to-carts ÷ product page viewsGA4 + Shopify9%Below 7% two weeks runningTest new hero photo and price display on subscription page
Checkout conversionOrders ÷ checkouts startedShopify Analytics55%Below 48%Run a test order; check shipping cost and payment errors
Email list growthNew subscribers − unsubscribesKlaviyo+180Below +100Review pop-up offer and placement; relaunch quiz lead magnet
Weekly cancellationsSubscriptions cancelled ÷ active at week startShopify SubscriptionsUnder 2.0%Above 2.8%Read cancellation reasons; email at-risk subscribers a skip option

How each moves the north star: sessions and cart rate feed new trials, checkout turns them into subscriptions, email brings repeat visits, cancellations subtract directly.

All targets are starting guesses. Revise after 4 weeks of data.

3. Weekly Report Template

Week of:
North star: active subscriptions this week | last week | change %

Inputs (status: on track / watch / triggered)

  • Qualified sessions:
  • Product page to cart rate:
  • Checkout conversion:
  • Email list growth:
  • Weekly cancellations:

Triggers fired and action taken (one line each)

What worked this week (max 2 bullets)

Next week's one priority

Decision needed from founder (yes/no, one line)

4. Data Gaps

GA4 and Shopify count conversions differently, so cart rate may drift; confirm UTM tagging on all email and ad links before week one.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Capping tracking at one north star and five inputs stops the dashboard from turning into a wall of vanity numbers.
  • Pairing each metric with a drop trigger and a first action turns the report into decisions, not just observations.
  • Labeling targets as starting guesses avoids made-up benchmarks and builds in a 4-week review.

Use this in ChatGPT, Claude or Gemini when your team reports too many numbers or none at all. Have your main goal, channel list and analytics tools ready to answer the four questions.

Common edits

  • Ask for the table as a Google Sheets layout with formulas for the 4-week average and trigger flags.
  • Change the audience to a client or board and request a monthly version with a short trend chart description.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Marketing