Skip to main content
darkknight
darkknight
Expert ⭐️
October 4, 2019
Solved

Map Timeline Activities back to CTA

  • October 4, 2019
  • 5 replies
  • 189 views
As we continue to analyze how our end users are using Gainsight to look for areas of improvement, we've run into a need to be able to extract a mapping of Timeline Activities that were created via a CTA back to the CTA from which it originated.

In looking at the Activity Timeline object, I have the Source field which tells me it came through a CTA but I don't see a lookup to the Call to Action object. I don't see any connection in the reverse, either.

Is there a way to produce such an extract via Report Builder or Rules Engine?

    Best answer by spencer_engel
    Hi Jeff - there is a field called "Context ID" on the Activity Timeline object that contains the CTA ID (assuming the Timeline entry is associated with a CTA). https://support.gainsight.com/SFDC_Edition/Administration_and_Permissions/General_Administration/Timeline_Module_Objects

    5 replies

    spencer_engel
    spencer_engelAnswer
    Expert ⭐️
    October 4, 2019
    Hi Jeff - there is a field called "Context ID" on the Activity Timeline object that contains the CTA ID (assuming the Timeline entry is associated with a CTA). https://support.gainsight.com/SFDC_Edition/Administration_and_Permissions/General_Administration/Timeline_Module_Objects

      darkknight
      darkknightAuthor
      Expert ⭐️
      October 4, 2019
      Thanks Spencer. if i had just dug a little deeper! 🙂

      And it looks like Source does NOT identify CTA so I was wrong on that point. Appreciate the clarification!

      Jeff Kirkpatrick
      J
      jochle
      Contributor ⭐️⭐️⭐️⭐️⭐️
      September 28, 2020

      I cannot create a lookup on context ID because the Activity Timeline is a standard object. Is it possible for your product team to implement this look up? 

      Is there a better way to get this information?

      We are trying to look at activities tied to Onboarding CTAs. Without a look up we would have to do some data mashing to try and derive this information.

      jean.nairon
      jean.nairon
      Expert ⭐️
      September 29, 2020

      Context ID holds the ID to the CTA record. You are correct, it’s not a lookup field, it’s a string. If GS can change it to a lookup, that would most likely be the easiest solution. But in the meantime, hope the below info helps. 

      You can use Data Designer to bring the two tables together (Timeline Activity and Call to Action). Data Designer allows you to merge tables into a single table for reporting. In this case, you’re looking to merge Activities with CTAs via the Context ID (which is the CTA’s GSID). 

      If you use this data, you’ll see there’s multiple Context types. You’ll want to filter down to Context Name = CTA. 

       

      Hope this helps address your solution. Let me know if you run into any challenges.

      Jean
        J
        jochle
        Contributor ⭐️⭐️⭐️⭐️⭐️
        September 29, 2020

        Jean - based on our findings I had implemented that as the alternative solution. As you mentioned, it would be nice to not have to create a custom space for a singular purpose.

        Terms & ConditionsAccessibility statement