Dashboard
⟳ Connecting…
JM
Total Prospects
Hazmat carriers
High Priority
Ready for outreach
Contacted
In active outreach
Est. Pipeline Value
$0
0 dashboard prospects · monthly estimate
Dashboard Prospects
#CompanyHazmat DriversFitPriorityEst. Monthly ValueStatus
Upcoming Follow-ups
Loading tasks…
Priority Mix
Total
High —
Medium —
Low —
Unknown —
Pipeline Stages
#CompanyLocationModeFleetFitPriorityInstagramStatusHazmat
High Priority
Medium Priority
Size = prospect count
Scroll to zoom · Click clusters to open prospects
Prospect Clusters by Region
Prospects
??
Loading…
Loading contacts…
Loading activities…
Outreach Rate
0%
Loading…
Active Contacts
In the system
Activities Logged
Won Deals
0
$0 revenue
Prospects by Transport Mode
Pipeline Stage Distribution
Summary Report

A single roll-up CSV: totals, prospects by status / priority / fit / mode / carrier type, hazmat-permit counts, pipeline by stage, and activities by type. Opens straight into Excel.

Prospects

Every prospect column, with human-readable headers that re-import cleanly through Import Data.

Contacts

All contacts joined to their company, with importer-compatible headers.

Activities

Full activity log with company and contact names, outcomes, and due / completed dates.

Opportunities

Pipeline export: stage, estimated value, probability, and expected close date.

Upload MMT_CRM_Master_Prospects.xlsx
Inserts new companies and updates existing ones by name — no duplicates. Supports .xlsx and .csv up to 15MB.
Upload File
Drop your file here
or click to browse — .xlsx or .csv
Import History
Loading history…
FMCSA SAFER System Integration
Connects to the free federal FMCSA database. No API key required for basic lookups — add FMCSA_API_KEY to your Render env vars for faster results.
Missing HQ Location
Need city / state
Missing DOT #
No DOT number yet
Missing Fleet Count
No official truck count
Needs Enrichment
of total prospects
Bulk Enrichment
⚡ Enrich Records with Missing Data
Runs through all prospects that are still missing DOT#, city/state, fleet count, or MC number. Fastest option — skips companies already complete.
🔄 Re-verify ALL Prospects
Runs through every prospect in your database — all records — and fills in any field that's still empty. Takes longer but ensures nothing is missed.
⚡ Speed Up with a Free API Key

Without an API key, enrichment scrapes the FMCSA SAFER website (1.2 sec/company, ~2 min for 111 records). With a free key it uses the JSON API — 3x faster and more reliable.

  1. Go to ai.fmcsa.dot.gov/Carrier
  2. Register for a free web key (instant)
  3. In Render → your service → Environment → add:
    FMCSA_API_KEY=your_key_here
  4. Redeploy — enrichment will automatically use the faster API
Enrich Individual Prospects

Click Enrich on any row to look up that company in FMCSA right now.

Company HQ DOT # Trucks
Loading…