--0000000000000e67c8061688224b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable @Sardar Azimov that 30 minute meeting Monday morning is with the SF team to talk about what process they will use to upload the zip codes. The website Phil runs pulls zip codes not from a stable list on some server, but from SalesForce directly. In order to update the website (and my agents) we have to get the new list of zip codes into SF and assigned to the correct office. That 30 minute meeting with the SF team can happen parallel to the list getting perfected, we're just aligning on process. @Audra Williams @Timothy Thomas your calendars are a sea of back to back. Is there a time you both could identify where you can meet with Sardar to discuss zip codes? @Sardar Azimov I'll try to find a time to set you up a meeting. Thanks! GW Gabrielle Wolfe * Head of Contact Center* gwolfe@thekey.com +1-360-502-3020 TheKey.com [image: TheKey] On Sat, Apr 20, 2024 at 5:18=E2=80=AFAM Sardar Azimov wrote: > Hi Timothy and Audra, > > We have a call on zip codes on Monday at 9AM EST on zip codes with > Gabrielle and Phil, among others. Given the situation with data completio= n > I wonder if we should A) postpone the original call to a later date and B= ) > use the time slot to address the topic on the missing zip codes instead. > > @Gabrielle Wolfe and @Phil Chanda > happy to have your thoughts. > Thank you. > > > On Fri, Apr 19, 2024 at 5:36=E2=80=AFPM Chad Everitt > wrote: > >> Hi Sardar, >> >> My availability is limited on Monday however so please include Tim and >> Audra on the call when you do schedule. >> >> Chad >> >> >> *Chad Everitt* >> President- East Division & Canada >> Mobile: 202.262.8318 >> [image: TheKey] >> >> >> On Fri, Apr 19, 2024 at 9:31=E2=80=AFAM Sardar Azimov >> wrote: >> >>> Hi Chad, >>> >>> Please find the link to the Excel file with 3 tabs: >>> https://docs.google.com/spreadsheets/d/151PcWGhgqon1jfqq262lGU63Yg8ppdO= t/edit?usp=3Dsharing&ouid=3D101409043019553880832&rtpof=3Dtrue&sd=3Dtrue >>> >>> 1) The initial SF data enriched with counties and other details + >>> changes that were shared by each division >>> 2) The CA related zip codes based on the matching of cities that are >>> currently serviced by local offices (ex if Vancouver was serviced then = all >>> zips pertaining to Vancouver were identified and added). There is a col= umn >>> specifying if the zip is already in SF. Heads up, there are nearly 290k >>> non-identified zips for Canada in the cities serviced by local offices. >>> That might take you a while to identify. >>> 3) Same for the US but this time based on the county level. I've >>> identified the missing zips for counties that are serviced by local off= ices >>> and are not in SF. I've also highlighted in yellow (first column) all z= ips >>> with over 1,000 estimated population so that you can focus on bigges on= es. >>> Approx 350 zip codes are in this sitiuation. >>> >>> I'm traveling today till T