Hi! Basic excel user here. I've read through a number of threads, tried some macros mentioned, etc...but still can't quite get what I need.
I have a file that has feedback text received from customers. I manually curate this feedback and assign a category and primary theme. At the very minimum, I'd like to be able to look at a list of the most frequently used words, by category. For example:
...Given however that I already have that done for the 1k set, it may be more value for me to figure out how to assign an NPS score based on the open text feedback, aka - detractors, passives, promotors.
Help?
I have a file that has feedback text received from customers. I manually curate this feedback and assign a category and primary theme. At the very minimum, I'd like to be able to look at a list of the most frequently used words, by category. For example:
| Category | Feedback |
|---|---|
| Purchase Price | So expensive! Why would I shop here? The cost WAY too much!! |
| Purchase Price | Love that you were able to match the price; the cost, even with shipping, was less than my local store! |
| Catalog | Have you considered adding Disney Character pajamas to purchase? |
| Delivery Quality | Item received, but the box was def damaged in shipping - I hate that you use UPS! |
- Min solution: For the category "Purchase Price", the word "cost" comes up 2x, "expensive" 1x, "price" 1x....I figure if I'm able to this, then #2 would may be possible?
- Next step up solution: After doing the above on a large amount of data and (maybe?) creating a list of those words, be able to create a script that would assign the category based on the words used. E.g. = If feedback includes "price", assign category "Purchase Price".
- Ideal solution: Combination of previous solutions, plus - NPS sentiment analysis on the feedback text.
...Given however that I already have that done for the 1k set, it may be more value for me to figure out how to assign an NPS score based on the open text feedback, aka - detractors, passives, promotors.
Help?
