This article lists all of the objects and fields related to helpfulness voting in the communities data lake.
helpfulness_changed_vote_percentage (fact)
This object table contains a list of fields related to when the user voted for helpfulness score.
| Field Name | Field Type | Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| vote_percentage | string | represents the percentage of helpful votes relative to the total number of votes (including helpful, not helpful, and neutral) for a topic; this percentage is calculated only if the total number of votes exceeds five; otherwise, the value in this column will be zero |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
helpfulness_score (dimension)
This object table contains current counts of helfulness votes assigned to the topics.
| Field Name | Field Type | Description |
|---|---|---|
| helpful_count | int | refers to the number of times users have marked a post as helpful within the community |
| not_helpful_count | int | refers to the number of times users have marked a post as not helpful within the community |
| neutral_count | int | refers to the number of neutral helpfulness votes a post has received within the community |
| community_id | string | contains a unique identifier assigned to a specific community |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
helpfulness_topic_helpful (fact)
This object table contains a list of fields related to when the user voted for helpfulness score as positive.
| Field Name | Field Type | Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| visitor_id | string | refers to the unique identifier assigned to a visitor to track anonymous users who voted within the community |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
helpfulness_topic_neutral (fact)
This object table contains a list of fields related to when the user voted for helpfulness score as neutral.
| Field Name | Field Type | Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| visitor_id | string | refers to the unique identifier assigned to a visitor to track anonymous users who voted within the community |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
helpfulness_topic_not_helpful (fact)
This object table contains a list of fields related to when the user voted for helpfulness score as not helpful.
| Field Name | Field Type | Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| visitor_id | string | refers to the unique identifier assigned to a visitor to track anonymous users who voted within the community |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |