Explore - Reporting CSAT by Date Survey Taken

5 Comments

  • Gentry Geissler
    Comment actions Permalink

    Hi Jason,

    Thanks for that question! It looks like you'll need to use custom metrics under the Ticket Updates dataset to get that data. Basically, we're looking for the satisfaction field value to change from something to good or bad. There are some caveats if ratings changed a lot on the same ticket, because it could potentially return more than one entry per ticket if a user changed their mind on satisfaction. See the screenshot below.

    I hope that helps!

    0
  • Jason D.
    Comment actions Permalink

    Hey Gentry,

    That is a great start and thanks for that, but is there anyway that it can be done in an attribute? Because I use this in my Support: Tickets, Users, Organizations data set to see how the CSAT is doing over time.

    0
  • James Sanford
    Comment actions Permalink

    Hey Jason!

    Please note that you are using a dataset that is not on the most current schema (Support: Tickets, Users, Organizations) and we would recommend following the process outlined in Which datasets use the latest data schema? to make sure you are using a current dataset schema.

    Since you are looking to show this data based on the time of the event it would be necessary to use the Ticket Updates Dataset.  If you wished to make a comparison between these two Queries we would recommend placing both of those on a Dashboard side by side so that you can see those long term trends in relation to the time of the event of those ratings.  Please note that if you are using the Tickets dataset to view the long term trends of this and using a date dimension such as Date Solved then the you are seeing that data based on the Date the Ticket was Solved and not the Date of the Satisfaction Rating event.  You may wish to move your current report over to using the Ticket Updates dataset as well if you wished to review those trends based on the date of the rating as well.

    0
  • Jason D.
    Comment actions Permalink

    Hey James,

    Thanks for this, I have been playing around with this and my question is, is there a way to put Satisfaction Score in combination with CSAT Date Rated metric?

    0
  • James Sanford
    Comment actions Permalink

    Hey Jason!

    Apologies, the Satisfaction Score metric is only available in the Tickets Dataset and is comprised of attributes that are only available to the Tickets Dataset so it is not possible to recreate this within the Ticket Updates Dataset.

     

    0

Please sign in to leave a comment.

Powered by Zendesk