Customer Communities (CC) Objects

Customer Communities (CC) Objects

This article provides a clear overview of Customer Communities (CC) objects, detailing how user, content, and activity data sync seamlessly into Gainsight for deeper insights and engagement.

Community {community-id} User Object

This object table contains the current list of community users with their details such as: user IDs, name, email, rank id, last activity or join date (deleted users are removed from the list).

Field	Description
A Bit About Yourself	Offers a brief overview or personal narrative about the user, allowing them to share their background, interests, or experiences, provided by the user on their profile page.
Badges	Specifies the titles or identifiers of the badges
Badges Dropdown	Contains a semicolon-separated list of user badges
Email	Refers to the user's email address
Company	Shows the CS Company record to which the Community user has been mapped.
Community User Id	Refers to the unique identifier of the person that identifies the user platform-wide.
Profile Picture	Specifies the URL of the image selected for the user's profile.
Rank Id	Refers to the unique identifier assigned to a specific rank within the community
Company Custom	Represents the name of the organization or business with which the user is affiliated, provided by the user on their profile page.
Custom Roles Dropdown	Contains a semicolon-separated list of user custom roles
Department	Contains user's organizational department based on the details provided on their profile page
First Name	Contains user's name as provided on their profile page.
Last Name	Contains user's surname as entered on their profile page.
Groups Dropdown	Contains a semicolon-separated list of user groups
Username	Refers to the username or display name of a user within the community. Specifies the chosen name for the user's account.
Signature	Refers to the signature defined by the user within the community, as one of the profile fieldsSpecifies the user's designated signature.
GS Modified By	Indicates who last modified the record in Gainsight
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created
Person	Shows the CS Person record to which the Community user has been mapped.
Registered On	Specifies the date when the user registered.
Last Activity At	Contains the timestamp of the most recent activity performed by the user
Job Title	Describes the user's professional position or role, provided by the user on their profile page
Is a Moderator	Indicates whether a user has moderator privileges within the community.
Company Person	Indicates the record that links a Person with a specific company in Gainsight Community.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight
GSID	Shows the unique identifier within the Gainsight system, used for tracking and managing user records.
Linkedin Profile	Contains the URL to the user's LinkedIn profile, which is provided by the user on their profile page.
Primary Roles Dropdown	Contains the user’s primary role
Rank Dropdown	Contains a unique identifier assigned to a specific rank within the community.
Roles	Refers to the names or titles that define a specific role within the community, where each user can have one primary role and multiple custom roles assigned.
Secondary Email	Additional email address provided by the user on their profile page.
User Title	Refers to the title assigned to a user within the community, defined as one of the profile field.

 

Community {community-id} Topic Object

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	Description
Answer Id	A unique identifier of a reply that has been marked as the best answer
Assigned By	Indicates the unique identifier of the user who assigned the idea to another user
Assigned To	Refers to the unique identifier of the user to whom the idea has been assigned for further action, facilitating responsibility and workflow management
Author Id	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	Refers to the unique identifier assigned to a specific category within the community
Closed At	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.
Content Type	Identifies the type of content, such as article, product update, question, idea, or discussion.
Created At	Contains the timestamp indicating when the topic was initially created.
Created By On Community	Contains the unique identifier of the user who created the topic.
Featured Image	Refers to the primary image attached to a post, representing the content visually.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.
GSID	Shows the unique identifier within the Gainsight system, used for tracking and managing user records.
Idea Status	Refers to the unique identifier assigned to a specific idea status.
Idea Status Changed At	Refers to the date and time when the status of an idea was last changed.
IP Address	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 Preview Public	Indicates whether the preview of content, such as an article or product update, is restricted to moderators or available to all users.
Is Sticky	Indicates whether a topic is set to stick to the top of the page, making it always visible to users within the community.
Last Activity At	Refers to the date and time of the most recent interaction with the topic.
Last Edit Id	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.
Last Moderated At	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.
Last Moderated By	Refers to the unique identifier of the user (typically a moderator or administrator) who last performed moderation actions on the topic.
Last Modified At	Refers to the date and time when the most recent edit or modification was made to a topic.
Marked Spam At	Indicates when topic was marked as spam.
Marked Spam By	Refers to the unique identifier of the user who marked topic as spam.
Moderation Label Id	Refers to the unique identifier of the assigned to moderation label and indicates the current status within a moderator-defined workflow.
Pinned Reply Id	Refers to the unique identifier of a reply that has been pinned to the topic.
Private Id	Refers to the unique identifier of the topic, which identifies the opening topic within the Content Type.
Public Id	Refers to the unique identifier of the topic that identifies the opening topic platform-wide.
Public Label	Represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose.
Published At	Indicaties when the article or product update was officially published and made publicly accessible.
Reported At	Refers to the date and time when a topic was reported.
Scheduled By	Refers to the unique identifier of the user who scheduled a topic (article or product update) to be published.
Title	Refers to the headline or name given to a topic, summarizing its content.
Trashed At	Refers to the headline or name given to a topic, summarizing its content.
Url	Specifies the URL of the topic.

 

