Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I export the customer satisfaction report in Jira to excel?

I need to be able to export the customer satisfaction report in Jira Service Desk to excel. I have tried in my dashboard and in confluence to create a custom report but nothing pulls in the satisfaction or the customer comments. Please help!

10 answers

Satisfaction can be exported as to native "number" type fields with the Better Excel Exporter app.

In fact, the apps supports all the Service Desk specific custom field types, like Customer Request Type, Organizations, Request Participants, Satisfaction, SLA to Excel, and so on.

UPDATE ON 13 MAY 2020

We release Better Excel Exporter 5.3.0 just recently. Among other improvements, it can export customer satisfaction comment together with the numerical rating value!

See: https://midori-global.com/products/better-excel-exporter-for-jira/server/documentation/integrations/jira-service-desk#configuring-satisfaction

Also, see column F in this example:

jira-service-desk-tickets-with-customer-satisfaction

(Disclaimer: I am one of the developers of the app. It is paid and supported.)

Hi Aron,

How do I export the satisfaction report from the Service Desk for the past 14 days (for example)?  I would like all the fields from this report; Comment, rating, key, agent, received.  Also the average rating, and number of user reviews.

I see the Export option when in Queues, but not when in Reports.  Have I missed a setup step?

As you noticed, the Better PDF Export functionality is available via the queue screen, but not via reports.

Via any screen, the app is trying to export issues, which means that your question comes down to this: which issues have its satisfaction data updated in the last 14 days?

I'm not sure if you can get that dataset via JQL, but you could use this to get all issues to the Issue Navigator, which were updated in that period:

"updated > -14d"

Having this you could write a little Groovy script that returns the satisfaction data (those fields that you listed) from the passed issues, and put those to a worksheet.

Average rating and number of reviews can be derived from this source data using Excel formulas.

Thanks Aron. It seems that the Better Excel Export functionality doesn't export the Customer Satisfaction data "out of the box" either. A jql query can be used to obtain the ratings in Issue Search, but not the comments, and these contain the information that helps us address customer needs, and improve our quality of service.

Unfortunately, I don't have the skill set to write a little Groovy script. Hopefully, given that the Midori team has those skills, and can see that this feature is wanted, they can write one and add it to the features list for those of us who use this product.

It could be that one extra feature that encourages other Jira Users to also purchase your product. :)

Like Ira Chandler likes this

It can export satisfaction, just select that field in the Issue Navigator view and it will be exported as an Excel column with numbers. As these are number, you will be able to calculate average, min, max, etc.

See the doc:

You can export the Jira Service Desk-managed custom field types, like Customer Request Type, Organizations, Request Participants, Satisfaction, SLA to Excel.

You are correct Aron, it can export the Satisfaction field. That is not the problem.

Users are looking for a way to export the Customer Satisfaction report as a whole, including the comments that go along with the Satisfaction rating, and without having to work out calculations for ourselves, given Jira calculates and displays that data already.

Like Levente Szabo _Midori_ likes this

Exactly, Nicole.

Likely all people with experience using any ITSM tool over the past decade are going to be somewhat familiar with the concept of having to massage data in Excel to get certain metrics. It's expected when it's a "less than standard" report or data point that might not appear on a standard dashboard and wouldn't be calculated within an out-of-the-box product.

I think people are getting stuck on - first,  how much manual work it takes to export this data without a filter, and then RE-DO what is already being shown within that filter outside of the platform. I guess my feeling on that is - if it's too much work to make an export replace 1-5 "star icons" with the 1-5 numeric value those stars add up to, then don't use STARS and just put the survey at 1-5! Look at any basic survey tool for guidance.

Also, not being able to easily sort and share comments for the agents or service owners they are intended for, likely means managers are not timely in sharing the feedback that isn't actionable (which usually means not great). If we are asking customers for feedback on our value and service delivery, we should be able to quickly and easily get those comments visible to the stakeholders who should see them and the agents who earned them. 

So, @Aron Gombas _Midori_ , your app CANNOT export the Satisfaction COMMENTS, is what I am getting here.  Am I right?
I also tried to make a queue, it IT cannot display those comments either.
Would have licensed you app JUST to get this, but I guess not...
The disappointment mounts.

