This article lists all of the objects and fields related to groups in the communities data lake.
group (dimension)
This object table contains a catalog of groups with their types, ids and names.
| Field Name | Field Type | Description |
|---|---|---|
| type | string | refers to the type of group that can be a public group, private group or hidden group |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| name | string | refers to the name or title assigned to a group within the community |
group_group_created (fact)
This object table contains a list of fields related to when a new group was created.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| group_title | string | refers to the name or title assigned to a group within community |
| type | string | refers to the type of group that can be a public group, private group, or hidden group |
group_group_deleted (fact)
This object table contains a list of fields related to when a new group was deleted.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
group_group_type_changed (fact)
This object table contains a list of fields related to when a type of the group is changed.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| type_id | string | refers to the type_id of the group that can be a public, private group, or hidden group |
| type | string | refers to the type of group that can be a public, private group or hidden group |
group_group_title_changed (fact)
This object table contains a list of fields related to when a group name is changed.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| old_group_title | string | refers to the old name or title assigned to a group within the community |
| new_group_title | string | refers to the new name or title assigned to a group within the community |
grouptag (dimension)
This object table contains a catalog of tags dedicated to groups with their ids and names.
| Field Name | Field Type | Description |
|---|---|---|
| grouptag_id | string | refers to the unique identifier assigned to a tag associated with a group within the community |
| name | string | refers to the name or label assigned to a tag associated with a group within the community |
group_group_tag_created (fact)
This object table contains a list of fields related to when a group tag was created.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| group_tag_id | string | refers to the unique identifier assigned to a tag associated with a group within the community |
| group_tag_name | string | refers to the name or label assigned to a tag associated with a group within the community |
group_group_tag_changed (fact)
This object table contains a list of fields related to when a member changes the group tags.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| added_grouptags | string | contains the list of the tags added |
| removed_grouptags | string | contains the list of tags removed |
| grouptags | string | contains the list of all the tags |
group_grouptag (dimension)
This object table contains current assignment of tags to groups.
| Field Name | Field Type | Description |
|---|---|---|
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| grouptag_id | string | refers to the unique identifier assigned to a tag associated with a group within the community |
group_member_approved (fact)
This object table contains a list of fields related to when a new group member was approved.
| 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 |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| group_title | string | refers to the name or title assigned to a group within community |
| member_group_ids | string | contains the list of group IDs that the user(executor) is currently part of. |
| 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) |
| member_id | string | identifies the person who is a member of the group, links to user_id in user dimension |
group_member_promoted (fact)
This object table contains a list of fields related to when a group member is promoted to a higher group role (e.g. from member to moderator).
| 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 |
| group_id | string | refers to the unique identifier assigned to a specific group 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) |
| member_id | string | identifies the person who is a member of the group, links to user_id in user dimension |
group_member_demoted (fact)
This object table contains a list of fields related to whena group member is demoted to a lower group role (e.g., from moderator to member).
| 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 |
| group_id | string | refers to the unique identifier assigned to a specific group 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) |
| member_id | string | identifies the person who is a member of the group, links to user_id in user dimension |
group_member_declined (fact)
This object table contains a list of fields related to when a new group member approval was declined.
| 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 |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| group_title | string | refers to the name or title assigned to a group within 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) |
group_member_joined (fact)
This object table contains a list of fields related to when a member joint the group.
| 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 |
| member_status | string | refers to the current status of a member within the group (joined or pending) |
| member_role | string | refers to the current role assigned to the new member (can be a moderator or a member). |
| member_group_ids | string | contains the list of group IDs that the user(executor) is currently part of. |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| group_title | string | refers to the name or title assigned to a group within community |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| origin | string | contains the method or source of the membership |
group_member_left (fact)
This object table contains a list of fields related to when a member left the group.
| 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 |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| group_title | string | refers to the name or title assigned to a group within community |
| member_group_ids | string | contains the list of group IDs that the user(executor) is currently part of. |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
group_member_request (fact)
This object table contains a list of fields related to when a user requests to join private group.
| 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 |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| group_title | string | refers to the name or title assigned to a group within community |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |