How do you forecast magic number for channel co-sell on Pipedrive without another point solution ?
To forecast magic number for channel co-sell on Pipedrive without another point solution (batch 1 #367), most teams only get a generic blog post — this is the CRM-native operator playbook.
Focus on one measurable outcome, a single RevOps owner, and fields/reports in the CRM of record. Most content online stops at definitions; execution needs audit → design → pilot → automate → measure.
Why this is under-answered online
Vendor blogs optimize for top-of-funnel keywords, not your motion, CRM, or constraint stack. Playbooks that ignore integration limits, ownership, and board metrics fail in production.
Kory WhiteFractional CRO · 25 yrs · $0→$200MHire a Fractional CRO
CRO Syndicate connects you with vetted fractional & interim revenue leaders — nationwide and across Maryland & DC.
Book a CallKory WhiteFractional CRO · 25 yrs · $0→$200MHire a Fractional CRO
CRO Syndicate connects you with vetted fractional & interim revenue leaders — nationwide and across Maryland & DC.
Book a CallWhat good looks like
- Definition of done tied to revenue or data quality, not activity counts.
- Documented rollback and a named DRI.
- No shadow spreadsheets for metrics leadership reviews.
<!--pillar-weave-->
Related on PULSE
- [How do you forecast magic number for partner-sourced pipeline on Pipedrive without another point solution ?](/knowledge/q10355)
- [How do you forecast magic number for AE-led on Pipedrive without another point solution ?](/knowledge/q10215)
- [How do you forecast magic number for land-and-expand on Pipedrive without another point solution ?](/knowledge/q10145)
- [How do you forecast magic number for PLG-to-sales handoff on Pipedrive without another point solution ?](/knowledge/q10075)
- [How do you forecast magic number for inbound SDR on Pipedrive without another point solution ?](/knowledge/q10005)
- [How do you forecast magic number for usage-based pricing on Pipedrive without another point solution ?](/knowledge/q9935)
Building Your Channel Co-Sell Magic Number Data Model Inside Pipedrive
The foundation of any reliable magic number forecast is a clean, consistent data model. Without a separate tool, you must design Pipedrive fields that capture the three core inputs: qualified co-sell opportunities, partner-influenced revenue, and time-to-close acceleration. Start by auditing your existing deal and person fields—most teams already have 60-70% of what they need, just scattered across custom fields, notes, and activity types.
Create three new custom fields on the Deal object (no point solution required):
- Co-Sell Type (single-select: "Partner-Led," "Partner-Assisted," "Partner-Referred," "None")
- Partner Influence % (numeric, 0-100, representing estimated revenue attribution)
- Co-Sell Start Date (date field, triggered when first partner activity is logged)
For the Person/Contact object, add a Partner Affiliation field (link to your Partner Companies pipeline) and a Co-Sell Activity Count (formula field counting activities with "partner" in the subject line). These fields become your raw data layer—no API calls, no third-party syncs.
The magic number itself is a calculated ratio: Total Partner-Influenced Closed Won Revenue ÷ Total Co-Sell Opportunities Created. To compute this inside Pipedrive without external tools, use a combination of:
- Deal-stage probability weighting (assign % likelihood at each stage)
- Weighted pipeline reports (Pipedrive’s built-in forecast report)
- Custom dashboard metrics (using the "Formula" field type for real-time calculations)
For example, if you have 15 co-sell deals at $50K each in stage 3 (40% probability), your weighted magic number contribution is $300K. Track this weekly in a dedicated "Channel Co-Sell Forecast" dashboard with four tiles: Active Co-Sell Deals, Weighted Pipeline, Average Deal Size, and Magic Number Ratio.
Operationalizing the Forecast with Pipedrive Workflows and Activity Patterns
Once your data model is live, the magic number forecast becomes a byproduct of operational cadence—not a separate calculation. Use Pipedrive’s Workflow Automation (available on Advanced and Enterprise plans) to trigger actions that keep your forecast accurate without manual data entry.
Design three automated workflows:
Workflow 1: Co-Sell Opportunity Creation
- Trigger: When a deal’s "Co-Sell Type" field changes from "None" to any partner value
- Action: Create a follow-up activity ("Partner Co-Sell Kickoff") due in 3 days, assign to the deal owner
- Action: Send an internal email to your channel manager with deal details
- Action: Update the "Co-Sell Start Date" field to today’s date
Workflow 2: Stage-Based Probability Updates
- Trigger: When a co-sell deal moves to a new stage
- Action: Recalculate the "Partner Influence %" based on stage-specific benchmarks (e.g., stage 2 = 20%, stage 4 = 70%)
- Action: Log an activity noting the stage change and updated influence percentage
Workflow 3: Weekly Forecast Snapshot
- Trigger: Every Monday at 8 AM
- Action: Export a filtered CSV of all co-sell deals (using Pipedrive’s email report feature) to your channel team
- Action: Create a note on the "Channel Co-Sell" pipeline with the week’s weighted total
For activity patterns that feed the forecast, standardize how your team logs partner interactions. Create a Partner Co-Sell Activity Type with mandatory fields: Partner Name, Interaction Type (Call/Email/Meeting), and Influence Level (High/Medium/Low). Pipedrive’s activity reports can then show you which partners generate the highest influence per interaction—a leading indicator for your magic number.
Track these three leading indicators weekly:
- Partner Activity Velocity (number of co-sell activities per deal per week)
- Stage Duration for Co-Sell Deals (average days to close vs. non-co-sell deals)
- Partner Influence % Stability (how often the percentage changes during a deal)
When you see activity velocity drop below 2 per week, or stage duration exceed your baseline by 20%, it’s a signal to intervene before the magic number declines.
Reporting the Magic Number with Pipedrive Dashboards and Manual Validation
Pipedrive’s reporting capabilities are sufficient for a weekly magic number forecast—no point solution needed. Build a Channel Co-Sell Forecast Dashboard with five key reports that give you both current state and trend analysis.
Report 1: Co-Sell Pipeline by Stage (Stacked Bar Chart)
- X-axis: Deal stages
- Y-axis: Total deal value
- Color: Co-Sell Type field
- Filter: Only deals with Co-Sell Type ≠ "None"
- This shows where your co-sell deals concentrate and whether they progress similarly to direct deals
Report 2: Magic Number Trend (Line Chart)
- X-axis: Week (last 12 weeks)
- Y-axis: Magic Number Ratio (calculated as Total Partner-Influenced Closed Won / Total Co-Sell Opportunities Created)
- Use Pipedrive’s "Calculated Field" to store the weekly ratio, then plot it
- Add a trendline (manual annotation) to show direction
Report 3: Partner Influence Distribution (Pie Chart)
- Segments: 0-25%, 26-50%, 51-75%, 76-100% influence brackets
- Value: Count of closed won deals
- This reveals whether a few partners drive most of the magic number or if it’s broadly distributed
Report 4: Co-Sell Velocity (Table with Conditional Formatting)
- Columns: Deal Name, Partner, Stage, Days in Stage, Expected Close Date
- Highlight deals where days in stage exceeds your median (e.g., >30 days) in red
- Sort by expected close date ascending to focus on at-risk deals
Report 5: Weekly Forecast Summary (Single Metric Cards)
- Card 1: Weighted Co-Sell Pipeline (sum of deal values × stage probability)
- Card 2: Average Days to Close (co-sell vs. non-co-sell)
- Card 3: Active Partners with Co-Sell Deals (count of unique partner contacts)
- Card 4: Magic Number (current week’s ratio)
For manual validation—because no CRM forecast is perfect—schedule a 15-minute weekly review every Monday. During this review:
- Compare your Pipedrive magic number against your actual closed deals from the prior week
- Flag any deals where the Partner Influence % seems off (e.g., a $100K deal with only 10% influence)
- Update any co-sell deals that went silent (no activity in 14+ days)
- Adjust your stage probability weights if actual close rates deviate by more than 10%
This manual touchpoint ensures your forecast remains grounded in reality, while the automated dashboards give you real-time visibility. Over 8-12 weeks, you’ll develop a baseline magic number that accounts for seasonality, partner ramp time, and deal complexity—all without a single point solution beyond Pipedrive’s native capabilities.
Sources
- Pipedrive official documentation — product features, API capabilities, and sales pipeline management.
- Gartner — market analysis and best practices for CRM and channel sales metrics.
- Forrester Research — frameworks for partner ecosystem performance and co-sell forecasting.
- Harvard Business Review — general principles of sales forecasting and channel strategy.
- Salesforce AppExchange — examples of integrated solutions for partner relationship management.
- CSO Insights (part of Miller Heiman Group) — research on sales effectiveness and channel metrics.
FAQ
What exactly is a “magic number” for channel co-sell? It’s a ratio that measures how efficiently your partner-sourced pipeline converts to revenue—typically calculated as (net new ARR from co-sell) / (total co-sell investment). The “magic” target varies by business model, but a healthy range is often 0.7x to 1.5x within the first 12 months of a partnership program.
Can I build this forecast using only Pipedrive’s native fields? Yes, if you create custom deal fields for partner source, co-sell stage, and revenue attribution. You’ll also need a pipeline report that sums closed-won amounts from those deals. No external tool is required, but you must enforce consistent data entry across your sales team.
How do I avoid double-counting revenue when multiple partners are involved? Use a single “primary partner” field on each deal and a percentage split field for revenue attribution. Pipedrive’s custom fields can store both, and you can run a sum report filtered by the primary partner. For splits, manual calculation in a weekly spreadsheet is acceptable until volume justifies automation.
What’s the minimum data history needed to start forecasting? At least 3 to 6 months of consistent co-sell deal tracking. With less data, the magic number will be noisy and unreliable. Start with a pilot segment (e.g., top 5 partners) and collect 10–20 closed-won co-sell deals before calculating a meaningful ratio.
How often should I update the forecast? Weekly for active pipeline reviews, monthly for the magic number itself. The ratio tends to stabilize over 90-day rolling windows. Avoid daily updates—they create false signals from small sample sizes.
What if my magic number is below 0.5x? That typically indicates either low partner engagement, misaligned incentives, or poor deal qualification. Audit your partner onboarding process, check if co-sell deals are being tagged correctly, and consider adjusting your partner commission structure. A number below 0.3x often means the program needs a redesign, not just better reporting.
Bottom line
Treat as RevOps product work: prove value on one slice, then scale. Polish can deepen this entry later.