How to: Create a Stakeholder Content Dashboard

A workflow for building a Confluence page that shows executives and PMO leaders a live overview of documentation health - page counts, contributor activity, content growth trends, and top contributors.

Dashboard Structure

Content Dashboard Page
├── Row 1: KPI tiles (Total Pages, New This Month, Stale Pages)
├── Row 2: Pie chart (Content by type) + Bar chart (Top contributors)
└── Row 3: Table (Recently updated pages)

Step 1 - Total Pages KPI

1. Insert the Reports macro → Header: Data Source = Spaces, select your space, Report Type = Table
2. Left Panel: load version expansion
3. Right Panel → Columns: add Page Title (Link type)
4. Set Result Limit to 1000
5. Save. This table is your base - you'll convert it to a chart next

→ For a count-only tile, use the Charts report type with Chart Type = Pie, Group By = Space (shows total in one slice).

Step 2 - Content Type Breakdown Pie Chart

1. Insert a second Reports macro
2. Data Source: Custom CQL → space = "KEY" AND type in (page, blogpost)
3. Report Type: Charts → Chart Type: Pie → Group By: Content Type
4. Save - shows the mix of pages vs blog posts

→ Chart Types

Step 3 - Top Contributors Bar Chart

1. Insert another Reports macro
2. Data Source: Custom CQL → space = "KEY" AND type = page AND lastmodified >= now("-30d")
3. Left Panel: load version expansion
4. Report Type: Charts → Chart Type: Bar → Group By: Last Author (version.by.displayName)
5. Save - shows who updated the most pages this month

Step 4 - Recently Updated Pages Table

1. Insert a final Reports macro
2. Data Source: Custom CQL → space = "KEY" AND type = page ORDER BY lastmodified DESC
3. Left Panel: load version expansion
4. Report Type: Table
5. Columns: Page Title (Link), Last Modified, Last Author, Created By
6. Result Limit: 20 (most recent 20 pages)
7. Save

→ Table View

Step 5 - Arrange and Publish

1. Use Confluence columns layout (two- or three-column) to arrange the macros side by side
2. Add headings above each report section: "Content Overview", "Top Contributors", "Recent Updates"
3. Publish the page

The page is now a live dashboard - all reports update automatically when the page is viewed.

→ Templates - use the Top Contributors and Recently Updated Pages pre-built templates instead of configuring from scratch