Skip to main content

Topics

  • November 20, 2024
  • 0 replies
  • 54 views

MayurGhiya
Forum|alt.badge.img

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.

Show content
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.

Show content
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.

Show content
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.

Show content
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.

Show content
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.

Show content
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.

Show content
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.

Show content
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.

Show content
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.

Show content
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)

Show content
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.

Show content
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

 

Did you find this topic helpful?
This topic has been closed for comments

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings