Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Google Analytics Views
| Name | Description |
| AccountSummaries | Lists summaries of all Accounts to which the user has access. |
| Acquisitions | Retrieves Acquisitions data. |
| AcquisitionsFirstUserCampaignReport | Retrieves Acquisitions first user Campaign data. |
| AcquisitionsFirstUserGoogleAdsAdGroupNameReport | Retrieves user Acquisitions first user google ads ad group name data. |
| AcquisitionsFirstUserGoogleAdsNetworkTypeReport | Retrieves Acquisitions first user google ads ad network type platform data. |
| AcquisitionsFirstUserMediumReport | Retrieves Acquisitions first user medium data. |
| AcquisitionsFirstUserSourceMediumReport | Retrieves Acquisitions first user source medium data. |
| AcquisitionsFirstUserSourcePlatformReport | Retrieves Acquisitions first user source platform data. |
| AcquisitionsFirstUserSourceReport | Retrieves Acquisitions first user source data. |
| AcquisitionsSessionCampaignReport | Retrieves Acquisitions session campaign report data. |
| AcquisitionsSessionDefaultChannelGroupingReport | Retrieves Acquisitions session default channel grouping report data. |
| AcquisitionsSessionMediumReport | Retrieves Acquisitions session medium report data. |
| AcquisitionsSessionSourceMediumReport | Retrieves Acquisitions session source medium report data. |
| AcquisitionsSessionSourcePlatformReport | Retrieves Acquisitions session source platform report data. |
| AcquisitionsSessionSourceReport | Retrieves Acquisitions session source report data. |
| ActiveUsers | Retrieves Active Users data. |
| DemographicAgeReport | Retrieves Demographics UserAgeBracket data. |
| DemographicCityReport | Retrieves Demographics City data. |
| DemographicCountryReport | Retrieves Demographics Country data. |
| DemographicGenderReport | Retrieves Demographics UserGender data. |
| DemographicInterestsReport | Retrieves Demographics BrandingInterest data. |
| DemographicLanguageReport | Retrieves Demographics Language data. |
| DemographicRegionReport | Retrieves Demographics Region data. |
| Demographics | Retrieves Demographics data. |
| EcommPurchasesItemBrandReport | Retrieves Ecommerce purchase item brand data. |
| EcommPurchasesItemCategory2Report | Retrieves Ecommerce purchase item category data. |
| EcommPurchasesItemCategory3Report | Retrieves Ecommerce purchase item category data. |
| EcommPurchasesItemCategory4Report | Retrieves Ecommerce purchase item category data. |
| EcommPurchasesItemCategory5Report | Retrieves Ecommerce purchase item category data. |
| EcommPurchasesItemCategoryReport | Retrieves Ecommerce purchase item category data. |
| EcommPurchasesItemCategoryReportCombined | Retrieves Ecommerce purchase item category data. |
| EcommPurchasesItemIdReport | Retrieves Ecommerce purchase item data. |
| EcommPurchasesItemNameReport | Retrieves Ecommerce purchase item data. |
| Engagement | Retrieves Engagement data. |
| EngagementContentGroupReport | Retrieves Engagement Content Group Report data. |
| EngagementConversionsReport | Retrieves Engagement conversions data. |
| EngagementEventsReport | Retrieves Engagement events data. |
| EngagementPagesPathReport | Retrieves Engagement Pages path report data. |
| EngagementPagesTitleAndScreenClassReport | Retrieves Engagement Pages title and screen class data. |
| EngagementPagesTitleAndScreenNameReport | Retrieves Engagement Pages Title And ScreenName data. |
| Events | Retrieves Event data. |
| GamesReporting | Retrieves Games Reporting data. |
| MetaData | Retrieves metadata information for standard and custom dimensions / metrics. |
| Monetization | Retrieves Monetization data. |
| MonetizationPublisherAdsAdFormatReport | Retrieves publisher ads page ad format data. |
| MonetizationPublisherAdsAdSourceReport | Retrieves publisher ads ad source data. |
| MonetizationPublisherAdsAdUnitReport | Retrieves publisher ads ad unit data. |
| MonetizationPublisherAdsPagePathReport | Retrieves publisher ads page path data. |
| Tech | Retrieves Tech data. |
| TechAppVersionReport | Retrieves Tech App Version data. |
| TechBrowserReport | Retrieves Tech Browser data. |
| TechDeviceCategoryReport | Retrieves Tech Device Category data. |
| TechDeviceModelReport | Retrieves Tech Device Model data. |
| TechOSSystemReport | Retrieves Tech os system data. |
| TechOSVersionReport | Retrieves Tech Os version data. |
| TechPlatformDeviceCategoryReport | Retrieves Tech platform device category data. |
| TechPlatformReport | Retrieves Tech platform data data. |
| TechScreenResolutionReport | Retrieves Tech Screen Resolution data |