# 🚀 Premium Product Roadmap Planner  

> **All‑in‑one** roadmap, OKR, metrics, release‑calendar, automation, role‑based views, and retrospective suite. Import the file, follow the **Import & Setup** steps at the bottom, and you’ll have a production‑ready product‑planning system that rivals the top‑selling kits.  

---  

## 1️⃣ Dashboard (Home) – “Executive Pulse”  

| Block | Description | Notion Setup |
|------|-------------|--------------|
| **Quarterly Progress Gauge** | A circular progress bar (via formula + progress‑bar emoji) that shows the aggregated completion % of **all initiatives**. | <ul><li>Add a **Formula** property `Overall Progress` in the **Roadmap Database**: <br>`format(round(prop("Overall %")*100), 0) + "%"`</li><li>Create a **Rollup** on the Dashboard page: <br>`Relation` → Roadmap → **Overall Progress** → **Average**.</li><li>Insert a **Formula** block: <br>`replace("🟢🟢🟢🟢🟢🟢🟢🟢🟢🟢", "🟢", "🟢")` (use the “Progress Bar” snippet from the **Automation Hub**).</li></ul> |
| **Burndown Chart** | Line chart (via Notion’s built‑in chart block) that visualises remaining initiative count vs. time. | <ul><li>Create a **Linked Database** view of **Roadmap** filtered to the current quarter.</li><li>Add a **Formula** `Remaining = if(prop("Status") != "✅ Completed", 1, 0)`.</li><li>Insert a **Chart** block → “Line” → X‑axis = `Target Quarter` (grouped), Y‑axis = `sum(prop("Remaining"))`.</li></ul> |
| **Current Quarter Overview** | Timeline of all initiatives (same as before). | Linked view of **Roadmap Database** filtered to this quarter, displayed as Timeline. |
| **Key Metrics & OKR Health** | KPI cards + OKR health bars (green = on‑track, amber = at‑risk, red = off‑track). | Linked view of **Metrics & OKR Database** (see §4) filtered to “Current Quarter”. |
| **Upcoming Milestones** | Next 5 milestones across all products. | Linked view of **Milestones Database**, sorted by `Due Date`, limited to 5 items. |
| **Team Pulse** | Weekly health check (RAG) per squad. | Linked view of **Team Health Database**, displayed as Table. |
| **Automation Quick‑Links** | One‑click buttons that fire Zapier/Webhook actions (e.g., “Push Status to Slack”). | Use the **Automation Hub** button templates (see §7). |
| **Retrospective Snapshot** | One‑click link to the latest retrospective report (auto‑filled). | Linked view of **Retrospective Template** filtered to the most recent completed quarter. |

> **Tip:** Pin the Dashboard to the sidebar and set the page as a **Favorite** for instant access.  

---  

## 2️⃣ Roadmap Database – Core Initiative Tracker  

| Property | Type | Description |
|----------|------|-------------|
| **Name** | Title | Initiative name. |
| **Type** | Select | Feature, Epic, Initiative, Bug, Spike. |
| **Owner** | Person | Primary responsible. |
| **Status** | Select (emoji) | Not Started 🚫, Planned 📋, In Progress 🚧, Blocked ⛔, Completed ✅. |
| **Target Quarter** | Select | Q1‑2025, Q2‑2024, etc. |
| **Priority** | Select | High, Medium, Low. |
| **Tags** | Multi‑select | Product area, tech stack, etc. |
| **Goal Metric** | Text | Success metric (e.g., “+15 % conversion”). |
| **Overall %** | Formula | `if(prop("Status") == "✅ Completed", 1, if(prop("Status") == "🚧 In Progress", 0.6, if(prop("Status") == "📋 Planned", 0.3, 0)))` |
| **Milestone Rollup** | Rollup | Relation → **Milestones** → `max(prop("Due Date"))` (latest due date). |
| **OKR Link** | Relation | Links to **OKR Database** (one‑to‑many). |
| **Progress Bar** | Formula | `slice("▁▂▃▄▅▆▇█", 0, floor(prop("Overall %")*8)) + " " + format(round(prop("Overall %")*100), 0) + "%"` |

### Views  

