SOLVED

Re: NPS survey in Marketo that captures score over time

Go to solution
Romina
Level 2

NPS survey in Marketo that captures score over time

Hello all. We are thinking of leveraging Marketo to generate NPS surveys, but we would like to retain the scoring over time, so we could analyse its progression. We did some tests and built a program for that, but it only retains the latest score. Has anyone been able to achieve the same thing? Any advice would be appreciated. Thank you!

2 ACCEPTED SOLUTIONS

Accepted Solutions
derelict_wombat
Level 5

Re: NPS survey in Marketo that captures score over time

I think you can do this with  2 fields. 

 

- NPS Score  (Score field)

- NPS Score Appended (or something similar)  (Text Field)

 

NPS Score would collect the latest score

"NPS Score Appended" would be a text field that would add the latest score and the date to the text file

See how to append data to a field here
https://experienceleague.adobe.com/docs/marketo/using/product-docs/core-marketo-concepts/smart-campa...

View solution in original post

SanfordWhiteman
Level 10 - Community Moderator

Re: NPS survey in Marketo that captures score over time

Expanding on @derelict_wombat’s correct answer, you can make the history field useful to your data team by using partial JSON format.

 

When you append to the field, add a comma and then a JSON object in curly brackets {}:

{{lead.History Field}}, { "{{system.DateTime}}" : {{lead.NPS Score}} }

 

This is a “partial” JSON array because it lacks enclosing square brackets [], but since the format is otherwise good JSON, your team can add those and then parse the value as a true sequential list.

View solution in original post

4 REPLIES 4
derelict_wombat
Level 5

Re: NPS survey in Marketo that captures score over time

I think you can do this with  2 fields. 

 

- NPS Score  (Score field)

- NPS Score Appended (or something similar)  (Text Field)

 

NPS Score would collect the latest score

"NPS Score Appended" would be a text field that would add the latest score and the date to the text file

See how to append data to a field here
https://experienceleague.adobe.com/docs/marketo/using/product-docs/core-marketo-concepts/smart-campa...

Romina
Level 2

Re: NPS survey in Marketo that captures score over time

Thank you for the suggestion. Will give it a try.

SanfordWhiteman
Level 10 - Community Moderator

Re: NPS survey in Marketo that captures score over time

Expanding on @derelict_wombat’s correct answer, you can make the history field useful to your data team by using partial JSON format.

 

When you append to the field, add a comma and then a JSON object in curly brackets {}:

{{lead.History Field}}, { "{{system.DateTime}}" : {{lead.NPS Score}} }

 

This is a “partial” JSON array because it lacks enclosing square brackets [], but since the format is otherwise good JSON, your team can add those and then parse the value as a true sequential list.

Romina
Level 2

Re: NPS survey in Marketo that captures score over time

Thank you for this. Will try implement it.