Use Case Templates
Three ready-to-use report templates for the most common Confluence reporting scenarios. Each template includes a CQL query, recommended expansions, and column configuration.
Template 1: Content Health Dashboard
Purpose: Identify stale, unowned, or high-risk pages across a Confluence space. Gives admins and documentation leads a full picture of content health in one report.
Recommended View: Table
CQL Query
type = page AND space = "YOUR_SPACE_KEY" AND lastmodified <= now("-60d") AND status = "current"
Replace
YOUR_SPACE_KEYwith your target space key (e.g., "DOCS", "ENG", "HR").
Expansions to Load
version- for last modifier and last modified datehistory- for original creator and creation datemetadata- for labels
Column Configuration
| Column Label | Block Type | Source Field |
|---|---|---|
| Page Title | Link | title → _links.webui |
| Space | Basic | space.name |
| Original Creator | Basic | history.createdBy.displayName |
| Last Modified By | Basic | version.by.displayName |
| Last Modified | Basic | version.when |
| Created Date | Basic | history.createdDate |
| Labels | Collection | metadata.labels.results[].name |
How to Use
- Open the macro editor and set Data Source to Custom CQL.
- Paste the CQL query above - update the space key.
- Load the three expansions listed.
- Add columns as shown in the table above.
- Set Result Limit to 200–500 for a comprehensive audit.
- Sort by Last Modified (ascending) - oldest pages appear first.
- Export as CSV to share with the team.
Template 2: Space Activity Report
Purpose: Track documentation activity across a Confluence space - which pages are being updated, who is updating them, and how often. Ideal for manager dashboards and team reporting.
Recommended View: Table (for data) + Charts (for trends)
CQL Query
type = page AND space = "YOUR_SPACE_KEY" AND lastmodified >= now("-30d") ORDER BY lastmodified DESC
Adjust the date window (
now("-30d")) to 7 days, 14 days, or 90 days as needed.
Expansions to Load
version- for last modifier and last modified datehistory- for creation date
Column Configuration (Table View)
| Column Label | Block Type | Source Field |
|---|---|---|
| Page Title | Link | title → _links.webui |
| Last Modified By | Basic | version.by.displayName |
| Last Modified | Basic | version.when |
| Version Number | Basic | version.number |
| Created Date | Basic | history.createdDate |
Chart Configuration (Charts View)
| Chart Goal | Chart Type | Group By | Metric |
|---|---|---|---|
| Updates over time | Line | Month (lastmodified) | Count |
| Top editors in space | Bar | version.by.displayName | Count |
How to Use
- Build the Table view report first - use the CQL and columns above.
- Save and review the data.
- Insert a second macro on the same page - configure it as a Chart.
- Use the same CQL query, set Chart Type to Line, Group By Month.
- Add a second chart macro for Bar chart - Group By last modifier.
- Save both macros to create a combined data + visual activity dashboard.
Template 3: Contributor Tracking Report
Purpose: Track who is contributing to documentation - original creators and active editors - and measure contribution patterns across a space or the entire Confluence instance.
Recommended View: Table + Bar Chart
CQL Query (All recent contributors)
type = page AND (creator = currentUser() OR contributor = currentUser()) ORDER BY lastmodified DESC
CQL Query (Space-wide contributor view - for admins)
type = page AND space = "YOUR_SPACE_KEY" AND lastmodified >= now("-90d")
Expansions to Load
version- for last modifierhistory- for original creator and contributors
Column Configuration (Table View)
| Column Label | Block Type | Source Field |
|---|---|---|
| Page Title | Link | title → _links.webui |
| Original Creator | Basic | history.createdBy.displayName |
| Last Modified By | Basic | version.by.displayName |
| Last Modified | Basic | version.when |
| Space | Basic | space.name |
| Version | Basic | version.number |
Chart Configuration (Bar Chart)
| Setting | Value |
|---|---|
| Chart Type | Bar |
| Group By | version.by.displayName (last modifier) |
| Metric | Count |
| Use Case | Ranks editors by number of page updates |
How to Use
- Use the personal CQL query (
creator = currentUser()) for a personal contribution dashboard. - Use the space-wide CQL for admin-level contributor tracking across the team.
- Load version and history expansions.
- Build the Table view to see individual page contributions.
- Add a second macro with Bar chart to visualize top contributors at a glance.
- Export the Table view as CSV for performance reviews or team reporting.
Tip: The "Content Created by Me" and "Pages Updated By a Specific User" pre-built templates in the Templates tab cover similar scenarios and can be used as starting points.