CRM Database Template

The skill Copy

A comprehensive Notion template for managing customer relationships, tracking interactions, managing leads and opportunities, and monitoring sales pipelines with full contact management.

## Overview

This template enables:
- Centralized contact management
- Lead tracking and nurturing
- Sales opportunity management
- Deal pipeline visualization
- Interaction history logging
- Customer health scoring
- Task and follow-up management
- Revenue forecasting

## Database Properties

### Contacts Database

| Property | Type | Description | AI Autofill |
|----------|------|-------------|-------------|
| Contact Name | Title | Person's name | – |
| Email | Email | Contact email | – |
| Phone | Phone | Contact number | – |
| Company | Relation | Associated company | – |
| Role | Select | Decision Maker, Influencer, User, Other | – |
| Industry | Select | Tech, Finance, Healthcare, Retail, Other | ✓ |
| Status | Select | Active, Prospect, Inactive, Lost | – |
| Last Contact | Date | Last interaction date | – |
| Next Follow-up | Date | Scheduled follow-up | – |
| Value | Select | High, Medium, Low | ✓ |
| Notes | Text | Contact information | – |
| Interactions | Relation | Related interactions | – |

## Setup Instructions

### Step 1: Create Databases
1. Create Contacts database
2. Create Deals database
3. Create Accounts database
4. Create Interactions database

### Step 2: Configure Properties
1. Add contact fields
2. Set deal stages
3. Configure interaction types
4. Create custom fields

### Step 3: Set Up Views
1. Create Sales Pipeline view
2. Create Contact by Company
3. Create Active Deals view
4. Create Upcoming Follow-ups
5. Create Customer Health view

### Step 4: Add Automations
1. Auto-update last contact
2. Generate follow-up reminders
3. Update deal status
4. Log interactions
5. Generate pipeline reports

## Usage Guide

### Adding Contacts
1. Capture contact information
2. Identify company and role
3. Set initial status
4. Add contact preferences
5. Schedule first follow-up

### Managing Deals
1. Create deal entry
2. Assign opportunity value
3. Set deal stage
4. Identify key stakeholders
5. Track deal progress

### Logging Interactions
1. Record interaction type
2. Add interaction notes
3. Update last contact date
4. Schedule next action
5. Update opportunity status

## Best Practices

1. **Regular Updates**: Keep contact info current
2. **Consistent Follow-ups**: Schedule timely next steps
3. **Detailed Notes**: Record all interactions
4. **Clean Data**: Remove duplicates and invalid records
5. **Relationship Building**: Personalize communications
6. **Pipeline Discipline**: Move deals when criteria met
7. **Engagement Tracking**: Monitor customer health
8. **Team Alignment**: Share account information
9. **Activity Logging**: Record all touchpoints
10. **Success Metrics**: Track conversion rates

## AI Automation Examples

### Next Best Action
Prompt: What should be the next step for this opportunity?

### Customer Health Score
Prompt: Calculate health score based on engagement

### Deal Prediction
Prompt: Which deals are most likely to close this quarter?

### Lead Scoring
Prompt: Score and rank open leads by conversion likelihood

## Related Templates

- [CRM System](crm-system.md)
- [Project Management](project-management.md)
- [Knowledge Base](knowledge-base.md)

---

**Last Updated**: November 2025
**Version**: 1.0
**Compatibility**: Notion with AI features

How to install it Copy

1. Open the tool and start a new conversation, project or template.
2. Paste the text below wherever the tool keeps standing instructions
   — usually called system prompt, instructions, or persona.
3. Save it so it applies to every run rather than a single message.

Did it work for you?

Where it came from

2025 Anfernee