Community{community-id} Category Object

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	Description
Category Id	Refers to the unique identifier assigned to a specific category within the community.
Description	Refers to the category description.
Display Order	Refers to the order/ hierarchy in which categories are displayed within the community.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.
GSID	Shows the unique identifier within the Gainsight system, used for tracking and managing user records.
Hide From Search	Indicates whether a category is excluded from search results within the community, making it less discoverable by users.
Include For Stats	Indicates whether user activity in this category is included in the user statistics, and used to unlock ranks.
Last Poster Id	Refers to the unique identifier of the user who made the most recent post, either a topic or a reply, in a category.
Last Reply Id	Refers to the unique identifier of the last reply added in the category.
Last Topic Id	Refers to the unique identifier of the last topic added in the category.
Meta Robots	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"..
Parent Id	Refers to the unique identifier of the parent item within a category hierarchy.
Seo Description	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.
Seo Title	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..
Show Description On Homepage	Indicates whether the description of a category is displayed on the homepage within the community.
Status	Indictes if the category is visble in the community.
Title	Refers to the category title.
Type	Indicates the type of category ( community, knowledge base).
Url	Specifies the complete URL for the post.

 

Community {community-id} IdeaStatus

This object table contains a catalog of idea statuses defined in the community with their types, ids, names and visual details.

Field	Description
Bgr Color	Refers to the specific background color assigned to visually distinguish different statuses of ideas.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created
GS Modified By	Indicates who last modified the record in Gainsight
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
Idea Status Id	Refers to the unique identifier assigned to a specific idea status.
Ideation Type	Refers to the type assigned to an ideations status It can have one from the following values: open, closed, delivered.
Is Default	Indicates whether a status is the default choice within the community.
Name	Refers to the label indicating the current stage of an idea in its lifecycle.
Txt Color	Refers to a specific color associated with the status of an idea.
Visible	Indicates whether a status is visible to users within the community.

 

Community {community-id} TopicReply Object

This object table contains the current list of community replies to existing topics, with their details such as: public_id, topic_id, content, status or creation date (deleted replies are removed from the list).

Field	Description
Author Id	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	Identifies the type of content, such as article, product update, question, idea, discussion.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
Ip Address	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	Refers to highlighting status, which is a visual representation in the UI.
Last Modified At	Refers to the date and time when the most recent edit or modification was made to a reply.
Marked Spam At	Indicates when reply was marked as spam.
Marked Spam By	Refers to the unique identifier of the user who marked reply as spam.
Private Id	Refers to the unique identifier assigned to a reply that identifies the reply within the Content Type.
Public Id	Refers to the unique identifier assigned to a reply that identifies it within the platform.
Replied At	Refers to the date and time when a reply was posted within a topic.
Topic Private Id	Refers to the unique identifier of the topic, that identifies the opening topic within the Content Type.
Topic Public Id	Refers to the unique identifier of the topic that identifies the opening topic platform-wide.
Trashed At	Refers to the date and time whenthe reply was moved to the trash, indicating it is no longer visible to regular users within the community.
Url	Specifies the URL of the reply.

 

Community {community-id} Badge Object

