MAHMOUD ABDELNABY
Cro · CLI SCRIPT · 2

B2B Sales Lead Velocity & Funnel Bottleneck Diagnostic CLI

Identify exact sales pipeline bottlenecks and audit lead response time latency from your CRM exports in seconds.

Problem it addresses

Build an open-source pipeline velocity diagnostic tool in Python (lead_velocity_analyzer.py): 1) Parses CRM lead exports with timestamps (Created, First Contact, Qualified, Won/Lost), 2) Calculates median time-to-first-contact and stage transition velocity, 3) Flags stalled leads exceeding SLA thresholds, 4) Generates an interactive visual HTML funnel diagram with bottleneck callouts.

Who it is for

PRO operating in high-growth e-commerce, digital publishing, and direct-response marketing across Saudi Arabia, UAE, and Egypt.

What is inside

Key files listed in the README repository architecture:

  • examples/hubspot_salesforce_leads.csv
  • examples/sample_crm_leads.csv
  • LICENSE
  • README.md
  • reports/funnel_velocity_dashboard.html
  • reports/funnel_velocity_preview.html
  • src/lead_velocity_analyzer.py
  • src/lead_velocity_calculator.py
  • templates/speed-to-lead-sla.md
  • tests/test_analyzer.py
  • tests/test_velocity.py

How to evaluate and use it

  1. Read the README first and confirm that the documented problem matches your use case.
  2. Inspect the listed files to find the data, tools, templates, and tests relevant to your task.
  3. Follow the repository’s Quick Start and check prerequisites before running commands.
  4. Compare outputs with documented examples and review limitations before using them in a decision or client workflow.

Quick Start from the README: python -m unittest discover -s tests · python src/lead_velocity_analyzer.py --help

Scope and limitations

  • Lead Velocity Rate (LVR) Formula: Measures qualified lead pipeline growth month-over-month as a reliable leading indicator of future closed-won revenue.
  • Sales Stage Conversion Benchmarks: Diagnoses conversion drop-offs between Lead -> MQL -> SQL -> Opportunity -> Closed-Won.
  • Sales Cycle Length Accommodation: Accounts for longer B2B purchasing cycles in the Middle East (typically 60-120 days for enterprise software).

This page summarizes the available documentation; it does not establish performance or business results. Verify data and prerequisites before use.

Related repositories