Database Record Enrichment | User Expertise Score | User Activity Logs

[harrytruman]

Hi Everyone,

I'd like to create a user activity/ expertise rating score. A user can increase their expertise rating score by updating records. This would include adding contact information, correcting errors, linking records, etc. I'm hoping this could incentivize users to enrich the database and increase their visibility and reputation among other users.

Here's what I'm thinking so far:

-Create a field in the user details that shows an expertise score (1-100)
-Create a field in the user details that that shows their ranking among other users. For example, #3 of 4000 users.


I realize this is probably a complicated project, but I would appreciate any feedback or suggestions.

To keep this simple to start, can I create a field in the user details that simply shows how many records the user has updated. How can I pull data from the user activity logs to award a point to a user each time they update a record? Thanks everyone!

[yuri]

Hi,

Advice: I think that the simplest approach from the programming point of view would be to have the ranking as a regular integer field stored in database. Then you create a scheduled job (or maybe even a scheduled workflow) that will update the field e.g. once a day.

More complex question is how to give user a score. It's more business/domain specific question.

[harrytruman]

Hi yuri do you think there is a way to add "activity history" under the target entity options in workflow creation?