JDBC Driver for Google Analytics

Build 22.0.8509

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

CData JDBC Driver for Google Analytics ビュー

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509