AnalyticsSocialAssists
Aggregates analytics data for social media interactions, specifically focusing on social assists contributing to conversions.
Table Specific Information
Get analytics data for social assist 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 AnalyticsSocialAssists WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' SELECT * FROM AnalyticsSocialAssists WHERE Granularity = 'summarize/weekly' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018'
Columns
| Name | Type | References | Description |
| SocialAssists | String | Provides the name or category of social assists, representing interactions on social platforms contributing to conversions. | |
| RawViews | Long | Total number of raw views recorded from social media interactions, unfiltered by session or visitor uniqueness. | |
| 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 詳細については、WHERE 句のセクションを参照してください。
| Name | Type | Description | |
| StartDate | Date | Specifies the starting date of the query range to filter social assists data. | |
| EndDate | Date | Specifies the ending date of the query range to limit social assists 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. |