deal-flow-tracker
CRM integration for tracking deals through pipeline stages with automated status updates
What this skill does
# Deal Flow Tracker ## Overview The Deal Flow Tracker skill provides comprehensive CRM integration for venture capital firms to track deals through various pipeline stages. It enables automated status updates, pipeline velocity analysis, and deal progression monitoring across the investment lifecycle. ## Capabilities ### Pipeline Stage Management - Track deals across customizable pipeline stages (Sourced, First Meeting, DD, IC, Term Sheet, Closing, Portfolio) - Automated stage transition triggers based on activities and milestones - Stage duration tracking and bottleneck identification - Multi-fund deal tracking with fund-specific pipelines ### CRM Integration - Integrate with Affinity, Salesforce, HubSpot, and other VC-specific CRMs - Bi-directional sync of deal data and contact information - Activity logging (emails, meetings, calls) associated with deals - Relationship intelligence from communication patterns ### Status Updates and Notifications - Automated status update generation based on deal activity - Configurable notification rules for stage changes - Partner/associate assignment and coverage tracking - Follow-up reminder scheduling ### Reporting and Analytics - Pipeline velocity metrics (time in stage, conversion rates) - Deal flow source attribution and ROI analysis - Partner productivity and coverage metrics - Historical pipeline trend analysis ## Usage ### Track New Deal ``` Input: Company information, source, initial assessment Process: Create deal record, assign stage, set up tracking Output: Deal ID, initial pipeline position, assigned coverage ``` ### Update Deal Status ``` Input: Deal ID, new stage or activity update Process: Record transition, calculate metrics, notify stakeholders Output: Updated deal record, transition history, notifications sent ``` ### Generate Pipeline Report ``` Input: Date range, filters (stage, partner, sector) Process: Aggregate deal data, calculate metrics Output: Pipeline summary, velocity metrics, conversion funnel ``` ### Analyze Deal Flow Sources ``` Input: Time period, source categories Process: Attribution analysis, ROI calculation Output: Source effectiveness report, recommendations ``` ## Integration Points - **Investor Network Mapper**: Link deal sources to network relationships - **Deal Scoring Engine**: Incorporate scores into pipeline prioritization - **Meeting Scheduler**: Coordinate deal-related meetings - **IC Memo Generator**: Pull deal data for memo generation ## Best Practices 1. Maintain consistent stage definitions across the firm 2. Log all significant deal interactions for accurate velocity tracking 3. Review pipeline weekly to identify stale deals 4. Use source attribution consistently for accurate ROI analysis 5. Set up automated alerts for deals exceeding stage time thresholds
Related in Data & Analytics
clawarr-suite
IncludedComprehensive management for self-hosted media stacks (Sonarr, Radarr, Lidarr, Readarr, Prowlarr, Bazarr, Overseerr, Plex, Tautulli, SABnzbd, Recyclarr, Unpackerr, Notifiarr, Maintainerr, Kometa, FlareSolverr). Deep library exploration, analytics, dashboard generation, content management, request handling, subtitle management, indexer control, download monitoring, quality profile sync, library cleanup automation, notification routing, collection/overlay management, and media tracker integration (Trakt, Letterboxd, Simkl).
querying-soql
IncludedSOQL query generation, optimization, and analysis with 100-point scoring. Use this skill when the user needs SOQL/SOSL authoring or optimization: natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance or safety improvements for Salesforce queries. TRIGGER when: user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. DO NOT TRIGGER when: bulk data operations (use handling-sf-data), Apex DML logic (use generating-apex), or report/dashboard queries.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
habit-flow
IncludedAI-powered atomic habit tracker with natural language logging, streak tracking, smart reminders, and coaching. Use for creating habits, logging completions naturally ("I meditated today"), viewing progress, and getting personalized coaching.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
visualizing-data
IncludedBuilds dashboards, reports, and data-driven interfaces requiring charts, graphs, or visual analytics. Provides systematic framework for selecting appropriate visualizations based on data characteristics and analytical purpose. Includes 24+ visualization types organized by purpose (trends, comparisons, distributions, relationships, flows, hierarchies, geospatial), accessibility patterns (WCAG 2.1 AA compliance), colorblind-safe palettes, and performance optimization strategies. Use when creating visualizations, choosing chart types, displaying data graphically, or designing data interfaces.