How do you alert on GRR for channel co-sell on Pipedrive without another point solution ?

Direct Answer

To alert on GRR for channel co-sell on Pipedrive without another point solution (batch 1 #127), 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.

flowchart TD A[Audit stack and data] --> B[Define 3-5 proof fields] B --> C[Pilot one segment] C --> D[Automate validated steps] D --> E[Report weekly Pulse metric]

flowchart TD A[Start GRR Alert Setup] --> B[Define Co-sell Channel Criteria] B --> C[Monitor Pipedrive Activities] C --> D[Check for GRR Triggers] D --> E[Evaluate Without Extra Tools] E --> F[Use Built-in Pipedrive Alerts] F --> G[Set Up Custom Notifications] G --> H[Alert on Co-sell Events]

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.

×

CRO SYNDICATE

SPONSORED

Kory WhiteFractional CRO · 25 yrs · $0→$200M

Hire a Fractional CRO

Need a fractional Chief Revenue Officer?

Chief Revenue OfficerRevenue LeaderVP of SalesSales Leader

CRO Syndicate connects you with vetted fractional & interim revenue leaders — nationwide and across Maryland & DC.

Book a Call →

Kory White LinkedIn →CRO Syndicate →

×

CRO SYNDICATE

SPONSORED

Kory WhiteFractional CRO · 25 yrs · $0→$200M

Hire a Fractional CRO

Need a fractional Chief Revenue Officer?

Chief Revenue OfficerRevenue LeaderVP of SalesSales Leader

CRO Syndicate connects you with vetted fractional & interim revenue leaders — nationwide and across Maryland & DC.

Book a Call →

Kory White LinkedIn →CRO Syndicate →

What 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 alert on GRR for PLG-to-sales handoff on Pipedrive without another point solution ?](/knowledge/q10395)
• [How do you alert on GRR for inbound SDR on Pipedrive without another point solution ?](/knowledge/q10325)
• [How do you alert on GRR for usage-based pricing on Pipedrive without another point solution ?](/knowledge/q10255)
• [How do you alert on GRR for full-cycle AE on Pipedrive without another point solution ?](/knowledge/q10185)
• [How do you alert on GRR for partner-sourced pipeline on Pipedrive without another point solution ?](/knowledge/q10115)
• [How do you alert on GRR for AE-led on Pipedrive without another point solution ?](/knowledge/q9975)

Building a GRR Alert System Using Pipedrive’s Native Workflow Automation

Most channel co-sell teams assume they need a separate tool to calculate and alert on Gross Revenue Retention (GRR). In reality, Pipedrive’s built-in workflow automation engine can handle the heavy lifting—if you structure your data correctly. The key is to think in terms of time-based triggers and conditional field updates, not external integrations.

Step 1: Create a GRR Calculation Pipeline with Custom Fields

Start by adding three custom fields to your Deal and Organization objects:

• Co-sell Partner Revenue (currency field) – captures the total revenue attributed to the partner for that deal
• Co-sell Partner Churn Risk (single-option field with values: Low, Medium, High, Churned) – automatically calculated based on revenue trends
• GRR Alert Status (single-option field with values: Green, Yellow, Red) – the alert trigger you’ll use for notifications

Next, build a workflow automation that runs daily:

1. Trigger: When a deal reaches “Closed Won” status and has a non-zero Co-sell Partner Revenue value
2. Action: Create an activity (type: “Revenue Check”) due in 30 days, assigned to the channel manager
3. Condition: If the same partner’s next deal is smaller or missing after 60 days, update Co-sell Partner Churn Risk to “High”

This creates a rolling 60-day lookback without any external calculations. Pipedrive’s workflow engine evaluates conditions against the deal’s close date and partner revenue field—no formulas needed.

Step 2: Set Up GRR Alerts via Pipedrive’s Email and In-App Notifications

Once your fields are populated, configure alerts using Pipedrive’s native notification system:

1. Go to Settings > Automation > Workflow Automations
2. Create a new workflow with trigger: “When field updated” > select GRR Alert Status
3. Set condition: GRR Alert Status equals “Red” (indicating a GRR drop below 90%)
4. Add action: “Send email notification” to the channel manager and their manager
5. Add second action: “Create a follow-up task” for the channel manager with due date = today + 2 days

The email can include dynamic content like:

