This article lists all of the objects and fields related to topic moderation in the communities data lake.
content_topic_anonymized (fact)
This object table contains a list of fields related to when the author of the topic was deleted.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| 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 |
content_topic_approved_by_moderator (fact)
This object table contains a list of fields related to when a moderator approves a topic.
| 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 |
| category_id | string | refers to the unique identifier assigned to a specific category or group within the community |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| 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 |
content_topic_assigned_moderator (fact)
This object table contains a list of fields related to when a moderator is assigned to a topic.
| 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 |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| assigned_to | string | refers to the unique identifier of the person to whom a topic moderation was assigned |
| 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 |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_closed_for_replies (fact)
This object table contains a list of fields related to when a topic is closed for new replies.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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 |
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community |
| content_type | string | identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_converted (fact)
This object table contains a list of fields related to when a topic is converted into a different content type.
| 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 |
| old_topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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 |
| converted_replies | string | contains previous and new reply_private_ids of the replies of the topic which were converted into new content type |
| new_topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| old_content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
| new_content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_created_from_reply (fact)
This object table contains a list of fields related to when a topic is created from existing reply.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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 |
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| author_username | string | contains the name of the user at the time of creating a content |
| author_avatar | string | refers to the graphical representation or image associated with a user profile |
| category_id | string | refers to the unique identifier assigned to a specific category or group within the community |
| category_name | string | contains the category name in which the post was created |
| title | string | refers to the headline or name given to a topicc, summarizing its content |
| content | string | refers to the main body of the post. If empty the event did not affect the body of the post |
| ip_address | 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 |
| reply_private_id | string | refers to the unique identifier assigned to a reply that identifies the reply within the Content Type |
| reply_public_id | string | refers to the unique identifier assigned to a reply that identifies it within the platform |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_edited (fact)
This object table contains a list of fields related to when the topic was edited.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| content | string | refers to the main body of the post. If empty the event did not affect the body of the post |
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community |
| is_pending | string | if moderator approval rules were enabled it indicates whether the topic is pending review or approval by a moderator |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_last_edit_updated (fact)
This object table contains a list of fields related to when last edit of an article 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| last_edited_at | string | refers to the date and time when the most recent edit or modification was made to a piece of content |
| last_edit_id | string | contains a unique identifier of a topic modification |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_marked_as_read_by_team (fact)
This object table contains a list of fields related to when a topic is marked as read by the team.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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) |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_marked_as_unread_by_team (fact)
This object table contains a list of fields related to when a topic is marked as unread by the team.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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) |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_moved_to_another_category (fact)
This object table contains a list of fields related to when a topic is moved to another category.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| new_category_id | string | refers to the unique identifier of the previous category |
| old_category_id | string | refers to the unique identifier of the category where the topic was moved |
| category_name | string | contains the category name in which the post was created |
| 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 |
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_permanently_deleted (fact)
This object table contains a list of fields related to when the topic was permanently deleted.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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 |
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| author_username | string | contains the name of the user at the time of creating a content |
| author_avatar | string | refers to the graphical representation or image associated with a user profile |
| category_id | string | refers to the unique identifier assigned to a specific category or group within the community |
| title | string | refers to the headline or name given to a topic, summarizing its content |
| content | string | refers to the main body of the post. If empty the event did not affect the body of the post |
| public_tags_name | string | refers to a keyword or phrase used to categorize and organize content, making it easily searchable and accessible to everyone. |
| is_sticky | string | indicates whether a topic is set to stick to the top of the page, making it always visible to users within the community |
| is_closed | string | indicates whether a topic is closed, meaning it is not allowed to receive further replies but is still visible. |
| moderator_tags_name | string | refers to a keyword or phrase used by moderators to categorize and manage the content |
| category_name | string | contains the category name in which the post was created |
| ip_address | 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 |
| is_trashed | string | indicates whether a topic is trashed and not visible to regular users, but still accessible to moderators within the trash can |
| is_spam | string | indicates if the topic was marked as spam either by a spam checker (Akismet) or by a moderator |
| poll | string | refers to a feature within the community where users can participate in voting or surveys on various topics |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_product_areas_changed (fact)
This object table contains a list of fields related to when the product area of a product update or an idea 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community |
| product_areas_id | string | contains a unique identifier assigned to a specific product area |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_restored (fact)
This object table contains a list of fields related to when trashed topic is restored.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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 |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_sticky_state_disabled (fact)
This object table contains a list of fields related to when a customer disables a sticky state of question, conversation or article.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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) |
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_sticky_state_enabled (fact)
This object table contains a list of fields related to when a customer enbles a sticky state of question, conversation or article.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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) |
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_trashed (fact)
This object table contains a list of fields related to when a topic is trashed.
| 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 |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| 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 |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_unassigned_moderator (fact)
This object table contains a list of fields related to when a moderator is unassigned to a topic.
| 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 |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| 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 |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
topic_edit_history (dimension)
This object table contains a list of edits done to the topics in the community.
| Field Name | Field Type | Field Description |
|---|---|---|
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| topic_edit_id | string | contains a unique identifier of a topic modification |
| edited_at | timestamp | refers to the date and time when the topic was edited or modified |
| content | string | refers to the main body of the post |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |