Skip to main content

This article lists all of the objects and fields related to articles and product updates in the communities data lake.

content_topic_author_changed (fact)

This object table contains a list of fields related to when the author of the topic was 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_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)
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
user_id string refers to the unique identifier of the person that identifies the user platform-wide
new_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

new_author_username string refers to the new name of a user within the community
old_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

content_type string Identifies the type of content, such as article, product update, question, idea, discussion

 

This object table contains a list of fields related to when the featured image of the article or product update was 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_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)
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
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
featured_image string refers to the primary image attached to a post, representing the content visually
content_type string Identifies the type of content, such as article, product update, question, idea, discussion

 

content_topic_preview_changed (fact)

This object table contains a list of fields related to when the preview of an article or product update 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_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
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
is_preview_public string

indicates whether the preview of content, such as an article or product update, is restricted to moderators or available to all users.

content_type string Identifies the type of content, such as article, product update, question, idea, discussion

 

content_topic_published (fact)

This object table contains a list of fields related to when an article or product update is published and become visible in 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
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)
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
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
title string refers to the headline or name given to a topic, summarizing its content
featured_image string refers to the primary image attached to a post, representing the content visually
public_label string represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose
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

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
poll string refers to a feature within the community where users can participate in voting or surveys on various topics
is_published string indicates whether content, such as an article or product update, is published and visible to users within the community
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_edited_by string refers to the user ID of the moderator who most recently reviewed or managed community content.
category_id string refers to the unique identifier assigned to a specific category within the community
content_type string Identifies the type of content, such as article, product update, question, idea, discussion

 

content_topic_schedule_canceled (fact)

This object table contains a list of fields related to when an article or product update that had a future publish date that was canceled.

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)
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
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
content_type string Identifies the type of content, such as article, product update, question, idea, discussion

 

content_topic_scheduled (fact)

This object table contains a list of fields related to when an article or product update has a future publish date scheduled.

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)
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
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
content_type string Identifies the type of content, such as article, product update, question, idea, discussion

 

content_topic_scheduled_published (fact)

This object table contains a list of fields related to when an article or product update that had a future publish date was published.

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
executed_by string identifies the person who executed the activity (zero, if system event)
topic_private_id string refers to the unique identifier of the topic, that identifies the opening topic within the Content Type
user_id string refers to the unique identifier of the person that identifies the user platform-wide
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
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

category_id string refers to the unique identifier assigned to a specific category within the community
title string refers to the headline or name given to a topic, summarizing its content
featured_image string refers to the primary image attached to a post, representing the content visually
public_label string represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose
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

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
poll string refers to a feature within the community where users can participate in voting or surveys on various topics
is_published string indicates whether content, such as an article or product update, is published and visible to users within the community
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_edited_by string refers to the user ID of the moderator who most recently reviewed or managed community content.
content_type string Identifies the type of content, such as article, product update, question, idea, discussion