Wednesday, March 3, 2010

2009 Services, Business/Marketing, Client Statistics Completed!

Have you been at the edge of your seat waiting for me to get this posted? I'm so happy to say that it's done, and am wishing I started with this bit of information first, rather than my bookkeeping statistics, since this information was much easier to tally up.


You can now click here to (hopefully) see how you rank against the rest of my clients among lots of categories and demographics. I left vowels out of lots of the categories to save on spreadsheet real estate, so I'll list everything here so you have a better idea of just what the numbers are representing. Please let me know if you are unable to access the file, I'm still figuring out Google Documents. I may still need to recreate it into a new file so more people can get to it, as I understand, not many people have Microsoft Works on their computers (except for me!).



The list starts with appointment times: 3-4p, 4-5p, 5-6p,  6-7p, 7-8p;
Day or the week: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday;
Returning Clients;
How long the massage session was: 30minute, 45minute, 60minute, 75minute, 90minute;
Spa treatments: Bodywrap, Body Mask & Wrap, Mask, Toning, Skin Polish, Bodywrap & Massage, Skin Polish & Massage, Hand & Foot Polish & Massage, Body Mask & Massage, Add-Ons, Retail Products Sold;
Transaction information: Trade, Gift Certificate Sold, Package Sold, Complimentary Gift Certificate/Coupon Redeem, Gift Certificate Redeem, Package Redeem, Cash, Check, Credit, Debit, American Specialty Health (HealthNet insurance massage benefit), Private Insurance (car accidents), No Tip, Tip<$5, Tip<$10, Tip<$15, Tip<$20, Tip>$20;
Booking information: Rebook Yes/No, Same Day Appointment Booked, Same Day Appointment Cancellation,  No Show Appointment, Sunday Appointment Request, Tuesday Appointment Request, Thursday Appointment Request, Saturday Appointment Request, Same Day Appointment Request With Full Schedule, Appointment Request Before3:30;
Source of new clients: New Client Referral, New Client Drive By, New Client Online, New Client Personal, New Client Miscellaneous;
Client demographics:
Male/Year of Birth/Female: M '20-'29 F, M '30-'39 F, M '40-'49 F, M '50-'59 F, M '60-'69 F, M '70-'79 F, M '80-'89 F, M '90-'99 F, M '00-'10 F;
City or residence: Beavercreek, Beaverton/West Side, Canby, Clackamas, Gladstone, Gresham, Happy Valley, Lake Oswego, Milwaukie, Molalla, Mulino, Oregon City, Out Of Town, Portland, West Linn, Wilsonville;
Job/career information: Accounting, Administration/Office, Architecture/Engineer, Armed Forces, Beauty, Computer, Customer Service, Design, Education, Food/Hospitality, General Labor, Government, Human Resources, Legal, Management, Medical, Media, Real Estate, Retail/Sales, Self Employed, Stay At Home Mom/Dad, Retired, Unemployed, Student;
Health insurance provider: AARP, Aetna, BCBS, Cigna, HealthNet, Kaiser, MediCaid, MediCare, ODS, Oregon Health Plan, Providence, Motor Vehicle Accident Insurance, Other, None;
General health description: Excellent, Good, Fair, Poor, Not Indicated;
How much water drank daily: H2O<16oz, H2O<32oz, H2O<48oz, H2O<64oz, H2O>64oz, Not Indicated;
Health ailments/concerns: Headaches/Migraines, Arthritis/Joint Swelling, Diabetes, High Blood Pressure, Epilepsy/Seizures, Cancer, Cardiac/Circulatory Problems, Bruise Easily, Osteoporosis, Varicose Veins, Contagious Disease, Chronic Pain, Surgery, Motor Vehicle Accident/Injury, Broken Bones, Numbness, Stabbing Pain, Pregnant, Allergies, Contacts/Dentures, Etc for LMT to know;
Massage history: 1st Massage, Last Massage within the last 2 months, M<4mo, M<6mo, M<1yr, M<18mo, M<2yrs, M<5yrs, M<10yrs;
Massage needs: Relaxation, decrease Pain/Tension, decrease Stress, Maintain Health, increase Energy, Headaches, Other, No Response;
Pressure preference: Light Pressure, Light-Medium Pressure, Medium Pressure, Medium-Firm Pressure, Firm Pressure;
Areas to receive massage: Full Body OK, No Head, No Face, No Neck, No Upper Chest, No Back, No Arms, No Hands, No Glutes, No Legs, No Feet