Skip to main content
sarah_couch
sarah_couch
Contributor ⭐️⭐️⭐️⭐️
March 8, 2016
Question

Trying to create a report to show customers whose last closed CTA was 6 months ago or greater.

  • March 8, 2016
  • 5 replies
  • 96 views
We'd like to report on any customer whose last closed CTA was 6 months ago or greater. We're trying to track customers who have not been "touched" recently. I'm struggling with getting customers whose last closed CTA falls into this timeframe ... I can filter on CTAs where close date meets the criteria but then those customers may additional CTAs closed more recently. Any suggestions are greatly appreciated!

    5 replies

    dave_wu_74b11e
    Gainsight Employee ⭐️
    dave_wu_74b11e
    Gainsight Employee ⭐️
    March 8, 2016
    Sarah - I believe that the best you can do now is "Closed Date" < "Last 120 Days". This will show you any CTAs that were closed more than 120 days ago.

    Additional relative phrases as well as an option for the end-user to choose the numeric portion of the phrase (instead of hardcoded drop-downs) is a great enhancement request.

    Product folks - Is this something already on the roadmap?
    sarah_couch
    sarah_couchAuthor
    Contributor ⭐️⭐️⭐️⭐️
    March 8, 2016
    Hi Dave, thanks for the quick reply. Where I still struggle though is that I only want to see customers whose most recently closed CTA is 120 days or older. I need to get to that point which I still think I cannot do ... 
    dave_wu_74b11e
    Gainsight Employee ⭐️
    dave_wu_74b11e
    Gainsight Employee ⭐️
    March 8, 2016
    I see now. You will need to create a rule that pushes the max CTA Closed Date to a new field on Customer Info. From there, you can use the report filter that looks at the new field to only show accounts < Last 120 days.
      heather_hansen
      heather_hansen
      VIP ⭐️⭐️⭐️⭐️⭐️
      March 8, 2016
      This just came up yesterday with our group too! We have the field in place for a couple of specific CTAs, but good to know we could do something similar with overall CTAs. For instance, we have a field to store the last date a QBR was completed based on when the last QBR CTA was closed. Then, in theory, we could push a CTA to tell the CSM that they haven't done one in x amount of days.
      kristin_f3c469
      kristin_f3c469
      Contributor ⭐️⭐️⭐️⭐️⭐️
      March 8, 2016
      I like Dave's reply. We did something similar to capture the "Last QBR Date" by writing a rule to update a date field with today's date when a CTA for a QBR closed. I have also thought about adding a roll-up summary field to the Customer Object that is a roll-up of the max of CTA Closed Date, but haven't tried it yet.
        Terms & ConditionsAccessibility statement