# Creator Profit OS

## 1. Command Dashboard
This is your mission control. It aggregates data from all other databases to give you a real-time snapshot of your digital empire.

**Key Widgets to Setup:**
*   **Total Net Profit (Rollup):** Sum of "Net Profit" from the Financial Ledger database.
*   **Active Products (Filtered View):** A linked view of the Product Library showing only items with Status "Launched."
*   **Recent Sales (Timeline View):** A calendar view of the Financial Ledger to visualize cash flow.

> 💡 Tip: Create a "Goal Progress" bar using a simple formula property in the Dashboard database (e.g., `prop("Current Profit") / prop("Goal")`) to visualize how close you are to your monthly revenue target.

## 2. Product Library (Core Database)
This is the heart of the OS. Every product you sell lives here. It connects your SEO research, your assets, and your sales data in one place.

| Product Name | Type | Price | Status | SEO Keywords (Relation) | Asset Link (Files) | Total Net Profit (Rollup) |
| :--- | :--- | :--- | :--- | :--- | :--- | :--- |
| Ultimate Notion Planner | Template | $29.00 | Launched | Notion productivity, Digital Planner | [View Assets](#) | $1,240.50 |
| SEO Masterclass | Course | $97.00 | Active | SEO for beginners, Marketing Strategy | [View Assets](#) | $3,450.00 |
| Minimalist Icon Pack | Asset | $15.00 | Launched | Vector icons, UI Design | [View Assets](#) | $320.00 |
| YouTube Thumbnail Kit | Template | $19.00 | Draft | High CTR thumbnails, YouTube growth | [View Assets](#) | $0.00 |

> 💡 Tip: Use the "Total Net Profit" column as a Rollup property that sums the "Net Profit" from the Financial Ledger. This allows you to sort your products by actual performance, not just price.

## 3. SEO & Content Research
Stop guessing what sells. Use this database to track search volume, difficulty, and content ideas, then link them directly to the products they support.

| Keyword / Topic | Search Volume | Difficulty | Target Product (Relation) | Content Status | Last Updated |
| :--- | :--- | :--- | :--- | :--- | :--- |
| Notion habit tracker | 5,400 | Low | Ultimate Notion Planner | Published | 2023-10-15 |
| SEO for beginners | 12,000 | Medium | SEO Masterclass | Writing | 2023-10-20 |
| 3D icon set free | 2,900 | High | Minimalist Icon Pack | Researching | 2023-10-22 |

> 💡 Tip: Add a "Priority" formula property: `if(prop("Difficulty") == "Low" and prop("Search Volume") > 1000, "High", "Medium")`. This automatically highlights low-hanging fruit for your content strategy.

## 4. Multi-Platform Listings
Track where your products are live. This helps you identify which platforms (Gumroad, Etsy, Shopify) are performing best for specific product types.

| Platform | Product (Relation) | Listing URL | Status | Platform Fee % | Notes |
| :--- | :--- | :--- | :--- | :--- | :--- |
| Gumroad | Ultimate Notion Planner | [Link](https://example.com) | Active | 8.5% + $0.30 | High conversion rate |
| Etsy | Minimalist Icon Pack | [Link](https://example.com) | Active | 6.5% + $0.20 | Needs better tags |
| Teachable | SEO Masterclass | [Link](https://example.com) | Active | 0% (Transaction fees apply) | Q4 Promo active |
| Shopify | Ultimate Notion Planner | [Link](https://example.com) | Draft | 2.9% + $0.30 | Setting up store |

> 💡 Tip: Create a "Platform Performance" grouped view. Group by "Platform" and sort by the "Total Net Profit" rollup to see if Etsy or Gumroad is your true breadwinner.

## 5. Financial Ledger
The engine of your profit tracking. Instead of manually updating a spreadsheet, log transactions here. The "Net Profit" is calculated automatically based on the platform fees defined in your Listings database.

| Date | Product (Relation) | Platform | Gross Revenue | Fees | Net Profit (Formula) |
| :--- | :--- | :--- | :--- | :--- | :--- |
| 2023-10-24 | Ultimate Notion Planner | Gumroad | $29.00 | $2.46 | $26.54 |
| 2023-10-24 | SEO Masterclass | Teachable | $97.00 | $0.00 | $97.00 |
| 2023-10-25 | Minimalist Icon Pack | Etsy | $15.00 | $1.18 | $13.82 |
| 2023-10-26 | Ultimate Notion Planner | Shopify | $29.00 | $1.84 | $27.16 |

> 💡 Tip: Set the "Net Profit" property to a Formula: `prop("Gross Revenue") - prop("Fees")`. If you want to get advanced, use a Rollup to pull the specific fee percentage from the "Multi-Platform Listings" database based on the selected Platform.

## 6. Digital Asset Vault
A centralized repository for your source files. Never lose a master file again. Link these assets to your Product Library entries.

| Asset Name | Type | File Link | Product (Relation) | Version |
| :--- | :--- | :--- | :--- | :--- |
| Planner_v2_Final.pdf | PDF | [Drive Link](#) | Ultimate Notion Planner | 2.0 |
| Promo_Banner_1200x628.png | Image | [Drive Link](#) | SEO Masterclass | 1.0 |
| Icon_Set_Vector.zip | ZIP | [Drive Link](#) | Minimalist Icon Pack | 1.5 |

> 💡 Tip: Use the "Gallery" view for this database. Set the cover image to the actual asset preview so you can visually scan your creative assets.

## How to import into Notion

1.  **Copy the Content:** Select and copy the entire Markdown text above.
2.  **Paste into Notion:** Create a new page in Notion and paste the text. Notion will automatically convert the Markdown headers into text blocks.
3.  **Create Databases:**
    *   Highlight the tables in sections **2, 3, 4, 5, and 6**.
    *   Type `/table` and convert the text into a full database view.
    *   Ensure the column names match exactly (e.g., "Product Name", "Gross Revenue").
4.  **Establish Relations:**
    *   Go to the **Product Library** database. Add a new property called `SEO Keywords` and select "Relation." Connect it to the **SEO & Content Research** database.
    *   Repeat this process for `Asset Link` (connect to **Digital Asset Vault**) and `Linked Listings` (connect to **Multi-Platform Listings**).
    *   In the **Financial Ledger**, create a relation to the **Product Library**.
5.  **Setup Formulas & Rollups:**
    *   In the **Financial Ledger**, turn the "Net Profit" column into a Formula property: `prop("Gross Revenue") - prop("Fees")`.
    *   In the **Product Library**, turn "Total Net Profit" into a Rollup property: Select the relation to **Financial Ledger**, choose the property "Net Profit," and calculate "Sum."
6.  **Customize Views:** Create specific views (Board, Calendar, Timeline) as suggested in the section descriptions to visualize your workflow.