Skip to main content
jaw
jaw
Contributor ⭐️⭐️⭐️⭐️⭐️
August 17, 2018
Question

Service Now Ticket CTA and Reporting

  • August 17, 2018
  • 2 replies
  • 68 views
 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 😵 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

    2 replies

    tim_schukar
    tim_schukar
    Helper ⭐️⭐️⭐️
    August 17, 2018
    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
      jaw
      jawAuthor
      Contributor ⭐️⭐️⭐️⭐️⭐️
      August 17, 2018
      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
      Terms & ConditionsAccessibility statement