How to Build Notion Database for Customer Onboarding Stage Tracking
🔍 WiseChecker

How to Build Notion Database for Customer Onboarding Stage Tracking

Customer onboarding is a critical phase where new users learn your product and become active customers. Without a structured tracking system, teams often lose visibility into where each customer is in the process. This article explains how to build a Notion database that tracks every onboarding stage, from welcome to activation. You will learn to set up a database with status properties, stage views, and automation rules. By the end, you will have a repeatable template that your team can use for every new customer.

Key Takeaways: Building a Customer Onboarding Tracker in Notion

  • Database template with Status and Stage properties: Creates a clear pipeline showing each customer’s current onboarding step.
  • Linked database views for each stage: Lets team members see only customers in their assigned stage without filtering manually.
  • Formula property for days in stage: Highlights stalled customers who need follow-up action.

ADVERTISEMENT

What a Notion Onboarding Database Does and What You Need Before Building

A Notion onboarding database is a structured table where each row represents one customer. Columns store data such as company name, assigned team member, start date, current stage, and notes. The database uses properties like Select, Date, and Formula to track progress automatically.

Before you build the database, confirm you have a Notion workspace where you can create new pages. You need edit permissions in that workspace. No paid plan is required for a basic setup, though formulas and database automations are available on all plans.

Prerequisites for the Onboarding Database

You need a Notion account with workspace access. If you are building this for a team, ensure each team member has at least Can Edit access to the database. Prepare a list of your onboarding stages. A typical sequence includes: Signed Up, Kickoff Call, Setup Completed, Training, Activated, and Closed Won. You can adjust these stages based on your product.

Steps to Build the Customer Onboarding Stage Tracking Database

  1. Create a new database page
    In your Notion workspace, click the + icon in the left sidebar to add a new page. Select the Table template from the database options. Name the page “Customer Onboarding Tracker.”
  2. Add the default Name property
    The Name column is already present. Rename it to “Customer Name” by clicking the column header and typing the new name. Enter a sample customer name to see how it works.
  3. Create the Stage Select property
    Click the + button on the rightmost column. Choose Select as the property type. Name it “Onboarding Stage.” Add options for each of your stages: Signed Up, Kickoff Call, Setup Completed, Training, Activated, Closed Won. Drag the options into the correct order.
  4. Add a Date property for start date
    Click the + button again and choose Date. Name it “Start Date.” This records when the customer entered the onboarding pipeline.
  5. Add a Person property for the assigned team member
    Click + and choose Person. Name it “Assigned To.” This property lets you assign a team member to each customer. The team member will see the customer in their notifications.
  6. Add a Formula property to calculate days in stage
    Click + and choose Formula. Name it “Days in Stage.” In the formula editor, type: dateBetween(now(), prop("Start Date"), "days"). This shows how many days the customer has been in the current stage. If you change the stage, you can reset the start date manually.
  7. Add a Status property for overall progress
    Click + and choose Status. Name it “Onboarding Status.” Notion provides default status options: Not started, In progress, Done. Rename them to match your workflow: Not Started, In Progress, Completed. This property gives a quick visual indicator.
  8. Create linked database views for each stage
    At the top of the database, click the + tab to add a new view. Choose Board as the view type. Name it “Stage Board.” Group by the Onboarding Stage property. Now you can see all customers grouped by stage. Add additional views like a Calendar view filtered by Start Date to see upcoming onboarding starts.
  9. Set up a filter to show active customers only
    In the default Table view, click the Filter button. Add a filter: Onboarding Status is not Completed. This hides customers who have finished onboarding. Your team focuses only on active customers.
  10. Add a Notes property for internal comments
    Click + and choose Text. Name it “Notes.” Team members can type updates, questions, or next steps directly in the database.

ADVERTISEMENT

Common Mistakes and Limitations to Avoid

Formula shows negative days when stage changes

The Days in Stage formula uses the Start Date. If you change the stage but keep the original Start Date, the formula will count from the original date. To fix this, add a second Date property named “Stage Entered Date” and update it each time the stage changes. Then modify the formula to use dateBetween(now(), prop("Stage Entered Date"), "days").

Team members cannot see assigned customers

If you use the Person property, each team member sees only their assigned customers when they view the database through the Notion sidebar. But if they open the database directly, they see all rows. To give each person a personal view, create a filtered view for each team member: Filter by Assigned To contains [their name]. Then rename the view with their name.

Database becomes cluttered with old customers

Customers who complete onboarding remain in the database. To keep the view clean, use the filter Onboarding Status is not Completed. Alternatively, create a separate Archive database and move completed rows there using Notion’s Move To feature.

Notion Free vs Plus vs Business: Limits for Onboarding Databases

Item Free Plan Plus Plan Business Plan
Database row limit 1,000 rows per database Unlimited Unlimited
File upload limit 5 MB per file 5 GB per file 5 GB per file
Version history 7 days 30 days 90 days
Guest access Up to 10 guests Up to 100 guests Up to 250 guests
Database automations Not available Available Available

For most onboarding tracking needs, the Free plan works if you have fewer than 1,000 customers at a time. The Plus plan adds automations that can send reminders when a customer stays in a stage too long. The Business plan provides longer version history and more guest access for external consultants.

You can now build a Notion database that tracks each customer’s onboarding stage from sign-up to activation. Start by entering your current customers into the database and assigning each one a stage. Use the Days in Stage formula to identify customers who need faster follow-up. As a next step, try adding a Rollup property that pulls the total number of customers per stage from a linked database, giving you a real-time pipeline summary.

ADVERTISEMENT