Skip to main content
Solved

Conditional Reports in CoPilot Emails


elizabeth_adams_c593ee
Forum|alt.badge.img
Hi - We are putting together a monthly utilization report for our clients. We have multiple products that clients could be using and we want to include the relevant report based on the products listed in their SFDC record. I tried including the varied reports in a single email, but the report shows a flat line if the account doesn't have that product.

I also looked at the segmentation functionality. Unfortunately, that would only work well if the clients have one product or another. However, there are many different combinations and even if I could build out the number of 'variant' templates to meet our needs, I'm not sure how we could get the criteria to match exactly.

What we really need is for the segmentation to behave more like tokens. Include this segment when this condition is met and so forth. Is that something that's a possibility?

If not, is there a way to make the report visible only if a condition in an SFDC field is met?

Thanks!

Best answer by dan_ahrens

Very interesting idea, Elizabeth!

Sounds similar in concept to what is being discussed in this thread: https://community.gainsight.com/gainsight/topics/conditions-in-email-template
View original
Did you find this topic helpful?

7 replies

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • Answer
  • April 19, 2017
Very interesting idea, Elizabeth!

Sounds similar in concept to what is being discussed in this thread: https://community.gainsight.com/gainsight/topics/conditions-in-email-template

elizabeth_adams_c593ee
Forum|alt.badge.img
It is! I even commented on that one.  I have short-term rememory loss . . . . :)


elizabeth_adams_c593ee
Forum|alt.badge.img
In the meantime, Dan. Any ideas how I can make the report visible only if there's data?

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • April 20, 2017
Hi Elizabeth. So here's a thought - you could use the Email Variant feature to do this. Basically use that SFDC condition as your variant trigger and have two versions of the CoPilot template - one that has the report (if the condition is met) and a second variant that does not have the report (for when the condition is not met). 

Would this accomplish what you were trying to do?

elizabeth_adams_c593ee
Forum|alt.badge.img
Unfortunately, the variant feature really isn't flexible enough for us. As I mentioned, we have multiple products so it's not just a simple matter of on or off. We would have to have a separate template for every possible combination and I don't think the variant criteria in the outreach will support that level of complexity. Is there any other way to accomplish this goal?

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • April 20, 2017
That's the only way I'm aware of, but maybe one of our product folks will chime in and share either another creative approach or perhaps an idea related to roadmap future functionality.

elizabeth_adams_c593ee
Forum|alt.badge.img
Thanks, Dan. This is a big initiative for us so all ideas are welcome!

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