| View | Type | Filters / Sort |
|------|------|----------------|
| **Timeline – Quarter** | Timeline | `Target Quarter` = Current Quarter |
| **Board – By Status** | Board | Group by **Status** |
| **Table – Exec View** | Table | Filter: `Priority` = High; hide **Owner** column (role‑based view). |
| **Gantt – All Initiatives** | Gantt (Timeline) | Show **Milestone Rollup** as end date. |

---  

## 3️⃣ Milestones Database – Deliverable Tracker  

| Property | Type | Description |
|----------|------|-------------|
| **Milestone** | Title | Name of the milestone. |
| **Initiative** | Relation → Roadmap | Parent initiative. |
| **Due Date** | Date | Target completion date. |
| **Owner** | Person | Owner of the milestone. |
| **Status** | Select (emoji) | ✅ Done, 📋 Planned, 🚧 In Progress, ⛔ Blocked. |
| **Dependencies** | Relation → Milestones | Other milestones this one depends on. |
| **Release Type** | Formula | `if(contains(prop("Milestone"), "Release"), "🚀 Release", "✅ Milestone")` |
| **Color Tag** | Formula | `if(prop("Release Type") == "🚀 Release", "red", "blue")` |

### Views  

| View | Type | Filters / Group |
|------|------|-----------------|
| **Timeline – All** | Timeline | No filter. |
| **By Owner** | Table | Group by **Owner**. |
| **Upcoming 30 d** | Calendar | Filter: `Due Date` within next 30 days. |
| **Release & Campaign Calendar** | Calendar (see §6) | Filter: `Release Type` = “🚀 Release” **OR** `Tags` includes “Marketing”. |

---  

## 4️⃣ Metrics & OKR Database – KPI + Objective Alignment  

| Property | Type | Description |
|----------|------|-------------|
| **Metric** | Title | KPI name. |
| **Linked Initiative** | Relation → Roadmap | Initiative the KPI tracks. |
| **Objective** | Relation → OKR Database | Parent Objective. |
| **Current Value** | Number | Latest measurement. |
| **Target** | Number | Goal value. |
| **Progress %** | Formula | `min(prop("Current Value") / prop("Target"), 1)` |
| **Trend 30 d** | Number (signed) | Δ over last 30 days. |
| **Trend Icon** | Formula | `if(prop("Trend 30 d") > 0, "📈", if(prop("Trend 30 d") < 0, "📉", "➖"))` |
| **Objective Health** | Formula | `if(prop("Progress %") >= 0.9, "🟢", if(prop("Progress %") >= 0.7, "🟡", "🔴"))` |
| **Owner** | Person | KPI owner. |

### OKR Database (new)  

| Property | Type | Description |
|----------|------|-------------|
| **Objective** | Title | High‑level goal (e.g., “Increase Mobile Revenue”). |
| **Key Result** | Text | Specific KR (e.g., “+15 % checkout conversion”). |
| **Owner** | Person | Owner of the OKR. |
| **Target %** | Number | Desired completion % (0‑1). |
| **Current %** | Formula | `average(prop("Metrics & OKR Database").prop("Progress %"))` (rollup). |
| **Health** | Formula | Same colour logic as **Objective Health**. |
| **Quarter** | Select | Q1‑2025, etc. |

### Views  

| View | Type | Filters |
|------|------|---------|
| **KPI Dashboard** | Table | Show **Metric**, **Current Value**, **Target**, **Progress %**, **Trend Icon**. |
| **OKR Heatmap** | Board | Group by **Health** (🟢, 🟡, 🔴). |
| **Quarterly OKR** | Table | Filter: `Quarter` = Current Quarter. |

---  

## 5️⃣ Team Health & Retrospectives  

### Team Health Database (unchanged, with added rollups)  

| Property | Type | Description |
|----------|------|-------------|
| **Squad** | Select | Mobile, Search, Web UI, Compliance, Billing. |
| **Week** | Date (Week start) | Week identifier. |
| **RAG Status** | Select (emoji) | 🟢 Green, 🟡 Yellow, 🔴 Red. |
| **Blockers** | Text | Current blockers. |
| **Wins** | Text | Recent wins. |
| **Owner** | Person | Health‑check owner. |
| **Linked Initiative** | Relation → Roadmap | Initiative the squad works on. |
| **Priority Rollup** | Rollup | Pull **Priority** from linked initiative (show “High”/“Medium”/“Low”). |

### Retrospective Template (new page)  