This object table contains all badges available within the community platform, including their unique IDs, names, descriptions, and associated images.

Field	Description
Badge Id	Refers to a unique identifier of the badge.
Name	Specifies the title or identifier of the badge.
Description	Provides a brief summary or explanation of the badge's purpose, significance, or criteria for achievement.
Created At	Represents the timestamp indicating when the badge was created in iso format.
Last Modified At	Represents the timestamp of the most recent modification made to the badge in iso format.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

 

Community {community-id} UserBadge Object

This object table contains current assignment of badges to users.

Field	Description
Badge Id	Refers to the unique identifier assigned to a specific badge.
User Id	Refers to the unique identifier of the person that identifies the user platform-wide.
Received At	Refers to the date and time when a user received the badge in iso format.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

 

Community {community-id} Group Object

This object table contains a catalog of groups with their types, ids and names.

Field	Description
Group Id	Refers to the unique identifier assigned to a specific group within the community.
Name	Refers to the name or title assigned to a group within a community.
Type	Refers to the type of group that can be a public group, private group, or hidden group.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

 

Community {community-id} UserGroup Object

This object table contains current assignment of users to groups.

Field	Description
Member Id	Identifies the person who is a member of the group, links to user_id in the user Object.
Group Id	Refers to the unique identifier assigned to a specific group within the community.
Member Since	Refers to the date when a user became a member of the group.
Member_ Status	Refers to the current status of a member within the group.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} Role Object

This object table contains a catalog of roles, their ids and names.

Field	Description
Role_ Id	Refers to the unique identifier assigned to a specific role within the community.
Name	Refers to the name or title of a specific role within the community.
Primary Role	Indicates if the role is one of the main roles defined within the community platform.
Label	Represents the descriptive name or title assigned to a specific role.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} UserRole Object

This object table contains current assignment of roles to users.

Field	Description
Role Id	Refers to the unique identifier assigned to a specific role within the community.
User Id	Refers to the unique identifier of the person that identifies the user platform-wide.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} Rank Object

This object table contains a catalog of ranks, their ids, names and hierarchy.

Field	Description
Rank Id	Refers to the unique identifier assigned to a specific rank within the community.
Name	Refers to the name or title assigned to a specific rank within the community.
Order	Refers to the sequence or position of a rank within the hierarchy of ranks in the community.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} Company

This object table contains a catalog of companies, their ids and names.

Field	Description
Company Id	Refers to the unique identifier assigned to a company within the community platform, used to track and manage company-specific activities and data
Company Name	Refers to the unique company name used to track and manage company-specific activities and data
Deleted [On Community]	Indicates whether a company has been removed from the community
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} CompanyEvent

This object captures the status of a company (either "Customer" or "Not a Customer") at specific points in time, along with timestamps indicating when the company was added to or removed from the community.

Field	Description
Event Id	Unique identifier assigned to each Company Event record
Company Id	Refers to the unique identifier assigned to a company within the community platform, used to track and manage company-specific activities and data
Company Added Timestamp	Records the date and time when a company was initially added to CRM ( SFDC)
Company Removed Timestamp	Records the date and time when a company was removed from CRM ( SFDC)
Company status	Indicates whether a company is classified as a "customer" or "not customer."
Deleted [On Community]	Indicates whether a company has been removed from the community
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} UserCompanyEvent

This object records the timestamp when a community member is assigned to or unassigned from a company within the community, along with the respective company identifier and status during those events.

Field	Description
Event Id	Unique identifier assigned to each UserCompany Event record
Deleted [On Community]	Indicates whether a company has been removed from the community
User Id	Refers to unique identifier of the user who executed Content Event
User Assigned to Company Timestamp	Records the date and time when a user was assigned to a specific company in CRM ( SFDC)
User Unassigned from Company Timestamp	Records the date and time when a user was unassigned from a specific company in CRM ( SFDC)

Community {community-id} ContentEvents

This object captures user interactions with community content, including actions such as created, liked, voted as (not)helpful, and viewed, along with corresponding timestamps and user details.

