Feedbacksubmissions
Retrieve the available Feedbacksubmissions in HubSpot.
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 =, !=, <, <=, >, >=. Further filtering is available using AND and OR combinations. A maximum of 2 OR operators are supported server-side, with each of these operators supporting up to 2 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 Contacts WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Contacts WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Contacts WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Contacts 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 | False | True |
Unique identifier of the object. | |
| Archived | Bool | True | False |
Whether the object is archived or not. | |
| CreatedAt | Datetime | True | False |
When the object was created. | |
| UpdatedAt | Datetime | True | False |
When the object was last updated. | |
| Agent email | String | True | True |
Conversation agent's email | |
| Agent responsible for the conversation | Decimal | True | True |
Agent responsible for the conversation which led to the feedback | |
| Agent name | String | True | True |
Conversation agent's full name | |
| All accessible team IDs | String | True | True |
The team IDs_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom | |
| Business units | String | False | True |
The business units this record is assigned to. | |
| All owner ids | String | True | True |
The value of all owner referencing properties for this object_ both default and custom. | |
| All team ids | String | True | True |
The team ids corresponding to all owner referencing properties for this object_ both default and custom. | |
| Chatflow ID | Decimal | True | True |
Chatflow ID of the conversation associated to the submission | |
| Chatflow name | String | True | True |
The name of the chatflow associated to the submission | |
| Chatflow object id | Decimal | True | True |
Chatflow object id of the conversation associated to the submission | |
| Contact first name | String | True | True |
First name of the contact associated with the submission | |
| Contact Id | Decimal | True | True |
The id of the contact most recently associated with this submission | |
| Contact last name | String | True | True |
Last name of the contact associated with the submission | |
| Conversation thread id | Decimal | True | True |
Thread id of the conversation associated to the submission | |
| Created by user ID | Decimal | True | True |
The user that created this object. This value is automatically set by HubSpot and may not be modified. | |
| Object create date_time | Datetime | True | True |
The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified. | |
| Object last modified date_time | Datetime | True | True |
Most recent timestamp of any property update for this object. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically. | |
| Merged object IDs | String | True | True |
The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. | |
| Record ID | Decimal | True | True |
The unique ID for this record. This value is automatically set by HubSpot and may not be modified. | |
| Read Only Object | Bool | True | True |
Is the object read only | |
| Tag IDs | String | True | True |
Tag IDs assigned to this submission. | |
| Tags | String | True | True |
Tags assigned to this submission. | |
| Ticket id | Decimal | True | True |
ID of the ticket associated with the submission | |
| Ticket owner avatar uri | String | True | True |
Avatar URI of the ticket associated to the feedback's owner | |
| Ticket owner | Decimal | True | True |
User the ticket is assigned to which is associated to feedback submission | |
| Ticket name | String | True | True |
Short summary of ticket associated with the submission | |
| Unique creation key | String | True | True |
Unique property used for idempotent creates | |
| Updated by user ID | Decimal | True | True |
The user that last updated this object. This value is automatically set by HubSpot and may not be modified. | |
| User IDs of all notification followers | String | True | True |
The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications | |
| User IDs of all notification unfollowers | String | True | True |
The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications | |
| User IDs of all owners | String | True | True |
The user IDs of all owners of this object | |
| Owner Assigned Date | Datetime | True | True |
The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting. | |
| Owner | String | False | True |
The owner of the object. | |
| HubSpot Team | String | True | True |
The primary team of the owner. | |
| Industry Standard Question Type | String | True | True |
Industry standard question type for custom surveys | |
| Sentiment | String | True | True |
This column is a custom field. Sentiment of feedback submission based on survey type | |
| Survey ID | Decimal | True | True |
The survey id that the feedback submission is linked with | |
| Survey Type | String | True | True |
The type of the survey | |
| Source | String | True | True |
The channel of the survey when the feedback submission occurred | |
| Date | Datetime | True | True |
The timestamp of the feedback submission | |
| Rating | Decimal | True | True |
The value of the feedback submission | |
| Feedback sentiment | String | True | True |
The sentiment of the feedback submission | |
| Response | String | False | True |
The follow_up response of the feedback submission | |
| Ingestion id | String | True | True |
The identifier we use when we initially capture a feedback submission | |
| Knowledge article id | Decimal | True | True |
The id of the knowledge article this submission was for | |
| Visitor id | Decimal | True | True |
The id of the visitor who submitted this feedback | |
| Engagement id | Decimal | True | True |
The id of the equivalent engagement object | |
| Submission URL | String | True | True |
The URL of the page the submission was made from | |
| Survey Name | String | True | True |
The name of the feedback survey the submission is linked with | |
| Form guid | String | True | True |
The form guid that the feedback submission is linked with | |
| String | True | True |
The email of the contact associated with a feedback submission | ||
| Submission Name | String | True | True |
The email of the contact associated with a feedback submission |