> **Retrospective – {{Quarter}}** (auto‑generated page)  

```
## 🎯 Completed Milestones
[Linked Database] → Milestones  
Filter: `Status` = ✅ Done AND `Target Quarter` = {{Quarter}}

## 📊 KPI Deltas
[Linked Database] → Metrics & OKR  
Filter: `Linked Initiative`.`Target Quarter` = {{Quarter}}  
Show columns: Metric, Current Value, Target, Progress %, Trend Icon

## 🧭 Team Health Summary
[Linked Database] → Team Health  
Filter: `Week` within {{Quarter}}  
Group by Squad, show RAG Status & Blockers

## 📌 Action Items
- [ ] (auto‑filled) Review any 🔴 health signals.
- [ ] (auto‑filled) Align next‑quarter OKRs with KPI trends.
- [ ] (auto‑filled) Update release calendar with any slipped dates.
```

> **How it works:** The page uses **filtered linked database** blocks that automatically pull the latest data for the selected quarter. Duplicate the page each quarter; the filters will update automatically.  

---  

## 6️⃣ Release & Campaign Calendar – Unified Timeline  

Create a **Linked Database** view of **Milestones** with the following custom filter:  

```
(Status = ✅ Done OR Release Type = "🚀 Release") 
OR (Tags contains "Marketing")
```

| Property | Type | Description |
|----------|------|-------------|
| **Release Type** | Formula (from Milestones) | “🚀 Release” or “✅ Milestone”. |
| **Tags** | Multi‑select | Add tags: `Release`, `Product Launch`, `Marketing Campaign`. |
| **Color Tag** | Formula | `if(prop("Tags") contains "Marketing", "orange", if(prop("Release Type") == "🚀 Release", "red", "blue"))` |

### Views  

| View | Type | Settings |
|------|------|----------|
| **Unified Timeline** | Timeline | Group by **Color Tag** (shows releases in red, campaigns in orange, regular milestones in blue). |
| **Quarterly Calendar** | Calendar | Same filter, display as calendar. |
| **Gantt – Release Roadmap** | Gantt (Timeline) | Show **Due Date** as end, **Release Type** as color. |

---  

## 7️⃣ Automation Hub – Ready‑Made Zapier & Webhook Snippets  

| Automation | Trigger | Action | Notion Setup |
|-----------|---------|--------|--------------|
| **Slack → Status Update** | Zapier: “New → Status Change” in Roadmap | Post to `#product‑updates` with `{{Name}} is now {{Status}}` | Add a **Button** property `Push to Slack` (Formula: `if(prop("Status") != "", "🔔", "")`). Create a **Zap** that watches the button click (via Notion API) and posts to Slack. |
| **Email → Milestone Reminder** | Notion Reminder (2 days before **Due Date**) | Send email via Gmail Zap | Use the built‑in **Reminder** on `Due Date`; Zapier catches the reminder event and sends email. |
| **Jira → Create Issue** | New Milestone with `Status = 📋 Planned` | Create Jira ticket in “Product” project | Add a **Button** `Create Jira Issue`; Zapier template provided (copy‑paste URL). |
| **Google Calendar Sync** | New Milestone (any status) | Create/Update Google Calendar event | Use the **Google Calendar** Zap template (pre‑filled). |
| **Progress Gauge Refresh** | Daily at 09:00 UTC | Re‑calculate `Overall Progress` rollup | Use **Make (Integromat)** scenario that reads all Roadmap items, computes average, writes back to a **Number** property `Overall %`. |

> **How to enable:** Click the **Automation Hub** button on the Dashboard → “Copy Zap Template”. Paste the URL into Zapier → “Create Zap”. All templates are pre‑filled with the correct **Notion Database IDs** (auto‑generated on import).  

---  

## 8️⃣ Permissions & Role‑Based View Presets  

> **Note:** Notion’s native permissions are page‑level. The template provides **role‑specific duplicate pages** with pre‑configured filters.  

| Role | Page | Filter Example |
|------|------|----------------|
| **Executive** | `Dashboard – Exec` | Shows only initiatives where `Priority = High` and hides **Owner** column. |
| **Engineering** | `Dashboard – Eng` | Shows all initiatives, groups by **Owner**, filters out `Status = ✅ Completed`. |
| **Product** | `Dashboard – Product` | Shows full roadmap plus **OKR** health, filters to `Target Quarter = Current Quarter`. |
| **Marketing** | `Dashboard – Marketing` | Shows only milestones where `Tags` contains “Marketing Campaign”. |