Field	Description
Activity Date	Indicates when activity was done
Activity Timestamp	Represents the timestamp indicating when the activity was executed in iso format.
Author Id	Refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community
Company Id	Refers to the unique identifier assigned to a company within the community platform, used to track and manage company-specific activities and data
Content Event Name	Specifies the nature of the event related to a piece of content, such as actions like "like," "view," "post created," or feedback types like "helpfulness_helpful," "helpfulness_not_helpful," and "helpfulness_neutral."
Deleted [On Community]	Indicates whether a Content Event is associated with a post (either a topic or reply) that has been removed from the community
Event Id	Unique identifier assigned to each Content Event record
First Response Timestamp	Captures the date and time of the first reply to a specific topic
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
Is Active	Indicates whether a Content Event is associated with a post (either a topic or reply) that has been removed from the community
Post Type	Indicates whether a post is a topic or a "reply" (a response to an existing topic).
Reply Private Id	Refers to the unique identifier assigned to a reply that identifies the reply within the Content Type.
Reply Public Id	Refers to the unique identifier assigned to a reply that identifies it within the platform.
Single User Topic	Indicates whether this is a topic where only one user contributed content.
Topic Private Id	Refers to the unique identifier of the topic, that identifies the opening topic within the Content Type.
Topic Public Id	Refers to the unique identifier of the topic that identifies the opening topic platform-wide.
Unique visitor Id	Refers to the unique identifier assigned to an anonymous user visiting the site, stored as a tracking cookie
User Id	Refers to unique identifier of the user who executed Content Event

Community {community-id} IdeaStatusChangeEvents

This object  tracks the timestamp when the status of an idea is changed, along with the public and private topic IDs, the user ID of the individual who made the change, and the ID of the new status, which references the IdeaStatus object.

Field	Description
Activity Date	Indicates when activity was done
Activity Timestamp	Represents the timestamp indicating when the activity was executed in iso format.
Event Id	Unique identifier assigned to each IdeaStatusChange Event record
Deleted [On Community]	Indicates whether a Event is associated with a idea that has been removed from the community
Topic Private Id	Refers to the unique identifier of the topic, that identifies the opening topic within the Content Type.
Topic Public Id	Refers to the unique identifier of the topic that identifies the opening topic platform-wide.
User Id	Refers to unique identifier of the user who executed Content Event
Idea Status Id	Refers to the unique identifier assigned to a specific idea status

Community {community-id} TicketEvents

This object tracks support ticket events, including the timestamp of the event, event type (e.g., "ticket_created"), the source of the tickets (currently Zendesk), the source user identifier (Zendesk User ID), and the source ticket identifier.

Field	Description
Activity Date	Indicates when activity was done
Activity Timestamp	Represents the timestamp indicating when the activity was executed in iso format.
Event Id	Unique identifier assigned to each Ticket Event record
Deleted [On Community]	Indicates whether a Event is associated with a idea that has been removed from the community
Source User Id	Unique identifier of the user from the source platform (currently Zendesk) associated with the ticket event
Ticket Event Name	Specifies the nature of the event related to the specific ticket
Ticket Id	Unique identifier for the ticket as it exists in the source platform (currently Zendesk)
Ticket Source	Indicates the platform from which the ticket originates (currently Zendesk)
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By

Community {community-id} User Events

Community User Events is an object that records user-specific activities within the community, capturing events such as view, points changed, and registered, along with relevant timestamps and user details.

Field	Description
Activity Date	Indicates when activity was done
Activity Timestamp	Represents the timestamp indicating when the activity was executed in iso format.
Event Id	Unique identifier assigned to each User Event record
Deleted [On Community]	Indicates whether a User Event is associated with a user that has been removed from the community
User Event Name	Specifies the nature of the event related to the specific user
User Id	Refers to unique identifier of the user who executed Content Event
Unique visitor Id	Refers to the unique identifier assigned to an anonymous user visiting the site, stored as a tracking cookie
User Type	Indicates whether a community member is a "guest" (unregistered participant) or a "user" (registered community member).
Points	Field records the numerical change in a user's points balance when a User Event is associated with an adjustment to points
User Event Details	Provides additional information about a user event, specifying the exact nature of the interaction or modification, like "Given.like," "Replied.topic," "Created.topic," or their negated versions such as "Given.like.negated," as well as outcomes like "Received.like," "Provided.answer," and "manually.assigned."
Company Id	Refers to the unique identifier assigned to a company within the community platform, used to track and manage company-specific activities and data
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community User Pod

