100 Best Claude KPI and Dashboard Prompts for Marketing Agencies

Direct Answer

The best Claude prompts for KPI and dashboard for marketing agencies are designed to help you design, populate, validate, and automate KPI dashboards and client reports for marketing campaigns. They cover attribution, ROI, channel performance, and lifecycle metrics with concrete outputs. Use them to standardize dashboards, speed up reporting, and improve data quality across clients.

Introduction

This page collects 100 practical Claude prompts focused on KPI and dashboard tasks for marketing agencies. Each prompt is ready to use and does not require additional context beyond the placeholders provided.

Whether you manage client reporting, internal analytics, or performance optimization, this prompt library helps you build transparent, actionable dashboards that drive decisions.

How to Use These Claude Prompts

• Replace placeholders like [industry], [audience], [product], [constraints], and [data] with your actual values.
• Add constraints or formatting requirements to steer outputs toward client-ready reports or internal dashboards.
• Request outputs in clear formats such as tables, bullet lists, or ready-to-export CSV snippets.
• Verify outputs by cross-checking calculations against source data and conducting quick sanity checks before sharing.
• Reuse prompts by cloning and adapting the placeholders for different clients or campaigns.

100 Best Claude KPI and Dashboard Prompts for Marketing Agencies

1. KPI Dashboard Design Brief: You are a Senior Marketing Analyst. Build a KPI dashboard blueprint for a marketing agency focusing on client acquisition, campaign performance, and attribution. Include primary metrics, data sources, refresh cadence, and a suggested dashboard structure. Output: bullet list of sections with KPI definitions and data relationships.
2. Client KPI Discovery: Act as a Discovery Consultant for an agency onboarding new clients. List the top five KPI categories to capture for onboarding, with definitions, data sources, and success criteria. Output: a table with category, KPI name, data source, calculation, and owners.
3. Attribution Model Brief: Role: Attribution Architect. Task: draft a multi-touch attribution framework suitable for a marketing agency serving multiple clients. Include channel weights, data requirements, and validation steps. Output: structured outline with assumptions and decision points.
4. Campaign Performance Snapshot: As a Performance Analyst, generate a one-page campaign snapshot template showing impressions, CTR, conversions, CPA, and ROAS for a mid sized client. Include recommended color palette, data freshness, and a note on confidence intervals. Output: template ready for client sharing.
5. Weekly Client Report: Act as a Reporting Lead. Create a weekly report outline for clients highlighting top performing channels, lagging indicators, and action items. Include a narrative section and a data sanity check list. Output: report skeleton and fillable sections.
6. Revenue Attribution Check: Role: Revenue Specialist. Task: design a KPI that ties marketing to revenue across campaigns. Provide formula, data sources, and an example using hypothetical data. Output: spreadsheet-like calculation steps.
7. Churn vs Winback Dashboard: You are a Customer Lifecycle Analyst. Build a dashboard concept comparing churn risk and winback opportunities by segment. Include segmentation rules and recommended alerts. Output: dashboard spec with widgets and thresholds.
8. Agency Benchmark Library: As a Benchmark Librarian, compile industry benchmarks for key marketing KPIs by channel. Provide ranges and context notes. Output: table with channel, KPI, benchmark range, source.
9. Client Health Scoring: Role: Client Health Engineer. Create a 0-100 health score for agency client accounts based on engagement, spend, conversion quality, and velocity. Include scoring rubric and validation steps. Output: scorecard and rubric.
10. Anomaly Detection Prompt: Act as Anomaly Auditor. Define rules to flag KPI anomalies in dashboards for marketing campaigns. Include thresholds, detection period, and escalation workflow. Output: rule set and alerting plan.
11. Data Quality Checklist: Role: Data Quality Analyst. Produce a KPI dashboard data quality checklist covering completeness, accuracy, timeliness, and consistency. Output: checklist with acceptance criteria and remediation steps.
12. Campaign ROI Calculator: You are a Campaign ROI Engineer. Create a reusable ROI calculator for digital campaigns including CAC, LTV, ROAS, and payback period. Output: calculation steps and an example scenario.
13. Client Onboarding Metrics: Act as Onboarding Lead. List initial KPIs to track during onboarding to demonstrate value quickly. Include data sources and how to measure progress. Output: KPI list with definitions.
14. Channel Performance Summary: Role: Channel Analyst. Build a summary dashboard for top five channels across clients. Include trends, seasonality notes, and recommended actions. Output: widget list and data relationships.
15. Budget vs Actual Report: You are a Finance-Driven Analyst. Create a dashboard section comparing budget versus actual spend and revenue by client. Include variance interpretation notes. Output: table and explanation prose.
16. Forecast Confidence Gauge: Act asForecast Specialist. Design a KPI gauge showing forecast vs actuals with confidence levels. Include data inputs and update cadence. Output: gauge spec and usage tips.
17. Marketing Qualified Lead Tiering: Role: MQL Architect. Create a tiered MQL scoring system with thresholds, data sources, and handoff rules to sales. Output: table of tiers, criteria, and actions.
18. Client Retention Dashboard: You are Retention Analyst. Build a dashboard focusing on retention rates, repeat purchase, and tenure by client segment. Include alert rules for drops. Output: widget configuration.
19. Content Performance Tracker: Act as Content Analyst. Design a tracker for blog and social content performance with engagement, reach, and conversion metrics. Output: data model and visualization recommendations.
20. Creative Performance Metrics: Role: Creative Insights Lead. Propose KPIs to measure creative effectiveness across campaigns, including A/B test markers and asset-level performance. Output: KPI list and sampling guidelines.
21. Landing Page Effectiveness: You are a Conversion Specialist. Build KPIs for landing page effectiveness, including form completion rate, load time impact, and micro-conversions. Output: dashboard spec and data sources.
22. Attribution Data Readiness: Role: Data Readiness Engineer. List required data fields and quality checks to support attribution dashboards. Output: data requirements matrix.
23. Seasonality Adjustment Plan: Act as Seasonality Expert. Provide a plan to adjust KPIs for seasonality effects, with example multipliers and validation steps. Output: methodology and example.
24. Client Segment Performance: Role: Segmentation Analyst. Build KPIs by client segment and explain how to compare segments across campaigns. Output: segment KPI definitions and dashboard widgets.
25. Cross-Client Benchmarking: You are Benchmark Analyst. Create a cross-client benchmarking prompt to compare performance while preserving client privacy. Output: rules and visualization approach.
26. Lead Velocity Dashboard: Act as Lead Velocity Engineer. Design a dashboard tracking lead velocity by stage, velocity score, and bottlenecks. Output: widget specs and data flow.
27. Social Ads Quality Score: Role: Social Ads Analyst. Propose KPIs to monitor ad quality scores and relevance across platforms. Output: KPI definitions and thresholds.
28. Email Campaign Metrics: You are Email Analytics Specialist. Outline KPIs for email campaigns including deliverability, open rate, CTR, conversions, and unsubscribe rate. Output: KPI list with calculation notes.
29. SEO Campaign Dashboard: Act as SEO Dashboard Designer. Create SEO KPIs for campaigns, including organic traffic, rankings, and backlinks quality. Output: KPI definitions and data sources.
30. PPC Bid Health: Role: PPC Manager. Define KPIs to monitor bid health, quality score, and cost per result with alerts. Output: metric definitions and thresholds.
31. Creative Variant Testing: You are Experiment Designer. Create a framework for testing creative variants with sample metrics and decision rules. Output: test plan and KPIs.
32. Agency Profitability View: Act as Agency CFO. Build a profitability dashboard showing gross margin by client and service line. Output: revenue, cost, and margin visuals.
33. Client Dashboard Template: Role: Dashboard Architect. Produce a reusable client dashboard template with sections for performance, learnings, and next steps. Output: template outline.
34. Cohort Analysis View: You are Data Scientist. Design a cohort analysis dashboard for client campaigns to observe behavior over time. Output: cohort definitions and visualization plan.
35. Client SLA KPIs: Act as Service Level Analyst. Define SLA aligned KPIs for response times, report delivery, and accuracy. Output: KPI list and thresholds.
36. Attribution Gap Analysis: Role: Attribution Auditor. Identify gaps between expected and actual attribution results and propose fixes. Output: gap report and remediation steps.
37. Mobile App Marketing KPIs: You are Mobile Marketing Analyst. List KPIs for app campaigns including retention, activation, and in-app purchases. Output: KPI definitions and data sources.
38. Influencer Campaign Metrics: Act as Influencer Analytics Lead. Propose KPIs for influencer campaigns including reach, engagement, and conversion impact. Output: KPI table with data sources.
39. Video Ad Performance: Role: Video Analytics Specialist. Define KPIs for video ads including completion rate, view-through rate, and impact on conversions. Output: KPI definitions and measurement plan.
40. Paid Social Benchmark: You are Benchmarking Expert. Create a paid social KPI benchmark by platform and industry with ranges. Output: table and interpretation tips.
41. Organic Growth Metrics: Act as Organic Growth Analyst. List KPIs for non-paid growth including share of voice and brand lift. Output: KPI definitions and data sources.
42. Client Risk Dashboard: Role: Risk Analytics Lead. Build a risk dashboard showing budget overruns, underperforming campaigns, and resource constraints. Output: widget list and alert plan.
43. Event Marketing KPIs: You are Event Marketing Analyst. Propose KPIs for events including registrations, attendance, and post event revenue. Output: KPI map and data sources.
44. Content ROI Framework: Act as Content ROI Specialist. Design a framework to attribute revenue to content assets with time to value. Output: formula, data sources, and example calculation.
45. Client Onboarding Demo Metrics: Role: Onboarding Demo Lead. Provide a small demo KPI set to show value during first week with data sources and timing. Output: compact KPI list.
46. Cross Channel Impact: You are Multi Channel Analyst. Create KPIs to measure cross channel impact and assisted conversions. Output: metrics and attribution notes.
47. Campaign Health Signals: Act as Campaign Health Monitor. List dashboard health signals such as data freshness, missing values, and anomaly counts. Output: signal definitions.
48. Client Dashboard Handoff: Role: Handoff Specialist. Prepare a client-ready dashboard handoff packet explaining metrics, data sources, and interpretation tips. Output: handoff outline.
49. Privacy Safe Dashboards: You are Data Privacy Engineer. Define methods to de-identify client data in dashboards while preserving usefulness. Output: techniques and validation steps.
50. Retention for Agencies: Act as Retention Strategist. Build retention KPIs by client tier and provide actions to improve retention. Output: KPI set and recommended tactics.
51. Conversion Path Analysis: Role: Path Analysis Expert. Map conversion paths and identify drop-off points with recommended optimizations. Output: path map and action items.
52. SaaS Marketing Metrics: You are SaaS Marketing Analyst. Propose KPIs for a software client including trials, activations, and churn. Output: KPI list and data sources.
53. Creative Spend Efficiency: Act as Creative Spend Analyst. Measure efficiency of creative spend with assets to revenue correlation. Output: metrics and example calculation.
54. Landing Page A/B Kit: Role: CRO Specialist. Provide a ready-to-run A/B test kit for landing pages with hypotheses and success criteria. Output: test plan and KPIs.
55. Agency Performance Review: You are Agency Performance Analyst. Build a quarterly performance review KPI bundle for clients. Output: metrics and narrative prompts.
56. Cross Client Recurring Report: Act as Reporting Lead. Design a recurring cross-client KPI report with anonymized benchmarks. Output: template and schedule.
57. Defect Tracking for Dashboards: Role: Data Ops. Create a defect tracking system for dashboard data quality issues. Output: workflow and fields.
58. Voice of Client Metrics: You are Voice of Customer Analyst. Propose KPIs to measure client feedback impact on campaigns. Output: KPI list and data sources.
59. Automation Readiness KPIs: Act as Automation Readiness Engineer. List KPIs to monitor the health of automated dashboard pipelines. Output: KPI definitions and thresholds.
60. Data Freshness Rules: Role: Data Freshness Specialist. Define rules for data refresh cadence per data source and explain impact on decisions. Output: rule set.
61. Budget Reforecast Prompts: You are Forecasting Prompts Lead. Create prompts to trigger monthly budget reforecasts based on performance signals. Output: prompts and outputs.
62. Client Segments by Value: Act as Value Segmentation Analyst. Segment clients by revenue potential and align KPIs. Output: segments and metrics.
63. Campaign Lifecycle Dashboard: Role: Lifecycle Analyst. Build a dashboard covering awareness to conversion stages with KPIs at each stage. Output: widget plan.
64. Escape Hatches for Dashboards: You are Dashboard Reliability Engineer. List emergency prompts to recover dashboards when data breaks. Output: failover steps and prompts.
65. Data Source Atlas: Act as Data Architect. Create an atlas of data sources used by marketing dashboards with owners and update cadence. Output: table.
66. Forecast vs Actual Narratives: Role: Narrative Designer. Produce concise narrative snippets comparing forecast to actuals for client reports. Output: text blocks and bullets.
67. Workflow for Client Questions: You are Client Q&A Facilitator. Design a workflow to answer common client questions with data-backed responses. Output: process and template answers.
68. Nonprofit Marketing KPIs: Act as Nonprofit Marketing Analyst. Propose KPI framework tailored for nonprofit campaigns and donors. Output: KPI definitions and data sources.
69. Lifecycle Value Dashboard: Role: LTV Specialist. Build a dashboard showing customer lifetime value by cohort and segment. Output: widgets and data flow.
70. Experiment Runbook: You are Experiment Manager. Create a runbook for marketing experiments with hypothesis, sample size, and success criteria. Output: runbook steps.
71. Agency Client Portal: Act as Portal Designer. Outline a client portal KPI section with live widgets and export options. Output: portal layout notes.
72. Quality Assurance Prompts: Role: QA Lead. Produce prompts for QA checks on dashboard data before sharing with clients. Output: QA checklist.
73. Attribution Summary Card: You are Attribution Designer. Create a one-card summary for attribution results with critical takeaways. Output: card content.
74. Campaign Health Alerts: Role: Alert Engineer. Define alert conditions for underperforming campaigns with escalation paths. Output: alert rules.
75. Media Mix Modeling: Act as MMM Specialist. Outline a simple media mix model for clients and how to show it on a dashboard. Output: method and visualization plan.
76. Client ROI Storyboard: You are Storyboard Designer. Draft a KPI-based narrative storyboard to present ROI to clients. Output: sequence and data points.
77. Changelog for Dashboards: Role: Documentation Analyst. Create a changelog template to track dashboard updates and KPI changes. Output: template.
78. Data Lineage Diagram: Act as Data Lineage Expert. Produce a diagram description showing how data flows to KPI dashboards. Output: description and table of sources.
79. Executive Summary Prompts: You are Executive Reporter. Provide prompts to generate a concise executive summary of KPI dashboards for clients. Output: summary prompts.
80. Seasonal Campaign Planner: Role: Campaign Planner. Build KPIs for seasonal campaigns with seasonal multipliers and risk notes. Output: KPI plan.
81. Geography Performance: Act as Geo Analyst. Define KPIs to measure geographic performance and regional variance. Output: definitions and map visuals.
82. Client Data Refresh Kit: You are Data Ops Lead. Produce a kit to refresh client dashboards with minimal downtime. Output: checklist and steps.
83. Ethical Data Reporting: Role: Compliance Lead. Outline guidelines for ethical data reporting and client consent in dashboards. Output: policy notes.
84. Conversion Funnel Health: Act as Funnel Analyst. Build KPIs to monitor funnel health with drop-off indicators and recovery actions. Output: metrics and alerts.
85. Cross Team Collaboration: You are Collaboration Facilitator. Propose dashboard prompts to align marketing, sales, and product teams. Output: prompts and meeting objectives.
86. Data Visualization Standards: Role: Viz Standards Keeper. Define visualization standards that make KPI dashboards easy to read for clients. Output: standard list.
87. Ancillary Metrics Library: Act as Metrics Librarian. List ancillary metrics that enrich KPI dashboards without clutter. Output: curated metric list.
88. Client Review Prompts: You are Review Facilitator. Create prompts to gather client feedback on dashboard usefulness and clarity. Output: question prompts.
89. Automation Failure Plan: Role: Automation Engineer. Prepare a plan to diagnose and recover from automation failures in dashboards. Output: runbook and alerts.
90. SLA Reporting Prompts: Act as SLA Reporter. Create prompts to generate service level reports showing adherence and exceptions. Output: report prompts.
91. Campaign Timeline KPIs: You are Timeline Analyst. Define KPIs aligned to campaign milestones and deadlines. Output: KPI list and data sources.
92. Client Value Dashboard: Role: Value Dashboard Designer. Build a dashboard focused on demonstrable client value and outcomes. Output: widget descriptions.
93. Data Privacy Dashboards: Act as Privacy Dashboard Expert. Propose dashboards that mask sensitive data while remaining useful. Output: design notes.
94. Ad Creative Efficiency: You are Ad Creative Analyst. Propose KPIs measuring creative efficiency and impact per impression. Output: metrics and example.
95. Conversion Rate by Channel: Role: Channel Analytics. Build KPIs for conversion rate by channel with attribution context. Output: table and notes.
96. Automated Insights Prompts: Act as Insight Generator. Create prompts to generate automated insights from KPI dashboards. Output: prompt templates.
97. Monthly Performance Review: You are Monthly Review Lead. Produce a KPI-focused outline for monthly performance reviews with client-facing language. Output: outline.
98. Export Formats Template: Role: Export Specialist. Define preferred export formats for KPI dashboards and client reports. Output: format specs.
99. Template for New Clients: Act as Template Builder. Provide a ready-to-fill KPI dashboard template for new marketing clients. Output: template with sections.
100. Future KPI Roadmap: You are Roadmap Planner. Propose a KPI dashboard evolution plan for marketing agencies over quarters. Output: roadmap and milestones.

Best Practices

• Document data sources for every KPI to maintain traceability.
• Create reusable prompt templates and keep a central glossary of KPI definitions.
• Test prompts with sample data to ensure calculations are correct.
• Use clear, client-ready language in outputs and narratives.
• Guard against data leakage by masking sensitive client information in dashboards.

Common Mistakes to Avoid

• Assuming data is clean without validation.
• Using vague KPI definitions that confuse clients.
• Overloading dashboards with too many metrics.
• Ignoring data refresh cadence and stale data.
• Copying prompts without adapting to client context.

FAQ

What is the purpose of KPI and dashboard prompts for marketing agencies?

They provide ready-to-use Claude prompts to design and maintain KPI dashboards, ensuring consistent metrics and faster client reporting.

How do I customize prompts for different clients?

Replace placeholders with client-specific values, adjust data sources, and set audience-specific formatting in the output.

Can these prompts handle attribution dashboards?

Yes, many prompts cover attribution, channel performance, and ROI with data requirements and validation steps.

How can I ensure data quality in dashboards?

Use prompts that include data quality checklists, validation steps, and anomaly detection rules.

What formats should outputs take for client reports?

Outputs should be structured as tables, bullet lists, summaries, and export-ready formats like CSV or PDF.

How often should dashboards refresh?

Define refresh cadence in prompts to match data source update frequencies and decision needs.