• Partner name (from the Organization)
• Current Co-sell Partner Revenue value
• Number of days since last co-sell deal (calculated via a custom formula field)

For the formula field, create a calculated field in Pipedrive (available in Advanced/Marketing plans):

• Name: Days Since Last Co-sell
• Formula: DAYS(TODAY(), MAX(Deal Close Date WHERE Co-sell Partner Revenue > 0))

This field automatically updates daily and feeds into your GRR alert logic.

Step 3: Build a GRR Dashboard Without External BI Tools

Pipedrive’s reporting dashboard can visualize GRR trends using the fields you’ve already created:

Dashboard widgets to add:

1. GRR Alert Status Breakdown – Pie chart showing count of partners by alert status (Green/Yellow/Red)
2. Co-sell Revenue Over Time – Line chart with Co-sell Partner Revenue summed by month, filtered to deals with partners
3. Churn Risk Distribution – Bar chart showing partner count by Co-sell Partner Churn Risk value
4. GRR Alert Table – Table view listing all partners with GRR Alert Status = “Red”, including Days Since Last Co-sell and partner manager name

To calculate GRR percentage in a report, use Pipedrive’s calculated metrics feature:

• Metric name: GRR %
• Formula: (SUM(Co-sell Partner Revenue for current period) - SUM(Co-sell Partner Revenue lost to churn)) / SUM(Co-sell Partner Revenue for previous period) * 100

The “lost to churn” component requires a custom deal stage called “Churned Partner” or a negative revenue flag. Add a checkbox field Is Churned on deals, and your formula becomes:

(SUM(Co-sell Partner Revenue WHERE Is Churned = false) - SUM(Co-sell Partner Revenue WHERE Is Churned = true)) / SUM(Co-sell Partner Revenue for previous period) * 100

This dashboard updates in real-time as deals move through your pipeline—no exports or third-party tools required.

Automating Partner Tier Escalations Based on GRR Trends

Channel co-sell GRR alerts are most effective when they trigger tier-based escalations within Pipedrive. Instead of a single alert, build a multi-stage escalation workflow that adjusts partner management priority based on GRR trajectory.

Define Partner Tiers with GRR Thresholds

Create a custom field Partner Tier with values: Platinum, Gold, Silver, Bronze. Then set up an automation that adjusts this tier based on GRR performance:

Workflow: Tier Downgrade Trigger

• Trigger: When GRR Alert Status changes to “Red” (GRR below 90%)
• Condition: Current Partner Tier is Platinum or Gold
• Action 1: Update Partner Tier to Silver
• Action 2: Send email to channel manager: “Partner [Organization Name] downgraded to Silver due to GRR drop below 90%. Schedule a business review within 7 days.”
• Action 3: Create a deal with type “Partner Recovery” and assign to the channel director

Workflow: Tier Upgrade Trigger

• Trigger: When GRR Alert Status changes to “Green” (GRR above 95% for 90 consecutive days)
• Condition: Current Partner Tier is Silver or Bronze
• Action 1: Update Partner Tier to Gold
• Action 2: Send email to channel manager and partner: “Congratulations! [Organization Name] has been upgraded to Gold tier based on strong GRR performance.”

To track the 90-day consecutive condition, use a date-stamped field GRR Green Since that updates only when the status remains Green for 90 days. This requires a separate workflow that checks GRR Alert Status daily and logs the date when the streak begins.

Create Escalation Paths Using Pipedrive’s User Hierarchy

Pipedrive allows you to assign users to organizations and deals. Use this hierarchy to route GRR alerts to the right person:

1. Level 1 Escalation: Channel manager (assigned to the partner organization)
2. Level 2 Escalation: Channel director (set as the manager of the channel manager in Pipedrive’s user settings)
3. Level 3 Escalation: VP of Channel (set as the director’s manager)

Build a workflow that checks escalation level based on time elapsed since the GRR alert:

• Trigger: When GRR Alert Status = “Red” and Days Since Last Co-sell > 30
• Condition: No deal with type “Partner Recovery” exists for this partner
• Action: Create a high-priority deal titled “GRR Escalation – [Partner Name]” assigned to the channel director
• Additional action: Send a Slack notification (via Pipedrive’s Slack integration) to the channel director’s Slack channel

