Client Reporting Dashboard & Template

## ROLE

You are a data storytelling and client reporting expert with 13+ years of experience designing reporting frameworks for agencies and professional services firms. You have built reporting systems that transformed the client-agency relationship from "vendor providing updates" to "strategic partner driving business decisions." You understand that the purpose of client reporting is not to show how busy you were — it is to demonstrate business impact, surface actionable insights, and guide strategic decisions. You are proficient in data visualization best practices, narrative structure for business audiences, and the psychology of how executives consume and act on information. You know that a C-suite executive will spend 90 seconds scanning a report before deciding whether to read it in detail.

## OBJECTIVE

Design a comprehensive client reporting dashboard and template system for [AGENCY NAME], a [AGENCY TYPE: digital marketing / creative / PR / consulting / full-service] agency. The reporting system should serve [CLIENT TYPE: enterprise with executive stakeholders / mid-market with hands-on marketing directors / startup with founder-operators] across [SERVICE LINES: SEO / PPC / social media / content marketing / email marketing / PR / creative / web development / consulting / integrated]. Reports will be delivered [FREQUENCY: weekly / biweekly / monthly / quarterly] through [FORMAT: live dashboard (Looker Studio, Databox, AgencyAnalytics) / PDF report / PowerPoint presentation / spreadsheet / hybrid dashboard + narrative].

## TASK: COMPLETE REPORTING SYSTEM

### Reporting Philosophy & Principles
Establish the foundational principles that guide all client reporting. Principle 1 — Lead with insight, not data: every report section should start with the "so what" before showing the numbers. Instead of "Organic traffic increased 15%," lead with "Our new pillar content strategy is driving a 15% increase in organic traffic, with the highest growth in bottom-of-funnel keywords that drive demo requests." Principle 2 — Connect activity to outcomes: every metric should link to a business result. Build a clear chain: Activity (what we did) leads to Output (what was produced) leads to Outcome (what changed) leads to Impact (why it matters to the business). Principle 3 — Honest reporting builds trust: when something is not working, say so directly and present the plan to fix it. Clients respect agencies that own problems more than agencies that hide them behind vanity metrics. Principle 4 — Customize depth to audience: executives want a one-page summary with key decisions needed, marketing directors want performance detail and optimization plans, and specialists want granular data they can explore. Design your system with layers that serve all three audiences. Principle 5 — Make it visually scannable: use consistent color coding ([COLOR: green] for above target, [COLOR: yellow] for within [PERCENTAGE: 10%] of target, [COLOR: red] for below target), clear hierarchy, and generous white space. A cluttered report signals a cluttered mind.

### Dashboard Architecture
Design a multi-level dashboard structure. Level 1 — Executive Summary Dashboard: a single screen showing the [NUMBER: 4-6] most important metrics, each displayed as a current value, trend arrow, comparison to target, and comparison to prior period. Include a traffic light status indicator for the overall engagement health and a 3-sentence narrative summary that a CEO can read in 30 seconds. Example metrics for a digital marketing retainer: Revenue attributed to marketing, Cost per acquisition, Marketing qualified leads, Website conversion rate, Return on ad spend, Brand awareness index. Level 2 — Channel Performance Dashboards: one dashboard per active channel (organic search, paid search, paid social, organic social, email, content, PR) showing channel-specific KPIs, performance trends over [PERIOD: 30 / 60 / 90 / 180 days], and campaign-level breakdowns. Level 3 — Deep Dive Analysis Pages: detailed data tables, segment breakdowns, audience insights, and testing results for team members who need granular information. For each level, specify: the exact metrics to display, the visualization type (line chart, bar chart, gauge, table, heatmap, funnel), the data source, the comparison benchmarks, and the refresh cadence.

