Notion Tutorial: Build a Client CRM Dashboard in 15 Minutes
TL;DR: Create a master database with client details and linked deal tables to centralize all customer information. Use views and relations to build a visual dashboard that tracks status, revenue, and communication history instantly.
Step 1: Create the Master Database
Start by creating a new page in your Notion workspace. Click on the plus icon and select “Database” then choose “Table.” Name this database “Client CRM.” This will serve as the single source of truth for all your client data. Add the following properties to your table: Client Name (Title), Company (Text), Email (Text), Phone (Text), Status (Select: Lead, Active, Churned, VIP), Total Revenue (Number), and Last Contact (Date). These core fields ensure you have the essential contact and financial data organized from day one.
If you want to dig deeper, check out our guide on How to Create a Successful SEO Tutorial: Step-by-Step Guide.
Step 2: Establish Relations for Deals
To track specific projects or sales opportunities, create a second database named “Deals” on a new page. Add properties such as Deal Name, Value, Probability (Select), and Expected Close Date. Crucially, add a “Relation” property in the Deals database that links back to the “Client CRM” database. This creates a two-way link, allowing you to see all associated deals directly within the client profile. When you open a specific client record, you will now see a list of every deal associated with them, providing immediate context for your interactions.
Step 3: Build the Dashboard Views
Now, let’s visualize the data. Go back to your “Client CRM” database. Above the table, you will see tabs for different views. Click the plus icon to create a “Board” view. Group this board by the “Status” property. This Kanban-style view allows you to drag and drop clients between stages like Lead to Active. Next, create a “Gallery” view. Set the cover image to pull from a property if you have added one, or leave it blank. This view is great for getting a quick visual overview of your top accounts. Finally, create a “Calendar” view filtered to show only clients with a “Last Contact” date within the next seven days. This helps you prioritize outreach tasks effectively.
Step 4: Add Formulas and Filters
Enhance your dashboard by adding calculated data. In the “Client CRM” database, add a formula property named “Total Deal Value.” Use the formula to sum the “Value” property from the related “Deals” database. This gives you an instant view of the total potential revenue per client. Additionally, apply filters to your views. For your main “Table” view, filter to show only clients where “Status” is not “Churned.” This keeps your active workspace clean and focused on current opportunities. You can also sort this table by “Total Deal Value” in descending order to prioritize high-value clients at the top of your list.
Step 5: Customize and Integrate
Personalize your dashboard by adding a header block at the top of your CRM page. Include a brief description of the CRM’s purpose and add a “To-Do” list or a “Notes” section for quick reference during meetings. If you use Notion’s API or integrations, consider syncing email data to automatically update the “Last Contact” date. For manual users, simply update the date field after every email or call. This small habit ensures your dashboard remains accurate without requiring complex automation. Keep your interface clean; hide unused properties to reduce visual clutter and improve usability for team members.
Pro Tips for Efficiency
Use Notion’s templates to speed up repetitive tasks. Create a template within the “Deals” database for standard onboarding processes. When you create a new deal, select this template to automatically populate common fields and checklists. Furthermore, leverage Notion’s sharing capabilities. Share specific views with team members based on their roles. For example, sales reps can have access to the “Board” view for
Leave a Reply