Missed Zip Codes¶

Menu Location: Customers > Reports > Missed Zip Codes

Overview¶

The Missed Zip Codes report lists people who tried to sign up (on the sign-up page, checkout, "Where We Deliver" zip check, or create-an-account form) but entered a zip code outside your current delivery area. Every row comes from the zip_codes_potcust table, which stores the zip code, the name and email they gave, when they tried, and whether you've since emailed them.

A row is only recorded when the zip check fails and the visitor also provided their name and email, so this report only captures interested prospects who left contact info, not every failed zip lookup.

Primary Functions:

See which zip codes people are trying to sign up from that you don't currently deliver to
See how many attempts each zip has had, over a date range you choose
Email the list (or a filtered subset of zips) using a saved email template
Track which of these prospects you've already contacted (Last Contacted column)

Page Layout¶

Header Section¶

From / To date fields - Date range filter (defaults to the last 120 days)
Sort - "Sort By Zip ASC" or "Sort By Count DESC" (count = total attempts for that zip within the date range)
Zip Code(s) checklist - Every zip that had an attempt in the date range, each shown with its attempt count, e.g. 90210 (4). Includes Select All / Unselect All buttons. All zips are checked by default until you filter.
Filter Missed Zips button - Re-runs the report with the date range, sort, and selected zips

Results Table¶

id - Internal row ID
Zip - The zip code entered
Name - Name they gave
Email - Email they gave
Date - When the attempt happened
Last Contacted - Date they were last emailed via this report's "Email This List" tool, or "--" if never

A count line above the table shows the total number of matching rows, e.g. "42 missed zip code entries found."

Emailing the List¶

Click Email This List below the results table to email everyone currently shown (i.e. matching your date range and selected zips):

Optionally pick a saved template from the dropdown and click Load Template to fill in the subject and body
Edit the Subject and body (rich text editor) as needed
Click Preview Email to see it rendered in an iframe before sending
Click Ok, really send Email to queue the emails

Sending skips duplicate email addresses within the batch, and skips any address that is not subscribed to email. After sending, you're redirected back to the report and see a message with how many emails were generated, how many not-subscribed addresses were skipped, and how many duplicates were avoided. Sent emails go through the normal email queue (viewable via the email queue link in that confirmation message), and each recipient's row gets its Last Contacted date updated.

Missed Signups - Customers > Reports > Missed Signups, people who started sign-up but didn't finish
Zip Codes - Settings page for configuring which zip/postal codes you deliver to, don't deliver to, or will ship to (admin-edit.php?table=zip_codes)
Routes - Delivery route configuration

FAQs¶

What counts as a "missed zip"?¶

Someone entered a zip code on a sign-up, checkout, or "Where We Deliver" form, the zip failed your delivery-area check, and they had also filled in their name and email. Only that combination gets logged.

Can I see zip codes that failed but never gave an email?¶

No. The insert only happens when name and email are both present, so zip attempts without contact info are not recorded here.

Does this show city, state, distance from my routes, or a map?¶

No. The table only stores zip, name, email, attempt date, and last-emailed date. There is no city/state lookup, distance calculation, or map view on this page.

How do I stop emailing someone from this list again?¶

There's no unsubscribe control on this page itself. If they're not "subscribed" to email in the system, the send step already skips them and reports that count back to you.

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.