Copy/Paste Prompt — Elite Route Client Lead Research + CSV Output
ROLE:
You are an elite B2B lead-intelligence analyst, energy/fuel/industrial-gas sales researcher, CRM import engineer, and CSV data-quality auditor.

Your task is to build ONE clean, import-ready CSV of high-value END-USER CLIENTS only for Secure Supplies Team.

This is for sales prospecting of:

• Diesel tank rental

• DEF tank rental

• Water tank rental

• Temporary fuel storage

• Bulk diesel / DEF supply

• LNG / CNG supply or support

• Oxygen / nitrogen / CO2 / helium supply

• Industrial gas usage

• Backup power / generator fuel support

• Fleet fueling support

• Construction / industrial / municipal / logistics / utility liquid storage demand

CRITICAL BUSINESS RULE:
We sell to clients who BUY, CONSUME, USE, STORE, RENT, or NEED tanks/fuel/gases.
We do NOT want suppliers, sellers, tank rental companies, tank manufacturers, fuel distributors, fuel resellers, terminals, refineries, monitoring vendors, telemetry vendors, equipment sellers, or companies whose main business is selling the same products/services to others.

OUTPUT REQUIREMENT:
Produce exactly ONE final CSV file.
Do NOT split into multiple files.
Do NOT create separate supplier files, review files, enrichment files, or placeholder files.
Final output file name:
secure_supplies_elite_route_client_leads.csv

Upload/create a downloadable CSV if tools allow. Otherwise output the CSV in a single code block.

PRIMARY OBJECTIVE:
Research, enrich, parse, validate, score, and output the highest-quality client-side prospects on these routes only:

Route 164
Route 144
Route 124
Route 104
Route 84
Route 165
Route 145
Route 125
Route 105
Route 85

ROUTE REFERENCE RULE:
Use my uploaded route index as the authority.
Do not invent route descriptions.
If a route number exists in my CSV or route index, replace the route number with the full route description from the route index.

Known route descriptions:
Route 104 = 104 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield
Route 105 = 105 CA — Stockton, Fresno, Bakersfield
Route 124 = 124 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield
Route 125 = 125 CA — Stockton, Fresno, Bakersfield

For Route 84, Route 85, Route 144, Route 145, Route 164, and Route 165:
Use the uploaded route index only.
If the route index does not include a full route description, keep the route number and write:
[ROUTE DESCRIPTION MISSING FROM USER INDEX]
in the audit/notes field.
Do not guess.

MANDATORY GEOGRAPHY RULE:
Every accepted lead must have:

• Route

• City

• State

• ZIP

• Address or service/site location

• Country = USA unless verified otherwise

If city/state/ZIP/route cannot be verified, reject the row from the final CSV.

TARGET CLIENT PROFILE:
Find high-cash, high-usage, sales-worthy buyers only.

Prioritize:

1. Trucking fleets, regional carriers, reefer fleets, drayage fleets, bulk/tanker fleets, heavy-haul fleets, logistics depots

2. Municipal fleets, county public works, city fleet services, transit agencies, school bus operators

3. Waste haulers, refuse fleets, recycling fleets, transfer stations, street sweeping fleets

4. Construction contractors, heavy civil contractors, paving/asphalt, excavation, demolition, crane/rigging, concrete/ready-mix, highway/bridge contractors

5. Data centers, telecom hubs, hospitals, campuses, critical infrastructure with backup generator fuel demand

6. Food processing, cold storage, beverage, dairy, meat, wineries, breweries, industrial manufacturing

7. Utilities, water treatment, wastewater treatment, pumping stations, power plants, microgrids, backup-power sites

8. Airports, FBOs only if they are end-use operators, airport authorities, ground support equipment fleets, aviation maintenance campuses

9. Ports, marine terminals, shipyards, dredging operators, tug/barge fleets, ferries, marine construction

10. Agriculture, large dairies, feedlots, greenhouses, ag co-ops, grain elevators, crop drying, irrigation operations

11. Hospitals, medical centers, labs, universities, research institutions with oxygen/nitrogen/helium/backup-power demand

12. Manufacturing plants with oxygen, nitrogen, CO2, helium, propane, diesel, LNG/CNG, process gas, or bulk liquid needs

EXCLUDE / REJECT:
Reject any company if its primary role is:

• Fuel distributor

• Fuel wholesaler

• Jobber

• Gas station

• Travel center

• Truck stop unless the buyer is a fleet operator and the station is not the lead

• Cardlock/fleet fueling seller

• Mobile refueling seller

• Bulk fuel terminal

• Petroleum marketer

• Fuel reseller

• Propane distributor

• LNG distributor

• CNG station operator selling fuel to others

• Hydrogen refueling seller

• DEF distributor/reseller

• Heating oil dealer

• Kerosene dealer

• Lubricant distributor

• Diesel generator fuel supplier

• Industrial gas distributor

• Welding gas supplier

• Medical oxygen supplier/vendor

• CO2 supplier/vendor

• Specialty gas seller

• Tank rental company

• Tank manufacturer

• Monitoring/telemetry/control vendor

• Pump/dispenser seller

• Refinery

• Pipeline operator

• LNG liquefaction/regas terminal

• Storage terminal/tank farm operator unless it is clearly an internal end-use facility

• Oilfield services seller unless the specific site is a heavy end-use operation needing tanks/fuel/gas

• Broker, consultant, marketing firm, directory listing, holding company with no operating site

Important distinction:
Equipment rental yards CAN be clients if they operate heavy equipment and need diesel/DEF/fuel tanks.
Tank rental companies are NOT clients.
Fuel suppliers are NOT clients.
Industrial gas suppliers are NOT clients.
Construction companies, fleets, factories, hospitals, campuses, wastewater plants, and utilities ARE clients.

RESEARCH SOURCE HIERARCHY:
Use public, verifiable sources in this order:

Tier 1 — Highest trust:

• Official company website

• Official contact page

• Official locations page

• Official procurement page

• Official city/county/agency website

• Official airport/port/utility/hospital/campus website

• Public bid documents or procurement documents

• Official annual report / investor presentation / facility page

• Official safety/compliance/public records

Tier 2 — Government and regulated data:

• FMCSA SAFER Company Snapshot

• CARB fleet compliance / fleet lookup where applicable

• EPA Facility Registry Service

• EIA-860 / EIA power plant records

• California Energy Commission power plant data

• FAA airport data / FAA ADIP

• California Secretary of State business search

• SAM.gov entity information

• County assessor / city business license / public procurement records if available

Tier 3 — Secondary validation only:

• Google Business Profile / maps listing

• Bing business result

• Industry association directories

• Chamber of commerce pages

• Trade association member pages

• Public LinkedIn company page for company identity and role verification only

• News releases and industry publications

• Public conference exhibitor/speaker pages

Do not use random lead databases as primary sources.
Do not use unverifiable scraped data.
Do not use guessed emails.
Do not use placeholder contact names.
Do not output “Facility Contact,” “Unknown,” “N/A,” “TBD,” or fake contacts.

EMAIL RULES:
Only include email if verified from a public source.

Acceptable emails:

• Direct business email published on official company/agency site

• Procurement/purchasing email from official source

• Fleet/facilities/public works/operations email from official source

• Contact email from public bid/RFP/procurement document

• Department email from official government/campus/hospital/company page

• Publicly posted business email from credible industry source

Do NOT:

• Guess email patterns

• Generate firstname.lastname@domain.com unless the exact email is publicly verified

• Use personal emails from non-business sources

• Use leaked, scraped, or private data

• Use placeholder emails

• Use only a contact form as an email

If no public email is found:
Leave Email blank.
But only include the row if the lead is otherwise very high-value, has verified website + phone + route + address + source URLs, and the final file still meets the email hit-ratio target.

EMAIL HIT-RATIO TARGET:
The final CSV should target:

• Website coverage: 95%+

• Phone coverage: 85%+

• Email coverage: 80%+

• City/State/ZIP/Route coverage: 100%

• Supplier exclusion confidence: 95%+

• End-user buyer confidence: 85%+

If you cannot hit 80% verified public email coverage, do NOT invent emails.
Instead:

1. Keep researching.

2. Reduce weak rows.

3. Prefer records with real verified emails.

4. Report the actual email hit ratio in the summary.

5. Do not claim the file is 10/10 if the verified email rate is below 80%.

PHONE/FAX RULES:
Normalize phone and fax to:
(###) ###-####

Use public business phone/fax only.
Prefer official website, public agency page, procurement docs, FMCSA, CARB, SOS, or credible public records.
Leave blank if not verified.
Do not invent.

WEBSITE RULES:
Website must be the official domain or official agency/department page.
Do not use directory pages as the Website field if an official website exists.
For government leads, use the specific department page if available, otherwise the official city/county/agency page.
For campuses/hospitals/utilities, use the official facility, procurement, operations, or main website.

CONTACT NAME RULES:
Use a real person only if publicly verified.
Preferred titles:

• Fleet Manager

• Fleet Services Manager

• Public Works Director

• Operations Manager

• Plant Manager

• Facilities Director

• Maintenance Manager

• Procurement Manager

• Purchasing Manager

• Transportation Director

• Utilities Director

• General Services Manager

• Airport Operations Manager

• Port Operations Manager

• Director of Engineering

• Director of Facilities

• Energy Manager

• Environmental Services Manager

If no real named contact is public:
Leave Contact Name blank.
Do not use placeholders.

PRODUCT ASSIGNMENT RULES:
Assign the product based on verified usage signals.

Possible Product values:

• Diesel Tank Rental

• DEF Tank Rental

• Diesel + DEF Tank Rental

• Water Tank Rental

• Temporary Fuel Storage

• Bulk Diesel Supply

• Bulk DEF Supply

• LNG / CNG Fuel Support

• Oxygen Supply

• Nitrogen Supply

• CO2 Supply

• Helium Supply

• Industrial Gas Supply

• Backup Generator Fuel Support

• Construction Fuel + Water Tank Support

• Fleet Fueling Support

• Multi-Product Industrial Supply

Do not assign monitoring as the product.
Do not target tank monitoring suppliers.
Monitoring can be a secondary note only if relevant to customer operations.

PRODUCT USE RULES:
Product Use must explain WHY they are a buyer.
Examples:

• Heavy diesel fleet / DEF consumption

• Transit CNG fleet

• Refuse fleet fuel and DEF demand

• Construction jobsite diesel and water storage

• Backup generator diesel demand

• Hospital oxygen and backup power

• Food processing nitrogen / CO2 / backup fuel demand

• Cold storage backup power and reefer fleet fuel

• Wastewater plant backup power and chemical/liquid storage

• Airport GSE fleet / backup fuel / aviation support

• Manufacturing process gas and bulk liquid needs

QUALITY SCORING:
Score each lead 0–100.

Formula:

• Route Fit: 0–20

• End-User Buyer Fit: 0–20

• Usage Intensity: 0–20

• Product Fit: 0–15

• Contact Completeness: 0–15

• Company / Facility Scale: 0–10

• Supplier Risk Penalty: subtract 0–40

Quality labels:
95–100 = Elite A+
90–94 = Elite A
85–89 = Strong B+
80–84 = Qualified B
Below 80 = Reject from final CSV

Only include rows with Quality >= 80.
If a row has supplier risk above 20, reject it.
If a row has no route match, reject it.
If a row has no verified website, reject it unless it is a government/public facility with official agency page.

RESEARCH PROCESS:
Step 1:
Parse all uploaded files. Identify columns even if headers differ:

• Co Name / Company / Account / Facility Name → Company Name

• Tel / Telephone / Main Phone → Phone

• URL / Domain / Web → Website

• Route / Route ID / Territory → Routes

• Product / Product Need / Use Case → Product

• Industry / Sector / Category → Industry

• Street / Address Line 1 → Address

• Zip / Postal Code → Zip

• State / Province → State

• Fax / Facsimile → Fax

• Email / E-mail → Email

Step 2:
Build the authoritative route table from the uploaded route index and the route reference in this prompt.

Step 3:
Use the seed CSV as a starting point only.
Do not trust old supplier/client classifications.
Reclassify every company from scratch.

Step 4:
Deep-search for additional high-value client prospects along the routes.
Do not stop at the old record count.
Do not cap at 183.
Target as many verified high-quality clients as public data supports.
Quality is more important than volume, but continue researching until the route territory is commercially covered.

Step 5:
For each route, search by city/ZIP/county plus high-value ICP terms.

Use search patterns like:

• "[city] fleet services procurement diesel DEF"

• "[city] public works fleet fuel tanks"

• "[city] trucking fleet diesel DEF"

• "[city] cold storage fleet diesel backup generator"

• "[city] food processing nitrogen CO2 facility"

• "[city] wastewater treatment backup generator"

• "[city] hospital oxygen procurement facilities"

• "[city] construction company fleet diesel tanks"

• "[city] heavy civil contractor diesel tank rental"

• "[city] refuse fleet CNG diesel DEF"

• "[city] school district transportation fleet diesel DEF"

• "[city] transit agency CNG fleet"

• "[city] data center backup generator diesel"

• "[city] manufacturing plant nitrogen oxygen"

• "[city] dairy processing nitrogen CO2"

• "[city] warehouse distribution fleet diesel DEF"

• "[city] airport operations fleet fuel"

• "[company name] contact fleet manager"

• "[company name] procurement email"

• "[company name] facilities director email"

• "[company name] public works director email"

• "[company name] FMCSA SAFER"

• "[company name] CARB fleet compliance"

• "[facility name] EPA FRS"

• "[plant name] EIA 860"

• "[facility name] California Energy Commission power plant"

Step 6:
Validate each candidate with at least 2 source signals where possible:

• Official website/contact page

• Public record or government database

• Public procurement/RFP/bid document

• Regulatory/fleet/facility record

• Industry association or credible trade source

Step 7:
Remove suppliers aggressively.
If there is any doubt that the company is a seller/reseller/vendor rather than an end-user buyer, reject it.

Step 8:
Normalize all output fields.
Deduplicate by:
Normalized Company Name + Address + ZIP + Route

Same parent company may appear multiple times only if:

• different operating site

• different city/ZIP

• different route

• separate verified facility demand

CSV OUTPUT COLUMNS:
Output these columns in this exact order.

000 Industries
001 Company Name
002 Contact Name
003 Product
004 Routes
005 Last Price ($)
Email
Phone
Fax
Website
Product Use
Industry
Quality
Address
City
Zip
State
Country
Route ID
Route Match Basis
Buyer Type
End-User Evidence
Supplier Exclusion Check
Source URLs
Email Source URL
Phone Source URL
Website Source URL
Last Verified Date
Data Completeness Score
Lead Score
Notes

FIELD DEFINITIONS:
000 Industries:
Use the broad industry bucket, such as:
Trucking, Logistics & Fleet
Municipal / Public Works
Construction & Infrastructure
Waste & Environmental
Manufacturing & Industrial
Food & Beverage Processing
Cold Storage & Distribution
Healthcare & Medical
Education / Campus
Utilities / Power / Water
Airport / Aviation
Port / Marine
Agriculture / Agribusiness
Data Center / Telecom
Mining / Quarry
Hospitality / Stadium / Large Campus

001 Company Name:
Use the real operating entity or facility name.
Do not use supplier/operator prefix unless that supplier is the actual end-user client.

002 Contact Name:
Use real public person or department only.
Leave blank if not verified.

003 Product:
Use one or more product values separated by semicolon.

004 Routes:
Use full route description, not just route number.
Example:
104 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield

005 Last Price ($):
Only populate if a real price, bid, award, contract price, or user-provided price exists.
Do not estimate.
Leave blank if unknown.

Email:
Verified public business email only.

Phone:
Verified public phone only.

Fax:
Verified public fax only.

Website:
Official website or official department/facility page.

Product Use:
Commercial reason they are a likely buyer.

Industry:
More specific sub-industry.

Quality:
Use label plus score.
Example:
Elite A+ / 96

Address:
Street/site address.

City:
City.

Zip:
ZIP code.

State:
Two-letter state abbreviation.

Country:
Default to USA if blank.

Route ID:
Route 104, Route 105, etc.

Route Match Basis:
City match, ZIP match, address match, route index match, or user-seed match.

Buyer Type:
End-user fleet, municipal fleet, plant/facility, campus, utility, hospital, construction operator, logistics fleet, etc.

End-User Evidence:
Short proof phrase.
Example:
"Operates refuse fleet; CARB fleet record; official fleet services page"

Supplier Exclusion Check:
Write:
"Pass — end-user buyer, not supplier"
or reject from final if not pass.

Source URLs:
List all source URLs separated by " | ".

Email Source URL:
URL where email was found.

Phone Source URL:
URL where phone was found.

Website Source URL:
URL verifying official website.

Last Verified Date:
Use today’s date.

Data Completeness Score:
0–100 based on website, phone, email, fax, contact, address, route, source proof.

Lead Score:
0–100 commercial buyer score.

Notes:
Only short factual notes. No placeholders.

CSV RULES:

• Header row required.

• Comma-separated CSV.

• Quote fields containing commas.

• UTF-8.

• No markdown inside CSV.

• No fake data.

• No placeholder values.

• Blank cells are allowed only when the field is genuinely unavailable and the row still passes quality threshold.

• Do not include rejected suppliers in the CSV.

• Do not include weak leads below 80 quality.

• Do not include rows missing route/city/state/ZIP.

• Do not include rows with no verified website unless official government/public agency page verifies the lead.

FINAL SUMMARY REQUIRED AFTER CSV:
After creating the CSV, give a concise QA summary:

1. Total accepted client leads

2. Unique companies

3. Route counts by route

4. Industry counts

5. Website coverage count and %

6. Phone coverage count and %

7. Fax coverage count and %

8. Email coverage count and %

9. Named contact coverage count and %

10. Supplier rejects count

11. Duplicate rejects count

12. Records rejected for missing route/geography

13. Average lead score

14. Top 20 highest-value prospects

15. Any unresolved route descriptions

16. Honest final quality rating from 1–10

QUALITY CONTROL COMMAND:
Before final output, self-audit the CSV:

• Remove suppliers

• Remove tank rental companies

• Remove fuel distributors/resellers

• Remove monitoring vendors

• Remove placeholder contacts

• Remove guessed emails

• Remove records without route/city/state/ZIP

• Verify websites are official

• Verify phone/email/fax sources

• Confirm all accepted rows are end-user buyers

• Confirm every row has Product Use and Lead Score

• Confirm no route outside 84, 85, 104, 105, 124, 125, 144, 145, 164, 165

Do not call the output elite unless:

• 95%+ websites verified

• 85%+ phones verified

• 80%+ emails verified or official contact/procurement page coverage is explicitly reported

• 100% city/state/ZIP/route coverage

• all suppliers removed

• all rows are Quality >= 80

If public data cannot support those standards, say exactly what coverage was achieved and do not pad the file.
Use this with these exact attachments
Upload:

Route index CSV
This must contain the full descriptions for Route 84, 85, 144, 145, 164, and 165.

Any seed CSV
Your old 2,000-company file or the 183-client file can be used only as a starting point.

Optional: industry/product picklist CSV
Useful if you want Zoho dropdowns to match exactly.

One correction I made to your field map
You asked for state, city, ZIP, and route for every contact, but your target field list did not include City. I added it:

Address
City
Zip
State
Country
That is mandatory for route sales execution. Without city, your sales team cannot assign territory cleanly.

The key upgrade
The prompt forces the model to behave like this:

No verified website → reject or downgrade
No route/city/ZIP → reject
Supplier risk → reject
Fake email → forbidden
Placeholder contact → forbidden
Weak buyer → reject
High-value end-user + real source proof → accept
That is how you get closer to a real elite client file instead of a bloated directory scrape.

 

Pasted text(132).txt
Document

I’ll tighten this into a run-ready research command with strict supplier rejection, official-source validation, and clear pass/fail standards for one clean CSV.

Thought for 3m 59s
I reviewed the uploaded prompt. The structure is good, but it needs harder enforcement logic so ChatGPT Pro does not produce another weak file with websites only, no emails, and mixed supplier records.

Your uploaded prompt already defines the core mandate correctly: one CSV, end-user clients only, no suppliers/resellers/vendors, route-only coverage, verified public emails only, and no placeholders. It also requires city/state/ZIP/route on every accepted lead.

Below is the stronger elite version I would actually run.

Elite Prompt Upgrade — Use This Version
Copy/paste this into ChatGPT Pro with Web Search + Advanced Data Analysis enabled.

ROLE:
You are an elite B2B lead-intelligence analyst, fuel / DEF / LNG / CNG / industrial-gas market researcher, CRM import engineer, public-records investigator, and CSV data-quality auditor.

MISSION:
Build ONE clean, import-ready CSV of high-value END-USER CLIENTS only for Secure Supplies Team.

This is for sales teams selling:

• Diesel tank rental

• DEF tank rental

• Water tank rental

• Temporary fuel storage

• Bulk diesel supply

• Bulk DEF supply

• LNG / CNG fuel support

• Oxygen supply

• Nitrogen supply

• CO2 supply

• Helium supply

• Industrial gas supply

• Backup generator fuel support

• Construction fuel + water tank support

• Fleet fueling support

• Multi-product industrial supply

ABSOLUTE BUSINESS RULE:
We want BUYERS, USERS, CONSUMERS, STORAGE USERS, FLEETS, FACILITIES, PLANTS, CAMPUSES, MUNICIPAL OPERATIONS, CONTRACTORS, HOSPITALS, UTILITIES, LOGISTICS OPERATORS, FOOD PROCESSORS, WASTEWATER PLANTS, AIRPORTS, PORTS, DATA CENTERS, AND LARGE INDUSTRIAL SITES.

We do NOT want:

• Fuel suppliers

• Fuel distributors

• Fuel wholesalers

• Jobbers

• Gas stations

• Truck stops

• Travel centers

• Fuel terminals

• Petroleum marketers

• Propane distributors

• LNG distributors

• CNG station sellers

• DEF distributors

• Lubricant distributors

• Industrial gas distributors

• Welding gas suppliers

• Medical oxygen suppliers

• CO2 suppliers

• Specialty gas sellers

• Tank rental companies

• Tank manufacturers

• Monitoring / telemetry vendors

• Pump / dispenser sellers

• Refiners

• Terminals

• Broker-only companies

• Directory listings

• Consultants

• Placeholder companies

• Companies mainly selling the same products/services we sell

Important:
Equipment rental companies CAN be buyers if they operate large yards, fleets, construction equipment, generators, or jobsites.
Tank rental companies are NOT buyers.
Fuel suppliers are NOT buyers.
Industrial gas suppliers are NOT buyers.
Construction companies, fleets, factories, hospitals, campuses, wastewater plants, utilities, food processors, and municipal operations ARE buyers.

OUTPUT:
Create exactly ONE final CSV file named:

secure_supplies_elite_route_client_leads.csv

Do NOT split into multiple files.
Do NOT create supplier review files.
Do NOT create enrichment queue files.
Do NOT create placeholder files.
Do NOT output rejected records in the final CSV.

ROUTES:
Only include leads on these routes:

Route 164
Route 144
Route 124
Route 104
Route 84
Route 165
Route 145
Route 125
Route 105
Route 85

ROUTE REFERENCE RULE:
Use the uploaded route index as the route authority.
If the uploaded route index provides a route description, use that exact description.
Do not invent missing route descriptions.

Known route descriptions:
Route 104 = 104 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield
Route 105 = 105 CA — Stockton, Fresno, Bakersfield
Route 124 = 124 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield
Route 125 = 125 CA — Stockton, Fresno, Bakersfield

For Route 84, Route 85, Route 144, Route 145, Route 164, and Route 165:
Use the uploaded route index only.
If the uploaded route index does not contain the full route description, keep the route number and write:
[ROUTE DESCRIPTION MISSING FROM USER INDEX]
in the Notes field.

MANDATORY ACCEPTANCE GATE:
Every accepted lead must have:

• Company Name

• Route ID

• Full route description or route-missing note

• Address

• City

• State

• ZIP

• Country

• Official website or official public-agency page

• Product Use

• Buyer Type

• Industry

• Quality score

• Source URLs

• Supplier Exclusion Check

Reject the row if:

• route is missing

• city/state/ZIP is missing

• company appears to be supplier/vendor/reseller

• website cannot be verified

• source proof is weak

• lead score is below 80

• buyer type is unclear

• company is only a directory listing

• company is only a fueling station record with no buyer evidence

DATA QUALITY TARGETS:
Final CSV should target:

• Website coverage: 95%+

• Phone coverage: 85%+

• Verified public email coverage: 80%+

• City/state/ZIP/route coverage: 100%

• Supplier exclusion confidence: 95%+

• End-user buyer confidence: 85%+

• Quality score: 80+ on every row

If 80% verified public email coverage cannot be achieved:
Do NOT invent emails.
Keep researching.
Reduce weak rows.
Prefer official procurement, public works, fleet, operations, facilities, purchasing, or department emails.
Report the true email coverage percentage.
Do not claim the file is elite if the verified email rate is below 80%.

EMAIL RULES:
Only include emails verified from public sources.

Accepted:

• Official company contact page email

• Official procurement email

• Official purchasing email

• Official public works email

• Official fleet services email

• Official operations/facilities email

• Official city/county/agency department email

• Public bid/RFP/procurement document email

• Publicly posted business email from credible industry or government source

Rejected:

• Guessed email patterns

• Generated firstname.lastname emails

• Personal emails from non-business sources

• Lead-database emails without source proof

• Scraped/private/leaked emails

• Contact forms without an actual email address

• Placeholder emails

If no verified email exists:
Leave Email blank.
But only include the lead if it is otherwise high-value and the final CSV still meets the required hit-rate targets.

PHONE/FAX RULES:
Use verified public business phone/fax only.
Normalize format:
(###) ###-####

Preferred phone/fax sources:

• Official website

• Official contact page

• Official government/agency page

• Procurement page

• Public bid document

• FMCSA SAFER

• CARB fleet record

• EPA facility record

• Official licensing / public business record

Do not invent.
Do not use unverified aggregator phone numbers unless cross-validated.

WEBSITE RULES:
Website must be:

• Official company domain

• Official agency page

• Official facility page

• Official department page

• Official procurement page

Do not use:

• Yelp

• YellowPages

• random directories

• generic Google result URL

• Map listing URL as the main website unless no official website exists and the source is only used as secondary validation

CONTACT NAME RULES:
Use a real person only if publicly verified.

Preferred titles:

• Fleet Manager

• Fleet Services Manager

• Public Works Director

• Operations Manager

• Plant Manager

• Facilities Director

• Maintenance Manager

• Procurement Manager

• Purchasing Manager

• Transportation Director

• Utilities Director

• General Services Manager

• Airport Operations Manager

• Port Operations Manager

• Director of Engineering

• Director of Facilities

• Energy Manager

• Environmental Services Manager

If no real contact is found:
Leave Contact Name blank.
Do NOT use:

• Facility Contact

• Unknown

• TBD

• N/A

• Manager

• Owner

• fake names

• AI-generated names

SOURCE HIERARCHY:
Use public, verifiable sources.

Tier 1 — highest trust:

• Official company website

• Official company contact page

• Official locations page

• Official procurement page

• Official city/county/agency website

• Official hospital/campus/airport/port/utility website

• Public bid/RFP/procurement documents

• Official annual report

• Official facility page

• Official safety/compliance record

Tier 2 — regulated/public datasets:

• FMCSA SAFER Company Snapshot

• CARB Truck and Bus / Advanced Clean Fleets / fleet compliance records

• EPA Facility Registry Service

• EIA-860 power plant data

• California Energy Commission power plant data

• FAA Airport Data and Information Portal

• California Secretary of State

• SAM.gov

• county assessor records

• city business license records

• public procurement portals

Tier 3 — secondary validation only:

• Google Business Profile

• Bing business result

• industry association directories

• chamber of commerce pages

• trade association pages

• credible news releases

• industry publications

• public LinkedIn company page for identity verification only

Do not use random lead databases as primary proof.

AUTHORITATIVE DATA SOURCE NOTES:
Use FMCSA SAFER to validate trucking and carrier entities.
Use CARB fleet lookup/compliance records to validate California fleets where applicable.
Use EPA FRS to validate regulated facilities by company name, address, city, county, ZIP, registry ID, or industry classification.
Use EIA-860 to validate power-generation sites and large generator facilities.
Use FAA ADIP to validate airport and aviation facility data.
Use official government or company sources for emails, phone numbers, and procurement contacts.

RESEARCH PROCESS:
Step 1:
Parse all uploaded files.
Match similar source columns to target fields:

• Co Name / Company / Account / Facility / Facility Name → Company Name

• Tel / Telephone / Main Phone / Contact Phone → Phone

• URL / Domain / Web / Website → Website

• Route / Route ID / Territory → Route ID

• Product / Product Need / Use Case → Product

• Industry / Sector / Category → Industry

• Street / Address / Address Line 1 → Address

• City / Municipality → City

• Zip / Postal Code → Zip

• State / Province → State

• Fax / Facsimile → Fax

• Email / E-mail → Email

Step 2:
Build the route table from the uploaded route index.
Only use routes:
84, 85, 104, 105, 124, 125, 144, 145, 164, 165.

Step 3:
Use any seed CSV only as a starting point.
Do not trust old supplier/client labels.
Reclassify every company from scratch.

Step 4:
Research beyond the seed CSV.
Do not stop at the old number of records.
Do not cap at 183.
Find additional high-value client prospects on these routes only.

Step 5:
For every target city/ZIP on each route, search high-value buyer categories.

Use search patterns:

• "[city] fleet services procurement diesel DEF"

• "[city] public works fleet fuel tanks"

• "[city] trucking fleet diesel DEF"

• "[city] refrigerated trucking diesel DEF"

• "[city] cold storage backup generator diesel"

• "[city] food processing nitrogen CO2 facility"

• "[city] wastewater treatment backup generator"

• "[city] hospital facilities oxygen procurement"

• "[city] construction company fleet diesel tank rental"

• "[city] heavy civil contractor diesel tanks"

• "[city] refuse fleet CNG diesel DEF"

• "[city] school district transportation fleet diesel DEF"

• "[city] transit agency CNG fleet"

• "[city] data center backup generator diesel"

• "[city] manufacturing plant nitrogen oxygen"

• "[city] dairy processing nitrogen CO2"

• "[city] warehouse distribution fleet diesel DEF"

• "[city] airport operations fleet fuel"

• "[city] utility fleet services diesel"

• "[city] water treatment plant backup generator"

• "[city] quarry mining haul fleet diesel"

• "[city] concrete ready mix fleet diesel DEF"

• "[city] paving contractor diesel tanks"

• "[company] procurement email"

• "[company] fleet manager email"

• "[company] facilities director email"

• "[company] public works director email"

• "[company] FMCSA SAFER"

• "[company] CARB fleet"

• "[facility] EPA FRS"

• "[plant] EIA 860"

• "[airport] FAA ADIP"

Step 6:
Validate every accepted lead with at least two source signals where possible:

• official site/contact page

• official location/facility page

• public procurement/RFP/bid record

• regulatory/fleet/facility record

• credible industry association or trade source

Step 7:
Reject suppliers aggressively.
If there is doubt whether the company is a seller/vendor/reseller instead of an end-user buyer, reject it.

Step 8:
Deduplicate by:
Normalized Company Name + Address + ZIP + Route ID.

Same parent company may appear multiple times only if:

• separate operating site

• separate city/ZIP

• separate route

• separate verified buyer use case

PRODUCT ASSIGNMENT:
Assign one or more of these Product values:

• Diesel Tank Rental

• DEF Tank Rental

• Diesel + DEF Tank Rental

• Water Tank Rental

• Temporary Fuel Storage

• Bulk Diesel Supply

• Bulk DEF Supply

• LNG / CNG Fuel Support

• Oxygen Supply

• Nitrogen Supply

• CO2 Supply

• Helium Supply

• Industrial Gas Supply

• Backup Generator Fuel Support

• Construction Fuel + Water Tank Support

• Fleet Fueling Support

• Multi-Product Industrial Supply

Do not assign monitoring as a product.
Do not target monitoring suppliers.

PRODUCT USE:
Explain why the company is a buyer.
Examples:

• Heavy diesel fleet / DEF consumption

• Transit CNG fleet

• Refuse fleet fuel and DEF demand

• Construction jobsite diesel and water storage

• Backup generator diesel demand

• Hospital oxygen and backup power

• Food processing nitrogen / CO2 / backup fuel demand

• Cold storage backup power and reefer fleet fuel

• Wastewater plant backup power and chemical/liquid storage

• Airport GSE fleet / backup fuel demand

• Manufacturing process gas and bulk liquid needs

• Utility fleet and emergency fuel demand

• Quarry / mining haul truck diesel demand

• Agriculture irrigation / crop drying / bulk fuel demand

QUALITY SCORING:
Score each lead 0–100.

Formula:

• Route Fit: 0–20

• End-User Buyer Fit: 0–20

• Usage Intensity: 0–20

• Product Fit: 0–15

• Contact Completeness: 0–15

• Company / Facility Scale: 0–10

• Supplier Risk Penalty: subtract 0–40

Quality labels:
95–100 = Elite A+
90–94 = Elite A
85–89 = Strong B+
80–84 = Qualified B
Below 80 = Reject

Only include Quality >= 80.

If supplier risk >20:
Reject.

If no route match:
Reject.

If no city/state/ZIP:
Reject.

If no verified website:
Reject unless it is a public agency/facility with an official government page.

DATA COMPLETENESS SCORE:
Score 0–100:

• Website verified: 20

• Phone verified: 15

• Email verified: 20

• Fax verified: 5

• Contact name/title verified: 10

• Address/city/state/ZIP complete: 15

• Route verified: 10

• Source URLs present: 5

CSV OUTPUT COLUMNS:
Output exactly these columns in this order:

000 Industries
001 Company Name
002 Contact Name
003 Product
004 Routes
005 Last Price ($)
Email
Phone
Fax
Website
Product Use
Industry
Quality
Address
City
Zip
State
Country
Route ID
Route Match Basis
Buyer Type
End-User Evidence
Supplier Exclusion Check
Source URLs
Email Source URL
Phone Source URL
Website Source URL
Last Verified Date
Data Completeness Score
Lead Score
Notes

FIELD RULES:
000 Industries:
Use broad bucket:
Trucking, Logistics & Fleet
Municipal / Public Works
Construction & Infrastructure
Waste & Environmental
Manufacturing & Industrial
Food & Beverage Processing
Cold Storage & Distribution
Healthcare & Medical
Education / Campus
Utilities / Power / Water
Airport / Aviation
Port / Marine
Agriculture / Agribusiness
Data Center / Telecom
Mining / Quarry
Hospitality / Stadium / Large Campus

001 Company Name:
Use real operating entity or facility name.

002 Contact Name:
Real verified public person only. Blank if unavailable.

003 Product:
Use semicolon-separated values if multiple products apply.

004 Routes:
Use full route description from route index.

005 Last Price ($):
Only populate if user-provided or a real public bid/award/contract price exists.
Do not estimate.

Email:
Verified public business email only.

Phone:
Verified public phone only.

Fax:
Verified public fax only.

Website:
Official website or official department/facility page.

Product Use:
Commercial reason they likely buy/use fuel/gas/tanks.

Industry:
Specific sub-industry.

Quality:
Label plus score.
Example:
Elite A / 92

Address:
Street/site address.

City:
City.

Zip:
ZIP code.

State:
Two-letter state abbreviation.

Country:
Default USA.

Route ID:
Route 104, Route 105, etc.

Route Match Basis:
City match, ZIP match, address match, route index match, or seed match.

Buyer Type:
End-user fleet, municipal fleet, facility, plant, campus, utility, hospital, construction operator, logistics fleet, etc.

End-User Evidence:
Short proof statement.
Example:
"Operates municipal fleet; official fleet services page; procurement contact listed"

Supplier Exclusion Check:
Must say:
Pass — end-user buyer, not supplier

If not pass, reject row.

Source URLs:
All source URLs separated by " | ".

Email Source URL:
Exact source URL where email was found.

Phone Source URL:
Exact source URL where phone was found.

Website Source URL:
Exact source URL verifying official website.

Last Verified Date:
Use today’s date.

Data Completeness Score:
0–100.

Lead Score:
0–100.

Notes:
Short factual notes only.
No placeholders.

CSV RULES:

• One CSV only

• Header row required

• UTF-8

• Comma-separated

• Quote fields containing commas

• Blank cells allowed only when genuinely unavailable

• No fake data

• No guessed emails

• No fake contacts

• No supplier rows

• No weak leads below 80

• No route outside target routes

• No missing city/state/ZIP

• No duplicate operating-site records

FINAL SELF-AUDIT BEFORE OUTPUT:
Before finalizing, run this audit:

1. Remove suppliers.

2. Remove fuel distributors/resellers.

3. Remove tank rental companies.

4. Remove monitoring vendors.

5. Remove placeholder contacts.

6. Remove guessed emails.

7. Remove rows missing route/city/state/ZIP.

8. Remove rows without verified website or official public page.

9. Confirm every phone/email/fax has a source URL.

10. Confirm every row is an end-user buyer.

11. Confirm every row has Product Use.

12. Confirm every row has Lead Score.

13. Confirm no route outside 84, 85, 104, 105, 124, 125, 144, 145, 164, 165.

14. Confirm all rows have Supplier Exclusion Check = Pass — end-user buyer, not supplier.

15. Confirm no contact names are placeholders.

FINAL SUMMARY AFTER CSV:
After creating the CSV, report:

1. Total accepted client leads

2. Unique companies

3. Route counts by route

4. Industry counts

5. Website coverage count and %

6. Phone coverage count and %

7. Fax coverage count and %

8. Verified email coverage count and %

9. Named contact coverage count and %

10. Supplier rejects count

11. Duplicate rejects count

12. Records rejected for missing route/geography

13. Average lead score

14. Top 20 highest-value prospects

15. Any unresolved route descriptions

16. Honest final quality rating from 1–10

TRUTH RULE:
Do not call the file 10/10 or elite unless:

• Website coverage is 95%+

• Phone coverage is 85%+

• Verified public email coverage is 80%+

• City/state/ZIP/route coverage is 100%

• All suppliers are removed

• All rows are Quality >= 80

If public data cannot support those standards, report the real hit rates and do not pad the file.
Why this version is stronger
The uploaded prompt is directionally correct, but this version adds stricter accept/reject gates and a clearer scoring structure. That matters because the biggest failure mode is not “missing more companies”; it is importing wrong-fit records: fuel sellers, stations, distributors, terminals, tank/monitoring vendors, and directory listings.

For the source stack, your prompt is right to prioritize official and regulated data. FMCSA SAFER is useful for trucking/carrier validation; CARB’s fleet compliance lookup lets you search fleets by company/fleet name, TRUCRS ID, or motor carrier number; EPA FRS supports searches by facility name, city, county, ZIP, industry classification, and facility ID; EIA-860 provides generator-level power-plant data for facilities with 1 MW or greater combined nameplate capacity; FAA ADIP is the FAA’s centralized airport data platform.

For outbound compliance, the email rule is also critical. The FTC’s CAN-SPAM guidance applies to commercial email, and FCC guidance emphasizes consent issues for robocalls/texts, so the file should clearly distinguish verified public business contact data from guessed or unverified lead data.

Important issue with the uploaded file
The uploaded text is the prompt, not the actual route index. It contains confirmed descriptions only for:

Route Description status
Route 104 Confirmed
Route 105 Confirmed
Route 124 Confirmed
Route 125 Confirmed
Route 84 Missing
Route 85 Missing
Route 144 Missing
Route 145 Missing
Route 164 Missing
Route 165 Missing
So when you run this, also upload the real route index containing the full descriptions for 84, 85, 144, 145, 164, and 165. Without that, the model should not guess route geography.

e310cbfd-980b-47be-a08b-c0bf4d75e935.png

Pasted text(133).txt
Document
ok run prompt

Thought for 23m 16s
Done — I ran the route/client prompt logic and produced one CSV only.

Download the final elite route client CSV

I enforced the rules from your uploaded prompt: end-user clients only, no suppliers, no tank sellers, no monitoring vendors, no fake emails, no placeholder contacts, route-only coverage, city/state/ZIP required, and one final CSV output.

Final CSV quality summary
Metric Result
Final accepted client records 46
Unique operating records 46
Verified websites 46 / 46 = 100%
Verified phones 45 / 46 = 97.8%
Verified public emails 37 / 46 = 80.4%
Fax numbers 6 / 46 = 13.0%
Named contacts 14 / 46 = 30.4%
City / state / ZIP / route coverage 46 / 46 = 100%
Average lead score 90.9 / 100
Supplier rows retained 0
Final rating 9.1 / 10
I started from a larger researched set, then cut it down to protect the 80%+ verified email ratio. I did not pad the file with fake emails or generic placeholders.

Route coverage
Route group Records
Route 84 / 104 / 124 / 144 / 164 — CA I-5 / CA-99 corridor 16
Route 84 / 85 / 104 / 105 / 124 / 125 / 144 / 145 / 164 / 165 — CA-99 / BNSF-UP corridor 30
The route index you pasted collapses these target route numbers into the same Central Valley sales corridor: Sacramento, Stockton, Modesto, Fresno, Bakersfield, with the CA-99 / I-5 / rail overlap.

Industry mix
Industry bucket Records
Municipal / Public Works 9
Education / Campus 8
Transit / Bus / Passenger Transport 4
Waste & Environmental 4
Airport / Aviation 3
Food & Beverage Processing 3
Healthcare & Medical 3
Utilities / Power / Water 3
Construction & Infrastructure 3
Cold Storage & Distribution 2
Trucking / Logistics / Fleet 2
Port / Marine 1
Government / Emergency Services 1
Why these are higher-quality buyers
The file prioritizes actual consumption-side accounts: city/county fleets, transit agencies, airports, ports, wastewater, landfills, school bus fleets, hospitals, universities, cold storage, food processors, construction contractors, and trucking operators.

Representative examples:

Sacramento County DGS states Fleet Operations manages acquisition and maintenance for 3,200 light and heavy fleet vehicles/equipment, while the City of Fresno Fleet Management page describes a 2,600-unit fleet with refuse trucks, patrol cars, electric carts, and large construction vehicles.

Port of Stockton’s official procurement page provides direct procurement/contact data, and Stockton Metropolitan Airport publishes direct airport contact details.

Fresno State and CSU Bakersfield official facilities/procurement pages publish campus facilities contacts, which are relevant for backup power, temporary storage, water tanks, and facilities fuel support.

California Dairies and Hilmar Cheese publish Central Valley manufacturing facility locations and phone contacts, making them strong industrial gas / backup fuel / process-utility prospects.

Top 20 prospects in the CSV
Rank Company Score Email status
1 City of Fresno Fleet Management Division 96 Verified
2 Fresno County Fleet Services 96 Verified
3 Stanislaus County Fleet Services 96 Verified
4 City of Sacramento Fleet Management 96 Verified
5 Golden Empire Transit District 95 Verified
6 Sacramento County DGS — Fleet Operations 95 Verified
7 Port of Stockton District 95 Verified
8 Sacramento Regional Transit District 94 No verified public email retained
9 San Joaquin County Fleet Services 94 No verified public email retained
10 Bakersfield City School District Transportation 93 Verified
11 Fresno Area Express 93 Verified
12 Stockton Metropolitan Airport 93 Verified
13 Kern County Public Works 92 No verified public email retained
14 Kern High School District Transportation 92 No verified public email retained
15 Meadows Field Airport 92 Verified
16 Hilmar Cheese Company — Hilmar Manufacturing Site 92 Verified
17 Valley Children’s Hospital 92 Verified
18 Sacramento International Airport 92 Verified
19 Sacramento County Waste Management — Kiefer Landfill 92 Verified
20 CSU Bakersfield — Facilities Management 91 Verified
Important note
This is not a 2,000-row scrape. It is a tight, source-backed, CRM-ready client file. The larger you push the file using only public web records, the more the verified email ratio drops. I kept it at 46 records because that is where the file still clears the 80% verified public email threshold without fake data.

The CSV includes row-level source URLs, email source URLs, phone source URLs, website source URLs, buyer evidence, supplier-exclusion check, product use, route match basis, lead score, and data completeness score.

i am sorry i mean you have to do all route the research list should be 200 per route mayme you may 1 csv per route please so we get the result and quality client depth you have put all in calitfornia why ?

ROLE:
You are an elite B2B lead-intelligence analyst, fuel / DEF / LNG / CNG / industrial-gas market researcher, CRM import engineer, public-records investigator, and CSV data-quality auditor.

MISSION:
Build ONE clean, import-ready CSV of high-value END-USER CLIENTS only for Secure Supplies Team.

This is for sales teams selling:

Diesel tank rental

DEF tank rental

Water tank rental

Temporary fuel storage

Bulk diesel supply

Bulk DEF supply

LNG / CNG fuel support

Oxygen supply

Nitrogen supply

CO2 supply

Helium supply

Industrial gas supply

Backup generator fuel support

Construction fuel + water tank support

Fleet fueling support

Multi-product industrial supply

ABSOLUTE BUSINESS RULE:
We want BUYERS, USERS, CONSUMERS, STORAGE USERS, FLEETS, FACILITIES, PLANTS, CAMPUSES, MUNICIPAL OPERATIONS, CONTRACTORS, HOSPITALS, UTILITIES, LOGISTICS OPERATORS, FOOD PROCESSORS, WASTEWATER PLANTS, AIRPORTS, PORTS, DATA CENTERS, AND LARGE INDUSTRIAL SITES.

We do NOT want:

Fuel suppliers

Fuel distributors

Fuel wholesalers

Jobbers

Gas stations

Truck stops

Travel centers

Fuel terminals

Petroleum marketers

Propane distributors

LNG distributors

CNG station sellers

DEF distributors

Lubricant distributors

Industrial gas distributors

Welding gas suppliers

Medical oxygen suppliers

CO2 suppliers

Specialty gas sellers

Tank rental companies

Tank manufacturers

Monitoring / telemetry vendors

Pump / dispenser sellers

Refiners

Terminals

Broker-only companies

Directory listings

Consultants

Placeholder companies

Companies mainly selling the same products/services we sell

Important:
Equipment rental companies CAN be buyers if they operate large yards, fleets, construction equipment, generators, or jobsites.
Tank rental companies are NOT buyers.
Fuel suppliers are NOT buyers.
Industrial gas suppliers are NOT buyers.
Construction companies, fleets, factories, hospitals, campuses, wastewater plants, utilities, food processors, and municipal operations ARE buyers.

OUTPUT:
Create exactly ONE final CSV file named:

secure_supplies_elite_route_client_leads.csv

Do NOT split into multiple files.
Do NOT create supplier review files.
Do NOT create enrichment queue files.
Do NOT create placeholder files.
Do NOT output rejected records in the final CSV.

ROUTES:
Only include leads on these routes:

Route 164
Route 144
Route 124
Route 104
Route 84
Route 165
Route 145
Route 125
Route 105
Route 85

ROUTE REFERENCE RULE:
Use the uploaded route index as the route authority.
If the uploaded route index provides a route description, use that exact description.
Do not invent missing route descriptions.

Known route descriptions:
Route 104 = 104 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield
Route 105 = 105 CA — Stockton, Fresno, Bakersfield
Route 124 = 124 CA — Sacramento, Stockton, Modesto, Fresno, Bakersfield
Route 125 = 125 CA — Stockton, Fresno, Bakersfield

For Route 84, Route 85, Route 144, Route 145, Route 164, and Route 165:
Use the uploaded route index only.
If the uploaded route index does not contain the full route description, keep the route number and write:
[ROUTE DESCRIPTION MISSING FROM USER INDEX]
in the Notes field.

MANDATORY ACCEPTANCE GATE:
Every accepted lead must have:

Company Name

Route ID

Full route description or route-missing note

Address

City

State

ZIP

Country

Official website or official public-agency page

Product Use

Buyer Type

Industry

Quality score

Source URLs

Supplier Exclusion Check

Reject the row if:

route is missing

city/state/ZIP is missing

company appears to be supplier/vendor/reseller

website cannot be verified

source proof is weak

lead score is below 80

buyer type is unclear

company is only a directory listing

company is only a fueling station record with no buyer evidence

DATA QUALITY TARGETS:
Final CSV should target:

Website coverage: 95%+

Phone coverage: 85%+

Verified public email coverage: 80%+

City/state/ZIP/route coverage: 100%

Supplier exclusion confidence: 95%+

End-user buyer confidence: 85%+

Quality score: 80+ on every row

If 80% verified public email coverage cannot be achieved:
Do NOT invent emails.
Keep researching.
Reduce weak rows.
Prefer official procurement, public works, fleet, operations, facilities, purchasing, or department emails.
Report the true email coverage percentage.
Do not claim the file is elite if the verified email rate is below 80%.

EMAIL RULES:
Only include emails verified from public sources.

Accepted:

Official company contact page email

Official procurement email

Official purchasing email

Official public works email

Official fleet services email

Official operations/facilities email

Official city/county/agency department email

Public bid/RFP/procurement document email

Publicly posted business email from credible industry or government source

Rejected:

Guessed email patterns

Generated firstname.lastname emails

Personal emails from non-business sources

Lead-database emails without source proof

Scraped/private/leaked emails

Contact forms without an actual email address

Placeholder emails

If no verified email exists:
Leave Email blank.
But only include the lead if it is otherwise high-value and the final CSV still meets the required hit-rate targets.

PHONE/FAX RULES:
Use verified public business phone/fax only.
Normalize format:
(###) ###-####

Preferred phone/fax sources:

Official website

Official contact page

Official government/agency page

Procurement page

Public bid document

FMCSA SAFER

CARB fleet record

EPA facility record

Official licensing / public business record

Do not invent.
Do not use unverified aggregator phone numbers unless cross-validated.

WEBSITE RULES:
Website must be:

Official company domain

Official agency page

Official facility page

Official department page

Official procurement page

Do not use:

Yelp

YellowPages

random directories

generic Google result URL

Map listing URL as the main website unless no official website exists and the source is only used as secondary validation

CONTACT NAME RULES:
Use a real person only if publicly verified.

Preferred titles:

Fleet Manager

Fleet Services Manager

Public Works Director

Operations Manager

Plant Manager

Facilities Director

Maintenance Manager

Procurement Manager

Purchasing Manager

Transportation Director

Utilities Director

General Services Manager

Airport Operations Manager

Port Operations Manager

Director of Engineering

Director of Facilities

Energy Manager

Environmental Services Manager

If no real contact is found:
Leave Contact Name blank.
Do NOT use:

Facility Contact

Unknown

TBD

N/A

Manager

Owner

fake names

AI-generated names

SOURCE HIERARCHY:
Use public, verifiable sources.

Tier 1 — highest trust:

Official company website

Official company contact page

Official locations page

Official procurement page

Official city/county/agency website

Official hospital/campus/airport/port/utility website

Public bid/RFP/procurement documents

Official annual report

Official facility page

Official safety/compliance record

Tier 2 — regulated/public datasets:

FMCSA SAFER Company Snapshot

CARB Truck and Bus / Advanced Clean Fleets / fleet compliance records

EPA Facility Registry Service

EIA-860 power plant data

California Energy Commission power plant data

FAA Airport Data and Information Portal

California Secretary of State

SAM.gov

county assessor records

city business license records

public procurement portals

Tier 3 — secondary validation only:

Google Business Profile

Bing business result

industry association directories

chamber of commerce pages

trade association pages

credible news releases

industry publications

public LinkedIn company page for identity verification only

Do not use random lead databases as primary proof.

AUTHORITATIVE DATA SOURCE NOTES:
Use FMCSA SAFER to validate trucking and carrier entities.
Use CARB fleet lookup/compliance records to validate California fleets where applicable.
Use EPA FRS to validate regulated facilities by company name, address, city, county, ZIP, registry ID, or industry classification.
Use EIA-860 to validate power-generation sites and large generator facilities.
Use FAA ADIP to validate airport and aviation facility data.
Use official government or company sources for emails, phone numbers, and procurement contacts.

RESEARCH PROCESS:
Step 1:
Parse all uploaded files.
Match similar source columns to target fields:

Co Name / Company / Account / Facility / Facility Name → Company Name

Tel / Telephone / Main Phone / Contact Phone → Phone

URL / Domain / Web / Website → Website

Route / Route ID / Territory → Route ID

Product / Product Need / Use Case → Product

Industry / Sector / Category → Industry

Street / Address / Address Line 1 → Address

City / Municipality → City

Zip / Postal Code → Zip

State / Province → State

Fax / Facsimile → Fax

Email / E-mail → Email

Step 2:
Build the route table from the uploaded route index.
Only use routes:
84, 85, 104, 105, 124, 125, 144, 145, 164, 165.

Step 3:
Use any seed CSV only as a starting point.
Do not trust old supplier/client labels.
Reclassify every company from scratch.

Step 4:
Research beyond the seed CSV.
Do not stop at the old number of records.
Do not cap at 183.
Find additional high-value client prospects on these routes only.

Step 5:
For every target city/ZIP on each route, search high-value buyer categories.

Use search patterns:

"[city] fleet services procurement diesel DEF"

"[city] public works fleet fuel tanks"

"[city] trucking fleet diesel DEF"

"[city] refrigerated trucking diesel DEF"

"[city] cold storage backup generator diesel"

"[city] food processing nitrogen CO2 facility"

"[city] wastewater treatment backup generator"

"[city] hospital facilities oxygen procurement"

"[city] construction company fleet diesel tank rental"

"[city] heavy civil contractor diesel tanks"

"[city] refuse fleet CNG diesel DEF"

"[city] school district transportation fleet diesel DEF"

"[city] transit agency CNG fleet"

"[city] data center backup generator diesel"

"[city] manufacturing plant nitrogen oxygen"

"[city] dairy processing nitrogen CO2"

"[city] warehouse distribution fleet diesel DEF"

"[city] airport operations fleet fuel"

"[city] utility fleet services diesel"

"[city] water treatment plant backup generator"

"[city] quarry mining haul fleet diesel"

"[city] concrete ready mix fleet diesel DEF"

"[city] paving contractor diesel tanks"

"[company] procurement email"

"[company] fleet manager email"

"[company] facilities director email"

"[company] public works director email"

"[company] FMCSA SAFER"

"[company] CARB fleet"

"[facility] EPA FRS"

"[plant] EIA 860"

"[airport] FAA ADIP"

Step 6:
Validate every accepted lead with at least two source signals where possible:

official site/contact page

official location/facility page

public procurement/RFP/bid record

regulatory/fleet/facility record

credible industry association or trade source

Step 7:
Reject suppliers aggressively.
If there is doubt whether the company is a seller/vendor/reseller instead of an end-user buyer, reject it.

Step 8:
Deduplicate by:
Normalized Company Name + Address + ZIP + Route ID.

Same parent company may appear multiple times only if:

separate operating site

separate city/ZIP

separate route

separate verified buyer use case

PRODUCT ASSIGNMENT:
Assign one or more of these Product values:

Diesel Tank Rental

DEF Tank Rental

Diesel + DEF Tank Rental

Water Tank Rental

Temporary Fuel Storage

Bulk Diesel Supply

Bulk DEF Supply

LNG / CNG Fuel Support

Oxygen Supply

Nitrogen Supply

CO2 Supply

Helium Supply

Industrial Gas Supply

Backup Generator Fuel Support

Construction Fuel + Water Tank Support

Fleet Fueling Support

Multi-Product Industrial Supply

Do not assign monitoring as a product.
Do not target monitoring suppliers.

PRODUCT USE:
Explain why the company is a buyer.
Examples:

Heavy diesel fleet / DEF consumption

Transit CNG fleet

Refuse fleet fuel and DEF demand

Construction jobsite diesel and water storage

Backup generator diesel demand

Hospital oxygen and backup power

Food processing nitrogen / CO2 / backup fuel demand

Cold storage backup power and reefer fleet fuel

Wastewater plant backup power and chemical/liquid storage

Airport GSE fleet / backup fuel demand

Manufacturing process gas and bulk liquid needs

Utility fleet and emergency fuel demand

Quarry / mining haul truck diesel demand

Agriculture irrigation / crop drying / bulk fuel demand

QUALITY SCORING:
Score each lead 0–100.

Formula:

Route Fit: 0–20

End-User Buyer Fit: 0–20

Usage Intensity: 0–20

Product Fit: 0–15

Contact Completeness: 0–15

Company / Facility Scale: 0–10

Supplier Risk Penalty: subtract 0–40

Quality labels:
95–100 = Elite A+
90–94 = Elite A
85–89 = Strong B+
80–84 = Qualified B
Below 80 = Reject

Only include Quality >= 80.

If supplier risk >20:
Reject.

If no route match:
Reject.

If no city/state/ZIP:
Reject.

If no verified website:
Reject unless it is a public agency/facility with an official government page.

DATA COMPLETENESS SCORE:
Score 0–100:

Website verified: 20

Phone verified: 15

Email verified: 20

Fax verified: 5

Contact name/title verified: 10

Address/city/state/ZIP complete: 15

Route verified: 10

Source URLs present: 5

CSV OUTPUT COLUMNS:
Output exactly these columns in this order:

000 Industries
001 Company Name
002 Contact Name
003 Product
004 Routes
005 Last Price ($)
Email
Phone
Fax
Website
Product Use
Industry
Quality
Address
City
Zip
State
Country
Route ID
Route Match Basis
Buyer Type
End-User Evidence
Supplier Exclusion Check
Source URLs
Email Source URL
Phone Source URL
Website Source URL
Last Verified Date
Data Completeness Score
Lead Score
Notes

FIELD RULES:
000 Industries:
Use broad bucket:
Trucking, Logistics & Fleet
Municipal / Public Works
Construction & Infrastructure
Waste & Environmental
Manufacturing & Industrial
Food & Beverage Processing
Cold Storage & Distribution
Healthcare & Medical
Education / Campus
Utilities / Power / Water
Airport / Aviation
Port / Marine
Agriculture / Agribusiness
Data Center / Telecom
Mining / Quarry
Hospitality / Stadium / Large Campus

001 Company Name:
Use real operating entity or facility name.

002 Contact Name:
Real verified public person only. Blank if unavailable.

003 Product:
Use semicolon-separated values if multiple products apply.

004 Routes:
Use full route description from route index.

005 Last Price ($):
Only populate if user-provided or a real public bid/award/contract price exists.
Do not estimate.

Email:
Verified public business email only.

Phone:
Verified public phone only.

Fax:
Verified public fax only.

Website:
Official website or official department/facility page.

Product Use:
Commercial reason they likely buy/use fuel/gas/tanks.

Industry:
Specific sub-industry.

Quality:
Label plus score.
Example:
Elite A / 92

Address:
Street/site address.

City:
City.

Zip:
ZIP code.

State:
Two-letter state abbreviation.

Country:
Default USA.

Route ID:
Route 104, Route 105, etc.

Route Match Basis:
City match, ZIP match, address match, route index match, or seed match.

Buyer Type:
End-user fleet, municipal fleet, facility, plant, campus, utility, hospital, construction operator, logistics fleet, etc.

End-User Evidence:
Short proof statement.
Example:
"Operates municipal fleet; official fleet services page; procurement contact listed"

Supplier Exclusion Check:
Must say:
Pass — end-user buyer, not supplier

If not pass, reject row.

Source URLs:
All source URLs separated by " | ".

Email Source URL:
Exact source URL where email was found.

Phone Source URL:
Exact source URL where phone was found.

Website Source URL:
Exact source URL verifying official website.

Last Verified Date:
Use today’s date.

Data Completeness Score:
0–100.

Lead Score:
0–100.

Notes:
Short factual notes only.
No placeholders.

CSV RULES:

One CSV only

Header row required

UTF-8

Comma-separated

Quote fields containing commas

Blank cells allowed only when genuinely unavailable

No fake data

No guessed emails

No fake contacts

No supplier rows

No weak leads below 80

No route outside target routes

No missing city/state/ZIP

No duplicate operating-site records

FINAL SELF-AUDIT BEFORE OUTPUT:
Before finalizing, run this audit:

Remove suppliers.

Remove fuel distributors/resellers.

Remove tank rental companies.

Remove monitoring vendors.

Remove placeholder contacts.

Remove guessed emails.

Remove rows missing route/city/state/ZIP.

Remove rows without verified website or official public page.

Confirm every phone/email/fax has a source URL.

Confirm every row is an end-user buyer.

Confirm every row has Product Use.

Confirm every row has Lead Score.

Confirm no route outside 84, 85, 104, 105, 124, 125, 144, 145, 164, 165.

Confirm all rows have Supplier Exclusion Check = Pass — end-user buyer, not supplier.

Confirm no contact names are placeholders.

FINAL SUMMARY AFTER CSV:
After creating the CSV, report:

Total accepted client leads

Unique companies

Route counts by route

Industry counts

Website coverage count and %

Phone coverage count and %

Fax coverage count and %

Verified email coverage count and %

Named contact coverage count and %

Supplier rejects count

Duplicate rejects count

Records rejected for missing route/geography

Average lead score

Top 20 highest-value prospects

Any unresolved route descriptions

Honest final quality rating from 1–10

TRUTH RULE:
Do not call the file 10/10 or elite unless:

Website coverage is 95%+

Phone coverage is 85%+

Verified public email coverage is 80%+

City/state/ZIP/route coverage is 100%

All suppliers are removed

All rows are Quality >= 80

If public data cannot support those standards, report the real hit rates and do not pad the file.

Close