Re: Tracking exceptions and churn for price increase

From
Audra Williams <audraw@thekey.com>
To
Beth Ann Rosario <bethann.rosario@thekey.com>
CC
Angie Markwell <angie.markwell@thekey.com>, northeastcanada-regional-operation-directors@thekey.com
Date
Fri, 31 Mar 2023 11:45:50 -0700
Folder
INBOX
--000000000000efc79005f8369e37 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I have asked Ben to update with the columns that you have all requested. On Fri, Mar 31, 2023 at 7:15=E2=80=AFAM Beth Ann Rosario wrote: > It appears the spreadsheet is broken (it wasn't me Audra!! I did NOT touc= h > it yet). But I have zero clients that received exceptions or ended > services. We had reduced services for 2 clients and 4 dissatisfied survey= s > > > 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 w= e 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 >>> is 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 f= or >>> an increase by the offices. >>> >>> >>> https://docs.google.com/spreadsheets/d/1DwGf35Y49_-YJhy7xoLsgRAdoe4R03I= ArIigtf-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 shee= t: >>>>> 1. One that has comments for cancellations >>>>> 2. Another column that has comments for exceptions - ie the person wa= s >>>>> 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 Group=

Thread (1)