By looking at the top 20…50 words used by a user, I hope to identify who cares about what the most, and then use the information to engage them in right topics and ask them right questions for better motivation.
What tables / columns would be useful for this task?
I suspect I should play with
post_search_data.search_data, which is a
tsvector, i.e. words and their frequencies per post. But if you think there’s a better way, please advise!