Topic Moderation
This article lists all of the objects and fields related to topic moderation in the communities data lake.
When classifying content types, the terms discussion and conversation are used interchangeably to refer to the same content type.
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_opened_for_replies (fact)
This object table contains a list of fields related to when a topic is opened 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, which 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_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 |
| category_id | string | refers to the unique identifier assigned to a specific category within the community |
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 |