analytics: analytics

In Hunt-Laboratory/huntr: Hunt Lab Experiment Data

Description

In this table we capture how many reports, resources, comments, resource_votes, comment_votes, single, partial or full ratings and chat messages each user makes for a specific problem in a specific group in one handy analytics file. We also calculate an engagement level. Engagement is measured by assigning 7 points for a report, 4 points for a resource, 3 points for a complete rating, 2 points for a comment, on point for a chat message, a single or partial rating or a comment vote.

Format

team

Name of team the user is in

team_id

Unique identifier of the team the user is in

problem_id

Unique identifier of the problem the team is working on

user

Name of user

user_id

Unique identifier of user

report_count

Number of reports user contributed to problem

resource_count

Number of resources user contributed to problem

comment_count

Number of comments user contributed in a problem

chat_count

Number of chat messages user contributed in a problem

comment_vote_count

Number of comment upvotes user contributed in a problem

resource_vote_count

Number of resource upvotes user contributed in a problem

simple_rating

Number of times a user contributed a simple (single number) rating

partial_rating

Number of times a user contributed a partial (some of the rubrics) rating

complete_rating

Number of times a user contributed a complete (all rubrics) rating

problem

Title of the problem

engagement

Engagement score calculated as a weighted sum of the various activity counts for the user on this problem. Reports have weight 7; resources and complete ratings have weight 3; comments have weight 2; chat messages, simple ratings, partial ratings, comment votes and resource votes have weight 1.

report_count_scaled

Number of reports user contributed to problem, scaled (within this platform instance) to range between 0 and 1

resource_count_scaled

Number of resources user contributed to problem, scaled (within this platform instance) to range between 0 and 1

comment_count_scaled

Number of comments user contributed in a problem, scaled (within this platform instance) to range between 0 and 1

chat_count_scaled

Number of chat messages user contributed in a problem, scaled (within this platform instance) to range between 0 and 1

comment_vote_count_scaled

Number of comment upvotes user contributed in a problem, scaled (within this platform instance) to range between 0 and 1

resource_vote_count_scaled

Number of resource upvotes user contributed in a problem, scaled (within this platform instance) to range between 0 and 1

simple_rating_scaled

Number of times a user contributed a simple (single number) rating, scaled (within this platform instance) to range between 0 and 1

partial_rating_scaled

Number of times a user contributed a partial (some of the rubrics) rating, scaled (within this platform instance) to range between 0 and 1

complete_rating_scaled

Number of times a user contributed a complete (all rubrics) rating, scaled (within this platform instance) to range between 0 and 1

engagement_scaled

Engagement score calculated as a weighted sum of the various scaled activity counts for the user on this problem. Reports have weight 7; resources and complete ratings have weight 3; comments have weight 2; chat messages, simple ratings, partial ratings, comment votes and resource votes have weight 1.

vote_count

comment_vote_count + resource_vote_count

quick_rating

simple_rating + partial_rating

Hunt-Laboratory/huntr documentation built on Sept. 27, 2020, 3:17 a.m.