We help IT Professionals succeed at work.
Get Started

Customer Attrition: SQL or VBA?

857 Views
Last Modified: 2013-11-29
I have a table which lists the activity of each of my customers. For example:

John Doe, 1/1/2009
Jane Doe, 1/2009
Eric Doe, 2/2009
John Doe, 2/2009
John Doe, 3/2009
Jane Doe, 3/2009

I need to pull out a variety of reports based on attrition and am not sure if I should use VBA or SQL to get it done. One specific report I need to pull is Customer Retention: what percentage of my customers have had consecutive months of activity for 1 month, 2 months, 3 months, etc (all the way to the maximum number of months - based on the first month of activity until the present - somewhere around five years and growing).

Another report is to show which customers are new and which left in any given month. This report will simply check if the customer has activity in the previous month - if yes, they are not new, if no, they are new. Then vice versa - for each customer that has activity in last month, do they also have activity in this month - if no, they are considered "dropped" for this month.

To answer this question, please provide a working solution for the first report (not as a report - it should be either SQL or VBA). It'd be nice to have a working solution for the second as well, but I can always split that into a second question.

Please accept my sincerest thanks in advance for considering this challenge and working with me on it. I truly appreciate the hard work, time and effort all the Experts on this site put in.
Comment
Watch Question
This problem has been solved!
Unlock 3 Answers and 62 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE