← Skills

reporting-dashboard

Client-facing metrics dashboards with automated reports

Used by

Skill: Reporting Dashboard

Agent: Devin (Delivery Ops), Daniel (Design) Purpose: Client-facing weekly/monthly metrics dashboard Category: Core Deliverable #6


Build Steps

1. Define Metrics Per Client

Standard metrics (customize per vertical):

  • Leads generated (by source)
  • Response time (average, min, max)
  • Meetings booked
  • Conversion rate (lead → meeting → deal)
  • Revenue attributed to automation
  • Review count and average rating

2. Data Collection

  • Pull from CRM (HubSpot API)
  • Pull from outreach tools (email open/reply rates)
  • Pull from scheduling (bookings, no-shows)
  • Pull from review platforms (Google Business API)

3. Dashboard Build

  • Simple, clean design (Daniel handles styling)
  • Google Sheets or Google Looker Studio (free, client-accessible)
  • Auto-refresh daily
  • Key numbers prominent: total leads, meetings booked, revenue

4. Reporting Cadence

  • Weekly email: Auto-generated summary with key metrics and trends
  • Monthly report: Detailed PDF with comparisons, insights, recommendations
  • Delivered via email + stored in client's workspace

Testing Checklist

  • All data sources connected and pulling correctly
  • Dashboard displays accurate, current data
  • Weekly email generates and sends on schedule
  • Monthly report PDF generates correctly
  • Client can access dashboard independently
View raw SKILL.md
# Skill: Reporting Dashboard

**Agent:** Devin (Delivery Ops), Daniel (Design)
**Purpose:** Client-facing weekly/monthly metrics dashboard
**Category:** Core Deliverable #6

---

## Build Steps

### 1. Define Metrics Per Client
Standard metrics (customize per vertical):
- Leads generated (by source)
- Response time (average, min, max)
- Meetings booked
- Conversion rate (lead → meeting → deal)
- Revenue attributed to automation
- Review count and average rating

### 2. Data Collection
- Pull from CRM (HubSpot API)
- Pull from outreach tools (email open/reply rates)
- Pull from scheduling (bookings, no-shows)
- Pull from review platforms (Google Business API)

### 3. Dashboard Build
- Simple, clean design (Daniel handles styling)
- Google Sheets or Google Looker Studio (free, client-accessible)
- Auto-refresh daily
- Key numbers prominent: total leads, meetings booked, revenue

### 4. Reporting Cadence
- **Weekly email:** Auto-generated summary with key metrics and trends
- **Monthly report:** Detailed PDF with comparisons, insights, recommendations
- Delivered via email + stored in client's workspace

## Testing Checklist

- [ ] All data sources connected and pulling correctly
- [ ] Dashboard displays accurate, current data
- [ ] Weekly email generates and sends on schedule
- [ ] Monthly report PDF generates correctly
- [ ] Client can access dashboard independently