Bid Analytics

Bid Analytics transforms your bid records into strategic intelligence through interactive dashboards, trend analysis, and performance metrics. Rather than relying on gut feel or anecdotal evidence, you gain data-driven insights into what drives wins, where you're most competitive, and how your bidding performance is evolving.

The analytics system automatically calculates key metrics from your bid records, revealing patterns invisible in individual opportunities: win rate trends, sweet spots where you dominate, competitive intensity indicators, and efficiency improvements over time.

Analytics Dashboard Overview

The Bid Analytics dashboard provides at-a-glance visibility into your bidding performance:

Dashboard Sections

The dashboard is organized into key analytical areas:

Overview Metrics (top of dashboard):

• Overall win rate with trend indicator
• Total pipeline value across all active bids
• Number of active opportunities being evaluated or bid
• Current period revenue from wins

Performance Trends (charts and graphs):

• Win rate over time (monthly, quarterly, yearly views)
• Win rate by opportunity size, category, and department
• Pipeline velocity and conversion metrics
• Time-to-decision analytics

Competitive Intelligence (comparison views):

• Your performance vs. industry benchmarks
• Head-to-head results against top competitors
• Market share trends in target categories

Efficiency Metrics (operational analytics):

• Bid preparation time trends
• Resource allocation effectiveness
• Bid/no-bid decision quality

Let's explore each analytical capability in detail.

Win Rate Analysis

Win rate—the percentage of submitted bids that result in contract awards—is the most fundamental performance metric.

Overall Win Rate

Your overall win rate is calculated as:

Win Rate = (Number of Wins) / (Number of Bids Submitted) × 100%

What's included:

• Numerator: Bid records with Outcome = "Won"
• Denominator: Bid records with Status = "Submitted" or "Won" or "Lost" (i.e., you actually bid)

What's excluded:

