Service Now Ticket CTA and Reporting

  • 1
  • Question
  • Updated 1 month ago
  • Answered
 Hi there, 

I hope your summer is going well. 

I am trying to figure out the best way on how to do the following:

We import a data file to Gainsight every Monday with a list of open service now tickets.

The account name for each ticket appears either in the “account” field or the “short description field”.

a. We would need a CTA that would trigger with an email notification to certain recipients to notify when the number of tickets on the weekly service now file for one specific account (account X) is greater than zero.

   OR

b.  We would need an automated report to run every week to display the open tickets for a specific account and send an automated email to certain recipients as an alert.

I'm happy to talk offline on how I can proceed with this.

Thank you in advance,

Jasmine



Photo of Jasmine

Jasmine

  • 394 Points 250 badge 2x thumb

Posted 1 month ago

  • 1
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,788 Points 1k badge 2x thumb
Hey Jasmine!  Both of your options would be doable.  

Does your MDA/CSV also contain the SFDC Account ID of the Account?  If not, you'll need to write a rule to write the SFDC Account ID to the associated Account Name in the MDA object (Assuming they match).  

Within the MDA Object schema, you'll need to add the "Account ID" field of type "SFDC ID" and map it to the Account ID on the Account object in SFDC.  This will allow you to target this MDA object with the rules engine and trigger CTAs and/or JO programs for any thresholds (number, priority or age) that are met.

Let me know if you have any questions on the above and we can jump on a call?  Thanks and good luck!

Tim
Photo of Jasmine

Jasmine

  • 394 Points 250 badge 2x thumb
Hi Tim,

The CSV file contains the SFDC Account ID.
I am happy to jump on a call with you after 2pm today?

Thanks,
Jasmine