Skip to main content
jitin_mehndiratta
Helper ⭐️⭐️⭐️
July 22, 2017

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

  • July 22, 2017
  • 2 replies
  • 90 views
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 ⭐️⭐️⭐️
July 24, 2017
Jitin, was your merge a left merge?
VP of Customer Success at Forcepoint
jitin_mehndiratta
Helper ⭐️⭐️⭐️
July 24, 2017
Dan,

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