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 |