AnalyticsEventCompletions
Tracks and retrieves analytics related to the completion of events, helping measure conversion actions within HubSpot.
Table Specific Information
Get analytics data for event completion objects.
SELECT
When selecting analytics for event completions, 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 AnalyticsEventCompletions WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' SELECT * FROM AnalyticsEventCompletions WHERE Granularity = 'summarize/weekly' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018'
Columns
| Name | Type | References | Description |
| EventCompletions | String | Provides the name or category of the completed event being tracked in the analytics data. | |
| Completions | Long | Displays the total number of times the event was completed within the specified timeframe. | |
| 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 the event completion data. | |
| EndDate | Date | Specifies the ending date of the query range to limit the event completion 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. |