[edited for tone violations]

Although satisfaction comments are not available as a Jira custom field, our Better Excel Exporter can export any piece of information that can be accessed via the Jira object graph even if those are not actually custom field values.

And, I am 90% sure that satisfaction comments can be accessed that way.

If you are interested, please open a ticket in our ticketing system with your specific requirements.

Like Monique vdB likes this
Monique vdB Community Manager Jan 14, 2020

@Ira Chandler please review our voice and tone guide@Aron Gombas _Midori_ is trying to work with you to solve your use case, please respond with fewer ALL CAPS and more civility or your account may be suspended or banned. Thank you. 

Yes, Aron is trying to help with that.

But, Atlassian's reliance on third parties for rudimentary functionality, and refusal to fix long-standing BLOCKING issues (TOC in Confluence n JSD) is hideous and embarrassing.

I am done here.

Like # people like this

Guys, we took this request seriously. We released a new version of the Better Excel Exporter app some days ago, and now it is able to export also the customer satisfaction comment! (I updated my answer above.)

Does it solve your use case now?

Hi Aron,

Thanks to Midori for addressing this problem!

I have set the def value to true as outlined in the release notes in the field-helper-tool.groovy template.  However, I am still not receiving comments when I do a simple jql query which includes the Satisfaction field in the columns, and then run a csv extract. Should I see the comments here, or do I need to build/update a template in addition to the field-helper-tool.groovy template?

In your screenshot it looks like you made a specific template to demonstrate how this works successfully.  Can you provide a copy of this "jira-service-desk-tickets-with-satisfaction.xlsx" template so I can see what is behind it.  Thanks

@Nicole Downes If you upgraded the field-helper script, it should be sufficient. Also, there is a required minimum Service Desk version number...

Please open a ticket and we will make sure you can start using it.

@Aron Gombas _Midori_ Is there a Cloud version on the horizon any time soon? I've got a customer that also wants to export the comments.

Or is the better pdf exporter able to do this?

@Rudy Holtkamp  Better Excel Exporter is not available for Jira Cloud yet.

We could, probably, implement this to Better PDF Exporter for Jira Cloud assuming that the Jira REST API returns the comment part, too.

Would that be working for you?

Well, it does not return the data as a custom field, like satisfaction rate, satisfaction date. 

Unless I'm mistaken Jira is capturing all details (rate, comment, date, submitter) in the same (single) custom field.

So, the question is not whether these are returned as separate custom field values (unlikely), but if all details are returned in that single well-formatted JSON custom field value?

If the answer is yes, then we can add it to Better PDF Exporter.

I think you are mistaken (and if not please explain to me where I can find it).

 

I've an issue where I can see this in the UI for satisfaction:

2020-06-08 16_31_39-Clipboard.png

If I look at the REST API output of this issue I see this:

...

"customfield_10028": {"rating": 4},"

customfield_10029": "2020-06-04T10:13:57.028+0200",

...

 

These custom fields are the satisfaction fields, but there is no field to be found where the comment should be in.

{
"expand": "renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations,customfield_10051.properties,customfield_10052.properties",
"id": "10196",
"self": "https://company.atlassian.net/rest/api/latest/issue/10196",
"key": "DEMO-29",
"fields": {
"statuscategorychangedate": "2020-06-04T10:07:39.025+0200",
"customfield_10070": null,
"customfield_10071": null,
"customfield_10072": null,
"customfield_10073": null,
"customfield_10074": null,
"customfield_10075": null,
"customfield_10076": null,
"customfield_10077": null,
"fixVersions": [],
"customfield_10078": null,
"customfield_10079": null,
"resolution": {
"self": "https://company.atlassian.net/rest/api/2/resolution/10000",
"id": "10000",
"description": "Work has been completed on this issue.",
"name": "Done"
},
"customfield_10104": null,
"customfield_10105": "Got another comment about this.",
"customfield_10106": null,
"customfield_10107": null,
"lastViewed": "2020-06-08T16:28:32.364+0200",
"customfield_10060": null,
"customfield_10061": null,
"customfield_10062": null,
"customfield_10063": null,
"customfield_10064": null,
"customfield_10065": null,
"customfield_10066": null,
"customfield_10067": null,
"customfield_10100": null,
"priority": {
"self": "https://company.atlassian.net/rest/api/2/priority/10005",
"iconUrl": "https://company.atlassian.net/images/icons/priorities/blocker.svg",
"name": "Blocker",
"id": "10005"
},
"customfield_10068": null,
"customfield_10101": null,
"customfield_10069": null,
"customfield_10102": null,
"customfield_10103": null,
"labels": [],
"aggregatetimeoriginalestimate": null,
"timeestimate": null,
"versions": [],
"issuelinks": [],
"assignee": {
"self": "https://company.atlassian.net/rest/api/2/user?accountId=557058%3Afbbb56de-c97c-4b68-8216-2e193b8dffdc",
"accountId": "557058:fbbb56de-c97c-4b68-8216-2e193b8dffdc",
"emailAddress": "company.-@example.com",
"avatarUrls": {
"48x48": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"24x24": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"16x16": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"32x32": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png"
},
"displayName": "company - [TMC]",
"active": true,
"timeZone": "Europe/Amsterdam",
"accountType": "atlassian"
},
"status": {
"self": "https://company.atlassian.net/rest/api/2/status/5",
"description": "A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.",
"iconUrl": "https://company.atlassian.net/images/icons/statuses/resolved.png",
"name": "Resolved",
"id": "5",
"statusCategory": {
"self": "https://company.atlassian.net/rest/api/2/statuscategory/3",
"id": 3,
"key": "done",
"colorName": "green",
"name": "Done"
}
},
"components": [
{
"self": "https://company.atlassian.net/rest/api/2/component/10000",
"id": "10000",
"name": "Jira",
"description": "Issues related to Jira. Created by Jira Service Desk."
}
],
"customfield_10050": null,
"customfield_10051": null,
"customfield_10052": null,
"customfield_10053": null,
"customfield_10054": null,
"customfield_10055": null,
"customfield_10056": "test",
"customfield_10057": {
"id": "3",
"name": "Time waiting for customers",
"_links": {
"self": "https://company.atlassian.net/rest/servicedeskapi/request/10196/sla/3"
},
"completedCycles": []
},
"customfield_10058": null,
"customfield_10059": null,
"customfield_10049": null,
"aggregatetimeestimate": null,
"creator": {
"self": "https://company.atlassian.net/rest/api/2/user?accountId=qm%3A2c421332-8d04-4e4b-8f82-6be557c04636%3A416c16ed-436c-421d-9ad3-6ccec5512f62",
"accountId": "qm:2c421332-8d04-4e4b-8f82-6be557c04636:416c16ed-436c-421d-9ad3-6ccec5512f62",
"emailAddress": "company-@hotmail.com",
"avatarUrls": {
"48x48": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/default-avatar.png",
"24x24": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/default-avatar.png",
"16x16": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/default-avatar.png",
"32x32": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/default-avatar.png"
},
"displayName": "company 4",
"active": true,
"timeZone": "Europe/Amsterdam",
"accountType": "customer"
},
"subtasks": [],
"customfield_10040": null,
"customfield_10041": null,
"customfield_10042": {
"self": "https://company.atlassian.net/rest/api/2/customFieldOption/10039",
"value": "Outside",
"id": "10039"
},
"customfield_10043": null,
"reporter": {
"self": "https://company.atlassian.net/rest/api/2/user?accountId=5e300b4ce504e30cabd38652",
"accountId": "5e300b4ce504e30cabd38652",
"avatarUrls": {
"48x48": "https://secure.gravatar.com/avatar/468fcdbc197e211dac89bff976d2217e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FR-2.png",
"24x24": "https://secure.gravatar.com/avatar/468fcdbc197e211dac89bff976d2217e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FR-2.png",
"16x16": "https://secure.gravatar.com/avatar/468fcdbc197e211dac89bff976d2217e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FR-2.png",
"32x32": "https://secure.gravatar.com/avatar/468fcdbc197e211dac89bff976d2217e?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FR-2.png"
},
"displayName": "company-+company.atlassian.net",
"active": true,
"timeZone": "Europe/Amsterdam",
"accountType": "atlassian"
},
"aggregateprogress": {
"progress": 0,
"total": 0
},
"customfield_10044": null,
"customfield_10045": null,
"customfield_10048": null,
"customfield_10038": null,
"customfield_10039": "teste",
"progress": {
"progress": 0,
"total": 0
},
"votes": {
"self": "https://company.atlassian.net/rest/api/2/issue/DEMO-29/votes",
"votes": 0,
"hasVoted": false
},
"worklog": {
"startAt": 0,
"maxResults": 20,
"total": 0,
"worklogs": []
},
"issuetype": {
"self": "https://company.atlassian.net/rest/api/2/issuetype/10005",
"id": "10005",
"description": "An IT problem or question.",
"iconUrl": "https://company.atlassian.net/secure/viewavatar?size=medium&avatarId=10512&avatarType=issuetype",
"name": "IT Help",
"subtask": false,
"avatarId": 10512
},
"timespent": null,
"customfield_10030": null,
"customfield_10031": {
"id": "1",
"name": "Time to resolution",
"_links": {
"self": "https://company.atlassian.net/rest/servicedeskapi/request/10196/sla/1"
},
"completedCycles": [
{
"startTime": {
"iso8601": "2020-05-19T13:36:21+0200",
"jira": "2020-05-19T13:36:21.763+0200",
"friendly": "19/May/20 1:36 PM",
"epochMillis": 1589888181763
},
"stopTime": {
"iso8601": "2020-06-04T10:07:39+0200",
"jira": "2020-06-04T10:07:39.077+0200",
"friendly": "Thursday 10:07 AM",
"epochMillis": 1591258059077
},
"breached": true,
"goalDuration": {
"millis": 57600000,
"friendly": "16h"
},
"elapsedTime": {
"millis": 333077314,
"friendly": "92h 31m"
},
"remainingTime": {
"millis": -275477314,
"friendly": "-76h 31m"
}
}
]
},
"project": {
"self": "https://company.atlassian.net/rest/api/2/project/10001",
"id": "10001",
"key": "DEMO",
"name": "Demo service desk",
"projectTypeKey": "service_desk",
"simplified": false,
"avatarUrls": {
"48x48": "https://company.atlassian.net/secure/projectavatar?pid=10001&avatarId=10420",
"24x24": "https://company.atlassian.net/secure/projectavatar?size=small&s=small&pid=10001&avatarId=10420",
"16x16": "https://company.atlassian.net/secure/projectavatar?size=xsmall&s=xsmall&pid=10001&avatarId=10420",
"32x32": "https://company.atlassian.net/secure/projectavatar?size=medium&s=medium&pid=10001&avatarId=10420"
}
},
"customfield_10032": {
"id": "2",
"name": "Time to first response",
"_links": {
"self": "https://company.atlassian.net/rest/servicedeskapi/request/10196/sla/2"
},
"completedCycles": [
{
"startTime": {
"iso8601": "2020-05-19T13:36:21+0200",
"jira": "2020-05-19T13:36:21.763+0200",
"friendly": "19/May/20 1:36 PM",
"epochMillis": 1589888181763
},
"stopTime": {
"iso8601": "2020-06-04T10:07:39+0200",
"jira": "2020-06-04T10:07:39.077+0200",
"friendly": "Thursday 10:07 AM",
"epochMillis": 1591258059077
},
"breached": true,
"goalDuration": {
"millis": 28800000,
"friendly": "8h"
},
"elapsedTime": {
"millis": 333077314,
"friendly": "92h 31m"
},
"remainingTime": {
"millis": -304277314,
"friendly": "-84h 31m"
}
}
]
},
"customfield_10033": {
"languageCode": "en",
"displayName": "English"
},
"aggregatetimespent": null,
"customfield_10034": null,
"customfield_10035": null,
"customfield_10036": null,
"customfield_10037": null,
"customfield_10027": [],
"customfield_10028": {
"rating": 4
},
"customfield_10029": "2020-06-04T10:13:57.028+0200",
"resolutiondate": "2020-06-04T10:07:39.013+0200",
"workratio": -1,
"watches": {
"self": "https://company.atlassian.net/rest/api/2/issue/DEMO-29/watchers",
"watchCount": 0,
"isWatching": false
},
"created": "2020-05-19T13:36:21.763+0200",
"customfield_10020": null,
"customfield_10021": null,
"customfield_10022": "2020-05-19T13:36:22.593+0200",
"customfield_10023": "3_*:*_1_*:*_7419_*|*_5_*:*_1_*:*_0_*|*_10003_*:*_1_*:*_1369869895",
"customfield_10016": null,
"customfield_10017": null,
"customfield_10018": {
"hasEpicLinkFieldDependency": false,
"showField": false,
"nonEditableReason": {
"reason": "PLUGIN_LICENSE_ERROR",
"message": "The Parent Link is only available to Jira Premium users."
}
},
"customfield_10019": "0|i003mq:",
"updated": "2020-06-04T10:14:00.442+0200",
"customfield_10090": null,
"customfield_10091": null,
"customfield_10092": null,
"customfield_10093": null,
"customfield_10094": null,
"customfield_10095": null,
"timeoriginalestimate": null,
"customfield_10096": null,
"customfield_10097": null,
"description": "test",
"customfield_10010": {
"_links": {
"jiraRest": "https://company.atlassian.net/rest/api/2/issue/10196",
"web": "https://company.atlassian.net/servicedesk/customer/portal/1/DEMO-29",
"self": "https://company.atlassian.net/rest/servicedeskapi/request/10196"
},
"requestType": {
"_expands": [
"field"
],
"id": "1",
"_links": {
"self": "https://company.atlassian.net/rest/servicedeskapi/servicedesk/1/requesttype/1"
},
"name": "IT help",
"description": "Get general tech support, like help with the Wi-Fi or printing.",
"helpText": "Hier wat info -bla-bla-bla",
"issueTypeId": "10005",
"serviceDeskId": "1",
"groupIds": [
"1",
"2"
],
"icon": {
"id": "10491",
"_links": {
"iconUrls": {
"48x48": "https://company.atlassian.net/secure/viewavatar?avatarType=SD_REQTYPE&avatarId=10491&size=large",
"24x24": "https://company.atlassian.net/secure/viewavatar?avatarType=SD_REQTYPE&avatarId=10491&size=small",
"16x16": "https://company.atlassian.net/secure/viewavatar?avatarType=SD_REQTYPE&avatarId=10491&size=xsmall",
"32x32": "https://company.atlassian.net/secure/viewavatar?avatarType=SD_REQTYPE&avatarId=10491&size=medium"
}
}
}
},
"currentStatus": {
"status": "Resolved",
"statusCategory": "DONE",
"statusDate": {
"iso8601": "2020-05-19T13:36:21+0200",
"jira": "2020-05-19T13:36:21.763+0200",
"friendly": "19/May/20 1:36 PM",
"epochMillis": 1589888181763
}
}
},
"customfield_10098": null,
"customfield_10099": null,
"customfield_10014": null,
"customfield_10015": null,
"timetracking": {},
"customfield_10005": null,
"customfield_10006": null,
"security": null,
"customfield_10007": null,
"customfield_10008": null,
"customfield_10009": null,
"attachment": [],
"summary": "test",
"customfield_10080": null,
"customfield_10081": null,
"customfield_10082": null,
"customfield_10083": null,
"customfield_10084": null,
"customfield_10085": null,
"customfield_10086": null,
"customfield_10087": null,
"customfield_10000": "{}",
"customfield_10088": null,
"customfield_10089": null,
"customfield_10001": null,
"customfield_10002": [],
"customfield_10003": null,
"customfield_10004": null,
"environment": null,
"duedate": "2020-05-12",
"comment": {
"comments": [
{
"self": "https://company.atlassian.net/rest/api/2/issue/10196/comment/10081",
"id": "10081",
"author": {
"self": "https://company.atlassian.net/rest/api/2/user?accountId=557058%3Afbbb56de-c97c-4b68-8216-2e193b8dffdc",
"accountId": "557058:fbbb56de-c97c-4b68-8216-2e193b8dffdc",
"emailAddress": "company.-@example.com",
"avatarUrls": {
"48x48": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"24x24": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"16x16": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"32x32": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png"
},
"displayName": "company - [TMC]",
"active": true,
"timeZone": "Europe/Amsterdam",
"accountType": "atlassian"
},
"body": "This issue was reported from the portal while the user was not signed into an account.",
"updateAuthor": {
"self": "https://company.atlassian.net/rest/api/2/user?accountId=557058%3Afbbb56de-c97c-4b68-8216-2e193b8dffdc",
"accountId": "557058:fbbb56de-c97c-4b68-8216-2e193b8dffdc",
"emailAddress": "company.-@example.com",
"avatarUrls": {
"48x48": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"24x24": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"16x16": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png",
"32x32": "https://secure.gravatar.com/avatar/933b97e6a36ae8bab74e36d9f462eb79?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-5.png"
},
"displayName": "company - [TMC]",
"active": true,
"timeZone": "Europe/Amsterdam",
"accountType": "atlassian"
},
"created": "2020-05-19T13:36:22.593+0200",
"updated": "2020-05-19T13:36:22.593+0200",
"jsdPublic": false
}
],
"maxResults": 1,
"total": 1,
"startAt": 0
}
}
}

