This article lists all of the objects and fields related to topics content in the communities data lake.
category (dimension)
This object table contains all categories within the community platform, including unique IDs, titles, descriptions, and other relevant information such as visibility settings, and hierarchy, used to organize and group related topics or content for easier navigation and discovery.
| Field Name | Field Type | Field Description |
|---|---|---|
| seo_title | string | refers to the meta title tag used for search engine optimization, representing the title of the page as it should appear in search engine results, aimed at improving search rankings and user engagement. |
| last_poster_id | string | refers to the unique identifier of the user who made the most recent post, either a topic or a reply, in a a category |
| seo_description | string | refers to the detailed descriptions associated with each of the SEO fields, explaining their purpose and how they contribute to the overall search engine optimization strategy |
| type | string | indicates the type of category ( community, knowledge base) |
| parent_id | string | refers to the unique identifier of the parent item within a category hierarchy |
| hide_from_search | boolean | Indicates whether a category is excluded from search results within the community, making it less discoverable by users |
| status | string | indicates if the category is visible in the community |
| last_topic_id | string | refers to the unique identifier of the last topic added in the category |
| description | string | refers to the category description |
| last_reply_id | string | refers to the unique identifier of the last reply added in the category |
| display_order | smallint | refers to the order/ hierarchy in which categories are displayed within the community |
| title | string | refers to the category title |
| show_description_on_homepage | boolean | indicates whether the description of a category is displayed on the homepage within the community |
| meta_robots | string | refers to the meta tag used in the HTML of a web page within the community platform that instructs web crawlers and search engines on how to index and follow links on that page, with possible values including "index", "noindex", "follow", and "nofollow". |
| include_for_stats | boolean | indicates whether user activity in this category is included in the user statistics, and used to unlock ranks |
| category_id | string | refers to the unique identifier assigned to a specific category within the community |
content_question_answered (fact)
This object table contains a list of fields related to when a reply to a question is marked as best answer.
| 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 |
| reply_private_id | string | refers to the unique identifier assigned to a reply that identifies the reply within the Content Type |
| reply_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 |
| 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 |
| reply_public_id | string | refers to the unique identifier assigned to a reply that identifies it within the platform |
content_topic_created (fact)
This object table contains a list of fields related to when a new topis is created.
| 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) |
| 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 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 |
| 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. |
| is_spam | string | indicates if the topic was marked as spam either by a spam checker (Akismet) or by a moderator |
| 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 |
| pending_since | string | indicates the timestamp of when a topic was marked as pending for review or approval |
| pending_details | string | refers to additional information or specific details about the pending status |
| is_trashed | string | indicates whether a topic is trashed and not visible to regular users, but still accessible to moderators within the trash can |
| idea_status_name | string | refers to the label indicating the current stage of an idea in its lifecycle |
| idea_status_changed_at | string | refers to the date and time when the status of an idea was last changed |
| product_areas_id | string | contains a unique identifier assigned to a specific product area |
| featured_image | string | refers to the primary image attached to a post, representing the content visually |
| 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. |
| public_label | string | represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_liked (fact)
This object table contains a list of fields related to when a user likes 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 |
| 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 |
| like_set | string | collection of user unique identifiers (user_ids) representing users who liked a content ( refers to qeustions, artces, product updates and conversations as well as all replies) |
| 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 |
content_topic_replied (fact)
This object table contains a list of fields related to when a new reply to a topic is posted.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| 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 |
| 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 |
| 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 |
| 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 |
| is_highlighted | string | refers to highlighting status, which is a visual representation in the UI |
| is_pending | string | if moderator approval rules were enabled it indicates whether the topic is pending review or approval by a moderator |
| pending_details | string | refers to additional information or specific details about the pending status |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_title_changed (fact)
This object table contains a list of fields related to when the topic title 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 |
| title | string | refers to the headline or name given to a topicc, summarizing its content |
| 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_unliked (fact)
This object table contains a list of fields related to when a user unlikes 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_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 |
| 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 |
| 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 |
| like_set | string | collection of user unique identifiers (user_ids) representing users who liked a content ( refers to qeustions, artces, product updates and conversations as well as all replies) |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
likes (dimension)
This object table tracks user interactions in the form of "likes" on content within the platform.
| Field Name | Field Type | Field Description |
|---|---|---|
| like_id | string | contains unique identifier for each like entry, ensuring that every like can be distinctly referenced within the system |
| 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 |
| 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 |
| liked_by | string | contains unique identifier of the user who gave the like |
| author_id | string | identifier of the content's author, linking the likes back to the user who created the original topic or reply |
| liked_at | timestamp | contains the timestamp indicating when the like was given |
pending_post (dimension)
This object table contains a list of posts currently pending approval.
| Field Name | Field Type | Field Description |
|---|---|---|
| is_reply | int | indicates whether the content is a reply to a topic within the community or is and opening post of the topic |
| post_public_id | string | refers to the public identifier that uniquely identifies a post across the platform within the community, which can be either a topic or a reply |
product_area (dimension)
This object table contains a catalog of product areas, their ids and names.
| Field Name | Field Type | Field Description |
|---|---|---|
| name | string | refers to the designated label that identifies a specific product area |
| product_area_id | string | contains a unique identifier assigned to a specific product area |
| parent_id | string | refers to the unique identifier of the parent item within a product area hierarchy |
topic (dimension)
This object table contains the current list of community topics with their details such as: public_id, category_id, content, status or creation date. (deleted topics are removed from the list)
| Field Name | Field Type | Field Description |
|---|---|---|
| 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 |
| title | string | refers to the headline or name given to a topic, summarizing its content |
| is_sticky | boolean | indicates whether a topic is set to stick to the top of the page, making it always visible to users within the community |
| category_id | string | refers to the unique identifier assigned to a specific category within the community |
| group_id | string | refers to the unique identifier assigned to a specific group within the community |
| moderation_label_id | string | refers to the unique identifier of the assigned to moderation label and indicates the current status within a moderator-defined workflow |
| trashed_at | timestamp | refers to the date and time when the topic was moved to the trash, indicating it is no longer visible to regular users within the community |
| reported_at | timestamp | refers to the date and time when a topic was reported |
| created_at | timestamp | contains the timestamp indicating when the topic was initially created |
| last_moderated_by | string | refers to the unique identifier of the user (typically a moderator or administrator) who last performed moderation actions on the topic |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| last_moderated_at | timestamp | refers to the date and time when the topic was most recently reviewed or managed by a moderator, indicating the latest moderation action taken on it |
| assigned_by | string | indicates the unique identifier of the user who assigned the idea to another user |
| pinned_reply_id | string | refers to the unique identifier of a reply that has been pinned to the topic |
| closed_at | timestamp | refers to the date and time when a topic is marked as closed, indicating that no further replies can be posted to the topic while it remains visible for viewing. |
| last_activity_at | timestamp | refers to the date and time of the most recent interaction with the topic |
| last_modified_at | timestamp | refers to the date and time when the most recent edit or modification was made to a topic |
| 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 |
| assigned_to | string | refers to the unique identifier of the user to whom the idea has been assigned for further action, facilitating responsibility and workflow management |
| 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 |
| last_reported_topic_id | string | refers to the unique identifier of the most recently reported topic, allowing for quick reference to the topic that has been flagged by users for review or moderation |
| answer_id | string | unique identifier of a reply that has been marked as the best answer |
| answered_at | timestamp | indicates the timestamp when the reply, which was later marked as the best answer, was created. |
| last_edit_id | string | links to the topic_edit_history table, which contains the history of modifications made to topics, indicating the most recent edit entry for a particular topic |
| scheduled_by | string | refers to the unique identifier of the user who scheduled a topic (article or product update) to be published |
| published_at | timestamp | indicates when the article or product update was officially published and made publicly accessible |
| created_by | string | contains the unique identifier of the user who created the topic |
| public_label | string | represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose |
| is_preview_public | boolean | indicates whether the preview of content, such as an article or product update, is restricted to moderators or available to all users. |
| featured_image | string | refers to the primary image attached to a post, representing the content visually |
| idea_status | string | refers to the unique identifier assigned to a specific idea status |
| idea_status_changed_at | timestamp | refers to the date and time when the status of an idea was last changed |
| marked_spam_at | timestamp | indicates when topic was marked as spam |
| marked_spam_by | string | refers to the unique identifier of the user who marked topic as spam |
topic_product_area (dimension)
This object table contains current assignment of topics to product areas.
| Field Name | Field Type | Field Description |
|---|---|---|
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| product_area_id | string | contains a unique identifier assigned to a specific product area |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |