I got an email from Arne of Empowerment Holdings with a request:

I have a question regarding the statistics for client engagement.

Since we have to report how active all of the coachees are we need to go to client activity and count all action assignments/completions by hand. Is there a possibility to add a feature where we you can list all stats in a certain timeframe for the whole client stock with one click?

That would be great!

A great thing about the record of coaching happenings (that CA naturally accumulates over the course of common use) is that there is a lot of insightful data that can be drawn from later to summarize and analyze things like participation, effectiveness, and ROI.  In this case I could see how the particulars of how many times a given client has done this or that would make a useful report, and one for which CA has all the data.

I sometimes get requests like this, and when I do what’s incredibly helpful is to have a mock up.

So I replied:

Possibly! It would help to have a concrete example of what sort of report would be useful in terms of tabular data.

If you mock something up as an example of what would be genuinely useful as a simple CSV, containing information and/or stats derived from what CA would have available, I’ll see about adding the ability to generate such a report automatically!

Often times when I pose the challenge, more or less to the tune of “sounds promising, please mock it up for me”, I don’t get anything back.  That’s problematic, because that means the idea for the report likely isn’t yet clearly based on a thought out use case, OR that the desired information might not actually be readily known to CoachAccountable (and if all that is clear, lacking a mock up still means I’m likely doing a lot of guesswork to create what would actually serve the need behind the request).

No such issue here.  What Arne gave me back was exactly what I needed, PLUS a little more insight into the desire fueling the request:

Hey John,

Sure, so for our client it’s super interesting to see how active the coachees are. So I could imagine a Report like this to answer the question: How actively engaged was a certain group of coachees during a certain time.

Coaching Report
	Cycle I	Cycle II	Cycle III	Total
# Coaching sessions that have taken place	231
# Coaching time in hours	288,75 h
# Milestones & Goals formulated	276
# Actions formulated	855
# Actions completed	340
# Actions incomplete	515
# Cancelled Coaching sessions	22
# Worksheets assigned	100
# Worksheets completed	60
# Data points added	100
# Metrics added	400

Perfect! Now this I can work with.  The vast world of all possible things that CA tracks (and thus could ostensibly report on) is reduced down to a set clear stats that I am assured would be interesting and worth including, and the insight into why this would be cool at all (“for our client it’s super interesting to see how active the coachees are”) made me excited to cook this up.

You can see the end result in Reports >> Data Lab >> Client Activity:

Lots of data to look at, but no need to feel overwhelmed! You can modify what’s included to get only what’s interesting.

As you can see, it’s not verbatim as suggested.  While building it I realized there were other similar categories of stats that might be interesting, and that breaking it in to sections made it more clear to follow.  I also added flexibility in letting the user choose how the data is broken into columns (either by day, week, month, quarter or year).

This is significant to point out, because it highlights an important fact: we never do programming for feature development to spec for a customer’s request (no matter how big the customer), BUT we very often run with input about what would be useful in order to create something that has the potential to be generally valuable.

Fun fact: while composing the above portions of this blog post this morning I noticed that Arne’s mock up contained a “Total” column, yet that wasn’t in the CA report as originally released last month. So I just spent a little time to add it, as well as the options to include averages and percentage stats.  Do I love my job and feel empowered to act?  You betcha!

When I originally released this I was delighted to hear back:

Thank you so much! This helps us A LOT!!!

Music to my ears: to save an organization time AND help them to better show off the work their doing to the folks that hired them?  That’s a serious double win, and I hope you’ll get similar value from this.

My thanks again to Arne who was thorough enough to illustrate what he was needing… CA is better for everyone because of it!