This object table contains the current list of users from all Account communities with their details.

Field	Description
Badges	Contains a list of badges a user has earned
Community User Id	Refers to unique identifier of the user in Community
Email	Refers to the user's email address
Is a Moderator	Indicates whether a user has moderator privileges within the community.
Last Activity At	Contains the timestamp of the most recent activity performed by the user
Profile Picture	Specifies the URL of the image selected for the user's profile.
Rank Id	Refers to the unique identifier assigned to a specific rank within the community
Registered On	Specifies the date when the user registered.
Roles	Refers to the names or titles that define a specific role within the community, where each user can have one primary role and multiple custom roles assigned.
Signature	Refers to the signature defined by the user within the community, as one of the profile fields. Specifies the user's designated signature.
Source Hub Name	Contains the community ID where the activity was executed
Username	Refers to the username or display name of a user within the community. Specifies the chosen name for the user's account.

Community {community-id} ModerationLabel

This object table contains a catalog of moderation labels, their ids and names.

Field	Description
Name	Refers to the descriptive title of the moderation label, indicating its current status within a moderator-defined workflow.
Moderation Label Id	Refers to the unique identifier of the moderation label, ensuring distinct recognition and management
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} ModerationTag

This object table contains a catalog of moderator tags, their ids and names.

Field	Description
Moderator Tag Name	Refers to a keyword or phrase used by moderators to categorize and manage content effectively
Moderator Tag Id	Refers to the unique identifier of the specific moderator tag, facilitating the categorization and management of content based on defined keywords.
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} PublicTags

This object table contains a catalog of public tags, their ids and names.

Field	Description
Public Tag Name	Refers to a keyword or phrase used to categorize and organize content, making it easily searchable and accessible to all users within the community
Deleted At	Refers to the date and time when the public tag was deleted
Public Tag Id	Refers to the unique identifier of the specific public tag, distinguishing it from other tags in the system.
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} ProductArea

This object table contains a catalog of product areas, their ids and names.

Field	Description
Name	Refers to the designated label that identifies a specific product area within the community
Product Area Id	Refers to the unique identifier of the specific product area, ensuring it can be clearly referenced
Parent Id	Refers to the unique identifier of the parent item within a product area hierarchy, enabling the organization of product areas in a structured manner.
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community {community-id} TopicAttributes

This object table contains a set of characteristics linked to topics within a community, including product areas, public tags, and moderator tags.

Field	Description
Topic Attribute Id	This refers to the unique identifier of a specific attribute within the community, such as product areas, public tags, or moderator tags, ensuring distinct recognition and effective management
Topic Public Id	Refers to the unique identifier of the topic that identifies the opening topic platform-wide.
Attribute Type	Refers to the classification of the attribute, indicating whether the attribute_id corresponds to a product area, public tag, or moderator tag within the community.
GSID	A unique identifier within the Gainsight system, used for tracking and managing user records.
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created.
GS Modified By	Indicates who last modified the record in Gainsight.
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight.

Community Content Object

This object table contains the current list of community topics with thier replies.

