AnalyticsBreakdowns
Provides detailed analytics segmented by specific categories, useful for performance comparisons across different dimensions.
Table Specific Information
Get analytics data broken down by the specified category.
SELECT
When selecting analytics by breakdown category, they can only be filtered by the StartDate, EndDate, Granularity, BreakdownBy, Filter, FirstDrilldown, SecondDrilldown, Exclude, FilterId, Sort or SortDirection. Defaults to the Totals dimension. The filters must use an exact comparison. For example:
SELECT Totals FROM AnalyticsBreakdowns WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' SELECT Sources FROM AnalyticsBreakdowns WHERE Granularity = 'total' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' SELECT Geolocation FROM AnalyticsBreakdowns WHERE Granularity = 'monthly' AND StartDate = '12/1/2017' AND EndDate = '12/30/2018' AND Filter = 'hubspot'
Columns
| Name | Type | References | Description |
| Totals | String | Displays the total aggregated metrics for all breakdown categories. | |
| Sources | String | Shows data segmented by the source of website traffic, such as direct, referral, organic search, or paid ads. | |
| Geolocation | String | Presents data categorized by the geographic location of visitors, useful for regional performance analysis. | |
| UtmCampaigns | String | Breaks down data based on the Urchin Tracking Module (UTM) campaign tracking parameter used in your marketing URLs. | |
| UtmContents | String | Segments data by the UTM content tracking parameter, which differentiates variations of ads or links. | |
| UtmMediums | String | Categorizes data according to the UTM medium parameter, specifying the marketing channel like email or cost per click (CPC). | |
| UtmSources | String | Organizes data by the UTM source parameter, identifying the source platform like Google or Facebook. | |
| UtmTerms | String | Groups data by the UTM term parameter, typically used to capture specific keywords for paid search campaigns. | |
| FirstDrilldown | String | Provides the primary drilldown level, reflecting detailed source categories as seen in HubSpot's source reports. | |
| SecondDrilldown | String | Offers a secondary drilldown level, enabling deeper segmentation within source categories in reports. | |
| BounceRate | Double | Percentage of sessions that result in a bounce, indicating visitors who leave without interacting further. | |
| ContactToCustomerRate | Double | Percentage of contacts that convert into customers, highlighting contact-to-customer conversion performance. | |
| Contacts | Long | Total number of contacts generated within the reporting period. | |
| Customers | Long | Total number of customers acquired during the reporting period. | |
| Leads | Long | Total number of leads identified in the system. | |
| MarketingQualifiedLeads | Long | Number of leads categorized as more likely to convert into customers, marked as marketing qualified leads. | |
| NewVisitorSessionRate | Double | Percentage of new visitor sessions, indicating the proportion of first-time visitor engagement. | |
| Opportunities | Long | Total number of sales opportunities created in the reporting period. | |
| PageviewsPerSession | Double | Average number of pageviews per session, measuring user engagement depth. | |
| RawViews | Long | Total number of raw pageviews recorded, unfiltered by session or visitor criteria. | |
| SalesQualifiedLeads | Long | Number of sales-qualified leads, representing prospects ready for direct sales engagement. | |
| SessionToContactRate | Double | Percentage showing how many sessions resulted in a contact being generated. | |
| Subscribers | Long | Total number of subscribers added during the reporting period. | |
| TimePerSession | Double | Average time visitors spend per session, indicating engagement duration. | |
| Visitors | Long | Total number of unique visitors within the reporting timeframe. | |
| Visits | Long | Total number of visits, which may include repeat visits by the same visitor. | |
| 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 results. | |
| EndDate | Date | Specifies the ending date of the query range to limit results. | |
| 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. |