🚀 Early Access: FREE full access to All Workflows and AI Prompt Systems! No credit card required.
Sales leaders, RevOps analysts, Sales operations managers, Frontline managers, Founders
Prepare the Required Inputs listed in the Workflow Prompt. Use as much detail as necessary.
1. Copy the Workflow Prompt.
2. Paste it into your AI tool.
3. Replace the "Required Inputs"
4. Run the prompt.
Get access to this workflow and 1000+ others designed to save hours and get better results with AI.
You are a sales operations analyst. Your task is to evaluate sales activity effectiveness and identify which activities are actually contributing to pipeline creation, deal progression, and revenue.
### Required Input
- Sales Team Context: [Example: 12 AEs, 6 SDRs, selling B2B software to finance teams]
- Activity Data: [Provide calls, emails, LinkedIn touches, meetings, demos, follow-ups, proposals, or CRM activity summaries]
- Outcome Data: [Provide meetings booked, opportunities created, stage movement, win rates, revenue, or response rates]
- Time Period: [Example: last 90 days]
- Segments or Rep Groups: [Example: SDR vs AE, enterprise vs mid-market, inbound vs outbound]
- Sales Process: [Brief overview of how activity should lead to outcomes]
- Current Concern: [Example: high email volume but low meetings, inconsistent follow-up, low opportunity creation]
- Goal: [Example: improve meeting-to-opportunity conversion or increase qualified pipeline]
### Input Validation
Check whether activity and outcome data are both present. If only activity volume is provided with no outcome data, ask for at least one measurable result before analysing effectiveness. Pause until the user clarifies.
### Instructions
Do not reward activity volume by itself. Analyse the relationship between activity, timing, quality, buyer response, stage progression, and revenue outcomes. Distinguish productive activity from busy work.
Compare activities by type, sequence, segment, and rep group where data allows. Identify patterns such as high outreach with low conversion, strong meeting booking but poor qualification, delayed follow-up after demos, proposal activity that does not close, or uneven performance between reps.
Look for behavioural and process causes: poor targeting, weak messaging, inadequate multi-threading, low call quality, lack of next steps, activity logged incorrectly, over-reliance on one channel, or manager expectations that drive quantity over quality.
Recommendations must be practical for sales managers. Provide coaching actions, activity standards, inspection points, CRM improvements, and sequence adjustments. Avoid generic advice like "make more calls" unless the evidence supports it and specify what should change.
### Output
- Executive Summary: whether activity is translating into meaningful revenue outcomes
- Activity-to-Outcome Snapshot: key activity types and the outcomes connected to them
- Effectiveness Findings: what is working, what is inefficient, and what is unclear
- Segment and Rep Pattern Review: differences by team, segment, source, or role
- Quality vs Quantity Assessment: where volume helps and where quality is the constraint
- Conversion Points: activity stages that most influence meetings, opportunities, progression, or wins
- Root Cause Diagnosis: targeting, messaging, timing, process, coaching, or data issues
- Manager Coaching Recommendations: specific behaviours to reinforce or correct
- Activity Standard Recommendations: practical expectations by role or sales stage
- Measurement Plan: metrics and dashboards to track effectiveness going forward
Create a manager-ready coaching scorecard for weekly activity reviews.
This audit evaluates the relationship between sales activity volume and actual pipeline production over the last 90 days. The focus product is the Cross-Border Customs API Hub, targeting mid-market and enterprise supply chain operations.
| Sales Role & Focus | 90-Day Activity Volumes (Per Rep/Week) | Direct Intermediate Outcomes | Final Pipeline Revenue Yield |
|---|---|---|---|
| Outbound SDRs (6 Reps) | 420 Automated Emails 45 Cold Phone Calls 30 LinkedIn Touches |
0.8% Email Open-to-Reply Rate 4.2% Call Connect Rate |
Average 1.8 qualified meetings booked per week per rep. |
| Mid-Market AEs (12 Reps) | 140 Follow-Up Emails 22 Manual Phone Calls 6 Product Demos |
12% Demo-to-Proposal Rate 24-Day Stage Stagnation |
Average $45,000 closed-won ARR per quarter. |
The Quantity Trap:
Our current sales performance metrics reward raw numbers rather than outreach accuracy. Because SDRs are evaluated primarily on hitting a weekly goal of 500 total activities, they rely on wide, automated email sequences targeting generic information aliases. This high volume creates an illusion of high productivity while hiding an execution gap: reps are failing to research target enterprise accounts or engage technical stakeholders early in the buying cycle.
An evaluation of our historical sales cycles shows that the following three critical sales activities have the highest statistical influence on winning deals:
Get access to all workflows, across every sector, with structured systems built for better results.