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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Diagnose conversion bottlenecks across a marketing funnel
Identify the primary leak in your multi-stage marketing funnel by evaluating conversion ratios against typical industry benchmarks.
Build a partner co-marketing brief for joint campaigns
Create an aligned co-marketing brief with clear partner deliverables, tracking rules, and timelines. Use it when launching joint webinars, reports, or product bundles.
Rewrite stiff marketing copy into plain English
Strip corporate jargon, inflated claims, and robotic phrasing from marketing drafts. Use it to make product pages, ads, or emails sound human.
Turn customer objections into landing page FAQs
Convert sales objections and hesitation triggers into conversion-focused FAQ accordions that close remaining buyer doubts near checkout.
Plan a Trade Show Booth with Opener Script, Lead Scoring and 48-Hour Follow-Up
You get a complete booth plan: headline, a 10-second opener, scored qualification questions, capture fields, a 48-hour follow-up email, a timeline and metrics.
Write Event Invitation and RSVP Reminder Emails That Lift Show-Up Rates
You get a five-email sequence (invite, confirmation, 1-week, 1-day and 1-hour reminders), each with its own reason to attend and the logistics people forget.
- Write Post-Event Follow-Up Emails for Attendees, No-Shows and Hot Leads
- Build a Content Pillar and Topic Cluster Plan Tied to Funnel Stages
- Build a Google Ads Negative Keyword List and Ad Group Structure
- Build an Email List Segmentation and Tagging Plan from Your Real Data
- Diagnose Low Email Open and Click Rates from Your Campaign Stats
- Pick a Lead Magnet and Write Its Opt-In Page Copy to Grow Your Email List