Skip to main content

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

  • July 22, 2017
  • 2 replies
  • 48 views

jitin_mehndiratta
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
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • July 24, 2017
Jitin, was your merge a left merge?

jitin_mehndiratta
  • Author
  • Helper ⭐️⭐️⭐️
  • July 24, 2017
Dan,

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