FeedbackSubmissions
Retrieves all feedback submission records in HubSpot, useful for tracking customer feedback.
Table Specific Information
When contacts submit feedback to your surveys, you can use submission data in HubSpot tools to help understand how customers feel about your business.
SELECT
When selecting contacts, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are =, !=, <, <=, >, >=, IN. Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:
SELECT * FROM FeedbackSubmissions WHERE [Survey Name] = 'Customer Support Survey 1' AND [Date] > '2021-08-01' SELECT * FROM FeedbackSubmissions WHERE [Email] = '[email protected]' OR [Feedback sentiment] = 'PROMOTER'
In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:
SELECT * FROM FeedbackSubmissions WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM FeedbackSubmissions WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM FeedbackSubmissions WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM FeedbackSubmissions WHERE ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value})
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | True | True |
Unique identifier for the feedback submission object. | |
| Archived | Bool | True | False |
Indicates whether the feedback submission has been archived. | |
| CreatedAt | Datetime | True | False |
The date and time when the feedback submission was initially created. | |
| UpdatedAt | Datetime | True | False |
The most recent date and time when the feedback submission was updated. | |
| Agent email | String | True | True |
Email address of the conversation agent involved in the interaction that led to the feedback. | |
| Agent responsible for the conversation | Decimal | True | True |
User ID of the agent who handled the conversation that triggered the feedback. | |
| Agent name | String | True | True |
Full name of the conversation agent responsible for the interaction. | |
| All accessible team IDs | String | True | True |
All team IDs, including parent teams in the hierarchy, associated with the owners of this object. | |
| Business units | String | False | True |
The business units assigned to this feedback submission record. | |
| All owner ids | String | True | True |
The IDs of all owners associated with this record, including both default and custom owner properties. | |
| All team ids | String | True | True |
All team IDs tied to the owner properties of this record, including default and custom owner associations. | |
| Chatflow ID | Decimal | True | True |
Unique identifier of the chatflow used in the conversation that generated this submission. | |
| Chatflow name | String | True | True |
The name of the chatflow that was active during the conversation resulting in the feedback. | |
| Chatflow object id | Decimal | True | True |
Internal object ID representing the chatflow involved in the submission. | |
| Contact first name | String | True | True |
First name of the contact associated with the feedback submission. | |
| Contact Id | Decimal | True | True |
HubSpot ID of the contact most recently linked to the submission. | |
| Contact last name | String | True | True |
Last name of the contact associated with the feedback submission. | |
| Conversation thread id | Decimal | True | True |
Thread ID of the conversation that triggered this feedback submission. | |
| Created by user ID | Decimal | True | True |
ID of the user who created the feedback submission. Automatically assigned by HubSpot. | |
| Object create date_time | Datetime | True | True |
Timestamp of when this submission object was created. This value is managed by HubSpot. | |
| Object last modified date_time | Datetime | True | True |
The most recent timestamp of any updates made to the submission object, including system-generated changes. | |
| Merged object IDs | String | True | True |
A list of IDs for other feedback submission records merged into this one. Automatically managed by HubSpot. | |
| Record ID | Decimal | True | True |
System-generated unique ID used to identify the record in HubSpot. | |
| Read Only Object | Bool | True | True |
Indicates whether this feedback submission is a read-only object. | |
| Tag IDs | String | True | True |
List of tag identifiers assigned to this feedback submission. | |
| Tags | String | True | True |
Textual labels or categories assigned to the feedback submission for classification purposes. | |
| Ticket id | Decimal | True | True |
ID of the service ticket linked to this feedback submission, if applicable. | |
| Ticket owner avatar uri | String | True | True |
The URI of the avatar image for the owner of the ticket associated with the feedback submission. | |
| Ticket owner | Decimal | True | True |
The user ID of the owner assigned to the ticket related to this feedback. | |
| Ticket name | String | True | True |
The name or subject of the ticket associated with this feedback submission. | |
| Unique creation key | String | True | True |
A unique key used to ensure idempotent creation of the feedback submission object. | |
| Updated by user ID | Decimal | True | True |
The ID of the user who most recently updated the feedback submission. Set automatically by HubSpot. | |
| User IDs of all notification followers | String | True | True |
The user IDs of individuals who opted to follow and receive notifications about this feedback submission. | |
| User IDs of all notification unfollowers | String | True | True |
The user IDs of owners who opted out of receiving notifications for this feedback submission. | |
| User IDs of all owners | String | True | True |
All user IDs associated with ownership of this feedback submission record. | |
| Owner Assigned Date | Datetime | True | True |
The timestamp of when an owner was assigned to the feedback submission. | |
| Owner | String | False | True |
The name or identifier of the current owner of the feedback submission. | |
| HubSpot Team | String | True | True |
The team name of the user assigned as the owner of the feedback submission. | |
| Industry Standard Question Type | String | True | True |
Standardized question type used in the survey, such as NPS, CSAT, or CES. | |
| Sentiment | String | True | True |
The interpreted sentiment of the feedback submission, such as positive, neutral, or negative. | |
| Survey ID | Decimal | True | True |
The unique identifier of the survey linked to this feedback submission. | |
| Survey Type | String | True | True |
The type of survey that was submitted, such as Customer Satisfaction or Net Promoter Score. | |
| Source | String | True | True |
The origin channel of the survey at the time of feedback submission, such as email or chat. | |
| Date | Datetime | True | True |
The date and time when the feedback submission was recorded. | |
| Rating | Decimal | True | True |
The numeric rating value given by the user as part of the feedback submission. | |
| Feedback sentiment | String | True | True |
The overall sentiment classification derived from the submitted feedback content. | |
| Response | String | False | True |
Any additional comments or responses provided by the user alongside the feedback rating. | |
| Ingestion id | String | True | True |
Internal ID used by HubSpot when the feedback submission was first captured. | |
| Knowledge article id | Decimal | True | True |
The ID of the knowledge base article for which this feedback was submitted, if applicable. | |
| Visitor id | Decimal | True | True |
The unique identifier of the anonymous or known visitor who submitted the feedback. | |
| Engagement id | Decimal | True | True |
The ID of the engagement record equivalent to this feedback submission, if applicable. | |
| Submission URL | String | True | True |
The URL of the webpage or chat window from which the feedback submission was made. | |
| Survey Name | String | True | True |
The name of the survey that this feedback submission is associated with. | |
| Form guid | String | True | True |
The globally unique identifier for the form used in the feedback survey. | |
| String | True | True |
Email address of the contact who submitted the feedback. | ||
| Submission Name | String | True | True |
The name of the feedback submission, often derived from the respondent's email address. |