# Author’s Book Writing Hub (Premium Edition)

---

## 📊 Dashboard  
A single‑page command center that pulls the most critical data via **linked database views**, **formula cards**, and **progress visualizations**. Duplicate this page to keep a personal “quick‑glance” hub for each project.

| Card | Type | Description |
|------|------|-------------|
| **Current Project** | Linked Table (Book Projects) | Filter: `Status = In Progress` – shows Project Title, Target Word Count, Total Word Count, **Progress %** (formula), and a **progress bar**. |
| **Today’s Writing Goal** | Linked Calendar (Writing Schedule) | Filter: `Date = today()` – shows scheduled chapter, target words, and status check‑box. |
| **Upcoming Deadlines** | Linked Calendar (Marketing & Launch) | Shows all launch milestones for the active book. |
| **Word‑Count Velocity** | Formula Card | `round(prop("Total Word Count") / max(dateBetween(now(), prop("Start Date"), "days"), 1), 0)` → words per day. |
| **Budget Summary** | Rollup Card (Budget & Royalty Tracker) | Shows **Total Expenses**, **Total Income**, **Net Profit**, and a **budget bar** (`prop("Total Income") - prop("Total Expenses")`). |
| **Marketing KPI** | Linked Table (Marketing Content Templates) | Filter: `Status = Published` – columns: Platform, Scheduled Date, Open Rate (Number), Click‑Through Rate (Number). |
| **Progress Bar** | Formula Card | `slice("▓▓▓▓▓▓▓▓▓▓", 0, floor(prop("Progress %")/10)) + slice("░░░░░░░░░░", floor(prop("Progress %")/10))` – visual bar for overall manuscript progress. |

> **Tip:** Use Notion’s **Sync block** to embed any of these cards on other pages (e.g., daily journal, team reviewer dashboard).

---

## 📚 Book Projects  
Top‑level database storing every manuscript from concept to publication.

| Property | Type | Details |
|----------|------|---------|
| **Project Title** | Title | – |
| **Genre** | Select | Fantasy, Thriller, Self‑Help, etc. |
| **Status** | Select | Idea, Outline, Drafting, In Progress, Editing, Published |
| **Target Word Count** | Number | Format: `#,###` |
| **Start Date** | Date | First day of writing. |
| **Expected Release** | Date | Publication target. |
| **Primary Author** | Person | – |
| **Cover Image** | Files & media | Upload cover concepts. |
| **Total Word Count** | Rollup (Chapter Tracker → Current Word Count) | Sum of all related chapters. |
| **Progress %** | Formula | `round(prop("Total Word Count") / prop("Target Word Count") * 100, 1)` |
| **Budget Spent** | Rollup (Budget & Royalty Tracker → Amount where Category = Expense) | Sum. |
| **Revenue Earned** | Rollup (Budget & Royalty Tracker → Amount where Category = Income) | Sum. |

### Views
- **All Projects** – Table, grouped by **Status**.  
- **Active Project** – Filter `Status = In Progress`.  
- **Published** – Filter `Status = Published`.  

---

## 📖 Chapter Tracker  
Database for every chapter, linked to **Book Projects** and **Characters**.

| Property | Type | Details |
|----------|------|---------|
| **Chapter #** | Number | Auto‑increment (use formula `prop("Chapter #") + 1` when adding). |
| **Title** | Title | – |
| **Book** | Relation → **Book Projects** | One‑to‑many. |
| **Word Goal** | Number | Target words for the chapter. |
| **Current Word Count** | Number | Updated manually or via Zapier import. |
| **Status** | Select | Not Started, Drafting, Editing, Completed |
| **Draft Link** | URL | Link to Google Doc / Scrivener export. |
| **Reviewer** | Person | Assigned beta reader or editor. |
| **Last Edited** | Last edited time | Auto‑updates. |
| **Characters Appearing** | Relation → **Character & World‑Building** (filter Type = Character) | Multi‑select. |
| **Notes** | Rich text | Quick‑ref notes. |

### Views
- **By Book** – Table, filtered by the selected book, grouped by **Status**.  
- **Progress Bar** – Formula column `slice("▓▓▓▓▓▓▓▓▓▓", 0, floor(prop("Current Word Count") / prop("Word Goal") * 10)) + slice("░░░░░░░░░░", floor(prop("Current Word Count") / prop("Word Goal") * 10))`.  
- **Reviewer Dashboard** – Filter `Reviewer is not empty`, grouped by **Reviewer**.  

---

## 🧙‍♀️ Character & World‑Building  
A fully‑fledged tracker for every element of your story world.

| Property | Type | Details |
|----------|------|---------|
| **Name** | Title | – |
| **Type** | Select | Character, Location, Faction, Item, Concept |
| **Book** | Relation → **Book Projects** | – |
| **Chapter Appearances** | Relation → **Chapter Tracker** | Multi‑select. |
| **Traits / Keywords** | Multi‑select | e.g., “Brave”, “Urban”, “Magical”. |
| **Arc** | Text | Short description of growth or plot role. |
| **Timeline** | Date range | When the element is introduced / active. |
| **Status** | Select | Draft, Confirmed, Revised, Retired |
| **Notes** | Rich text | Detailed description, backstory, references. |
| **Image** | Files & media | Visual reference or concept art. |

### Views
- **All Elements** – Table, grouped by **Type**.  
- **Characters** – Filter `Type = Character`, grouped by **Status**.  
- **World Map** – Gallery view showing images for Locations & Factions.  

---

## 📚 Research Library  
Central repository for sources, notes, and inspiration. Linked to chapters and world‑building entries.

| Property | Type | Details |
|----------|------|---------|
| **Source Type** | Select | Book, Article, Interview, Image, Video, Website |
| **Title / Citation** | Title | – |
| **Link** | URL / Web bookmark | Auto‑preview thumbnail. |
| **Notes** | Rich text | Summaries, quotes, ideas. |
| **Relevance** | Multi‑select | All Chapters, Specific Chapters, Characters, Locations |
| **Related Chapters** | Relation → **Chapter Tracker** | Multi‑select. |
| **Related Elements** | Relation → **Character & World‑Building** | Multi‑select. |
| **Date Added** | Created time | – |

### Views
- **All Sources** – Table, sortable by **Source Type**.  
- **By Chapter** – Filtered view per chapter (linked from Chapter Tracker).  
- **Images Gallery** – Gallery view for visual assets.  

---

## 🗓️ Writing Schedule  
Calendar‑style planner for daily writing blocks, word‑count targets, and status tracking.

| Property | Type | Details |
|----------|------|---------|
| **Date** | Date | Calendar day. |
| **Project** | Relation → **Book Projects** | – |
| **Chapter** | Relation → **Chapter Tracker** | – |
| **Writing Block (hrs)** | Number | Planned hours. |
| **Target Words** | Number | Auto‑calc: `prop("Writing Block (hrs)") * 2500` (assumes 2 500 wph). |
| **Actual Words** | Number | Fill after session. |
| **Status** | Formula | `if(prop("Actual Words") >= prop("Target Words"), "✅", "❌")` |
| **Notes** | Rich text | Session reflections. |

### Views
- **Daily Planner** – Calendar view, grouped by **Project**.  
- **Word‑Count Tracker** – Table view showing `Target Words`, `Actual Words`, and **Status**.  
- **Burndown Chart** – Grouped by **Date**, sum of `Target Words` minus `Actual Words` (use Notion’s **Bar** view).  

---

## 📈 Progress Visualizations (Page)  
Dynamic charts and formula cards that give you real‑time insight.

1. **Overall Manuscript Progress Bar** – Formula card (see Dashboard).  
2. **Word‑Count Velocity Graph** – Linked view of **Writing Schedule**, grouped by **Date**, displayed as a **Line** chart (Notion’s built‑in chart).  
3. **Burndown Chart** – Bar view of **Writing Schedule** showing daily remaining words (`prop("Target Words") - prop("Actual Words")`).  
4. **Milestone Timeline** – Gantt view of **Marketing & Launch** milestones (requires Notion’s timeline view).  

