Sardar,
Can we externally pull all the Postal Codes within the respective Canadian
provinces for review? Pulling from SalesForce may be recycling the garbage
in and producing garbage out.
*Chad Everitt*
President- East Division & Canada
Mobile: 202.262.8318
[image: TheKey] <https://homecareassistance.com/>
On Wed, Apr 17, 2024 at 12:19 PM Sardar Azimov <sardar.azimov@thekey.com>
wrote:
> OK, thank you.
> Let me try to narrow down this list and get back to you. With a list of
> missing zip codes for these areas.
>
> Sent from Outlook for iOS <https://aka.ms/o0ukef>
> ------------------------------
> *From:* Timothy Thomas <tt@thekey.com>
> *Sent:* Wednesday, April 17, 2024 5:20:52 PM
> *To:* Sardar Azimov <sardar.azimov@thekey.com>
> *Cc:* Ray Smale <ray.smale@thekey.com>; Chad Everitt <
> chad.everitt@thekey.com>; Phil Chanda <phil.chanda@thekey.com>; Gabrielle
> Wolfe <gwolfe@thekey.com>
> *Subject:* Re: Updated zip codes for SF
>
> That's a great question. I'm not 100% sure. Perhaps Canada Post would have
> a tool based on the greater metro areas of our territories.
>
> 1. Great Montreal
> 2. Greater Toronto Area
> 3. Regional Municipality of Waterloo
> 4. Calgary Metropolitan Region
> 5. Winnipeg Metropolitan Region
> 6. Greater Vancouver
>
> On Wed, Apr 17, 2024 at 10:22 AM Sardar Azimov <sardar.azimov@thekey.com>
> wrote:
>
> 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/>
>
>
>
> --
> 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/>
>