Skip to main content
All CollectionsProduct Updates
Product Update: 21 Sept 2022
Product Update: 21 Sept 2022

Improved Numerical and NPS field mapping and cleaning!

Ryan Stuart avatar
Written by Ryan Stuart
Updated over a week ago

We know how important it is to have clean data coming into Kapiche especially if you're using one of our handy integrations - so we're really excited to share that we have recently launched a new feature to help clean certain types of data that is loaded into Kapiche!

Here's a bit of context about what we're launching and why:

We've noticed a number of customers have been experiencing some issues with the way their survey providers export certain types of numerical responses like NPS & CSAT where records would contain both Numerical and Text. For example:

  • Disagree0

  • 10Agree

  • 0 - Extremely Disagree

  • 10 Excellent

  • Completely Satisfied10

When this happens, Kapiche doesn't know whether to process these records as Numerical Data or Text data which results in a processing error - ultimately causing Kapiche to ignore these records during the upload stage.

To help solve this problem we've launched a new feature that allows Kapiche to automatically detect and clean any data that is set to the NUMERICAL and NPS field types during the Schema Mapping stages.

This means that if Kapiche detects that a record mapped to the NUMERICAL or NPS field type contains text (like one of the examples above) we will automatically remove the text and process the data as intended/expected!

Launch Plan:

This feature will be available for all new Projects that are created either on or after today (21st September 2022) πŸŽ‰


​

What about historical Projects?

At this stage the feature will only be available for new Projects but if you do have an existing Project that you believe has fields that contain both Numerical & Text data please let us know by sending us a message and we'll work with you to upgrade those projects on an as needed basis!


That's it for today's update!


​

Questions? πŸ€”

If you have any questions about Numerical & NPS Field Cleaning (or need some help!) you can get in touch with us any time by hitting the blue chat button to your right πŸ‘‰

Did this answer your question?