Awesome survey tools

[Craig Corfield]

Hi Everyone,

Just thought i would help everyone else out here. Over the past week or so we have been implementing a powerful survey feature to our ticketing system. We have looked at all the surveying tools available and have found the best out there.

Using a survey tool called super simple survey we are able to pipe the data from the ticket closed email as well as the ticket status change email into online surveys for real powerful BI.

As an added bonus we are able to hide all the information into hidden fields so the client simply sees a 4 question survey that is very colourful and engaging.

There are also question rules that allow for certain fields to be displayed given a certain answer. Eg if a customer rates the service as a 4 or below then a hidden field gets displayed asking how we could have improved the service etc.

[Craig Corfield]

Re: Awesome survey tools

Here is what the survey looks like:

[Craig Corfield]

Re: Awesome survey tools

Here is what the email to the client looks like:
-----------------------------







-----------------------------
And yes the piping does work so whatever the customer clicks on (eg 7) then that data is already filled in on the survey.

You can do very awesome stuff with CommitCRM! We are starting to integrate this and a lot more into Power BI which is giving incredible results!

Will keep everyone posted.

[Support Team]

Re: Awesome survey tools

This looks awesome, thanks for sharing.
(screenshots were moved inline).

[Craig Corfield]

Re: Awesome survey tools

Hi Commit, please advise how best to embed the image? I want to add the power BI dashboard to this thread as that the real power of the surveys.

Thanks

[Support Team]

Re: Awesome survey tools

You can attach the image to your post and we then update it and replace it with the inline image.
You can also email us the image and we will upload it to the forum.

[Craig Corfield]

Re: Awesome survey tools



This is the result using Power Bi to get a fully interactive dashboard

[lpopejoy]

Re: Awesome survey tools

Craig, great work!

How well do those circles with #'s come through? (As in are they images or just HTML code)

We did something similar with the CommitCRM API and update a field back in commitCRM - but I like what you did with the email. Looks sharp!

[Craig Corfield]

Re: Awesome survey tools

Hi Luke,

Thanks. The numbers are images each with their own piping code so that the user doesnt have to fill that detail out again. They are highly compressed (1KB each) so each mail has loaded the images without any problem so far. Have you done an html code like this before?

I would suggest putting the data back in CommitCRM in a field but we are still working on the Power Bi integration into the Advantage database. you know 32 bit ODBC connection doesnt play well with 64 bit Power BI and 32 bit Power BI just has endless problems with memory so thats a bit of a tricky one so once we have that sorted i think the data going back into a field in CommitCRM with Power Bi reporting on it would be incredible!!!

[lpopejoy]

Re: Awesome survey tools

Craig,

The problem with images (IMO) is that they are typically blocked unless you do a base64 incode and send it as part of the email - which I have not been able to do with the CommitCRM Email Templates.

We currently follow the same approach but just use HTML links. That then hits a PHP script that send an XML email that updates a custom field in CommitCRM with the score.

That then redirects the users to a more robust survey form as well.

We've had about 5000 tickets get scored this way so far - it's incredibly helpful.

But I like the way you've extended this with PowerBI. You just gave me some more work to do. :)

[Craig Corfield]

Re: Awesome survey tools

Hi Luke,

Fully agree with the image problem. It does seem to be working but agree that the html coding in the email for the numbers is the right way to go.

Using Power BI to pull the data from your custom fields in CommitCRM can be a bit of a mission, especially if you on a older database. Would love to see what you come up with so please post a pic when you manage to get it all together :)

Out of curiosity did you manage to make numbers with a background colour using pure html? Never done it with pure html before, with css it would be easy but pure html circle number would be incredibly "challenging"

[lpopejoy]

Re: Awesome survey tools

Hey Craig, here's a pic of what our ticket survey looks like:

[lpopejoy]

Re: Awesome survey tools

...so to answer your question, yes, it is "pure html", but no circles. I was too lazy to figure that out, plus unsure of how it would render across different platforms.

I can share the email template with you if you would like.

The way we have it setup, as soon as someone clicks the link, it grades the ticket (saved in CommitCRM) instantly. From there, the additional survey questions get saved in a a Google Spreadsheet.

[lpopejoy]

Re: Awesome survey tools

I then wrote a dashboard to graph this out (but Power BI would be easier probably...)

[nattivillin]

Re: Awesome survey tools

How would a novice utilize something like this?