Tygart Media

Tag: Agency Os

  • Notion Project Management for Small Agencies: The 6-Database Architecture

    Notion Project Management for Small Agencies: The 6-Database Architecture

    The Agency Playbook
    TYGART MEDIA · PRACTITIONER SERIES
    Will Tygart
    · Senior Advisory
    · Operator-grade intelligence

    The project management tools built for agencies assume you have a team. They’re priced per seat, designed for handoffs between people, and optimized for visibility across a group. If you’re running a small agency — two to five people, or solo with contractors — most of that architecture is overhead you don’t need and complexity that actively slows you down.

    Notion solves this differently. Instead of fitting your operation into a tool designed for someone else’s workflow, you build the system your operation actually requires. For a small agency managing multiple clients and business lines simultaneously, that system is a six-database architecture that keeps everything connected without the bloat of enterprise project management software.

    This is what that architecture looks like and why each piece exists.

    What is the 6-database Notion architecture? The 6-database architecture is a Notion workspace structure designed for small agencies and solo operators managing multiple clients or business lines. Six interconnected databases — tasks, content, revenue, CRM, knowledge, and a daily dashboard — cover every operational layer of the business, linked by shared properties so information flows between them without duplication.

    Why Six Databases and Not More

    The instinct when building a Notion system from scratch is to create a database for everything. A database for meetings. A database for ideas. A database for invoices. A database for each client. This is how Notion workspaces become unusable — too many places things could live, no clear answer for where they actually belong.

    Six databases is the right number for a small agency because it maps cleanly to the six operational questions you need to answer at any moment: What do I need to do? What content is in the pipeline? Where does revenue stand? Who are my contacts? What do I know? What matters today?

    Every piece of information in the operation belongs in one of those six categories. If something doesn’t fit, it either belongs in a sub-page of an existing database record or it doesn’t need to be documented at all.

    Database 1: Master Actions

    Every task across every client and business line lives in one database. Not separate task lists per client, not separate boards per project — one database, partitioned by entity tag.

    The key properties: Priority (P1 through P4), Status (Inbox, Next Up, In Progress, Blocked, Done), Entity (which business line or client), Due Date, and a relation field linking to whichever other database the task belongs to — a content piece, a deal, a contact.

    The priority logic is worth being explicit about. P1 means revenue or reputation suffers today if this doesn’t get done. P2 means this creates leverage — a system, an asset, something that compounds. P3 means operational work that needs to happen but doesn’t compound. P4 means it should be delegated or killed. If your P1 list has more than five items, something is mislabeled.

    The daily operating rule: never more than five tasks in Next Up at once. The system forces prioritization rather than enabling the comfortable illusion that everything is equally important.

    Database 2: Content Pipeline

    Every piece of content — articles, reports, audits, deliverables — moves through a defined status sequence before it reaches the client or goes live. Brief, Draft, Optimized, Review, Scheduled, Published.

    The Content Pipeline database tracks where every piece is in that sequence, which client it belongs to, the target keyword or topic, the target platform, word count, and publication date. The relation field links back to the Master Actions database so the task of writing a specific piece and the piece itself are connected.

    The hard rule: nothing publishes without a Content Pipeline record. This creates an audit trail that answers “what did we deliver in March?” in seconds rather than requiring a search through email threads or shared drives.

    Database 3: Revenue Pipeline

    Active deals, proposals, and retainer renewals tracked through defined stages: Lead, Qualified, Proposal Sent, Active, Renewal, Closed.

    Each record carries the deal value, the stage, the last activity date, and a relation to the Master CRM for the associated contacts. The weekly review checks whether any deal has sat in the same stage for more than seven days without activity — that stagnation is a signal that requires a decision, not more waiting.

    The Revenue Pipeline doesn’t replace an accounting system. It tracks the relationship status and deal momentum, not invoices or payments. Those live in dedicated accounting software. The pipeline answers “where are we in the conversation?” not “what was billed?”

    Database 4: Master CRM

    Every contact across every business line — clients, prospects, partners, vendors, network relationships — in one database, tagged by entity and relationship type.

    The CRM properties: Entity, Relationship Type (client, prospect, partner, vendor, network), Last Contact Date, and a relation field linking to any Revenue Pipeline deals associated with that contact.

    The weekly review includes a check for any contact who should have heard from you and didn’t. “Should have heard from you” is defined by relationship type — active clients warrant more frequent contact than cold prospects. The CRM makes that check systematic rather than dependent on memory.

    Database 5: Knowledge Lab

    SOPs, architecture decisions, reference documents, and session logs. This is the institutional knowledge layer — everything that would take significant time to reconstruct if the person who knows it left or forgot.

    Every Knowledge Lab record carries a Type (SOP, architecture decision, reference, session log), an Entity tag, a Status (evergreen, active, draft, deprecated), and a Last Verified date. The Last Verified date drives the maintenance cycle — any record older than 90 days gets flagged for a quick review.

    The Knowledge Lab is also the layer that makes the operation AI-readable. Every page carries a machine-readable metadata block at the top that allows Claude to orient itself to the content quickly during a live session. This is what transforms the Knowledge Lab from a static document library into an active operational asset.

    Database 6: Daily Dashboard (HQ)

    Not a database in the traditional sense — a command page that aggregates filtered views from the other five databases into a single daily interface. The goal is one page that answers “what needs attention right now?” without clicking through five separate databases.

    The HQ page contains: a filtered view of P1 and P2 tasks due today or overdue, the content queue for the next 48 hours, an inbox view of unprocessed items (tasks without a priority or status assigned), and a quick-access list of the most frequently used database views.

    The HQ page is where every working day starts. Everything else in the system is accessed from here or from the five source databases. It’s the navigation layer, not a database of its own.

    How the Databases Connect

    The architecture only works as a system if the databases talk to each other. The connection mechanism in Notion is relation properties — fields that link a record in one database to a record in another.

    The key relations: every Content Pipeline record links to a Master Actions task. Every Revenue Pipeline deal links to a Master CRM contact. Every Master Actions task can link to a Content Pipeline record, a Revenue Pipeline deal, or a Knowledge Lab SOP. These relations mean you can navigate from a task to the content piece it produces, from a deal to the contact it involves, from a procedure to the tasks that execute it — without leaving Notion or losing the thread.

    Rollup properties extend this further: a Content Pipeline view can show the priority of the associated task without opening the task record. A Revenue Pipeline view can show the last contact date from the CRM without opening the contact. The data stays connected visually, not just structurally.

    What This Architecture Replaces

    For a small agency, the 6-database architecture typically replaces: a project management tool (the tasks and content pipeline handle this), a CRM (the Master CRM handles this), a shared drive for SOPs (the Knowledge Lab handles this), and a deal tracker (the Revenue Pipeline handles this). It does not replace accounting software, calendar tools, or communication platforms — those remain separate because they do things Notion doesn’t.

    The consolidation matters not just for cost but for operational clarity. When every operational question has one answer and one place to look, the cognitive overhead of running the business drops significantly. The system becomes something you trust rather than something you maintain out of obligation.

    Want this built for your agency?

    We build the 6-database Notion architecture for small agencies — configured for your specific operation, with the relations, views, and daily operating rhythm set up and documented.

    Tygart Media runs this system live. We know what the build process looks like and what breaks without the right architecture from the start.

    See what we build →

    Frequently Asked Questions

    How is the 6-database Notion architecture different from using ClickUp or Asana?

    ClickUp and Asana are built around tasks and projects as the primary organizational unit. The 6-database architecture treats the business itself as the organizational unit — tasks, content, revenue, relationships, and knowledge are all connected layers of one system rather than separate tools or modules. The tradeoff is that Notion requires more upfront architecture work, but produces a system that fits your specific operation rather than a generic project management workflow.

    Can one person realistically maintain six databases?

    Yes — that’s what the architecture is designed for. The daily maintenance is five to fifteen minutes of triage and status updates. The weekly review is thirty minutes. Most of the database updating happens naturally as work progresses: publishing a piece updates the Content Pipeline, closing a deal updates the Revenue Pipeline. The system is designed for a solo operator or a very small team, not a department.

    What Notion plan do you need for the 6-database architecture?

    The Plus plan at around ten dollars per month per member is sufficient for everything described here — unlimited pages, unlimited blocks, and the relation and rollup properties that make the database connections work. The free plan limits relations and rollups in ways that would break the architecture. The Business plan adds features useful for larger teams but isn’t necessary for a small agency setup.

    How long does it take to build the 6-database architecture from scratch?

    Plan for twenty to forty hours to build, configure, and populate the initial system — creating the databases, setting up the properties and relations, building the filtered views, writing the first SOPs, and establishing the daily operating rhythm. Most operators who build it solo spend two to three months in iteration before it stabilizes. Starting from a pre-built architecture configured for your specific operation compresses that significantly.

    What’s the biggest mistake people make when building a Notion agency system?

    Creating too many databases. The instinct is to give everything its own database — one per client, one per project type, one for every category of information. This creates the same problem as a disorganized file system: too many places things could live, no clear answer for where they actually belong. Start with six. Add a seventh only when there’s a category of information that genuinely doesn’t fit in any of the six and that you need to query or filter regularly.

  • Notion SOP System: How We Document Everything Across Multiple Business Lines

    Notion SOP System: How We Document Everything Across Multiple Business Lines

    The Agency Playbook
    TYGART MEDIA · PRACTITIONER SERIES
    Will Tygart
    · Senior Advisory
    · Operator-grade intelligence

    Most SOP systems fail not because the SOPs are bad but because nobody can find them when they need them. They live in a Google Doc that was shared once, in a Notion page buried three levels deep, or in someone’s head because the written version was never kept current. The system exists on paper and nowhere else.

    We run SOPs for every repeatable process across multiple business lines — content publishing workflows, client onboarding steps, quality control checks, platform-specific operating rules. All of it lives in Notion, structured so that a person or an AI can find the right SOP in seconds and trust that it reflects how the work actually gets done today.

    This is how that system is built.

    What is a Notion SOP system? A Notion SOP system is a structured collection of standard operating procedures stored in Notion, organized so they are findable by context, searchable by keyword, and maintainable without a dedicated document owner. Unlike a folder of static documents, a well-built Notion SOP system is a living knowledge base that updates as the operation evolves.

    Why Notion Works Well for SOPs

    SOPs need to be three things: findable, readable, and maintainable. Notion handles all three better than most alternatives.

    Findable: Notion’s database structure lets you tag SOPs by entity, process type, and status, then filter to find exactly what you need. A filtered view showing all active SOPs for a specific business line is one click. A search across the entire SOP library is instant.

    Readable: Notion’s page format supports the structure SOPs actually need — numbered steps, toggle blocks for detail, callout boxes for warnings, tables for decision logic. The reading experience is better than a Google Doc and far better than a shared spreadsheet.

    Maintainable: Because SOPs live in a database, you can see at a glance which ones haven’t been verified recently, which are marked as drafts, and which are flagged for review. The metadata makes maintenance auditable rather than aspirational.

    The SOP Database Structure

    Every SOP in our system is a record in a single database — the Knowledge Lab. It’s not a folder of pages. It’s a database where each SOP is a row with properties that make it queryable.

    The core properties on each SOP record:

    Doc Name — the title of the SOP, written as a plain description of what the procedure covers. “Content Pipeline — Publishing Sequence” not “Publishing SOP v3.”

    Type — whether this is an SOP, an architecture decision, a reference document, or a session log. SOPs are filtered separately from other knowledge types.

    Entity — which business line or client this SOP belongs to. Allows filtering to show only the SOPs relevant to the current context.

    Layer — what kind of decision this documents. Options: architecture-decision, operational-rule, client-specific, platform-specific. Helps distinguish “how we always do this” from “how we do this for this one client.”

    Status — evergreen, active, draft, deprecated. Evergreen SOPs are procedures that don’t change often and can be trusted as written. Active SOPs are current but may be evolving. Draft SOPs are being written or tested. Deprecated SOPs are kept for reference but no longer in use.

    Last Verified — the date the SOP was last confirmed to reflect current practice. Any SOP with a Last Verified date more than 90 days ago gets flagged for review in the weekly system health check.

    How SOPs Are Written

    The format matters as much as the content. An SOP that buries the key step in paragraph four will be ignored in favor of asking someone who knows. We follow a consistent structure for every SOP:

    One-line summary at the top. What this procedure is for and when to use it. Readable in five seconds.

    Trigger conditions. What situation prompts someone to follow this SOP. Specific enough that there’s no ambiguity about whether this is the right document.

    Numbered steps. One action per step. Steps that require judgment get a callout box explaining the decision logic. Steps that have common failure modes get a warning callout explaining what goes wrong and how to catch it.

    Hard rules section. Any non-negotiable constraints — things that are never done, always done, or require explicit sign-off before proceeding. These get their own section at the bottom so they’re easy to find without reading the full procedure.

    Last updated note. Who verified this and when. Simple accountability that makes the maintenance question answerable.

    The Machine-Readable Layer

    Every SOP in our system carries a JSON metadata block at the very top of the page — before any human-readable content. This block follows a consistent structure that makes the SOP readable not just by people but by Claude during a live session.

    The metadata block includes the page type, status, a two-to-three sentence summary of what the SOP covers, the entities it applies to, any dependencies on other SOPs or documents, and a resume instruction — a single sentence describing the most important thing to know before executing this procedure.

    In practice, this means Claude can fetch an SOP mid-session, read the metadata block, and understand the procedure’s constraints and intent without reading the full document. For a system running dozens of active SOPs, this makes the difference between Claude operating on institutional knowledge and Claude operating on guesswork.

    Finding the Right SOP in the Right Moment

    The best SOP system is one you actually use when you need it. That requires the right SOP to be findable in under thirty seconds — not after a search, three clicks, and a scan of an unfamiliar page structure.

    We solve this with two mechanisms. First, a master SOP index — a filtered database view showing all active and evergreen SOPs, sorted by entity and process type, with one-line summaries visible in the list view. Opening the index and scanning it takes fifteen seconds. Second, the Claude Context Index includes every SOP by title and summary, so Claude can surface the right one during a session without a manual search.

    Both mechanisms depend on the same underlying structure: consistent naming, accurate status tags, and current summaries. The index is only as good as the metadata behind it.

    Keeping SOPs Current

    The maintenance problem is real. SOPs written accurately in January are often wrong by April — not because anyone changed them, but because the operation evolved and nobody updated the documentation.

    Our approach: the weekly system health review includes a check for any SOP with a Last Verified date more than 90 days old. Those get flagged for a five-minute review — read the procedure, compare it to how the work actually gets done, update if needed, reset the Last Verified date. Most reviews result in no changes. A few result in small updates. Occasionally one reveals a significant drift that needs a full rewrite.

    The 90-day cycle keeps the system from drifting too far before the problem is caught. It also makes SOP maintenance a predictable overhead rather than an occasional emergency project.

    When a New SOP Gets Written

    Not every procedure needs an SOP. We write a new SOP when a procedure meets two criteria: it will be repeated more than three times, and getting it wrong has a real cost — either in time, quality, or client relationship.

    One-off tasks don’t get SOPs. Simple two-step procedures that any competent operator would handle correctly without documentation don’t get SOPs. The SOP library should be comprehensive but not exhaustive — a collection of genuinely useful reference documents, not a compliance exercise.

    When a new SOP is warranted, we write it immediately after the first time we execute the procedure correctly — while the steps are fresh and the edge cases are visible. SOPs written from memory weeks later are usually missing exactly the details that matter most.

    SOPs as Training Infrastructure

    A well-maintained SOP library has a secondary function beyond daily operations: it’s the training infrastructure for anyone new joining the operation, or for handing off work to an AI agent running a process for the first time.

    When a new person joins, the SOP library is the answer to “how do we do things here?” — not a shadowing exercise or an informal knowledge transfer, but a structured, searchable, current reference that covers the actual procedures. When Claude is tasked with executing a process it hasn’t run before, the SOP is what it reads first.

    This dual function is why the investment in documentation quality pays off beyond the obvious. The SOP isn’t just for today’s operation — it’s the institutional knowledge layer that makes the operation transferable, scalable, and less dependent on any one person’s memory.

    Want this built for your operation?

    We build Notion SOP systems and full Knowledge Lab architectures — structured, machine-readable, and maintained to actually stay current.

    Tygart Media runs this system across multiple business lines. We know what makes an SOP library useful versus aspirational.

    See what we build →

    Frequently Asked Questions

    How many SOPs does a small agency need?

    A small agency running five to fifteen active clients typically needs fifteen to forty SOPs covering the core operational procedures — onboarding, content production, quality control, client communication, platform-specific rules, and system maintenance. More than sixty SOPs in an operation of that size usually indicates over-documentation: procedures that don’t need to be written down are getting written down.

    What’s the difference between an SOP and a checklist in Notion?

    A checklist is a reminder of what to do. An SOP explains how to do it, why each step matters, what to do when something goes wrong, and what the non-negotiable constraints are. Checklists work well for simple procedures with no decision points. SOPs work well for procedures with judgment calls, common failure modes, or significant consequences if done incorrectly. Most operations need both.

    Should SOPs be pages or database records in Notion?

    Database records. A page is a standalone document with no queryable properties. A database record is a document with structured metadata — status, entity, type, last verified date — that makes it filterable, sortable, and auditable. The operational overhead of maintaining SOPs as database records rather than loose pages pays off quickly once you need to find all active SOPs for a specific context or identify which ones haven’t been reviewed recently.

    How do you prevent SOPs from becoming outdated?

    Build the review into a regular rhythm rather than relying on ad hoc updates. A Last Verified date property on each SOP, combined with a weekly or monthly check for records older than a set threshold, creates a systematic maintenance loop. SOPs that are never reviewed drift silently — the regular review cycle catches drift before it causes operational problems.

    Can Claude use Notion SOPs during a live session?

    Yes, with the right setup. Claude can fetch a Notion page via the Notion MCP integration and read its content mid-session. SOPs written with a consistent metadata block at the top — a structured summary, trigger conditions, and key constraints — are especially effective because Claude can orient itself quickly without reading the full document. This is what makes a Notion SOP system genuinely useful for AI-native operations rather than just human reference.

  • Notion Client Portal Setup for Agencies: How We Build Ours

    Notion Client Portal Setup for Agencies: How We Build Ours

    The Agency Playbook
    TYGART MEDIA · PRACTITIONER SERIES
    Will Tygart
    · Senior Advisory
    · Operator-grade intelligence

    Most agency client portals are either too complicated to maintain or too bare to be useful. A shared Google Drive folder isn’t a portal. A ClickUp guest view requires the client to learn ClickUp. A custom-built portal requires a developer. Notion sits in the middle — flexible enough to build something professional, simple enough that clients can actually use it without training.

    This is how we build Notion client portals for our own operation. Not a template walkthrough — a description of the actual architecture, what we include, what we leave out, and why.

    What is a Notion client portal? A Notion client portal is a shared Notion page or workspace section that gives a client controlled visibility into their project — deliverables, timelines, assets, and communication — without exposing the rest of your internal operation. It functions as a lightweight client-facing dashboard built inside your existing Notion workspace.

    What a Notion Client Portal Actually Needs to Do

    Before building anything, it helps to be clear about what the portal is for. In our operation, a client portal has three jobs:

    Reduce inbound questions. If a client can see where their project stands without emailing, they will. A well-structured portal cuts “what’s the status?” messages significantly.

    Create a delivery record. Every deliverable — article, report, strategy doc — has a logged home. When a client asks what was delivered in March, the answer is one click away.

    Protect internal operations. The portal is a window, not a door. Clients see what’s relevant to them. They don’t see your internal task database, your pricing notes, your other clients, or your operational SOPs.

    The Core Portal Structure

    Every client portal we build follows the same structural template, customized by scope. The core components are:

    Project Status Dashboard

    A simple table or board view showing the current state of all active deliverables. Columns: deliverable name, status (In Progress / Review / Delivered), due date, and a link to the asset. Clients can see at a glance what’s moving and what’s done without needing to ask.

    This view is a filtered view of our internal Content Pipeline database — the client sees only their rows, not the full database. We use Notion’s filter-by-property feature to scope the view to their entity tag. They get a live view of their work without any access to the broader pipeline.

    Deliverables Library

    A running archive of everything completed and delivered. Articles, audits, reports, strategy documents — each as a linked page or embedded file. Organized by month. This solves the “can you resend that?” problem permanently and gives clients a sense of the body of work accumulating over a retainer.

    Communication Log

    A simple chronological page where significant decisions, feedback rounds, and strategic pivots get logged. Not a chat — a record. When a client says “I thought we decided X,” the communication log is the answer. This protects both parties and reduces scope creep from memory drift.

    Reference Documents

    Brand guidelines, target keyword lists, approved personas, style notes — anything the client has provided or that governs the work. Stored here so the answer to “do we have their brand guide?” is always yes.

    Next Steps

    A short, always-current list of what happens next. Three to five items max. What we’re working on, what we need from them, and when they can expect the next delivery. Clients check this more than anything else in the portal.

    How Access and Permissions Work

    Notion’s sharing model for client portals works at the page level, not the database level. This is the key architectural decision that determines how isolated the portal actually is.

    The correct approach: build the client portal as a standalone page that is not a child of your main Command Center. Share that page with the client via email invite at the “Can view” or “Can comment” level. The portal contains only filtered views and manually duplicated content — never direct database access.

    What to avoid: sharing a database directly with a client, even with filters applied. Notion’s permissions model allows determined users to remove filters from shared database views, exposing rows you didn’t intend to share. Always use a standalone page with embedded filtered views, not a raw database share.

    The Air-Gap Principle

    We call our approach to client portals “air-gapped” — the portal is architecturally separated from the internal operation even though it draws from the same underlying data.

    In practice, this means the portal page never has a back-link to the Command Center. The filtered views are set up so the client can see their data but cannot navigate to the parent database. Any document shared in the portal is either a shared Notion page with its own permissions or an exported file — never a raw internal page with full internal linking.

    The air gap matters because Notion’s page graph is navigable. If you share a page that contains a link to an internal page the client shouldn’t see, they can follow that link if it’s not properly permissioned. Build the portal as if it’s a separate product, even if it isn’t.

    What Not to Put in a Client Portal

    Equally important as what to include: what to leave out.

    Internal task notes. Your notes about why something is late, what went wrong, or what you think about the brief belong in your internal system, not in a client-visible page.

    Pricing and contract details. These live in your Revenue Pipeline and are shared via PDF or dedicated document — not embedded in an operational portal.

    Other clients’ work. Obvious, but worth stating explicitly given how easy it is to accidentally link across projects in a shared workspace.

    Unfinished deliverables. The portal is a delivery mechanism, not a work-in-progress view. Drafts go into the portal when they’re ready for client review, not before.

    Maintaining Portals at Scale

    The main friction with Notion client portals at scale is maintenance overhead. If you’re running ten or more active clients, keeping ten portals current manually is a real time cost.

    The solution is to minimize what requires manual updating. The Project Status Dashboard and Deliverables Library should pull from your internal pipeline database via filtered views — when you update the internal record, the portal updates automatically. The only things requiring manual attention are the Communication Log and Next Steps, which genuinely need a human decision about what to write.

    In our operation, portal maintenance takes roughly five minutes per client per week — the time it takes to update Next Steps and log any significant decisions from that week’s work. Everything else is live from the internal system.

    When Notion Portals Work Well and When They Don’t

    Notion client portals work well for content agencies, SEO operations, strategy consultants, and any service business where the deliverables are primarily documents. The portal model fits naturally when what you’re delivering is readable, linkable, and accumulates over time.

    They work less well for project-heavy engagements where the client needs to interact with tasks, leave comments on specific items, or participate in the workflow. For those cases, a purpose-built client portal tool — or a dedicated shared Notion workspace rather than a view-only portal — is a better fit. Notion can support collaborative client workspaces, but it requires a different architecture than the air-gapped portal model described here.

    Want this built for your agency?

    We set up Notion client portals and full Command Center architectures for agencies — configured for your operation, not a template to customize yourself.

    Tygart Media runs this system live across multiple active clients. We know what the build process looks like and what breaks without proper architecture.

    See what we build →

    Frequently Asked Questions

    Can clients edit content in a Notion client portal?

    Yes, if you give them “Can edit” or “Can comment” permissions. For most agency relationships, “Can comment” is the right level — clients can leave feedback directly on pages without being able to accidentally delete or restructure content. “Can view” works for portals that are purely informational delivery mechanisms.

    Is it safe to share a Notion database view with a client?

    With caution. Filtered database views can have their filters removed by users with edit access. For client-facing portals, use standalone pages with embedded filtered views set to view-only, rather than sharing the database itself. This is the air-gap approach — the client sees the data but cannot access the underlying database structure.

    How do you handle multiple clients in one Notion workspace?

    Each client gets their own portal page, shared individually. Internally, all client data lives in shared databases partitioned by an entity or client tag. Filtered views in each portal show only that client’s records. Clients never see each other’s portals or data because each portal is a separately permissioned page.

    What’s the difference between a Notion client portal and a shared Notion workspace?

    A client portal is a view-only or comment-only window into your operation — the client sees deliverables and status but doesn’t work inside Notion alongside you. A shared workspace is a collaborative environment where both agency and client actively use Notion together. Portals are simpler to maintain and better for most agency relationships. Shared workspaces make sense for longer-term, higher-touch engagements where the client is an active participant in the work.

    How long does it take to set up a Notion client portal?

    A well-structured portal takes two to four hours to build from scratch for the first client. Once you have a working template, duplicating and customizing it for additional clients takes thirty to sixty minutes. The time investment is in designing the architecture correctly the first time — portals built without a clear structure tend to get abandoned within a few months.

  • How I Run 27 Client Sites from One Notion Command Center

    How I Run 27 Client Sites from One Notion Command Center

    The Agency Playbook
    TYGART MEDIA · PRACTITIONER SERIES
    Will Tygart
    · Senior Advisory
    · Operator-grade intelligence

    I run 27 client WordPress sites from a single Notion workspace. No project management software, no agency platform, no dedicated CRM. Just Notion — architected deliberately across six interconnected databases — handling task triage, content pipelines, client relationships, revenue tracking, and the knowledge infrastructure that feeds an AI-native content operation.

    This is not a productivity tutorial. This is a description of a real system, built over two years, that runs across seven distinct business entities simultaneously. If you’re an agency owner, solo operator, or content business trying to figure out how to use Notion for something more serious than a to-do list, this is what the other end of that road looks like.

    What is a Notion Command Center? A Notion Command Center is a multi-database workspace architecture that functions as a single operating system for a business or portfolio of businesses. Rather than using Notion as a note-taking app, a Command Center connects tasks, clients, content, and knowledge into a unified system with defined workflows, priority rules, and daily operating rhythms.

    Why Notion Instead of Dedicated Agency Software

    The honest answer: I tried the alternatives. ClickUp has more native project management features. Asana handles task dependencies better out of the box. Monday.com is more polished for client-facing views.

    None of them let me build exactly the system my operation requires. And at the scale I’m running — 27 client sites, seven business entities, a live AI publishing pipeline — the ability to customize the architecture matters more than any individual feature.

    Notion also has a meaningful advantage that most people underestimate: it integrates with Claude natively. My entire operation runs on Claude as the AI layer, and a Notion workspace structured correctly becomes something Claude can read, reason about, and act on. That combination — Notion as the OS, Claude as the intelligence — is what makes this a genuinely AI-native operation rather than just an AI-assisted one.

    The 6-Database Architecture

    The Command Center runs on six core databases. Everything else in the workspace is either a view of these databases, a child page underneath them, or a standalone reference document. The six databases are:

    1. Master Actions

    Every task across all seven entities lives here. Priority levels run P1 (revenue or reputation at risk today) through P4 (delegate or kill). Each task carries an Entity tag, a Status, a Due Date, and a linked record in whichever other database it belongs to — a client, a content piece, a deal.

    The daily operating rule: never more than five tasks marked “Next Up” across the entire workspace at once. If your Next Up list has eight items, something is mislabeled. P1 means the thing doesn’t get done and real consequences follow today.

    2. Content Pipeline

    Every article across all 27 client sites flows through this database before it hits WordPress. Status stages run from Brief → Draft → Optimized → Scheduled → Published. The database links to the client entity, carries the target keyword, the target site URL, word count, and a publication date.

    Nothing publishes without a Notion record. This is a hard rule established after the alternative — articles written in sessions and pushed directly — created audit gaps that took hours to resolve. Notion first, WordPress second.

    3. Revenue Pipeline

    Client deals, proposals, and retainer renewals. Stage-based (Lead → Qualified → Proposal Sent → Active → Renewal). Links to the Master CRM for contact records. The weekly review checks whether any deal has sat in the same stage for more than seven days without activity — that’s a warning sign that gets flagged.

    4. Master CRM

    Every contact across all seven entities. Clients, prospects, golf league members, partners, vendors. Tagged by entity, relationship type, and last contact date. The weekly review catches anyone who should have heard from me and didn’t.

    5. Knowledge Lab

    SOPs, architecture decisions, session logs, and reference documents. This is where the institutional knowledge lives — the things that would take hours to reconstruct if I had to start from scratch. The Knowledge Lab uses a metadata standard (I call it claude_delta) that makes every page machine-readable, so Claude can fetch and reason about the content in a live session without losing context.

    6. William’s HQ

    The daily dashboard. A filtered view of P1 and P2 tasks due today or overdue, the content queue for the next 48 hours, and the inbox triage. This is the page that opens first every morning. Everything else in the system is accessed from here.

    The Seven Entity Structure

    The system manages seven distinct business entities, each with its own Focus Room — a sub-page containing that entity’s active projects, open tasks filtered by entity tag, and key reference documents. The entities are:

    • The parent agency — managing all client sites and retainer relationships
    • Personal brand — direct services, thought leadership, and new business
    • Client A — content operation for a contractor in a regional market
    • Client B — content operation for a service business in a metro market
    • Industry network — B2B community and event operation
    • Content property — topical authority site in a specific vertical
    • Personal — finances, health commitments, personal projects

    The entity structure means a task logged under “a regional client content operation” never bleeds into the the parent agency content queue. The databases are shared, but the entity tag acts as a partition. This matters operationally when you’re switching contexts fifteen times a day — the system tells you where you are and what belongs there.

    The Daily Operating Rhythm

    The Command Center only works if you use it on a rhythm. Mine runs on three loops:

    Morning Triage (10–15 minutes)

    Open William’s HQ. Zero the inbox — every untagged item gets a priority, a status, and an entity. Read the P1 and P2 list. Mentally commit to the top three. Check the content queue for anything publishing in the next 48 hours that isn’t scheduled. That’s a P1 fix before anything else happens.

    End-of-Day Close (5 minutes)

    Mark done tasks complete. Push anything untouched but intended — update the due date or reprioritize down. Check the content queue for tomorrow’s publications. If anything new was created during the day — a contact, a content piece, a deal — verify it’s logged in the right database with the right entity tag.

    Weekly Review (30 minutes, Sunday evening)

    Revenue: any deal stuck in the same stage as last week? Content: next week’s queue fully populated? Tasks: archive all Done tasks older than 14 days. Relationships: anyone who should have heard from me and didn’t? System health: any automation that failed silently?

    The weekly review is the repair mechanism. It catches the things the daily rhythm misses and resets the system before the next week compounds the drift.

    How Claude Plugs Into This

    The Knowledge Lab’s claude_delta metadata standard is what makes the Notion–Claude integration functional rather than theoretical. Every page in the Knowledge Lab carries a JSON metadata block at the top that tells Claude the page type, status, summary, key entities, and a resume instruction for picking up work in progress.

    In practice, this means I can start a session by telling Claude to read a specific Knowledge Lab page, and Claude has enough structured context to continue from exactly where the last session ended — without me re-explaining the project, the client, the constraints, or the decisions already made. The Notion workspace functions as persistent memory across Claude sessions.

    This is the part of the architecture that most people haven’t built yet. Notion as a note-taking app is one thing. Notion as a structured knowledge layer that an AI can navigate and act on is a meaningfully different proposition — and it’s the direction serious operators are moving.

    What This Architecture Costs to Build

    Honest answer: the architecture itself took about three months of active iteration to stabilize. The first version had too many databases, unclear relationships between them, and no real operating rhythm to enforce the discipline. The current version is the result of tearing down and rebuilding twice.

    The tooling cost is low. Notion’s Plus plan at $10/month per member handles everything described here. The BigQuery knowledge ledger that backs the AI memory layer runs on Google Cloud at effectively zero cost at this scale. Claude API usage for content operations runs roughly $50–150/month depending on session volume.

    What actually costs something is the setup time and the learning curve of building databases that relate to each other correctly. Most Notion setups fail not because the tool is limited but because the architecture wasn’t designed before the databases were created.

    Whether This Is Right for Your Agency

    The Command Center architecture works well for solo operators and small agencies managing multiple clients or business lines simultaneously. It works especially well when you’re running an AI-native content operation and need Notion to function as more than task management.

    It’s not the right choice if you need strong native time-tracking, Gantt charts, or client-facing portals that look polished without customization. Those cases have better-suited tools.

    But if you’re running a content agency, a multi-client SEO operation, or any business where the work is primarily knowledge work — briefs, articles, strategies, SOPs, client communications — and you want one system that sees all of it, the 6-database Command Center architecture is worth the build time.

    Want this built for your operation?

    We set up Notion Command Centers for agencies and operators — the full architecture, configured and documented, not a template to figure out yourself.

    Tygart Media has built and runs this system live across 27 client sites. We know what the setup process actually looks like.

    See what we build →

    Frequently Asked Questions

    How many databases does a Notion Command Center need?

    A functional Command Center for an agency or multi-client operation typically needs six core databases: a task database, a content pipeline, a revenue pipeline, a CRM, a knowledge base, and a daily dashboard. More than eight databases usually indicates an architecture problem — complexity that should be handled with views and filters, not additional databases.

    Can Notion handle 27 client sites without getting slow?

    Yes, with proper architecture. The key is using filtered views rather than separate databases for each client, and keeping database page counts manageable by archiving completed records regularly. Notion’s performance degrades when a single database exceeds a few thousand active records — archive aggressively and it stays fast.

    How does Notion integrate with Claude AI?

    Notion and Claude integrate through structured page formatting and the Notion API. By standardizing metadata at the top of key pages — page type, status, summary, key entities — Claude can fetch and interpret Notion content in a live session. More advanced setups use the Notion API to read and write records programmatically during Claude sessions, effectively making Notion the persistent memory layer for AI operations.

    What’s the difference between a Notion Command Center and a regular Notion workspace?

    A regular Notion workspace is typically organized around document types — pages, notes, tasks — without enforced relationships between them. A Command Center is organized around business operations — entities, pipelines, and workflows — with databases that relate to each other and a defined operating rhythm that governs how the system gets used each day.

    How long does it take to set up a Notion Command Center?

    Building the architecture from scratch takes 20–40 hours of focused setup time, including database design, relationship configuration, view creation, and SOP documentation. Most operators who attempt it solo take 2–3 months of iteration before the system stabilizes. Working from an existing architecture and having it configured for your specific operation compresses that significantly.

    Is Notion good for content agencies specifically?

    Notion is well-suited for content agencies because the core work — briefs, drafts, SOPs, client communication, publishing schedules — is document-centric. The Content Pipeline database, linked to a CRM and task system, gives visibility into every piece of content across every client at once, which is difficult to replicate in project management tools not built for document-heavy workflows.

  • I Accidentally Built an Operating System for an Industry

    I Accidentally Built an Operating System for an Industry

    Nobody sits down and says “I’m going to build an operating system for an entire industry.” That’s not how it starts. It starts with one client who needs a website. Then another who needs their Google Ads cleaned up. Then someone asks if you can help them figure out why their phone isn’t ringing.

    You solve problems. You move on to the next one. You don’t zoom out.

    I zoomed out recently — for the first time in a long time — and what I saw surprised me. I hadn’t been building a marketing consultancy. I’d been building a vertical operating system for the restoration industry, one problem at a time, without ever calling it that.

    Accidentally Built an Industry OS — Assembled System
    Every piece was built to solve a specific problem. Zoom out and it’s one system.

    How It Actually Started

    The first piece was SEO. A restoration contractor needed to show up when someone searched “water damage restoration” in their city. Straightforward enough. I built the content, optimized the site, tracked the rankings. It worked. They referred someone else. That someone else had a slightly different problem — their ads were running but the calls weren’t converting. So I looked at that.

    Call Track Metrics came in because I kept running into the same argument: the client thought the calls were coming from one place, I thought they were coming from another, and neither of us could prove it. CTM solved that. Now every call is tagged to the source — the keyword, the page, the campaign, the full journey. Attribution stopped being a debate and became math.

    Then I noticed that the calls were coming in but jobs weren’t closing at the rate they should. That’s not an SEO problem. That’s an operations problem. So I started looking at intake — how calls were answered, how follow-up happened, how estimates were scheduled. An AI intake agent started to make sense. Not because I was trying to build AI products, but because the gap was right there and I could see it.

    The Restoration Golf League came from a completely different direction. Restoration contractors need referral relationships with insurance adjusters and property managers. That’s the commercial side of the business. A golf league is one of the best relationship-building structures that exists in professional services — relaxed, repeated contact, shared experience. It wasn’t a marketing idea. It was a relationship infrastructure idea that happened to use golf as the mechanism.

    Accidentally Built an Industry OS — Specialized Tools
    Each tool built for a specific job. The pattern only becomes visible when you step back.

    The Inventory I Didn’t Know I Had

    When I actually sat down and listed everything that exists right now across the work I’ve been doing, here’s what came out:

    A content intelligence platform — a BigQuery knowledge base that logs every session, surfaces patterns, and drives automated publishing. A lead tracking infrastructure built on Call Track Metrics, wired to every traffic source. A referral network of restoration contractors meeting through a structured golf league across multiple cities. A commercial compliance strategy using fire extinguisher inspections as a loss leader to get in the door with property managers. An AI receptionist product purpose-built for restoration intake — Twilio, Claude on Vertex AI, Cloud Run, Firestore. A Company OS model — a fully hosted GCP environment where I run a contractor’s entire revenue infrastructure and take a commission on verified results. A WordPress CRM being built and dogfooded on my own site before being offered to clients. A knowledge cluster of five interconnected websites building topical authority in the restoration and risk intelligence space.

    None of those were planned in sequence. Each one was the answer to a specific question that kept coming up. But together they cover almost every layer of how a restoration business actually operates — lead generation, lead tracking, intake, conversion, referral relationships, commercial acquisition, operations tools, and content authority.

    That’s not a service menu. That’s a stack.

    Accidentally Built an Industry OS — Network Map
    Golf, AI, SEO, compliance, CRM — they look unrelated until you see the thread connecting them.

    Why Accidental Might Be Better Than Planned

    I’ve thought about whether it would have been better to plan this from the start. Design the full system upfront, build it in sequence, launch it as a coherent product.

    I don’t think so. And here’s why.

    Every piece of this was validated before the next one got built. The CTM infrastructure exists because attribution disputes are real and expensive. The AI intake agent exists because I watched calls get dropped after I’d already driven them. The golf league exists because I saw contractors lose commercial accounts to competitors who had better adjuster relationships, not better work. Each problem was visible because I was close enough to the industry to see it — not designing from a distance.

    The version of this that gets designed upfront has a different failure mode: it’s theoretically complete but practically wrong. The problems you think exist from the outside are never quite the same as the ones that actually exist on the inside. Building problem by problem, staying inside the industry, means every piece of the stack is load-bearing because it was built under load.

    There’s also something that happens when you’re not trying to build a system. You’re more honest about what’s actually needed. You don’t add things because they complete the picture — you add them because the gap is genuinely painful. The result is a leaner, more accurate stack than anything I could have designed in a planning session.

    The Question I’m Sitting With

    The thing I keep coming back to: is this replicable in other verticals, or is it only possible because of the depth of time I’ve spent inside restoration specifically?

    I genuinely don’t know. The honest answer is probably both. The approach — stay close, solve real problems, let the system emerge — is transferable. But the specific inventory I ended up with is deeply shaped by restoration’s particular quirks: the insurance dependency, the emergency-driven intake, the adjuster relationship dynamics, the commercial vs. residential split, the franchise structures, the IICRC certification culture.

    A different vertical would produce a different stack. HVAC has different intake patterns. Personal injury law has a completely different referral economy. Healthcare has different compliance requirements and trust dynamics. The method of paying attention and building toward what you see would be the same. The pieces that emerge would be different.

    What I’m more confident about: you can’t fake the depth. The reason the stack works is because I know what it’s like to be a restoration contractor well enough to feel the pain of each layer. That knowledge isn’t transferable quickly. It’s accumulated. Someone who decided tomorrow to “build a vertical OS for HVAC” would be designing from the outside. They’d get some things right and miss the things that matter most, because those only become visible from inside.

    Accidentally Built an Industry OS — The Road Back
    Looking back, the pattern is obvious. In the moment, it was just the next problem to solve.

    What This Changes

    Naming a thing changes how you relate to it. Before this realization, I was a marketing consultant who did a lot of different things for restoration companies. That description is accurate but it undersells the coherence of what’s actually there.

    Now I think of it differently: I’m a vertical infrastructure builder who happened to start in restoration and went deep enough that the full stack became visible. The individual services aren’t the product. The system is the product. Any one piece of it — just the SEO, just the CTM setup, just the AI intake — is less valuable than the whole because the whole is integrated in ways that individual pieces can’t be.

    That changes what I build next, how I talk about what I do, and who I build it for. It also changes what “being done” means — because a vertical OS is never really done. Industries evolve, problems shift, new gaps appear. The work is staying close enough to keep seeing them.

    I didn’t plan any of this. I just kept solving the next problem.

    Turns out that’s a strategy.