Field	Description
Author Id	A lookup object to the Community User refers to unique identifier of the user who created a piece of content: topic or reply
Category Name	Contains the category name in which the content was posted
Module/ Category SubType	Indicates whether the module category is associated with the Community or the Knowledge Base.
Closed At	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.
Company	Lookup to GS Company record.
Company Person	Lookup to Company Person record.
Post Created At/ Content Created At	Contains the timestamp indicating when the post was initially created
Content Data Identifier	Used for mapping connections between Community Activity and Community Trend data.
Context ID / Content Id	Refers to the public identifier that uniquely identifies a post ( topic or reply) or category
Post Moderated At/Content Moderated At	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
Post Moderated By/ Content Moderated By	Refers to the unique identifier of the user (typically a moderator or administrator) who last performed moderation actions on the post
Post Modified At	Refers to the date and time when the most recent edit or modification was made to a post
Context/ Content Type	Indicates the context of the content whether is a topic, reply, category or group
Content Type/ Content Subtype	Identifies the type of content, such as article, product update, question, idea, discussion
GS Created By	Indicates who created the record in Gainsight.
GS Created Date	Indicates when the Gainsight record was created
GS Modified By	Indicates who last modified the record in Gainsight
GS Modified Date	Indicates when the Gainsight record was modified in Gainsight
Best Answer or Pinned Reply ID/ Highlighted response Content ID	Refers to the reply ID that was marked best answer or pinned to the topic
Idea Status	Refers to the label indicating the current stage of an idea in its lifecycle
Idea Status Changed At	Refers to the date and time when the status of an idea was last changed
Ideation Type	Refers to the type assigned to an ideations status It can have one from the following values: open, closed, delivered
Last Activity At	Refers to the date and time of the most recent interaction with the post
Last Reply At	Indicates when the last response was posted.
Main Topic Public ID /Main Topic Content ID	Refers to the unique identifier of the topic that identifies the opening topic platform-wide
Marked Spam At	Indicates when topic was marked as spam
Marked Spam By	Refers to the unique identifier of the user who marked topic as spam
Person ID	Lookup to Person Object.
Published At	Indicates when the article or product update was officially published and made publicly accessible
Source Hub Name	Contains the community ID where the activity was executed
Topic Title /subject	Refers to the headline or name given to a opening topic, summarizing its content
Trashed At	Indicates the date and time the content was Trashed.
URL	Specifies the complete URL for the post.
First Reply At	Indicates when the first response was posted.
First Reply ID	Refers to the unique identifier of the first reply to the opening post
Total Replies	Indicates the total response count.

Community Activity Object

This object captures user interactions within the community, including actions such as liked, unliked, voted, unvoted, and viewed, along with corresponding timestamps and user details.

Field	Description
Activity Date	Indicates the time when the activity took place.
Context ID	Contains unique identifier of the context in which the operation was executed (community post Id, category Id, rank, group, event, badge )
Community User Id	Indicates the User ID found in the Community User Object. Contains the unique identifier of the person that identifies community user platform-wide and associates with Community User Object.
Company	Associates with the Company object.
Company Person	Associates with the Company Person object.
Context	Indicates the context in which the operation was executed (community post, category, rank, group, event, badge etc )
Operation	Specifies the type of action performed by the user or system, such as "create," "update," "delete," or "view,"
Person Id	Associates with the Person object.
SEO Url	Contains the web address that links directly to the content
Source Hub Name	Contains the community ID where the activity was executed

 

Community Trend Object

This object contains aggregated data on user interactions within the community, including views of topics, categories, articles, and ideas, offering valuable insights into trends in community engagement.

Field	Description
Activity Date	Displays the date when the activity took place.
Articles Created	Indicates the number of articles created.
Articles Views	Indicates the number of views for articles.
Category Views	Indicates the number of views for a category.
Community User ID	Indicates the User ID found in the Community User Object.
Company	Associates with the Company object.
Company Person	Associates with the Company Person object.
Discussions Created	Indicates the number of discussions created.
Discussions Views	Indicates the number of discussions viewed.
Idea Views	Indicates the number of ideas viewed.
Ideas Created	Indicates the number of ideas created.
Page / Post Views	Represents the aggregate of Topic Views, Reply Views, and Category Views.
Person Id	Associates with the Person object.
Product Update Created	Indicates the number of product updates created.
Product Update Views	Indicates the number of product updates viewed.
Questions Created	Indicates the number of questions created.
Questions Views	Indicates the number of questions viewed.
Source Hub Name	Indicates the Customer Community Hub name.
Topic Replies Created	Indicates the number of topic-replies created.
Topic Reply Views	Indicates the number of topic-replies viewed.
Topic Views	Indicates the number of topics viewed.
Topics Created	Specifies a count that merges all topic subtypes, determined through a distinct grouping of Created Time, Community user and Source Hub Name.
Topics Viewed	Indicates the number topics viewed
User Created	Represents users created based on the activity date and company ID.