Skip to main content
Question

Creating Reports that help show % of Account Portfolio with Success Plans


samantha_braastad
Forum|alt.badge.img+1
Our team would like to be able to see the % of their portfolio that has an existing success plan to help gauge their level of engagement with their portfolio as a whole. For example, Sara owns 20 account, 15 have active success plans (75% of portfolio) and 5 have non (25% of portfolio). Is it possible to do this? 

6 replies

heather_hansen
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 954 replies
  • May 6, 2016
Hi Samantha,

I was able to accomplish this by creating a check box field on the Customer Info object called Active Success Plan, and then, I wrote a rule to check the box when there was an active Success Plan. I was then able to build reporting to show total accounts assigned to CSM and a true/false value based on whether or not they had an active plan.

lila_meyer
Forum|alt.badge.img+5
  • Gainsight Employee ⭐️⭐️⭐️
  • 1447 replies
  • May 9, 2016
Samantha, you can also find more info on how to report on Success Plans here:

https://support.gainsight.com/hc/en-us/articles/216458907

samantha_braastad
Forum|alt.badge.img+1
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 229 replies
  • May 11, 2016
Thanks Heather! I am a bit of a newbie. How do you add a check box field to the Customer Info object? 

  • Helper ⭐️
  • 24 replies
  • November 3, 2022

Is it possible to find accounts with or without Success Plans without changing anything on the Customer info object?


saltamash
Forum|alt.badge.img+8
  • Helper ⭐️⭐️
  • 65 replies
  • November 4, 2022

@SaifSN You can’t report on absence of data so this needs a custom solution.

 

Two ways you can do this is to have a checkbox on Company object and then build a rule on success plan object. If any company has a success plan then you can check the box and similarly for companies without success plan, the box remains unchecked.

The other way is to build a data designer and in first fetch, bring all records from company and in 2nd fetch bring the data from success plans. Use left outer join in your merge and you’ll now have visibility into the accounts that do not have a success plan.


  • Helper ⭐️
  • 24 replies
  • November 7, 2022

@saltamash, thank you.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings