Solved

Identify most recently triggered CTA by account

  • 19 April 2019
  • 7 replies
  • 93 views

Userlevel 7
Badge +3
I've been wracking my brain - and even reached out to GS support - to try and figure out if it's possible to identify the most recently triggered CTA per account, retrieve to whom that CTA was assigned, and use that to trigger subsequent CTAs to the same individual. This is in an attempt to trigger CTAs to our "pooled" team of CSMs covering our long tail accounts.



I can certainly pull by MIN Created Date, but of course any additional Show Me fields I add breaks down the list by those values (i.e. if I add Assignee, it will give me MIN Created Date BY Assignee). So I thought I could pull in the MAX CTA ID and then use that to map to another dataset task containing the CTA details I need for the subsequent CTA triggers. But apparently the CTA IDs are not created in an incremental fashion, because on some accounts it kept pulling a CTA that was NOT the most recently triggered CTA:







So putting this out there - anyone know if it's possible to do what I'm trying to do?



1. Retrieve most recently created CTA



2. Identify the Assignee ID for the most recently created CTA



3. Trigger a new CTA to that Assignee ID


icon

Best answer by jeffrey_coleman 19 April 2019, 17:23

View original

7 replies

Userlevel 7
Badge +3
@joseph_siudzinski do you know off the top of your head?


Badge
Jeff — I think you can achieve this with a bionic rule... first get all the relevant CTAs and the data you need, including the create date. Best if you can filter to a reasonable time period like the past 90 days or something, just to avoid a totally massive result set.



Transform that result, grouping by account and selecting the max date.



Now merge those two files based on the date, keeping all records from the “max date” file (which I usually put on the left.) Select whatever data you need from the right file. That should give you all the details for the most recent CTA.



You may consider running that rule daily or weekly and then storing the CSM ID back to a field on Customer Info so that you can then quickly grab it for use in whatever rule is triggering the new CTA.



Hope that helps!


Userlevel 7
Badge +2
Hi Jeff,



What you need to do is two data fetch tasks. First one to find the most recent CTA per account, fetching just the account name and MAX of created date (and no other fields). Second fetch is all of the CTA details like assignee, etc. Then merge those two fetches.



This thread has a similar use case as well: https://community.gainsight.com/conversations/bionic-rule-help-5cb640eae4b07807d83ebc0d


Userlevel 7
Badge +3
I feel like I tried doing that but it still didn't pull the correct CTA. I'll give it another shot. Maybe I made a mistake. Thanks!


Userlevel 7
Badge +2
Also keep in mind that MIN on a date field will give you the oldest record and MAX will give you the newest record. It's easy to confuse date with age. ;-)


Userlevel 7
Badge +3
Yeah thanks for the reminder. I admit I get those confused because I don't use them that frequently. What you stated above is how I've always known it to work, but I confused myself because an account had a more recently created CTA but it was Manual and I'm looking for Source = Rules.


Userlevel 7
Badge +2
Jeff Coleman's idea would work too, but I just find it easier to do two fetch tasks instead of a fetch and a transform.


Reply