CiviCRM Community Forums (archive)

The extension does two things

It creates a custom field that asks the question ”Would you recommend membership of this organisation to anyone else”
with  0-10 response scale.
The custom field can be added to profiles or sent out in newsletter and the organisations will obviously get responses.

The second thing the extension does is create a CiviCRM report template.
Basically the template allows Admins to create report instances that can be mailed out, put on a dashboards and so on.
So for example, an organisation might be managing two sorts of memberships, so they will need two report instances, each derived from the master template.

You will see that a membership report normally provides a bunch of columns that are displayed in the results.  We actually need to do some counting, rather than displaying a list of contacts.

From these counts we can calculate the Net Promoter Score.
 
Net Promoter Score calculation.
The calculation gets the percentage from people who respond to the question who responded 0-6 (A)  and the percentage who responded 9-10 (B)
We subtract B from A to get the Net Promoter Score.

We display the Net Promoter Score as the report.

Ive done the easy bit which is to create the extension and the custom fields.

But Im stuck on the hard bit which is the SQL and the output.

Anyone fancy assisting?

If you want more info on Net Promoter Scores, look here

http://www.netpromoter.com/why-net-promoter/know

I should add, I'm not doing this for a particular client, just doing it because I think it's a good thing to have.