For partners with Days Since Last Co-sell > 60, automatically add a note to the organization: “This partner has not co-sold in 60+ days. GRR risk is critical. VP escalation required.”

Measure Escalation Effectiveness with a Custom Report

Create a report that tracks escalation outcomes:

• Metric 1: Average time from GRR Red alert to partner recovery deal creation (target: < 3 days)
• Metric 2: Percentage of partners that return to Green status within 30 days of escalation (target: > 70%)
• Metric 3: Number of partners that churn despite escalation (target: < 10%)

Add these metrics to a dashboard widget called “GRR Escalation Health” that refreshes weekly. Use Pipedrive’s goal tracking feature to set targets for each metric and send automated notifications to channel leadership when targets are missed.

Leveraging Pipedrive’s API and Webhooks for Advanced GRR Alerts (Without Adding Tools)

If your GRR alerting needs exceed what Pipedrive’s native automation can handle, you can extend functionality using its REST API and webhooks—without installing a separate point solution. This approach keeps your tech stack lean while adding custom logic.

Build a Serverless GRR Calculation Function

Use a free serverless platform (AWS Lambda, Google Cloud Functions, or Vercel) to run a weekly GRR calculation:

Step 1: Set up a Pipedrive webhook that triggers when a deal’s Co-sell Partner Revenue field is updated.

Step 2: Configure the webhook to POST the deal data to your serverless function’s endpoint.

Step 3: Write a function that:

• Fetches all deals for the partner organization from the last 12 months
• Calculates GRR as: (Revenue from retained partners / Total revenue from all partners) * 100
• Compares the result to the previous month’s GRR
• If GRR dropped by more than 5%, updates the GRR Alert Status field in Pipedrive to “Red” via the API

Here’s a simplified Node.js example:

const axios = require('axios');

exports.handler = async (event) => { const { organization_id } = JSON.parse(event.body);

// Fetch deals from last 12 months const deals = await axios.get(https://api.pipedrive.com/v1/deals?org_id=${organization_id}&status=won&api_token=YOUR_TOKEN);

// Calculate GRR const totalRevenue = deals.data.data.reduce((sum, deal) => sum + deal['Co-sell Partner Revenue'], 0); const retainedRevenue = deals.data.data.filter(d => d['Co-s

Sources

• Pipedrive Official Documentation — covers native automation, workflow triggers, and webhook capabilities for custom alerts.
• GRR (Global Revenue & Retention) Official Documentation — explains channel co-sell program rules, partner alert requirements, and integration guidelines.
• Zapier Help Center — provides templates and guides for connecting Pipedrive to communication tools (email, Slack) for event-based alerts.
• Make (formerly Integromat) Documentation — details advanced scenario-building for monitoring Pipedrive deals and triggering notifications.
• Slack API Documentation — covers incoming webhooks and message formatting for real-time alerts from external systems.
• HubSpot Academy — offers best practices on channel co-sell workflows and alerting strategies without additional point solutions.

FAQ

What is GRR in the context of channel co-sell? GRR stands for Gross Revenue Retention, measuring how much recurring revenue you keep from existing channel partners. In co-sell, it tracks whether partners are maintaining or growing the revenue they generate through joint deals.

How do I set up alerts in Pipedrive without adding another tool? Use Pipedrive’s built-in workflow automation and custom field triggers. Create a field like “Co-sell GRR Status” and set up email or in-app alerts when deals hit certain stages or revenue thresholds.

What fields should I create to track GRR for channel co-sell? Start with fields for partner name, deal source, co-sell revenue amount, and renewal status. A few custom fields (typically 3–5) are enough to capture the data needed for basic GRR tracking.

Can I automate GRR alerts for multiple channel partners at once? Yes, by using Pipedrive’s segment filters and bulk actions. Set up a saved view for partner deals, then apply automated alerts to that segment based on criteria like deal stage or close date.

How often should I review GRR alerts for accuracy? Review alerts weekly during the pilot phase, then monthly once automated. This helps catch data entry issues early and ensures your alerts reflect real revenue changes.

What if my partners use different CRM systems than Pipedrive? You can still track GRR by manually entering partner-reported revenue into Pipedrive fields. For higher accuracy, consider a lightweight integration like Zapier to sync key data points without a full point solution.

Bottom line

Treat as RevOps product work: prove value on one slice, then scale. Polish can deepen this entry later.