AnalyticsForms
Get analytics data for form objects.
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 | Analytics data for forms. | |
| Completions | Long | The number of completions. | |
| FormViews | Long | The number of times the form has been viewed. | |
| Installs | Long | The number of installs. | |
| Interactions | Long | The number of interactions. | |
| Submissions | Long | The number of submissions. | |
| Visibles | Long | The number of times the form has been visible. | |
| BreakdownDate | Date | The start date of the time period for which the breakdown data are grouped. This column is applicable only for Granularity types: daily, weekly, monthly, summarize/daily, summarize/weekly and 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 | The beginning value of the query range. | |
| EndDate | Date | The ending value of the query range. | |
| Granularity | String | The time period used to group the data. Must be one of: total, daily, weekly, monthly, summarize/daily, summarize/weekly, summarize/monthly. | |
| Filter | String | Filter the returned data to include only the specified breakdown. This parameter can be included multiple times to filter for multiple breakdowns. | |
| Exclude | String | Exclude data for the specified breakdown. This parameter can be included multiple times to exclude multiple breakdowns. | |
| FilterId | String | The ID of an Analytics view. If included, the returned data will only include data that matches the view. |