SSIS Components for Google Analytics

Build 26.0.9663

Properties

Lists all Properties to which the user has access.

ビュー固有の情報

Select

プロバイダーは GoogleAnalytics4 API を使用して、以下のカラムと演算子で構築された WHERE 句条件を処理します: その他のフィルタはクライアントサイドでプロバイダー内部で処理されます。

  • Parent は次の演算子をサポートします:=、IN
  • Id は次の演算子をサポートします:=、IN
次のクエリはサーバーサイドで処理されます。
   	SELECT * FROM Properties WHERE Id = '54516992'
    SELECT * FROM Properties WHERE Parent = 'accounts/54516992'

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
CreateTime Datetime Time the property was created.
CurrencyCode String The currency type used in reports involving monetary values.
DisplayName String Display name for the property.
IndustryCategory String Industry associated with the property. Possible values are INDUSTRY_CATEGORY_UNSPECIFIED, AUTOMOTIVE, BUSINESS_AND_INDUSTRIAL_MARKETS, FINANCE, HEALTHCARE, TECHNOLOGY, TRAVEL, OTHER, ARTS_AND_ENTERTAINMENT, BEAUTY_AND_FITNESS, BOOKS_AND_LITERATURE, FOOD_AND_DRINK, GAMES, HOBBIES_AND_LEISURE, HOME_AND_GARDEN,INTERNET_AND_TELECOM, LAW_AND_GOVERNMENT, NEWS, ONLINE_COMMUNITIES, PEOPLE_AND_SOCIETY, PETS_AND_ANIMALS, REAL_ESTATE, REFERENCE, SCIENCE, SPORTS, JOBS_AND_EDUCATION, SHOPPING
Id Integer Property Id.
Parent String Name of the property's logical parent.
TimeZone String Reporting Time Zone.
UpdateTime Datetime Time the property was last modified.
DeleteTime Datetime Time at which this property was trashed.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9663