Re: Tracking exceptions and churn for price increase

From
Beth Ann Rosario <bethann.rosario@thekey.com>
To
Angie Markwell <angie.markwell@thekey.com>
CC
northeastcanada-regional-operation-directors@thekey.com
Date
Fri, 31 Mar 2023 10:14:48 -0400
Folder
INBOX
--0000000000009e0bdc05f832d5e0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable It appears the spreadsheet is broken (it wasn't me Audra!! I did NOT touch it yet). But I have zero clients that received exceptions or ended services. We had reduced services for 2 clients and 4 dissatisfied surveys Beth Ann Rosario *Regional Director VA/NC* *919.899.5543* [image: TheKey] On Thu, Mar 30, 2023 at 10:49=E2=80=AFPM Angie Markwell wrote: > Did everyone go into the spreadsheet and update the clients who we have > lost? > > On Thu, Mar 30, 2023 at 9:14=E2=80=AFAM Angie Markwell > wrote: > >> Hi all - hope everyone got back safely and on time. Can complete this >> asap please. BA can you make sure DC gets done as well and ensure these = are >> those actually not lost - don=E2=80=99t want if they say they are and we= feel idyll >> conversation- >> >> Sent from Angie's iPhone >> >> Begin forwarded message: >> >> *From:* Benjamin Lewis >> *Date:* March 30, 2023 at 3:48:50 AM EDT >> *To:* Melissa Reyes >> *Cc:* Paul Kahn , Chen Xie , >> Angie Markwell >> *Subject:* *Re: Tracking exceptions and churn for price increase* >> >> =EF=BB=BF >> I don't think I had published a version on Google Sheets yet. But here i= s >> a sheet I just put together that has the entire population from the >> beginning of the process, flagged for whether or not they were tagged fo= r >> an increase by the offices. >> >> >> https://docs.google.com/spreadsheets/d/1DwGf35Y49_-YJhy7xoLsgRAdoe4R03IA= rIigtf-w_mM/edit?usp=3Dsharing >> >> Additionally, I added a tab that can be used to document the effective >> dates determined by each region for the rates. >> >> On Wed, Mar 29, 2023 at 7:31=E2=80=AFPM Melissa Reyes >> wrote: >> >>> @Benjamin Lewis can you please re-share the >>> document we are to put our exception updates on? Thanks! >>> >>> On Wed, Mar 29, 2023 at 9:54=E2=80=AFAM Paul Kahn wrote: >>> >>>> Please can everyone enter on Ben's Google Sheet price increase >>>> schedules for each region 3 columns on the right of each pricing sheet= : >>>> 1. One that has comments for cancellations >>>> 2. Another column that has comments for exceptions - ie the person was >>>> retained but at a lower price and >>>> 3. Note the final price in the 3rd column for exceptions >>>> >>>> This way we can run analysis understanding the elasticity of pricing >>>> and also track churn related to the price increase. Please call with = any >>>> questions. >>>> >>>> Ben - perhaps you can add these three columns in each sheet for >>>> everyone to use. >>>> >>>> Thanks >>>> Paul >>>> >>> >>> >>> -- >>> *Melissa Reyes* >>> Head of the West Division(916)743-0530 >>> >> -- > You received this message because you are subscribed to the Google Groups > "Northeast/Canada Regional Operation Directors" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to > northeastcanada-regional-operation-directors+unsubscribe@thekey.com. > To view this disc

Thread (1)