Skip to main content
Solved

How to send an email when sponsor changes company

  • June 10, 2019
  • 2 replies
  • 36 views

tony_tao
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
Hi, I am looking to send an internal email alert when a Sponsor Changes company.

I was hoping to use a program to build this out.

What I am having trouble with is how to build a query that states a change in company as a the indicator for an email.

Does anyone have any advice on how to build this out?

Best answer by dan_ahrens

Hi Tony,

You can also get more information on how to configure this rule via this tutorial: https://support.gainsight.com/View_More_Categories/Sponsor_Tracking/Tutorials/Create_Rule_to_Track_Sponsors

In your example, you'd use the logic in this rule to build a bionic query as a participant source in a Journey Orchestrator program. If you need some help on putting these elements together, your Gainsight Customer Success Manager can help.

2 replies

jagadeesh_kumar_paidimarri
Forum|alt.badge.img
Hi Tony,

Could you try using following filters from SponsorTrackingHistory object ?

Filters:

SponsorTrackingHistory::ChangedAttribute equals title

SponsorTrackingHistory::Created Date greater or equal Add N Days to Rule Date (-1)

SponsorTrackingHistory::Created Date less than Rule Date

SponsorTrackingHistory::ChangedAttribute equals company

SponsorTrackingHistory::ChangedAttribute equals location

Please let me know if this helps.


dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • Answer
  • June 11, 2019
Hi Tony,

You can also get more information on how to configure this rule via this tutorial: https://support.gainsight.com/View_More_Categories/Sponsor_Tracking/Tutorials/Create_Rule_to_Track_Sponsors

In your example, you'd use the logic in this rule to build a bionic query as a participant source in a Journey Orchestrator program. If you need some help on putting these elements together, your Gainsight Customer Success Manager can help.