This article lists all of the objects and fields related to reported and escalated content in the communities data lake.
content_reply_report_resolved (fact)
This object table contains a list of fields related to when a reply report is resolved.
| 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 |
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_reply_reported (fact)
This object table contains a list of fields related to when a reply is reported.
| 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 |
| 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 |
| 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_avatar | string | refers to the graphical representation or image associated with a user profile |
| author_username | string | contains the name of the user at the time of creating a content |
| executed_by_avatar | string | refers to the graphical representation or image associated with a user profile |
| executed_by_username | string | refers to the username or display name of a user within the community |
| reason | string | refers to the explanation or justification provided by a user when reporting a post within a community |
| notification_recipients | string | refers to individuals designated to receive notifications triggered when post is reported. |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_report_resolved (fact)
This object table contains a list of fields related to when a topic report is resolved.
| 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 |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
content_topic_reported (fact)
This object table contains a list of fields related to when a topic is reported.
| 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_avatar | string | refers to the graphical representation or image associated with a user profile |
| author_username | string | contains the name of the user at the time of creating a content |
| executed_by_avatar | string | refers to the graphical representation or image associated with a user profile |
| executed_by_username | string | refers to the username or display name of a user within the community |
| reason | string | specifies the justification or rationale provided for reporting a particular topic |
| notification_recipients | string | contains the email addresses designated to receive notifications regarding reported topics, ensuring that relevant users are informed about issues that require attention or moderation |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
escalated_post (dimension)
This object table contains information about posts converted into tickets through 3rd party ticket escalation integrations.
| Field Name | Field Type | Field Description |
|---|---|---|
| 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 |
| ticket_id | string | refers to the unique identifier assigned to a support or issue ticket created from escalated post |
| ticket_url | string | refers to the URL link to access or view a support or issue ticket |
| content | string | refers to the main body of the post |
| type | string | refers to the type of escalation (depending on the 3rd party ticket escalation integrations) |
| moderator_id | string | refers to the unique user ID assigned to a user who is a moderator within the community |
| 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 |
| created_at | timestamp | refers to the timestamp indicating the precise moment when a specific post was converted into a ticket |
| is_reply | tinyint | indicates whether the content is a reply to a topic within the community or is and opening post of the topic |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
reported_reply (dimension)
This object table contains current list of reported replies.
| Field Name | Field Type | Field Description |
|---|---|---|
| reported_by | string | refers to the unique identifier of the user who reported a reply |
| reply_public_id | string | refers to the unique identifier assigned to a reply that identifies it within the platform |
| reported_reply_id | string | refers to the unique identifier of the reply that was reported within the community |
| reported_at | timestamp | refers to the date and time when a reply was reported |
| resolved_by | string | refers to the unique identifier of the user who resolved reported reply |
| resolved_at | timestamp | refers to the date and time when a reported reply was resolved |
| reason | string | contains a description of the grounds for reporting the reply |
reported_topic (dimension)
This object table contains current list of reported topics.
| Field Name | Field Type | Field Description |
|---|---|---|
| reason | string | contains a description of the grounds for reporting the topic |
| reported_by | string | refers to the unique identifier of the user who reported a topic |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| resolved_at | timestamp | refers to the date and time when a reported topic was resolved |
| reported_at | timestamp | refers to the date and time when a topic was reported |
| resolved_by | string | refers to the unique identifier of the user who resolved reported topic |
| reported_topic_id | string | refers to the unique identifier of the tppic that was reported within the community |