Hi Timothy,
The data came from SF exports. We mapped only the existing zip codes for
counties/states and did not check if all existing zip codes were present so
that you could remove/add those that are missing or no longer serviced.
There are over 875k zip codes in Canada and roughly 10k in SF. What would
be the best way to identify the important missing ones?
On Wed, Apr 17, 2024 at 4:06 PM Timothy Thomas <tt@thekey.com> wrote:
> Hi Ray,
>
> The list that was provided to us last week is missing postal codes from
> our corporate territories. What source are you using to identify the codes?
>
> As for Halifax, this should not be a priority. We're not in a position to
> service clients there at the moment.
>
> On Wed, Apr 17, 2024 at 9:49 AM Ray Smale <ray.smale@thekey.com> wrote:
>
>> Good morning Tim,
>> I read this and I'm not sure what it means in terms of direction for the
>> team as to what post codes should be in or out.
>> Sorry. Could you please clarify...
>>
>> ---------- Forwarded message ---------
>> From: Timothy Thomas <tt@thekey.com>
>> Date: Wed, Apr 17, 2024 at 9:01 AM
>> Subject: Re: Updated zip codes for SF
>> To: Chad Everitt <chad.everitt@thekey.com>
>>
>>
>> Hi Chad,
>>
>> 1) Phil asked me to provide a postal code for testing the new web form. I
>> selected one at random by googling Calgary postal codes and it was not
>> listed included in Phil’s data.
>>
>> When we audited the postal code list last week, we only checked to make
>> sure the codes listed were within our territory. I didn’t think to make
>> sure that some may have been omitted.
>>
>> 2) We dont actively service any clients in Halifax nor are we doing any
>> marketing. When the Boston client first arrived we thought we could
>> leverage the staff there to service other clients. We were unsuccessful.
>>
>> That said, we do still have a Halifax page on the website but we have not
>> received an inquiry.
>>
>> On Wed, Apr 17, 2024 at 9:19 AM Chad Everitt <chad.everitt@thekey.com>
>> wrote:
>>
>>> Below is the response I received from Tim re: Canada. Confirming we did
>>> close the Charleston and Columbia, SC office and those zip codes should
>>> have been removed.
>>>
>>>
>>> *Chad Everitt*
>>> President- East Division & Canada
>>> Mobile: 202.262.8318
>>> [image: TheKey] <https://homecareassistance.com/>
>>>
>>>
>>>
>>>
>>> ---------- Forwarded message ---------
>>> From: Timothy Thomas <tt@thekey.com>
>>> Date: Wed, Apr 17, 2024 at 9:01 AM
>>> Subject: Re: Updated zip codes for SF
>>> To: Chad Everitt <chad.everitt@thekey.com>
>>>
>>>
>>> Hi Chad,
>>>
>>> 1) Phil asked me to provide a postal code for testing the new web form.
>>> I selected one at random by googling Calgary postal codes and it was not
>>> listed included in Phil’s data.
>>>
>>> When we audited the postal code list last week, we only checked to make
>>> sure the codes listed were within our territory. I didn’t think to make
>>> sure that some may have been omitted.
>>>
>>> 2) We dont actively service any clients in Halifax nor are we doing any
>>> marketing. When the Boston client first arrived we thought we could
>>> leverage the staff there to service other clients. We were unsuccessful.
>>>
>>> That said, we do still have a Halifax page on the website but we have
>>> not received an inquiry.
>>>
>>>
>>> Tim Thomas
>>> Head of Canada Division
>>> *Please note my email has changed:*
>>> tt@TheKey.com <tt@thekey.com>
>>> (514) 591-9387
>>> TheKey.ca <https://www.thekey.ca/>
>>> [image: TheKey] <https://www.thekey.com/>
>>>
>>>
>>> On Wed, Apr 17, 2024 at 8:19 AM Chad Everitt <chad.everitt@thekey.com>
>>> wrote:
>>>
>>>> Hi Tim,
>>>>
>>>> Received the below questions I’m hoping you can clarify:
>>>>
>>>> 1) that there may be some missing postal codes for Canada.
>>>> - Tim Thomas gave me some Calgary postal codes that are in premium
>>>> areas (T3E7M8, T0L0X0) for testing purposes and they are not in your Excel
>>>> file
>>>> - V7V1J7 is in West Vancouver and is not in your file or Salesforce,
>>>> but is serviced by TheKey Canada
>>>>
>>>> 2) Canada at one point served Halifax, but there aren't any postal
>>>> codes in that area.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Chad Everitt*
>>>> President- East Division & Canada
>>>> Mobile: 202.262.8318
>>>> [image: TheKey] <https://homecareassistance.com/>
>>>>
>>>>
>>>> ---------- Forwarded message ---------
>>>> From: Ray Smale <ray.smale@thekey.com>
>>>> Date: Wed, Apr 17, 2024 at 7:11 AM
>>>> Subject: Fwd: Updated zip codes for SF
>>>> To: Chad Everitt <chad.everitt@thekey.com>
>>>> CC: Gabrielle Wolfe <gwolfe@thekey.com>, Phil Chanda <
>>>> phil.chanda@thekey.com>, Sardar Azimov <sardar.azimov@thekey.com>
>>>>
>>>>
>>>> Hi Chad,
>>>> The ladies have pointed out questions with what you provided for:
>>>> 1. Canada
>>>> 2. Recently closed offices
>>>> Pls see below and let us know.
>>>> Thanks,
>>>> Ray
>>>>
>>>> ---------- Forwarded message ---------
>>>> From: Gabrielle Wolfe <gwolfe@thekey.com>
>>>> Date: Tue, Apr 16, 2024 at 11:12 PM
>>>> Subject: Re: Updated zip codes for SF
>>>> To: Ray Smale <ray.smale@thekey.com>
>>>> CC: Phil Chanda <phil.chanda@thekey.com>, Sardar Azimov <
>>>> sardar.azimov@thekey.com>
>>>>
>>>>
>>>> As well, it looks like the Charleston and Columbia offices are closed
>>>> and we no longer are licensed there. This may have just happened though I
>>>> only saw an email about it this week with them asking to remove all zip
>>>> codes supported by Columbia and Charleston.
>>>>
>>>> GW
>>>>
>>>> Gabrielle Wolfe
>>>>
>>>> * Head of Contact Center*
>>>> gwolfe@thekey.com <https://brand.thekey.com/esg/gwolfe@thekey.com>
>>>> +1-360-502-3020
>>>> TheKey.com <https://www.thekey.com/>
>>>> [image: TheKey] <https://homecareassistance.com/>
>>>>
>>>>
>>>> On Tue, Apr 16, 2024 at 8:52 PM Ray Smale <ray.smale@thekey.com> wrote:
>>>>
>>>>> Thanks Phil.
>>>>> Let’s see if we can get clarity from the source (who I believe is
>>>>> Chad) and let’s get him to connect with Tim. We can’t decide this - garbage
>>>>> in garbage out as they say.
>>>>> If the source is Chad then let’s ask him to confirm his submission.
>>>>>
>>>>> On Tue, Apr 16, 2024 at 9:54 PM Phil Chanda <phil.chanda@thekey.com>
>>>>> wrote:
>>>>>
>>>>>> Hi Sardar & Ray,
>>>>>>
>>>>>> I took a look at your file and noticed a few things:
>>>>>>
>>>>>> 1) that there may be some missing postal codes for Canada.
>>>>>> - Tim Thomas gave me some Calgary postal codes that are in premium
>>>>>> areas (T3E7M8, T0L0X0) for testing purposes and they are not in your Excel
>>>>>> file
>>>>>> - V7V1J7 is in West Vancouver and is not in your file or Salesforce,
>>>>>> but is serviced by TheKey Canada
>>>>>>
>>>>>> 2) Canada at one point served Halifax, but there aren't any postal
>>>>>> codes in that area.
>>>>>>
>>>>>> Can we discuss over email or on our Monday call?
>>>>>>
>>>>>> Thanks,
>>>>>> Phil
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ---------- Forwarded message ---------
>>>>>> From: Phil Chanda <phil.chanda@thekey.com>
>>>>>> Date: Mon, Apr 15, 2024 at 3:39 PM
>>>>>> Subject: Re: Updated zip codes for SF
>>>>>> To: Sardar Azimov <sardar.azimov@thekey.com>
>>>>>> Cc: Ray Smale <ray.smale@thekey.com>, Gabrielle Wolfe <
>>>>>> gwolfe@thekey.com>
>>>>>>
>>>>>>
>>>>>> Hi Sardar,
>>>>>>
>>>>>> I will take a look at the file and will let you know if I have any
>>>>>> questions.
>>>>>>
>>>>>> CC'ing Gabrielle so that she is aware. Our Salesforce team will
>>>>>> likely need to reformat this for their upload.
>>>>>>
>>>>>> Thanks,
>>>>>> Phil
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon, Apr 15, 2024 at 3:31 PM Sardar Azimov <
>>>>>> sardar.azimov@thekey.com> wrote:
>>>>>>
>>>>>>> Hi Phil,
>>>>>>>
>>>>>>> I hope you had a good weekend.
>>>>>>>
>>>>>>> I'm attaching the file with all the zip codes reviewed and appended
>>>>>>> with counties and states (plus other details from the zip code source files
>>>>>>> I used for appending; you can disregard those you don't need).
>>>>>>>
>>>>>>> I've added the comments from the divisions in column G for
>>>>>>> reference. Column H shows whether the data has changed.
>>>>>>>
>>>>>>> With Ray, we thought that one quick win for the website would be
>>>>>>> indicating the county instead of the name of each office.
>>>>>>>
>>>>>>> I'm happy to have a call and walk through the steps applied if you'd
>>>>>>> like. You might also have some questions related to the website's dynamic
>>>>>>> data display.
>>>>>>>
>>>>>>> Thank you,
>>>>>>>
>>>>>>> Sardar
>>>>>>>
>>>>>>>
>
> --
> Tim Thomas
> Head of Canada Division
> *Please note my email has changed:*
> tt@TheKey.com <tt@thekey.com>
> (514) 591-9387
> TheKey.ca <https://www.thekey.ca/>
> [image: TheKey] <https://www.thekey.com/>
>