Re: Vancouver Mailout

From
Sardar Azimov <sardar.azimov@thekey.com>
To
Timothy Thomas <tt@thekey.com>
CC
Ray Smale <ray.smale@thekey.com>
Date
Thu, 25 Apr 2024 18:34:32 +0200
Folder
INBOX
--0000000000005fa1d20616ee5dbd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Tim I ran some numbers, here are the "best" postal codes (grouped by Forward Sorting Area). I hope this helps. FSA Count of client Sum LTV Sum of avg_last 4w V6L 6 $ 403,263 $ 12,907 V6L3A9 4 $ 11,371 $ 3,186 V6L2E2 2 $ 391,892 $ 9,721 V7S 5 $ 67,853 $ 7,055 V7S2P1 1 $ 31,494 $ 3,276 V7S1R2 1 $ 25,568 $ 1,252 V7S2Y7 1 $ 661 $ 220 V7S2A8 1 $ 6,078 $ 1,519 V7S2N2 1 $ 4,053 $ 787 V7T 12 $ 56,000 $ 6,148 V7T1C8 6 $ 47,504 $ 4,217 V7T1M2 3 $ 3,961 $ 1,187 V7T1A7 1 $ 322 $ 107 V7T2Y4 1 $ 3,934 $ 496 V7T2H5 1 $ 279 $ 140 V5S 2 $ 48,327 $ 4,463 V5S4L6 1 $ 31,844 $ 4,258 V5S4J9 1 $ 16,483 $ 205 V7V 6 $ 40,570 $ 6,955 V7V1K8 1 $ 18,777 $ 534 V7V2J9 1 $ 298 $ 298 V7V1S3 1 $ 2,655 $ 1,327 V7V1B8 1 $ 5,093 $ 1,273 V7V1A4 1 $ 13,632 $ 3,408 V7V1E6 1 $ 115 $ 115 On Tue, Apr 23, 2024 at 6:25=E2=80=AFPM Timothy Thomas wrot= e: > That's ok. No rush. Thank you > > On Tue, Apr 23, 2024 at 12:08=E2=80=AFPM Sardar Azimov > wrote: > >> Hi Timothy, >> Yes, the data was coming from Clearcare. I'd need to eliminate the >> locations with the tags you mentioned. I'll try to share some data ASAP, >> but I don't think I'll have time before tomorrow's EOD. >> >> Thank you, >> Sardar >> >> On Tue, Apr 23, 2024 at 3:59=E2=80=AFPM Timothy Thomas w= rote: >> >>> Hi Sardar, >>> >>> Did you pull this data from our Vancouver clearcare? The majority of ou= r >>> clients are government paid in Vancouver, so their location wouldn't >>> necessarily match up with our ideal private pay clientele. If you can >>> exclude clients tagged "Vancouver Coastal Health" then we can exclusive= ly >>> focus on our private pay business. >>> >>> In the past we've used the Canada Post campaign tool which lets us >>> identify postal routes with the highest concentration of wealth and 45-= 60yr >>> old demographic. >>> >>> As for the offer, yes I'm open to those suggestions. In previous >>> campaigns we've used the $500 care credit but I like the idea of offeri= ng >>> multiple items and having them come by the office to pick up a gift. We= can >>> use the same promo items as the upcoming event. Phil would need to assi= st >>> in designing a conversion page around this. >>> >>> Happy to chat in more detail. >>> Thanks! >>> >>> On Tue, Apr 23, 2024 at 9:25=E2=80=AFAM Sardar Azimov >>> wrote: >>> >>>> Good morning, >>>> >>>> Below is the data I can share on Vancouver: areas with the most >>>> clients and highest revenues, grouped by the Forward Sortation Area (t= he >>>> first 3 characters of the postal code). >>>> >>>> Depending on how well you can / want to target with your mailing >>>> solution, we can drill down on an individual postal code if needed (th= ere >>>> are over 200 codes for the Vancouver area in the SF database). >>>> >>>> Let me know if you have any questions or if I can be of further >>>> assistance for the below. >>>> >>>> FSA Count of client Sum LTV Sum of avg_last 4w >