Skip to main content
jitin_mehndiratta
Helper ⭐️⭐️⭐️
Jul 22, 2017 6:07 PM UTC

How to fetch latest NPS Score from NPS survey response using Bionic Rules

It is a common use case to fetch the latest NPS score per account. Below post shows how you can fetch the latest NPS score using Bionic Rules:

Step 1: Create a dataset task fetching account and Maximum Last Modified date as shown in the screenshot below:

Dataset Task Name: Fetch Latest NPS Date


Step 2: Create a dataset task to fetch all NPS scores

Dataset Task name: Fetch all NPS scores


Step 3: Merge above dataset tasks on “Last Modified date”



Running the above rule will fetch you the latest NPS score per account.

You can perform any action, Load to customer info or any other action to load latest NPS score.

2 replies

dan_ahrens
Expert ⭐️⭐️⭐️
Jul 24, 2017 1:40 AM UTC
Jitin, was your merge a left merge?
Translate
VP of Customer Success at Forcepoint
jitin_mehndiratta
Helper ⭐️⭐️⭐️
Jul 24, 2017 5:36 AM UTC
Dan,

Yes. It was a left merge. Retained all records from the left dataset.
Translate