---

## 💰 Budget & Royalty Tracker  
Track every expense and income stream in one hub, linked to each book.

| Property | Type | Details |
|----------|------|---------|
| **Item** | Title | e.g., “Cover Design”, “Amazon Royalties”. |
| **Category** | Select | Expense, Income |
| **Subcategory** | Select | Editing, Design, Advertising, Platform Fees, Royalties, Advances |
| **Amount** | Number | Format: `$#,###.00` |
| **Date** | Date | Transaction date. |
| **Project** | Relation → **Book Projects** | – |
| **Status** | Select | Pending, Paid, Received |
| **Notes** | Rich text | Invoice numbers, payment links. |
| **ROI** | Formula | `if(prop("Category") = "Income", prop("Amount") / sum(prop("Amount") where Category = "Expense"), 0)` |

### Rollups on Book Projects
- **Total Expenses** – Sum of **Amount** where Category = Expense.  
- **Total Income** – Sum of **Amount** where Category = Income.  
- **Net Profit** – `prop("Total Income") - prop("Total Expenses")`.  

### Views
- **All Transactions** – Table, grouped by **Category**.  
- **Expenses** – Filter `Category = Expense`.  
- **Income** – Filter `Category = Income`.  
- **Cash‑Flow Dashboard** – Formula cards for **Total Expenses**, **Total Income**, **Net Profit**, and **ROI**.  

---

## 📣 Marketing & Launch (Project Management)  
Board that guides you from manuscript completion to market release, plus ready‑to‑fill content templates.

### Marketing Milestones (Board)

| Milestone | Owner | Due Date | Status | Checklist |
|----------|-------|----------|--------|-----------|
| Final Manuscript Edit | Jane Doe | 2026‑12‑15 | In Progress | ☐ Chapter edits ☐ Beta reader feedback ☐ Proofread |
| Cover Design | Designer X | 2027‑01‑10 | Not Started | ☐ Concept sketches ☐ Final artwork |
| ISBN & Copyright | Jane Doe | 2027‑01‑20 | Not Started | ☐ Apply for ISBN ☐ Register copyright |
| Pre‑Launch Marketing | Jane Doe | 2027‑02‑01 | Not Started | ☐ Build email list ☐ Social media teaser campaign |
| Launch Day | Jane Doe | 2027‑03‑15 | Not Started | ☐ Publish on platforms ☐ Press release ☐ Giveaway |

*View:* **Kanban** grouped by **Status**.

### Marketing Content Templates (Database)

| Property | Type | Details |
|----------|------|---------|
| **Template Type** | Select | Press Release, Email Sequence, Social Media Post, Blog Article |
| **Title** | Title | – |
| **Body** | Rich text | Pre‑written copy with placeholder variables (`{{BookTitle}}`, `{{ReleaseDate}}`). |
| **Schedule Date** | Date | When to publish. |
| **Platform** | Select | Email, Twitter, Instagram, Facebook, Blog, LinkedIn |
| **Status** | Select | Draft, Ready, Published |
| **Open Rate** | Number | (for email templates) |
| **Click‑Through Rate** | Number | (for email templates) |
| **Notes** | Rich text | Customization tips. |

*Views:*  
- **All Templates** – Table.  
- **Ready to Publish** – Filter `Status = Ready`.  
- **Social Calendar** – Calendar view (Schedule Date) grouped by **Platform**.  

---

## 🔗 Integration Guidance (Page)

**1. Scrivener → Notion**  
- Export your Scrivener project as **.docx**.  
- In Notion, click **Import → Word Document** and select the file.  
- The import preserves headings; then **turn the table into a database** (Chapter Tracker) and re‑link the **Book** relation.

**2. Google Docs Sync**  
- Open the Google Doc you write in.  
- Click **File → Publish to the web → Publish** and copy the link.  
- In Notion, add a **Embed** block and paste the link → live‑sync view.  
- For bidirectional editing, use **Zapier**: *New Google Doc → Update “Actual Words” in Writing Schedule*.