• No-bid decisions (you didn't submit, so not in denominator)
• Cancelled opportunities (removed from both numerator and denominator)
• Opportunities still pending decision (not yet in either calculation)

Win Rate Trends

More valuable than a single win rate number is understanding how it's changing:

Time-based trend chart:

• Monthly view: Detailed short-term fluctuations (useful with high bid volume)
• Quarterly view: Smooths noise, reveals medium-term trends (most commonly used)
• Yearly view: Long-term strategic view (requires 3+ years of data)

Interpreting trends:

Upward trend (win rate increasing):

• Positive indicators: Improved capability, better bid discipline, weaker competition
• Monitor: Is improvement sustainable or temporary?
• Action: Identify what's working and replicate

Downward trend (win rate decreasing):

• Warning indicators: Stronger competition, capability gaps, market changes
• Monitor: Is decline across all categories or specific areas?
• Action: Investigate root causes and adjust strategy

Stable trend (win rate flat):

• Could indicate: Mature market position, balanced competitive environment
• Monitor: Ensure stability isn't masking category-specific changes
• Action: Look for opportunities to improve or new markets to enter

Volatile trend (erratic ups and downs):

• May indicate: Small sample sizes, inconsistent bidding strategy, opportunistic vs. strategic bidding
• Monitor: Sample size (volatility normal with <10 bids/quarter)
• Action: Increase bid volume or improve bid discipline for more consistent results

Win Rate by Opportunity Size

Your competitiveness often varies dramatically by contract value:

Typical segmentation:

• Small: <$100K
• Medium: $100K-$500K
• Large: $500K-$2M
• Major: >$2M

(Adjust thresholds to match your market)

Common patterns:

Higher win rate on small opportunities:

• Less competition (major competitors ignore small work)
• Lower risk for clients (easier to award to less-established firms)
• Possible interpretation: You're more competitive in lower tiers

Higher win rate on large opportunities:

• Established credibility required
• Fewer capable competitors
• Possible interpretation: You have strong differentiation at scale

Sweet spot in middle:

• Win rate peaks in $500K-$2M range
• May indicate: Optimal size for your capabilities and capacity
• Strategic implication: Pursue opportunities in this range more aggressively

Win Rate by Category

Procurement categories reveal your capability strengths:

Category segmentation examples:

• IT Services
• Professional Services
• Construction/Facilities
• Consulting
• Equipment/Supplies
• R&D/Innovation

Analysis questions:

Where do you win most?

• Categories with >50% win rate are strengths
• Focus business development here
• Use as anchor for adjacent category expansion

Where do you struggle?

• Categories with <25% win rate may indicate:
  • Capability gaps (you're not competitive)
  • Poor bid selection (you're pursuing wrong opportunities)
  • Established competition (incumbents or specialists dominate)

Emerging categories:

• New categories where you've bid 3-5 times
• If winning, signals successful diversification
• If losing, may need more investment before competitive

Example analysis:

IT Security: 65% win rate (20 bids) → STRENGTH - Core competency
Cloud Services: 45% win rate (11 bids) → DEVELOPING - Improving capability
IT Training: 20% win rate (10 bids) → WEAKNESS - Consider exit or partnership

Strategic implications:

• Double down on IT Security business development
• Continue building Cloud Services capability and pipeline
• Either invest heavily in IT Training or stop bidding to improve overall win rate

Win Rate by Department/Agency

Government departments have different procurement cultures and vendor relationships:

Department-level analysis:

Strategic insights:

• Transport Canada: Priority for business development, proven success
• Public Safety: Consider no-bid unless unique opportunity or teaming
• Health Canada: Solid secondary market, maintain presence
• National Defence: Invest in clearances if strategic, otherwise avoid

Win Rate by Competition Level

When you track competitors in bid records, analytics can segment by competitive intensity:

Competition segmentation:

• Low competition: 1-3 known bidders
• Medium competition: 4-6 bidders
• High competition: 7+ bidders

Typical pattern:

Low competition (3 bidders avg): 55% win rate
Medium competition (5 bidders avg): 35% win rate
High competition (8+ bidders avg): 15% win rate

Strategic application:

• If your win rate drops dramatically with competition level, you may be winning on availability rather than differentiation
• Focus on opportunities with lower anticipated competition
• Or invest in capability development to compete in crowded markets

Win Rate vs. Specific Competitors

The most actionable win rate analysis compares head-to-head performance:

Competitor comparison table:

Interpretation:

• TechCorp Inc & Global IT: You typically beat them → Bid confidently when they're likely competitors
• SecureNet Solutions: They typically beat you → Consider no-bid, teaming, or capability investment to counter them

This granular analysis drives specific strategic responses to specific competitive threats.

Pipeline Analysis

Pipeline analytics track opportunities in process, forecasting future revenue and resource needs:

Pipeline Value

Total value of all opportunities currently being pursued:

Pipeline segments:

• Evaluating: Opportunities under bid/no-bid review
• Bidding: Opportunities you're actively preparing proposals for
• Submitted: Bids submitted awaiting decision
• Total Pipeline: Sum of all active stages

Example pipeline view:

Evaluating: $2.3M across 8 opportunities
Bidding: $1.8M across 5 opportunities
Submitted: $3.5M across 6 opportunities
Total Pipeline: $7.6M across 19 opportunities

Weighted Pipeline

More sophisticated pipeline analysis applies probability weights:

Weighting by stage:

• Evaluating: 25% probability (1 in 4 becomes a bid)
• Bidding: 50% probability (you're committed to bid)
• Submitted: Based on your win rate (e.g., 35% if that's your historical win rate)

Weighted pipeline calculation:

Evaluating: $2.3M × 0.25 = $575K weighted value
Bidding: $1.8M × 0.50 = $900K weighted value
Submitted: $3.5M × 0.35 = $1.2M weighted value
Total Weighted Pipeline: $2.7M

Weighted pipeline provides more realistic revenue forecasts than raw pipeline value.

Pipeline Velocity

How fast opportunities move through your pipeline:

Key metrics:

• Average time in Evaluating: Days from discovery to bid/no-bid decision
• Average time in Bidding: Days from decision-to-bid to submission
• Average time in Submitted: Days from submission to outcome
• Total cycle time: Discovery to outcome

Velocity trends:

Improving velocity (time decreasing):

• More efficient evaluation processes
• Better bid preparation workflows
• Faster decision-making

Declining velocity (time increasing):

• More thorough evaluation (could be positive)
• Resource constraints causing delays (negative)
• More complex opportunities (neutral)

Example:

2023 Average: 45 days evaluation → 30 days bidding → 60 days awaiting outcome = 135 days total
2024 Average: 30 days evaluation → 25 days bidding → 60 days awaiting outcome = 115 days total

Improvement: 15% faster cycle time, primarily from better evaluation efficiency

Pipeline Health Indicators

Analytics can flag pipeline health issues:

Warning indicators:

Too many "Evaluating":

• Large number stuck in evaluation without bid/no-bid decisions
• Suggests: Poor bid discipline, capacity constraints, or indecisiveness
• Action: Improve evaluation criteria and decision authority

Few "Bidding":

• Not enough opportunities moving from evaluation to active pursuit
• Suggests: Too selective, capability gaps, or insufficient pipeline
• Action: Expand business development or relax bid criteria

High "Submitted" to "Won" failure rate:

• Many bids submitted but low win rate
• Suggests: Poor bid quality, unrealistic self-assessment, or very high competition
• Action: Improve bid/no-bid decision-making or proposal quality

Example health check:

HEALTHY PIPELINE:
Evaluating: 10-15 opportunities
Bidding: 5-8 opportunities
Submitted: 4-6 opportunities (awaiting outcome)
Win Rate: 35-45%

UNHEALTHY PIPELINE (too selective):
Evaluating: 3 opportunities
Bidding: 1 opportunity
Submitted: 1 opportunity
Win Rate: 60% (but insufficient volume)

UNHEALTHY PIPELINE (poor discipline):
Evaluating: 25 opportunities
Bidding: 15 opportunities
Submitted: 12 opportunities
Win Rate: 20% (bidding too many unsuitable opportunities)

Average Deal Size

Beyond win rate, the size of won opportunities drives revenue:

Won Deal Size Analysis

Key metrics:

• Average won deal value: Mean contract value of wins
• Median won deal value: Middle value (less affected by outliers)
• Deal size range: Smallest to largest wins
• Deal size distribution: How wins cluster by size

Example:

Average Won Deal: $650K
Median Won Deal: $425K
Range: $75K (smallest) to $2.3M (largest)

Distribution:
<$250K: 35% of wins (high volume, lower value)
$250K-$750K: 45% of wins (core market)
$750K-$1.5M: 15% of wins (growth segment)
>$1.5M: 5% of wins (occasional major win)

Strategic insights:

• Core market is $250K-$750K (45% of wins)
• Good volume in small deals (<$250K) but lower total revenue
• Few major wins (>$1.5M) but significant revenue impact when they occur

Deal Size vs. Win Rate

Plotting win rate against deal size often reveals strategic insights:

Example analysis:

<$100K: 55% win rate, avg deal $65K
$100K-$500K: 40% win rate, avg deal $275K
$500K-$1M: 35% win rate, avg deal $700K
>$1M: 25% win rate, avg deal $1.5M

Interpretation options:

Pattern 1 - Higher win rate on smaller deals:

• You may be more competitive in lower tiers
• Less competition on small work
• Consider: Can you maintain volume of small work while improving competitiveness on large?

Pattern 2 - Higher win rate on larger deals:

• Established credibility and capability at scale
• Fewer capable large competitors
• Consider: How to increase volume of large opportunities pursued?

Pattern 3 - Sweet spot in middle:

• Best win rate in $500K-$1M range
• Possible over-bidding both smaller and larger
• Consider: Focus on optimal size range, team or build for others

Revenue Mix

Analyzing where your revenue comes from:

By opportunity size:

Small (<$250K): 35% of wins, 15% of revenue
Medium ($250K-$750K): 45% of wins, 50% of revenue
Large ($750K+): 20% of wins, 35% of revenue

Insight: 20% of wins (large deals) drive 35% of revenue. Major deals have outsized impact.

By category:

IT Services: 50% of wins, 60% of revenue
Consulting: 30% of wins, 25% of revenue
Professional Services: 20% of wins, 15% of revenue

Insight: IT Services is core business (majority of wins and revenue). Consulting and Professional Services are secondary.

Strategic implications:

• Protect and grow IT Services (core revenue driver)
• Assess if Consulting and Professional Services are strategic or distractions
• Consider pursuing larger deals despite lower win rate (revenue impact justifies effort)

Time-to-Decision Analytics

How long does your organization take to evaluate opportunities and make bid/no-bid decisions?

Evaluation Cycle Time

Metric: Days from opportunity discovery (record created) to bid/no-bid decision

Typical ranges:

• Fast evaluation: 1-5 days (quick go/no-go based on clear criteria)
• Standard evaluation: 5-15 days (thorough analysis, team discussion)
• Slow evaluation: 15+ days (complex analysis, multiple stakeholders)

Tracking over time:

Q1 2024: Average 12 days to decision
Q2 2024: Average 10 days to decision
Q3 2024: Average 8 days to decision
Q4 2024: Average 7 days to decision

Trend: Improving efficiency (42% faster than Q1)

Factors affecting evaluation time:

• Opportunity complexity
• Availability of decision-makers
• Quality of bid/no-bid criteria
• Workload and competing priorities

Bid Preparation Time

Metric: Days from bid decision to submission

Tracking:

Average bid prep time: 18 days
By opportunity size:
  <$250K: 10 days avg
  $250K-$750K: 18 days avg
  $750K-$1.5M: 25 days avg
  >$1.5M: 35 days avg

Efficiency trends:

• Are you getting faster at proposal development?
• Is prep time consistent or highly variable?
• Do rush jobs (short prep time) have lower win rates?

Example insight:

FINDING: Bids prepared in <10 days have 25% win rate
         Bids prepared in 10-20 days have 40% win rate
         Bids prepared in >20 days have 35% win rate

INTERPRETATION: Rushing reduces quality. Excessive time doesn't improve results.
OPTIMAL PREP TIME: 10-20 days for best win rate

Decision-to-Outcome Time

Metric: Days from submission to outcome announcement

This metric reflects government procurement timelines (mostly outside your control) but can inform planning:

Tracking by department:

Transport Canada: 45 days avg to decision
Public Safety: 60 days avg
Health Canada: 50 days avg
National Defence: 75 days avg

Application: When forecasting revenue or resource planning, use historical decision times to estimate when submitted bids will likely conclude.

Competitive Benchmarks

How does your performance compare to industry standards?

Win Rate Benchmarks

Government contracting industry averages (approximate):

Your performance vs. benchmark:

Your IT Services Win Rate: 38%
Industry Benchmark: 15-25% (competitive) to 35-45% (established)

Assessment: ABOVE AVERAGE - You're in the "established relationships" tier

Market Share Analysis

If you track total contract values in your target markets:

Market share calculation:

Your Wins in Category: $5M annual contract value
Total Market in Category: $100M (from public procurement data)

Your Market Share: 5%

Trend tracking:

2022: 3% market share
2023: 4% market share
2024: 5% market share

Trend: Growing market share (+67% over 2 years)

Strategic implications:

• Growing share indicates increasing competitiveness
• Declining share suggests losing ground to competitors
• Stable low share may indicate niche positioning

Head-to-Head Performance

Your win rate against specific competitors (covered in Competitor Profiles) provides the most actionable benchmarks:

Against key competitors:

vs. TechCorp Inc: 67% win rate (you dominate)
vs. SecureNet Solutions: 30% win rate (they dominate)
vs. Global IT: 50% win rate (evenly matched)

These specific head-to-head benchmarks directly inform bid/no-bid decisions when you know who you're competing against.

Bid/No-Bid Decision Quality

Analytics can assess the quality of your bid/no-bid decisions:

No-Bid Rate

What percentage of evaluated opportunities do you choose NOT to bid?

Calculation:

No-Bid Rate = (No-Bid Decisions) / (All Evaluations) × 100%

Interpreting no-bid rate:

Very low (<20%):

• You're bidding almost everything you evaluate
• Risk: Poor bid discipline, wasting resources on unsuitable opportunities
• Likely result: Low win rate (bidding too broadly)

Moderate (30-50%):

• Thoughtful bid discipline
• You're selective but not overly cautious
• Likely result: Healthier win rate

Very high (>70%):

• Extremely selective
• Risk: Insufficient pipeline, missed opportunities
• Possible causes: Overly strict criteria, capability gaps, or very challenging market

Example:

2023 No-Bid Rate: 25%
2024 No-Bid Rate: 40%

Change: More selective (60% increase in no-bid rate)

Potential causes:
- Improved bid discipline (positive)
- Market becoming more competitive (challenging)
- Capability gaps limiting suitable opportunities (concerning)

Action: Investigate why no-bid rate increased and whether it's strategic or problematic

Win Rate of Bid Decisions

Of the opportunities you chose to bid, what's your win rate?

This is your standard win rate, but viewed through the lens of decision quality:

High win rate (>50%):

• Good bid selection
• You're accurately identifying winnable opportunities
• Efficient resource use (not wasting effort on likely losses)

Low win rate (<25%):

• Poor bid selection
• You're overestimating your competitiveness
• Wasting resources on unwinnable opportunities

Improving win rate:

• If win rate is increasing → Decision-making is improving
• If win rate is decreasing → Reevaluate bid/no-bid criteria

Post-Outcome Analysis

Looking back at no-bid decisions, did you make the right call?

Example analysis:

No-Bid Opportunities (50 total):

Outcomes of opportunities you didn't bid:
- Winner bid $800K avg (25% below your estimated bid) → Good no-bid (not price competitive)
- Winner was formidable competitor you rarely beat → Good no-bid (low win probability)
- Winner was weaker competitor you usually beat → Bad no-bid (missed opportunity)
- 10 opportunities fit your capabilities perfectly → Investigate why you didn't bid

Learning from no-bid decisions:

• If you frequently don't bid on opportunities won by weaker competitors → Too conservative
• If you frequently don't bid on opportunities with very competitive pricing → Correct discipline
• If you frequently don't bid on opportunities your capabilities match → Possible pipeline problem

Custom Analytics and Reporting

Beyond standard dashboards, create custom views for specific strategic questions:

Custom Filters

Analyze specific subsets of your bid records:

Examples:

• "All IT Security bids to Transport Canada in last 2 years"
• "Bids >$1M where SecureNet Solutions competed"
• "Professional services bids led by Team Lead Jane Doe"
• "Opportunities evaluated but not bid in Q4 2024"

Use cases:

• Assess specific market segment performance
• Evaluate team member effectiveness
• Research competitor patterns in a niche
• Understand why certain opportunities aren't pursued

Cohort Analysis

Track groups of opportunities over time:

Example cohort:

"All bids submitted in Q1 2024"

Week 1: 12 bids submitted
Week 4: 3 outcomes (2 wins, 1 loss) → 67% win rate so far
Week 8: 8 outcomes (5 wins, 3 losses) → 63% win rate
Week 12: All 12 outcomes (7 wins, 5 losses) → 58% final win rate

Insights:

• How long does it typically take for your cohort to have all outcomes?
• Does early win rate predict final cohort performance?
• Are certain quarters or time periods stronger/weaker?

Correlation Analysis

Identify factors that correlate with wins:

Examples:

• Do opportunities with longer bid prep time have higher win rates?
• Do larger teams improve win probability?
• Does opportunity source (Tenders vs. Direct Outreach) affect outcomes?
• Do bids submitted earlier (days before deadline) win more often?

Sample finding:

ANALYSIS: Team size vs. Win Rate

1-2 team members: 30% win rate
3-4 team members: 42% win rate
5+ team members: 35% win rate

INTERPRETATION: Optimal team size is 3-4 people. Solo or duo bids underperform (insufficient resources). Large teams (5+) also underperform (coordination challenges or overkill).

ACTION: Target 3-4 person teams for optimal win rate

Exporting and Sharing Analytics

Dashboards for Different Audiences

Create audience-specific views:

Executive Dashboard:

• Overall win rate and trend
• Total pipeline value (weighted)
• Won revenue vs. target
• Top 3 insights or alerts

Capture Manager Dashboard:

• Pipeline by stage (evaluating, bidding, submitted)
• Win rate by category and opportunity size
• Competitor analysis for active opportunities
• Time-to-decision metrics

Proposal Manager Dashboard:

• Active bids in preparation
• Bid preparation time trends
• Win rate by team composition
• Resource allocation (who's working on what)

Leadership Dashboard:

• Market share trends
• Competitive positioning (win rates vs. key competitors)
• Strategic opportunity analysis (growth categories, capability gaps)
• Long-term performance trends (3-5 years)

Exporting Data

Export analytics for presentations, reports, or external analysis:

Export formats:

• PDF: Full dashboard snapshots for presentations
• Excel/CSV: Raw data for custom analysis
• PowerPoint: Chart images for executive briefings
• Images (PNG/SVG): Individual charts for reports

Common exports:

• Quarterly performance reports for leadership
• Annual strategic reviews with multi-year trends
• Competitive analysis reports for capture planning
• Market opportunity assessments for business development

Analytics Best Practices

1. Establish Baselines Early

Track metrics consistently from the start:

First 6 months: Establish baselines

• What's your initial win rate?
• What's typical pipeline size?
• How long are evaluation and bid cycles?

Months 6-12: Identify patterns

• Are metrics stable or trending?
• Where is performance strongest/weakest?
• What correlates with success?

12+ months: Drive improvement

• Set data-driven targets based on baselines
• Measure impact of strategic changes
• Benchmark against past performance

2. Review Analytics Regularly

Make analytics review a routine practice:

Weekly: Quick scan

• Pipeline value and active opportunities
• Any new wins or losses to record
• Urgent alerts or anomalies

Monthly: Operational review

• Win rate for the month
• Pipeline health check
• Time-to-decision metrics

Quarterly: Strategic review

• Win rate trends (is performance improving?)
• Category and competitor analysis
• Bid discipline assessment (no-bid rate, decision quality)

Annually: Comprehensive assessment

• Full-year performance vs. targets
• Multi-year trends
• Strategic adjustments for next year

3. Act on Insights

Analytics should drive action, not just satisfy curiosity:

Example insight-to-action workflow:

Insight: "Our win rate in Cloud Services has declined from 45% to 25% over the last year."

Analysis:

• Review losses in that category
• Check competitor profiles (who's winning now?)
• Assess capability changes (did we lose key staff? Did competitors improve?)

Action:

• Investigate specific losses for root causes
• Conduct competitor research to understand their advantage
• Decide: Invest in capability improvement, team with stronger partner, or exit category

Measure:

• Track Cloud Services win rate next 2 quarters
• Assess if actions improved competitiveness

4. Combine Quantitative and Qualitative

Numbers tell you WHAT is happening. Notes and context tell you WHY.

Quantitative: "Win rate dropped from 40% to 25%"

Qualitative (from bid record notes): "Lost last 3 bids to SecureNet Solutions. Their debrief feedback emphasized our lack of recent past performance in the specific sub-category."

Combined insight: "Win rate decline driven by specific competitor with recent past performance advantage. Our references are aging out."

Action: "Pursue smaller opportunities to build recent past performance, or team with partner who has current references."

Analytics dashboards provide the metrics. Detailed bid records provide the context. Both are necessary for strategic decisions.

5. Segment Before Aggregating

Overall win rate can hide important category or segment-specific patterns:

Aggregated view:

Overall Win Rate: 35% (stable)

Looks fine. But segmented:

IT Security: 60% win rate (up from 50% last year) → STRENGTH GROWING
Cloud Services: 25% win rate (down from 45%) → WEAKNESS DEVELOPING
Professional Services: 35% win rate (stable)

Reality: Your overall win rate is stable because a growing strength (IT Security) is masking a developing weakness (Cloud Services). Aggregated metrics miss this critical insight.

Always segment by:

• Category or service line
• Opportunity size
• Department or client
• Time period

6. Set Realistic Targets

Use your baseline data to set achievable improvement targets:

Example target-setting:

Baseline (Year 1): 30% win rate

Ambitious but unrealistic: "Achieve 60% win rate next year" (doubling win rate in one year is nearly impossible without major market changes)

Realistic: "Improve to 35% win rate next year" (17% improvement is meaningful but achievable)

Specific: "Improve IT Security win rate from 55% to 60%, maintain Professional Services at 35%, improve Cloud Services from 25% to 30%"

Specific, segment-level targets are more actionable than overall targets.

7. Share Intelligence Across Your Team

Analytics are most valuable when they inform your entire organization:

Proposal teams: Share win rate by category so they know which bids are strategically important

Capture managers: Provide competitor analysis so they know who to expect and how to differentiate

Business development: Share sweet spot analysis (where you win most) so they pursue optimal opportunities

Leadership: Report on strategic trends so they can allocate resources and set priorities

Everyone: Celebrate wins and conduct honest loss analysis together, using analytics to identify patterns

Frequently Asked Questions

Next Steps