AnalyticsForms
Accesses analytics data for HubSpot form submissions to evaluate form engagement and performance.
Table Specific Information
Get analytics data for form objects.
SELECT
When selecting analytics for forms, they can only be filtered by the StartDate, EndDate, Granularity, Filter, Exclude, FilterId, Sort or SortDirection. The filters must use an exact comparison. For example:
SELECT * FROM AnalyticsForms WHERE Granularity = 'summarize/monthly' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' SELECT * FROM AnalyticsForms WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018 AND Sort = 'FormViews''
Columns
| Name | Type | References | Description |
| Forms | String | Provides the name or identifier of each form being analyzed for performance metrics. | |
| Completions | Long | Displays the total number of times the form has been successfully completed by users. | |
| FormViews | Long | Counts the number of times the form has been viewed by visitors. | |
| Installs | Long | Shows the total number of times the form has been installed or embedded on a page. | |
| Interactions | Long | Counts the total number of interactions users had with the form, including clicks or field entries. | |
| Submissions | Long | Total number of form submissions completed by users. | |
| Visibles | Long | Counts how many times the form was visible to visitors on the page, regardless of interaction. | |
| BreakdownDate | Date | Start date of the breakdown data aggregation period. Applicable for these granularity types: daily, weekly, monthly, summarize/daily, summarize/weekly, summarize/monthly. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description | |
| StartDate | Date | Specifies the starting date of the query range to filter form analytics data. | |
| EndDate | Date | Specifies the ending date of the query range to limit the form analytics data. | |
| Granularity | String | Defines the time interval for data grouping. Acceptable values include total, daily, weekly, monthly, summarize/daily, summarize/weekly, summarize/monthly. | |
| Filter | String | Filters results to include only records matching the specified breakdowns. Multiple filters can be applied. | |
| Exclude | String | Excludes records matching the specified breakdowns from the results. Multiple exclusions are supported. | |
| FilterId | String | Specifies the ID of a HubSpot Analytics view. Filters the returned data to match the selected view. |