CRM Data Model

Model Notion CRM opportunity data across 11 Biz Funnel stages.

Updated Nov 19, 2025
One-click install
npx skills add https://github.com/rogeriorm/crm --skill crm-data-model
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: CRM Data Model
Source: https://github.com/rogeriorm/crm/tree/main/.claude/skills/crm-data-model
Command: npx skills add https://github.com/rogeriorm/crm --skill crm-data-model

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the chaos of managing complex CRM data in Notion, ensuring every sales opportunity is tracked, updated, and analyzed consistently. It frees you from manual data entry and inconsistent reporting, allowing you to focus on closing deals and strategic growth.

Core Features & Use Cases

  • Standardized Opportunity Tracking: Enforces a consistent data model for sales opportunities, including 11 Biz Funnel stages and 8 status options, ensuring data integrity across your Notion CRM.
  • Intelligent Data Interaction: Guides AI to accurately search, fetch, and update opportunity properties in Notion, including critical Update Log entries and Next Action dates, reducing manual errors and ensuring timely follow-ups.
  • AI-Driven Strategic Insights: Provides a framework for generating concise, actionable AI recommendations (2-3 sentences) based on detected patterns, advancement signals, and potential risks in your sales pipeline.
  • Use Case: Imagine you need to review all opportunities in the "Oferta" stage. This Skill empowers your AI to not only list them but also identify those needing immediate attention, suggest next steps, and update their status in Notion, all with a single command, letting you rest while the AI handles the details.

Quick Start

"Analyze my Notion CRM opportunities. Identify any in the 'Oferta' stage that haven't moved in 14 days and suggest a next action for each."

Frequently Asked Questions about CRM Data Model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up a sales pipeline tracking system in Notion with automated opportunity management?

A CRM data model in Notion enforces standardized opportunity tracking across 11 Biz Funnel stages with consistent field schemas, status options, and automated calculations like Days in Stage. This eliminates manual data entry and ensures every opportunity moves through your pipeline with enforced stage-transition rules and timely follow-ups.

Can I automate updates and track changes to my Notion CRM opportunities without manual logging?

Yes. An append-only Update Log captures every change to opportunity records, while Next Action fields with due dates trigger timely follow-ups. AI can query, fetch, and update these properties automatically, reducing errors and ensuring consistent record-keeping across your sales pipeline.

How do I get AI-driven recommendations for opportunities stuck in my sales funnel?

A CRM data model provides a framework for AI to detect stalled opportunities, identify advancement signals, and generate 2-3 sentence actionable recommendations based on Days in Stage, Next Action dates, and related Contact and Client data—all within a single query.

What fields and relations do I need in a Notion CRM to track opportunities through multiple sales stages?

A structured data model includes title, select, status, text, date, and multi-select field types; relations to Contacts and Clients; auto-calculated metrics like Days Until Due; and inline or linked Meeting notes. Stage-transition rules prevent skipping stages and maintain pipeline integrity.

Can I use Notion to manage opportunities with related contacts, clients, and meeting notes in one system?

Yes. A unified CRM data model links Opportunity, Contact, and Client databases with standardized queries and structured meeting note handling—either inline or linked—allowing you to view complete context and generate strategic insights without switching tools.

How do I identify opportunities in a specific sales stage that need immediate action?

Query your Notion CRM by Biz Funnel stage and Days in Stage to surface stalled opportunities, then use AI to analyze Next Action dates and generate targeted recommendations for each—enabling batch status updates and strategic follow-up in a single operation.