Solved

Display a Report in a CTA?

  • 23 November 2020
  • 13 replies
  • 152 views

Userlevel 5
Badge +3

In an effort to not overwhelm a CSM’s cockpit, we are wanting to create a CTA that aggregates survey responses over the previous week. How can I include in the notes a report of the survey response and what they responded?

icon

Best answer by andreammelde 13 January 2021, 16:20

View original

13 replies

Userlevel 7
Badge +2

Hi @andreammelde - how many variables from the survey are you looking to include in the CTA notes? If you pull in the data you want to include in the survey results in the rule setup you can tokenize the comments and have that data represented in the CTA creation step: https://support.gainsight.com/SFDC_Edition/Cockpit_and_Playbooks/Admin_Guides/11_Creating_and_Closing_CTAs_from_Rules_Engine#Creating_CTAs_from_Rules_Engine

Userlevel 5
Badge +3

@dan_ahrens  the thing is we want to aggregate multiple survey responses and detail the email, score, and notes on the CTA. so it’s not just columns to tokenize, but it’s aggregating multiple rows of data.

 

We are sending a survey with a large audience and want to trigger the CTA to fire on Monday for the all the responses received the week prior and list each response. Pivot and then concatenating doesn’t really work for this

Userlevel 5
Badge +3

@dan_ahrens we also want to provide the info in the CTA to limit CSMs having to toggle between reports on the C360 as much as possible

Userlevel 7
Badge +2

This is helpful information, thanks @andreammelde . For the rule that creates the CTA - what is the triggering criteria? Does it fire the CTA on the first survey response or does it wait for a set number of responses or a set amount of time before the CTA is fired? 

The way that CTA comments are structured, you can’t really embed a whole report, but you could look to present the most relevant information in the CTA comments. Short of that, the option you outlined of a section in the C360 with the report and/or a dashboard view with a global filter that would allow the user to select a specific customer or region or other logical grouping to aggregate on. 

Userlevel 5
Badge +3

@dan_ahrens  it would trigger every Monday, and count how many surveys were received the week before. The amount could vary each week

Userlevel 7
Badge +11

@andreammelde would a report-based email template in a JO do the trick? Tabular reports are not supported though, so you may need to try something out, based on the level of detail you’re looking for...

Userlevel 5
Badge +3

it might - but the goal was to hopefully list all the emails so that the CSM could use the email assist task to send a follow up and not have to leave Cockpit as much as possible.

 

We have seen a big drop off in CSMs following up on NPS CTAs when they have to toggle between areas.

 

However, this is a one off program. We sent over 1400 requests for survey response whereas our normal monthly one will only be a couple hundred and can be individual.

 

 

Userlevel 5
Badge +3

My idea is to create a low volume GS object and send a few key data points from the NPS Survey Response object, and then link the low volume object to the CTA.

 

Is it possible to have multiple records link to one CTA if I use the Company GSID to link?

Userlevel 7
Badge +1

@gunjanm please have a look at @andreammelde comments. 

Userlevel 5
Badge +3

I was able to set up the rule to count the GSID of each survey type and then use that as token in the comments instead of displaying a chart

Userlevel 7
Badge +1

@gunjanm 

Userlevel 7
Badge +11

@andreammelde what does the output look like?

  
End Proctoring-
 
Userlevel 5
Badge +3

Here is the logic and the action with the tokens

 

Reply