Build a KPI Dashboard for a Web Agency
This prompt generates a comprehensive and personalized KPI dashboard for a web agency, integrating financial, operational, and relational metrics.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a digital strategy consultant specializing in web agencies. Build an operational KPI dashboard for [AGENCY_NAME], which employs [NUMBER_OF_COLLABORATORS] collaborators and generates an annual revenue of [ANNUAL_REVENUE] euros. The agency offers services in [MAIN_SERVICES] (e.g., website creation, SEO, SEA, marketing automation).
The dashboard must include 4 main sections:
- Acquisition & Sales: tracking of incoming leads (via [LEAD_SOURCES]), prospect-to-client conversion rate, average basket, and revenue generated by service type.
- Key Account Performance: tracking of revenue by client (top 5), retention rate, NPS, and number of recurring contracts.
- Profitability & Productivity: gross margin per project, resource utilization rate, customer acquisition cost (CAC) vs. lifetime value (LTV).
- Satisfaction & Quality: average rating of delivered projects, on-time delivery rate, number of client support tickets.
For each metric, specify: unit, update frequency (weekly/monthly), alert threshold (e.g., margin < 20%), and data source (CRM tool, billing software, etc.).
Ensure the dashboard is suitable for a monthly review with executives and includes a summary view for the executive committee. Use precise B2B language.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
<p>This prompt is designed to obtain a structured dashboard that addresses the specific challenges of a web agency. By replacing the variables <strong>[AGENCY_NAME]</strong>, <strong>[NUMBER_OF_COLLABORATORS]</strong>, <strong>[ANNUAL_REVENUE]</strong>, <strong>[MAIN_SERVICES]</strong>, and <strong>[LEAD_SOURCES]</strong>, you get a customized tool.</p><p>To use it, copy the prompt into your preferred generative AI, fill in the variables with your agency's actual data, and request an output format (e.g., a table or document). You can refine the result by asking for visualizations or priorities.</p><p>This dashboard helps you drive growth, optimize profitability, and improve client satisfaction. It is ideal for monthly reviews with management and sales teams.</p>
Use Cases
Expected Output
A detailed dashboard plan structured in sections, with for each metric: definition, unit, frequency, alert threshold, and data source.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
Be the first to comment on this prompt.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Define impactful OKRs for your tech startup
Structured prompt to define OKRs specific to a B2B tech startup, incorporating sector-specific constraints and levers.
Project Brief Template
Getting all the information needed before starting work
Develop Your Gym Pricing Strategy
This prompt helps you build a comprehensive pricing strategy for a gym, taking into account competitors, customer segments, and financial goals.
Root Cause Analysis
Diagnosing the real source of client problems