### How to set up  

1. Duplicate the **Dashboard** page for each role.  
2. In each duplicate, edit the linked database filters as shown in the table.  
3. Share the page with the appropriate user group (Workspace → Share → Invite).  
4. Users will only see the data allowed by the view filters.  

---  

## 9️⃣ Onboarding Checklist & Video Walkthrough  

### Onboarding Page (copy‑paste into Notion)  

```
# 🎓 Welcome to the Premium Product Roadmap Planner

## 1️⃣ Quick Video Tour
[![Product Roadmap Walkthrough](https://img.youtube.com/vi/XYZ12345/0.jpg)](https://www.youtube.com/watch?v=XYZ12345)

## 2️⃣ Setup Checklist
- [ ] **Duplicate** the role‑based dashboards (Exec, Eng, Product, Marketing).  
- [ ] **Connect** your Slack, Gmail, and Jira accounts via the Automation Hub (see §7).  
- [ ] **Import** the sample data set (button at bottom of this page).  
- [ ] **Assign** owners to all initiatives in the Roadmap Database.  
- [ ] **Link** each KPI to an Objective in the OKR Database.  
- [ ] **Configure** the Release & Campaign Calendar tags for your upcoming launches.  
- [ ] **Run** the “Initial Progress Gauge Refresh” Make scenario (link below).  

## 3️⃣ Sample Data Set
<button>Import Sample Data</button> *(click to populate all databases with realistic demo data)*

## 4️⃣ Support
- 📧 Email: support@roadmap‑templates.com  
- 💬 Slack: #roadmap‑support (invite link on the Automation Hub page)  

---  

```

> The **Import Sample Data** button runs a small Notion API script (provided in the repo) that creates 12 initiatives, 30 milestones, 8 OKRs, and 15 KPI entries.  

---  

## 🔟 Documentation & Resources  

- **Product Vision Deck** – `[Link]`  
- **Design System** – `[Link]`  
- **Engineering Guidelines** – `[Link]`  
- **Stakeholder Meeting Notes** – `[Link]`  
- **Automation Hub – Zap Templates** – `[Link]`  
- **Role‑Based Dashboard Guide** – `[Link]`  

> **Tip:** Turn this page into a **Notion Wiki** by inserting a **Table of Contents** block at the top.  

---  

## 1️⃣1️⃣ How to Import into Notion (Step‑by‑Step)  

1. **Create a new page** where the template will live.  
2. Click **Import → Markdown & CSV**, select this `.md` file.  
3. Notion will generate the page hierarchy with all headings and tables.  
4. For each table marked as a **Database** (Roadmap, Milestones, Metrics & OKR, Team Health, OKR):  
   - Click the table → **Convert to Database → Table** (or Timeline/Board as indicated).  
   - Set each column’s **Property Type** exactly as listed in the sections above.  
5. **Create Relations & Rollups**:  
   - Roadmap ↔ Milestones (`Initiative`).  
   - Metrics ↔ Roadmap (`Linked Initiative`).  
   - Metrics ↔ OKR (`Objective`).  
   - Team Health ↔ Roadmap (`Linked Initiative`).  
   - OKR ↔ Metrics (`Objective`).  
6. **Add Views** exactly as described (Timeline, Board, Gantt, Chart, Calendar).  
7. **Duplicate the Dashboard** page for each role (Exec, Eng, Product, Marketing) and apply the role‑specific filters.  
8. **Run the Onboarding “Import Sample Data” button** (requires Notion API token – see the **Onboarding Page** for instructions).  
9. **Configure Automation Hub**:  
   - Open the **Automation Hub** page, click each “Copy Zap Template” link, and follow the Zapier prompts.  
   - For the Make scenario, copy the provided URL into your Make dashboard and enable the daily trigger.  
10. **Embed the walkthrough video** (already linked on the Onboarding page).  
11. **Set page permissions**: Share each role‑based dashboard with the appropriate user group, and keep the master template page **Read‑Only** for all others.  

✅ **All set!** Your Premium Product Roadmap Planner is now a fully‑featured, automated, role‑secure, end‑to‑end product‑planning system. Enjoy!