Solved

What object to see who has been sent a survey via JO, even they have not responded?

  • 26 January 2021
  • 4 replies
  • 56 views
andreammelde
Rank
Userlevel 5
Badge +3

We want to make sure we don’t send too many NPS surveys to customers, so we need to determine who has received a survey email in the last 90 days. NPS Survey Response only tracks responses, we need to know when someone received an email with a survey regardless if they took the survey

icon

Best answer by heather_hansen 26 January 2021, 18:34

View original
Andrea Carroll

4 replies

heather_hansen
Rank
Userlevel 7
Badge +10

@andreammelde There should be a field on the AO Participants object.  I have a Survey Responded (Y/N) and a Survey Responded Date that I’m using.

andreammelde
Rank
Userlevel 5
Badge +3

@heather_hansen  thank you! Does this object do one record per Person ID or multiple records if they are a participant in multiple programs?

Andrea Carroll
heather_hansen
Rank
Userlevel 7
Badge +10

@andreammelde multiple entries per program.  There is an Advanced Outreach ID that I use to narrow down to the specific one I want.

andreammelde
Rank
Userlevel 5
Badge +3

@heather_hansen thank you! i grouped by the person ID to get the count of NPS surveys sent, left merged to our participant list where person ID = person ID, added transform to make nulls = 0. 

 

We can then use this count field where Count of NPS Delivered in Last 90 Days <=2 to stay in our compliance

Andrea Carroll

Reply


Terms & ConditionsCookie settings