This article lists all of the objects and fields related to user and visits facts in the communities data lake.
identity_access_control_user_logged_in (fact)
This object table contains a list of fields related to when user login to community.
| Field Name | Field Type | Field 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 |
identity_access_enduser_logged_in (fact)
This object table contains a list of fields related to when user login to community.
| Field Name | Field Type | Field 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 |
| user_name | string | refers to the username or display name of a user within the community |
| string | refers to user's email address | |
| controller | string | indicates the method by which the user logged into the community, specifying whether the login was accomplished through Single Sign-On (SSO) or a standard member login |
| session_id | string | refers to the unique identifier assigned to a user's session on the community platform, used to track and manage the user's interactions and activities during their visit |
| event_source | string | specify whether a user is accessing the Destination, Control, or Hub |
| primary_role_name | string | refers to the name of the user's primary role 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) |
identity_access_sso_enduser_logged_in (fact)
This object table contains a list of fields related to when user login to destination env with and without end-user sso.
| Field Name | Field Type | Field 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 |
| sso_provider | string | refers to the Single Sign-On (SSO) service configured for the destination environment, such as OpenID, Google Sign-In, or other authentication provider |
| 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) |
identity_access_user_activated (fact)
This object table contains a list of fields related to when user has verified his/her email address.
| Field Name | Field Type | Field 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 |
| 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) |
| string | refers to user's email address | |
| user_name | string | refers to the username or display name of a user within the community |
| rank | string | contains the details of the rank assigned to the user |
| join_date | string | refers to the date when a user first registered on the community |
| primary_role | string | contains the name of the primary role of the user |
| roles | string | contains the list of all the roles assigned to the user |
| profile_fields | string | contains the list of the inputs from user profile fields |
identity_access_user_erased (fact)
This object table contains a list of fields related to when a user is deleted from the community.
| Field Name | Field Type | Field 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 |
| user_name | string | refers to the username or display name of a user 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) |
identity_access_user_registered (fact)
This object table contains a list of fields related to when user registered for the community.
| Field Name | Field Type | Field 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 |
| 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) |
| user_name | string | refers to the username or display name of a user within the community |
| user_avatar | string | refers to the graphical representation or image associated with a user profile |
| signature | string | refers to the signature defined by the user within the community, as one of the profile fields |
| primary_role | string | contains the name of the primary role of the user |
| roles | string | contains the list of all the roles assigned to the user |
| has_control_permissions | string | indicates whether a user has been granted permission to access control |
| has_moderation_permissions | string | indicates whether a user has been granted the authority to perform moderation actions within the community |
| is_seat | string | indicates whether the user is assigned a paid seat for accessing a service |
| string | refers to user's email address | |
| is_excluded_from_spam_check | string | indicates whether a user is exempt from spam detection procedures in the system |
identity_access_user_updated (fact)
This object table contains a list of fields related to when user information is changed in user profile page.
| Field Name | Field Type | Field 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 |
| user_name | string | refers to the username or display name of a user within the community |
| campaigns_opt_out | string | indicates whether a user has opted out of receiving communications related to email campaigns |
| company_id | string | refers to the unique identifier assigned to a company within the community platform, used to track and manage company-specific activities and data |
| string | refers to user's email address | |
| is_banned | string | indicates whether a user has been permanently or temporarily banned from accessing the community |
| join_date | string | refers to the date when a user first registered on the community |
| last_active_at | string | refers to the date and time when a user was last active on the community |
| rank_id | string | refers to the unique identifier assigned to a specific rank within the community |
| replies | string | number of replies posted in the community |
| primary_role | string | contains primary role_id |
| topics | string | number of topics posted in the community |
| custom_roles | string | collection of user custom roles IDs after the last change |
| badges | string | collection of user badges Ids after the last change |
identity_access_user_role_changed (fact)
This object table contains a list of fields related to when user role is changed.
| Field Name | Field Type | Field 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 |
| user_name | string | refers to the username or display name of a user within the community |
| string | refers to the user's email address | |
| new_primary_role | string | contains primary role name |
| all_custom_roles | string | collection of user custom roles names after the last change |
| has_control_permission | string | indicates whether the user's role includes access to the admin-facing interface within the community platform. |
| has_moderation_permissions | string | specifies whether the user's role grants them moderation permissions, allowing them to manage content or user interactions. |
| is_seat | string | determines whether the user's role includes licensed access to the community platform. |
| is_exluded_from spam_check | string | indicates whether the user's role exempts them from automated spam checks within the platform |
pageview (fact)
This object table contains a list of fields related to when a user or visitor viewed a page in Community (excluding any activities in the community Control panel)
| Field Name | Field Type | Field 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 |
| language | string | indicates the language chosen by the user or visitor while viewing the page; it defaults to the community's primary language but can be overridden by the user's individual language preference |
| device | string | refers to the type or identifier of the device used to access the community platform, such as a smartphone, tablet, or desktop computer |
| type | string | contains values that indicate the specific subsection or particular name of the page being viewed |
| section | string | contains values such as "Content", "Home", "Error", "null", "Member", "Search",,"Setting" or "Inbox" indicating the specific area of the community that the user was interacting with |
| url | string | contains a segment of the URL address that should be appended to the prefix of the community address (control or destination), allowing to construct the complete link to the specific page within the community |
| category_id | string | refers to the unique identifier assigned to a specific category within the community |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
| page_number | string | indicates the specific page from multiple pages in a paginated list that the user is was viewing |
| reply_public_id | string | refers to the unique identifier assigned to a reply that identifies it within the platform |
| ip | string | refers to the unique numerical label assigned to a user's device by an Internet Service Provider (ISP) to identify and locate it on a network |
| country | string | represents the country from which the user was connected when viewing the page |
| session_id | string | refers to the unique identifier assigned to a user's session on the community platform, used to track and manage the user's interactions and activities during their visit |
| visitor_id | string | refers to the unique identifier assigned to an anonymous user visiting the site, stored as a tracking cookie |
| user_agent | string | contains the user agent string provided by the user's web browser or application when accessing the page and contains information about the user's device, operating system, and browser type |