Map4 Client Prospector

All Map4 E-Rate accounts use an under-2-mile distance rule for prospecting, with a 1-week search window.

In the Map4 expired-ACD cleanup, rows with Status BidYes are never deleted, even after their ACD has passed.

Keep Map4 E-Rate lead emails separate from the RHC/State RFP report email; every account gets its daily email even when nothing new is found.

Use every route line in a client's network KMZ files as given, but always skip polygon (coverage) layers.

Report emails use HTML tables, no attachments, and the subject format "Map4 E-Rate Daily Leads: <client> <date> <time> ET" or "Map4 RHC/State Daily Leads: <client> <date> <time> ET".

Client emails go Monday to Friday only; on weekends reports go to the owner only.

RHC consortium member-site addresses aren't stored centrally by USAC; they come from Form 461 attached documents and are often incomplete, so town-center geocodes are marked approximate.

Emails are sent through the Resend API with the RESEND_API_KEY secret (https://api.resend.com/emails).

Use on the first conversation with a new owner of the Map4 Client Prospector bot template, to set up their client accounts, network files and daily run.

Use when setting up the Map4 prospecting workflow on a new computer, or when report.py, rfp_proximity.py or consortium_screen.py is missing, to rebuild the scripts that make the daily lead and RFP emails.

Fire{slack_channel} once a day to find new E-Rate, RHC and State opportunitie{slack_channel} near each client'{slack_channel} network and email each client'{slack_channel} report{slack_channel}.