**3. Zapier / Make Automations**  
| Trigger | Action | Example |
|--------|--------|---------|
| New row in **Writing Schedule** (status = Planned) | Create Google Calendar event | Auto‑schedule writing blocks. |
| New file in **Research Library** (type = Image) | Add to **Character & World‑Building** → Image property | Keep visual assets synced. |
| New transaction in **Budget & Royalty Tracker** | Append row to Google Sheet “Finance Dashboard” | External reporting. |

**4. Export to CSV for External Analysis**  
- Open any database → **⋯ → Export → CSV**.  
- Use in Excel, Airtable, or your preferred analytics tool.

**5. Native Notion Template Link**  
- Duplicate the complete hub with one click: **[🔗 Duplicate Author’s Book Writing Hub (Premium)](https://www.notion.so/template-link)**.  
- The link creates a copy in your workspace preserving **all relations, formulas, and views**.

---

## 👥 Team Collaboration (Page)

### Permission Presets (Workspace Settings)
| Role | Access |
|------|--------|
| **Owner** | Full edit, share, delete. |
| **Editor** | Edit pages, add comments, view all databases. |
| **Reviewer** | Comment only, view assigned chapters, no delete. |
| **Viewer** | Read‑only access (e.g., agents). |

### Comment Templates (Snippet)
- **General Feedback** – “Overall impression, pacing, and theme.”  
- **Line Edit** – “Specific wording, grammar, and style suggestions.”  
- **Structural Edit** – “Plot holes, character arc concerns, chapter re‑ordering.”  

> **How to use:** Copy a template into a comment, replace placeholders, and tag the reviewer.

### Reviewer Dashboard (Linked View)
- Filter: `Reviewer is not empty`.  
- Columns: Chapter #, Title, Status, **Reviewer**, **Comments** (linked to the page).  
- Grouped by **Reviewer** – each beta reader sees only their assigned chapters.

---

## 📈 Analytics (Page)

| Metric | Source | Formula / Rollup |
|--------|--------|------------------|
| **Daily Word Count** | Writing Schedule → `Actual Words` | Rollup sum grouped by **Date** (Line chart). |
| **Weekly Velocity** | Writing Schedule → `Actual Words` | Rollup sum over last 7 days (Formula: `prop("Weekly Total") / 7`). |
| **Deadline Adherence** | Marketing & Launch → `Due Date` vs. actual completion date (custom property **Completed On**) | Formula `if(prop("Completed On") <= prop("Due Date"), "On Time", "Late")`. |
| **Budget Utilization** | Budget & Royalty Tracker → `Total Expenses / Total Income` | Formula `round(prop("Total Expenses") / prop("Total Income") * 100, 1)`. |
| **Marketing KPI** | Marketing Content Templates → **Open Rate**, **CTR** | Average rollup per platform. |
| **Overall Completion** | Book Projects → **Progress %** | Formula card (same as Dashboard). |

### Views
- **Word‑Count Trend** – Line chart (group by Date).  
- **Weekly Summary** – Table with weekly totals, average words/day.  
- **Financial Dashboard** – Bar view of **Expenses vs. Income** per project.  
- **Marketing KPI Dashboard** – Table with platform metrics, conditional coloring (green > 30% open rate).  

---

## 📥 How to Install (Native Notion Template)

1. Click the **duplicate link** at the top of this page: **[🔗 Duplicate Author’s Book Writing Hub (Premium)](https://www.notion.so/template-link)**.  
2. Notion will create a copy in your workspace with **all databases, relations, formulas, and views intact**.  
3. Rename the top‑level page if desired (e.g., “My Author Hub”).  
4. Adjust the **Current Project** filter on the Dashboard to point to the manuscript you’ll work on first.  
5. Invite collaborators (editors, beta readers) and assign them the appropriate **permission preset** from the *Team Collaboration* page.  
6. Start populating the databases – the template is ready for day‑to‑day use.

> **All set!** You now have a production‑grade, end‑to‑end system for writing, world‑building, budgeting, marketing, and analytics—all in one Notion workspace. Happy writing!