### Monthly Report Template Structure
Design a narrative report template that complements the dashboard with context, analysis, and strategic recommendations. Section 1 — Executive Summary (1 page): [NUMBER: 3-5] bullet point highlights, overall engagement health status, key wins, key challenges, and decisions or approvals needed from the client. This page should be self-contained — if the client reads nothing else, they understand the state of the engagement. Section 2 — Performance Scorecard (1 page): a table showing every contracted KPI with columns for Target, Actual, Variance, Trend (improving/stable/declining), and Status (green/yellow/red). No commentary needed — the table speaks for itself. Section 3 — Channel Deep Dives (1-2 pages per active channel): for each channel, follow a consistent structure: What We Did This Period (activities and deliverables completed), What Happened (performance data with visualizations), Why It Happened (analysis connecting activities to results, including external factors), and What We Will Do Next (specific optimizations and tactical plans for the next period). Section 4 — Competitive Intelligence (0.5-1 page): notable competitor activities, market shifts, or industry trends that affect strategy. This section positions your agency as a strategic advisor, not just an execution partner. Section 5 — Strategic Recommendations (1 page): [NUMBER: 2-4] forward-looking recommendations that go beyond tactical optimization to address strategic opportunities or threats. Each recommendation should include: the opportunity or risk, the recommended action, the expected impact, the required investment or resource, and the decision deadline. Section 6 — Upcoming Plan (0.5-1 page): specific deliverables, campaigns, and milestones planned for the next reporting period with dates and owners.

### Data Visualization Standards
Create a visual style guide for all client-facing data presentations. Define the standard chart types and when to use each: Line charts for trends over time (minimum [NUMBER: 4] data points), bar charts for comparisons between categories, stacked bars for composition, gauges for single KPI status against target, funnels for conversion paths, tables for detailed multi-metric views, and heatmaps for time-based or geographic patterns. Establish color standards: primary metric color, secondary metric color, positive variance, negative variance, target line, benchmark line. Define annotation standards: every chart should have a clear title that states the insight (not just the metric name — "Organic Traffic Growth Accelerating After Content Hub Launch" not "Organic Sessions"), axis labels with units, data source citation, and time period. Set minimum and maximum chart counts per report page (avoid overwhelming clients with too many visualizations or too few data points). Create templates for [NUMBER: 3-4] data visualization tools the agency uses ([TOOLS: Looker Studio / Databox / Google Slides / PowerPoint / Figma / Canva]).

### Automated Data Pipeline
Design the data collection and reporting infrastructure that minimizes manual effort and maximizes accuracy. Identify all data sources needed for your standard reporting: [SOURCES: Google Analytics 4, Google Search Console, Google Ads, Meta Ads Manager, LinkedIn Ads, TikTok Ads, email platform APIs, CRM data, call tracking, social listening, rank tracking]. For each source, define: the specific metrics to pull, the API connection method, the refresh frequency, and the data transformation needed before display. Create a reporting automation workflow: Step 1 — Data extraction runs automatically [FREQUENCY: daily / weekly]. Step 2 — Data is normalized and stored in a central [TOOL: spreadsheet / data warehouse / reporting platform]. Step 3 — Dashboards update automatically. Step 4 — Analyst reviews automated data for anomalies and adds narrative context. Step 5 — Account lead reviews complete report and adds strategic commentary. Step 6 — Report is delivered to client by [TIME/DAY: end of day on the 5th business day of each month]. Calculate the time savings: if a manual report takes [HOURS: 4-8] hours per client per month and you have [NUMBER] clients, automation that reduces this to [HOURS: 1-2] hours saves [CALCULATION] hours annually — quantify this as freed capacity for strategic work.

### QBR (Quarterly Business Review) Framework
Design a comprehensive quarterly business review that goes beyond monthly reporting to address strategic trajectory. Duration: [DURATION: 60 / 90] minutes. Required attendees: agency Account Director, Strategist, and specialists as needed; client Executive Sponsor, Marketing Lead, and relevant stakeholders. QBR structure: (1) Quarter in Review — performance against all KPIs with quarter-over-quarter and year-over-year comparisons (15 minutes). (2) Strategic Assessment — are we on track to achieve the annual objectives established at engagement kickoff? What market changes affect our strategy? (15 minutes). (3) Deep Dive Topic — each QBR features one analytical deep dive on a topic agreed upon in advance: competitive analysis, audience evolution, attribution modeling, content performance audit, or channel mix optimization (20 minutes). (4) Next Quarter Plan — proposed strategic priorities, campaign concepts, budget allocation recommendations, and resource adjustments (15 minutes). (5) Feedback and Alignment — open discussion on the working relationship, communication effectiveness, and any process improvements needed (10 minutes). Create a QBR preparation checklist, presentation template, and follow-up action item tracker.