Marketing AnalystCampaign AnalyticsAdvancedSingle prompt

Marketing Performance Dashboard Design AI Prompt

Design a comprehensive marketing performance dashboard for the CMO and marketing leadership team. Business model: {{business_model}} Marketing channels: {{channels}} Key busines... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
Design a comprehensive marketing performance dashboard for the CMO and marketing leadership team.

Business model: {{business_model}}
Marketing channels: {{channels}}
Key business goals: {{goals}}
Reporting cadence: weekly and monthly

1. Dashboard sections and metrics:

   SECTION 1 - Revenue and Pipeline Impact:
   - Marketing-sourced revenue (month and YTD vs target)
   - Marketing-influenced revenue
   - Total pipeline value from marketing-sourced leads
   - Pipeline coverage ratio (pipeline / quota)

   SECTION 2 - Demand Generation:
   - MQL volume (week, month, YTD vs target)
   - MQL-to-SQL conversion rate (trend)
   - Cost per MQL by channel
   - Funnel velocity (days MQL to close)

   SECTION 3 - Channel Performance:
   - Spend, conversions, CPA, ROAS by channel
   - Channel mix % (share of spend vs share of conversions)
   - MoM change in CPA by channel

   SECTION 4 - Brand and Organic:
   - Organic traffic (YoY trend)
   - Domain authority and backlink growth
   - Branded search volume trend
   - NPS score (monthly)

   SECTION 5 - Customer Marketing:
   - Email engagement rate (open rate, CTOR)
   - Churn rate trend
   - Expansion revenue from marketing programs
   - Renewal rate (if applicable)

2. Alert conditions for weekly review:
   - MQL volume > 20% below weekly target: investigate channel performance
   - CPA increase > 15% WoW in any channel: bid strategy or competition change
   - Organic traffic > 10% below baseline: potential SEO issue

3. Drill-down structure:
   - Each metric links to a supporting report
   - CMO can click from MQL count to breakdown by channel, source, and sales owner

4. Audience customization:
   - CMO view: pipeline impact + channel efficiency + NPS
   - Channel manager view: their channel only, deep detail
   - CEO view: revenue impact + efficiency ratio only

Return: dashboard sections with metric definitions, alert conditions, drill-down structure, and audience views.

When to use this prompt

Use case 01

Use it when you want to begin campaign analytics work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in Campaign Analytics or the wider Marketing Analyst library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Dashboard sections and metrics:, Marketing-sourced revenue (month and YTD vs target), Marketing-influenced revenue. The final answer should stay clear, actionable, and easy to review inside a campaign analytics workflow for marketing analyst work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in Campaign Analytics.

Frequently asked questions

What does the Marketing Performance Dashboard Design prompt do?+

It gives you a structured campaign analytics starting point for marketing analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for marketing analyst workflows and marked as advanced, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

Marketing Performance Dashboard Design is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are A/B Test Analysis for Campaigns, Campaign Performance Report, Campaign ROI Analysis.