Hi all,

I found a workaround for Cloud and possibly for Server (if you have Automation for Jira installed).

It seems that the CSAT comment is not stored in a custom field, but in a property of the issue. With the REST API call 

https://<company>.atlassian.net/rest/api/2/issue/{{key}}/properties/service-request-feedback-comment

you can retrieve it.

The workaround

What you can do is the following:

1. Create a custom field ‘CSAT comment’ and place it on the correct screen(s)

2. Create an automation rule in Automation for Jira:

3. Trigger: Field value changed: Satisfaction date (Note: don’t use ‘Satisfaction’)
4. Send webrequest:
    URL: https://<company>.atlassian.net/rest/api/2/issue/{{key}}/properties/service-request-feedback-comment
     Headers: Content-Type: application/json
                     Authorization: Basic <your API key>
    Http method: GET
    Webhook body: empty
    Wait for response: check
5. Edit issue fields: CSAT comment: {{webhookResponse.body.value.comment}}

(Note: the API key is built up as follows: Base64(your username: API key, example
user@example.com:ieVYwdSgYG3VauI6vjcT7B00 --> dXNlckBleGFtcGxlLmNvbTppZVZZd2RTZ1lHM1ZhdUk2dmpjVDdCMDA=)

Now you can search in your JQL for CSAT comment and export it to Excel, etc.

Enjoy

Also using Automation for jira, when your instance is in cloud you can use the smart value {{issue.properties.service-request-feedback-comment.comment}} without have to send a webrequest to the API, and directly edit the issue field. 


Also, vote on this Suggestion to get the Customer Comment searchable

https://jira.atlassian.com/browse/JSDSERVER-4317

I just voted above. Thanks for suggestion.

Is this something Atlassian plans on addressing?

I believe you will find very few users who do not expect the ability to export data from these (very basic) reports. 

Exactly.  This is just one of many reasons why I am starting a project to move all of IT away from Jira for ITSM.  We will just leave DEV projects in the scaled down Jira.

Like Jerel Crosland likes this

In some of the normal things, JSD just sucks, and this feature is 1 among of them.

Like Wasim Buden likes this

As usual, HUGE DISAPPOINTMENT with stinking JSD.  We also cannot display TOCs in Confluence docs, and JIRA REFUSES to address it.

They basically have a half-baked turd in this product...

0 votes
Julien Rey Atlassian Team Mar 27, 2018

@Jennifer Burkhart

It is unfortunately not possible with Service Desk out of the box to export the customer satisfaction report.

For now, the only workaround that I can think of (using JIRA built-in functionalities) is to:

  • Go to the issue search
  • Create a JQL filter which looks for issues within a specific project, which has no empty satisfaction (for example: project = SD2 AND Satisfaction is not EMPTY):

SatisfactionFilter.png

  • Click on Export > CSV (Current fields)

 

Due to this bug report https://jira.atlassian.com/browse/JSDSERVER-4334, the CSV export contains unreadable satisfaction data, so you will have to perform the conversion below to convert the value from the export into a 5 star value:

1 = com.atlassian.servicedesk.internal.api.customfields.feedback.RequestFeedbackCFValue@d29c0

2 = com.atlassian.servicedesk.internal.api.customfields.feedback.RequestFeedbackCFValue@d2f19

3 = com.atlassian.servicedesk.internal.api.customfields.feedback.RequestFeedbackCFValue@d3472

4 = com.atlassian.servicedesk.internal.api.customfields.feedback.RequestFeedbackCFValue@d39cb

5 = com.atlassian.servicedesk.internal.api.customfields.feedback.RequestFeedbackCFValue@d3f24

@Julien Rey 

Your company HAS NO RIGHT releasing ANY product UPDATES until they fix existing, long-standing BUGS and DEFICIENCIES.

For example, I cannot display a TOC in a Confluence doc in JSD and YOU REFUSE to address it.  That issue has been around for FOUR YEARS.

We had faith and THOUGHT we were buying a viable product.  Every time we try to use it, we are bit in the butt with more BUGS/DEFICIENCIES that you refuse to fix.

Monique vdB Community Manager Jan 13, 2020

@Ira Chandler I removed one comment that can be considered a personal attack in keeping with our community guidelines. If you have any questions or concerns about this, I'm at communitymanagers@atlassian.com.  

Like Dave Liao likes this

@Monique vdB 

I apologize.

No comments I make are directed at any specific person.  Everyone I have tried to work with has been professional, however totally powerless and of zero help.

My unbridled frustration is directed at the company in general.  

Monique vdB Community Manager Jan 13, 2020

@Ira Chandler no problem, and I'm sorry the product is frustrating you! 

What about comments?  Are comments still not available to export or at least filter on to display on a dashboard?

Like Levente Szabo _Midori_ likes this

Just asking again, how can there still be no way to export comments from surveys? This is the most basic of service desk functionality.

How can this still be an issue?  This is the first thing that management asks for and it is not available?

It's really crazy.

Like # people like this

The implementation of this feature is simply incomplete. It's there, but it's impossible to use beyond their limited vision of it without paying for an add-on. (There is a ScriptRunner solution posted by another community member, but you have to buy ScriptRunner.) But this one is a baby. It's only 3 years old! You will find many such requests as this have been around for 5-8 years. They only fix things that get a lot of votes. So round up all your friends and have them vote!

I forgot to explain how to get the data into Excel (without buying an add-on) now that the "Export to Excel" option is gone and CSV is horrible. This is the state-of-the-art solution given by Atlassian, so we know it's approved.

BTW, the column you must include is a number field called "satisfaction", and that is the only field you get that has anything to do with customer satisfaction. 

How to export data from Jira into Excel:

  1. Do your search. Pick the columns you want in Excel.
  2. Choose "Export to HTML".
  3. Open the HTML file in a browser.
  4. Select-all and copy to your clipboard.
  5. Open Excel and paste. Et voila!

The Satisfaction column will have 5 stars in every cell, but the number of solid black stars is the actual satisfaction rating. Use Excel wizardry to turn those to numbers.

@Jennifer Burkhart 

 

 You can create a custom filter like   project = SD AND Satisfaction > 0 . Add it on a Total cound or any other trend macro and then you can click on the total and export it fine.

 

Thank you

Why is this an issue? This is basic functionality.

It is JIRA.  They do not care.

Note that THEY do not use JSD for JIRA itself.  That should have told me something...

Ira - shouting in all your answers make everyone yawn - not bringing more attention to your answers

With all due respect, your reply contradicts your assertion. 

;-)

We discovered an undocumented API that exposes all that -- but like all undocumented API use at your own risk (SER is our project):

https://xxx.atlassian.net/rest/servicedesk/1/projects/SER/report/feedback/date-range?start=1&limit=100&expand=overall&startDate=2019-02-17&endDate=2020-02-18

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Atlympic Event: Jira Service Managemnt

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

215 views 1 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you