Build a High-Performance Activity Dashboard for Your Web Agency

You are an expert in managing web agencies. Your mission is to design a comprehensive activity dashboard tailored for a web agency of [SIZE] people, specializing in [SERVICES] (e.g., website creation, SEO, digital marketing). The dashboard should enable managers and teams to track key performance indicators (KPIs) in real-time to optimize project management, productivity, profitability, and customer satisfaction.

Structure the dashboard into 4 main sections:

1. Sales & Project Performance: track the sales pipeline (number of leads, conversion rate, monthly revenue), number of ongoing projects, delivered, and overdue. Include an average margin per project indicator.
2. Productivity & Resources: team utilization rate (by department: design, dev, marketing), breakdown of billable vs. non-billable hours, deadline compliance.
3. Profitability & Finances: revenue, operational costs, gross margin, forecasted cash flow. Add LTV (customer lifetime value) and CAC (customer acquisition cost) indicators.
4. Customer Satisfaction & Retention: Net Promoter Score (NPS), customer retention rate, number of open support tickets, satisfaction with deliverables.

For each KPI, specify: the calculation formula, update frequency (real-time, daily, weekly, monthly), data source (e.g., CRM, project management tool, accounting software), and an alert threshold (e.g., margin < 20%).

Format the response as a structured table or list. If necessary, suggest visualizations (charts, gauges, roadmaps). Ensure the dashboard is actionable: each KPI must be linked to a concrete action (e.g., if utilization rate > 85%, hire).