# 从 Google Ads 实体中读取
<a name="googleads-reading-from-entities"></a>

 **先决条件** 
+  您要从中读取内容的 Google Ads 对象。请参阅下面的支持的实体表，查看可用的实体。

 **支持的实体** 


| 实体 | 可以筛选 | 支持限制 | 支持排序依据 | 支持 Select \$1 | 支持分区 | 
| --- | --- | --- | --- | --- | --- | 
| 广告组广告 | 支持 | 是 | 是 | 否 | 是 | 
| 广告组 | 支持 | 是 | 是 | 否 | 是 | 
| 活动预算 | 支持 | 是 | 是 | 是 | 是 | 
| 账户预算 | 是 | 否 | 是 | 是 | 否 | 
| 活动 | 支持 | 是 | 是 | 是 | 是 | 
| Account | 是 | 否 | 是 | 否 | 否 | 

 **示例** 

```
googleAds_read = glueContext.create_dynamic_frame.from_options(
    connection_type="googleads",
    connection_options={
        "connectionName": "connectionName",
        "ENTITY_NAME": "campaign-3467***",
        "API_VERSION": "v16"
    }
```

 **Google Ads 实体和字段详细信息** 


| 实体 | 字段 | 数据类型 | 支持的运算符 | 
| --- | --- | --- | --- | 
| Account | resourceName | 字符串 | \$1=, = | 
| Account | callReportingEnabled | 布尔值 | \$1=, = | 
| Account | callConversionReportingEnabled | 布尔值 | \$1=, = | 
| Account | callConversionAction | 字符串 | \$1=, = | 
| Account | conversionTrackingId | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | crossAccountConversionTrackingId | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | payPerConversionEligibilityFailureReasons | 列表 |  | 
| Account | id | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | currencyCode | 字符串 | \$1=, =, LIKE | 
| Account | timeZone | 字符串 | \$1=, =, LIKE | 
| Account | autoTaggingEnabled | 布尔值 | \$1=, = | 
| Account | hasPartnersBadge | 布尔值 | \$1=, = | 
| Account | manager | 布尔值 | \$1=, = | 
| Account | testAccount | 布尔值 | \$1=, = | 
| Account | date | 日期 | BETWEEN, =, <, >, <=, >= | 
| Account | costMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | acceptedCustomerDataTerms | 布尔值 |  | 
| Account | conversionTrackingStatus | 字符串 | \$1=, =, LIKE | 
| Account | enhancedConversionsForLeadsEnabled | 布尔值 |  | 
| Account | googleAdsConversionCustomer | 字符串 |  | 
| Account | 状态 | 字符串 | \$1=, = | 
| Account | allConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| Account | allConversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| Account | conversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| Account | conversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| Account | valuePerAllConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| Account | videoViews | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | clicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | invalidClicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | costPerAllConversions | 双精度 | \$1=, =, <, > | 
| Account | costPerConversion | 双精度 | \$1=, =, <, > | 
| Account | conversions | 双精度 | \$1=, =, <, > | 
| Account | absoluteTopImpressionPercentage | 双精度 | \$1=, =, <, > | 
| Account | 展示 | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | topImpressionPercentage | 双精度 | \$1=, =, <, > | 
| Account | averageCpc | 双精度 | \$1=, =, <, > | 
| Account | activeViewMeasurableCostMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| Account | averageCost | 双精度 | \$1=, =, <, > | 
| Account | ctr | 双精度 | \$1=, =, <, > | 
| Account | activeViewCtr | 双精度 | \$1=, =, <, > | 
| Account | searchImpressionShare | 双精度 | \$1=, =, <, > | 
| Account | conversionAction | 字符串 | \$1=, = | 
| Account | conversionActionCategory | 字符串 | \$1=, = | 
| Account | conversionActionName | 字符串 | \$1=, =, LIKE | 
| 账户预算 | resourceName | 字符串 | \$1=, = | 
| 账户预算 | 状态 | 字符串 | \$1=, = | 
| 账户预算 | proposedEndTimeType | 字符串 | \$1=, = | 
| 账户预算 | approvedEndTimeType | 字符串 | \$1=, = | 
| 账户预算 | id | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 账户预算 | billingSetup | 字符串 | \$1=, = | 
| 账户预算 | 名称 | 字符串 | \$1=, =, LIKE | 
| 账户预算 | approvedStartDateTime |  日期时间 | BETWEEN, =, <, >, <=, >= | 
| 账户预算 | proposedSpendingLimitMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 账户预算 | approvedSpendingLimitMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 账户预算 | adjustedSpendingLimitMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 账户预算 | amountServedMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | resourceName | 字符串 | \$1=, =, LIKE | 
| 广告组 | 状态 | 字符串 | \$1=, =, LIKE | 
| 广告组 | type | 字符串 | \$1=, =, LIKE | 
| 广告组 | id | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | 名称 | 字符串 | \$1=, =, LIKE | 
| 广告组 | 市场活动 | 字符串 | \$1=, = | 
| 广告组 | cpcBidMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | targetCpaMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | cpmBidMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | cpvBidMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | targetCpmMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | effectiveTargetCpaMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | date | 日期 | BETWEEN, =, <, >, <=, >= | 
| 广告组 | costMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | useAudienceGrouped | 布尔值 | \$1=, = | 
| 广告组 | effectiveCpcBidMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | allConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组 | allConversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组 | conversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组 | conversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组 | valuePerAllConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组 | valuePerConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组 | averageCost | 双精度 | \$1=, =, <, > | 
| 广告组 | costPerAllConversions | 双精度 | \$1=, =, <, > | 
| 广告组 | costPerConversion | 双精度 | \$1=, =, <, > | 
| 广告组 | averagePageViews | 双精度 | \$1=, =, <, > | 
| 广告组 | videoViews | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | clicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | allConversions | 双精度 | \$1=, =, <, > | 
| 广告组 | averageCpc | 双精度 | \$1=, =, <, > | 
| 广告组 | absoluteTopImpressionPercentage | 双精度 | \$1=, =, <, > | 
| 广告组 | 展示 | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组 | topImpressionPercentage | 双精度 | \$1=, =, <, > | 
| 广告组 | activeViewCtr | 双精度 | \$1=, =, <, > | 
| 广告组 | ctr | 双精度 | \$1=, =, <, > | 
| 广告组 | searchTopImpressionShare | 双精度 | \$1=, =, <, > | 
| 广告组 | searchImpressionShare | 双精度 | \$1=, =, <, > | 
| 广告组 | searchAbsoluteTopImpressionShare | 双精度 | \$1=, =, <, > | 
| 广告组 | relativeCtr | 双精度 | \$1=, =, <, > | 
| 广告组 | conversionAction | 字符串 | \$1=, = | 
| 广告组 | conversionActionCategory | 字符串 | \$1=, = | 
| 广告组 | conversionActionName | 字符串 | \$1=, =, LIKE | 
| 广告组 | updateMask | 字符串 |  | 
| 广告组 | 创建 | 结构体 |  | 
| 广告组 | 更新 | 结构体 |  | 
| 广告组 | primaryStatus | 字符串 | \$1=, = | 
| 广告组 | primaryStatusReasons | 列表 |  | 
| 广告组广告 | resourceName | 字符串 | \$1=, = | 
| 广告组广告 | id | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组广告 | 状态 | 字符串 | \$1=, = | 
| 广告组广告 | labels | 列表 |  | 
| 广告组广告 | adGroup | 字符串 | \$1=, = | 
| 广告组广告 | costMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组广告 | approvalStatus | 字符串 | \$1=, = | 
| 广告组广告 | reviewStatus | 字符串 | \$1=, = | 
| 广告组广告 | adStrength | 字符串 | \$1=, = | 
| 广告组广告 | type | 字符串 | \$1=, = | 
| 广告组广告 | businessName | 字符串 | \$1=, =, LIKE | 
| 广告组广告 | date | 日期 | BETWEEN, =, <, >, <=, >= | 
| 广告组广告 | allConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组广告 | allConversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组广告 | conversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组广告 | conversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组广告 | valuePerAllConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组广告 | valuePerConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 广告组广告 | activeViewMeasurableCostMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组广告 | averageCost | 双精度 | \$1=, =, <, > | 
| 广告组广告 | costPerAllConversions | 双精度 | \$1=, =, <, > | 
| 广告组广告 | costPerConversion | 双精度 | \$1=, =, <, > | 
| 广告组广告 | clicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组广告 | averagePageViews | 双精度 | \$1=, =, <, > | 
| 广告组广告 | videoViews | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组广告 | allConversions | 双精度 | \$1=, =, <, > | 
| 广告组广告 | averageCpc | 双精度 | \$1=, =, <, > | 
| 广告组广告 | topImpressionPercentage | 双精度 | \$1=, =, <, > | 
| 广告组广告 | 展示 | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 广告组广告 | absoluteTopImpressionPercentage | 双精度 | \$1=, =, <, > | 
| 广告组广告 | activeViewCtr | 双精度 | \$1=, =, <, > | 
| 广告组广告 | ctr | 双精度 | \$1=, =, <, > | 
| 广告组广告 | conversionAction | 字符串 | \$1=, = | 
| 广告组广告 | conversionActionCategory | 字符串 | \$1=, = | 
| 广告组广告 | conversionActionName | 字符串 | \$1=, =, LIKE | 
| 广告组广告 | updateMask | 字符串 |  | 
| 广告组广告 | 创建 | 结构体 |  | 
| 广告组广告 | 更新 | 结构体 |  | 
| 广告组广告 | policyValidationParameter | 结构体 |  | 
| 广告组广告 | primaryStatus | 字符串 | \$1=, = | 
| 广告组广告 | primaryStatusReasons | 列表 |  | 
| 活动 | resourceName | 字符串 | \$1=, = | 
| 活动 | 状态 | 字符串 | \$1=, = | 
| 活动 | baseCampaign | 字符串 | \$1=, = | 
| 活动 | 名称 | 字符串 | \$1=, =, LIKE | 
| 活动 | id | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | campaignBudget | 字符串 | \$1=, =, LIKE | 
| 活动 | startDate | 日期 | BETWEEN, =, <, >, <=, >= | 
| 活动 | endDate | 日期 | BETWEEN, =, <, >, <=, >= | 
| 活动 | adServingOptimizationStatus | 字符串 | \$1=, = | 
| 活动 | advertisingChannelType | 字符串 | \$1=, = | 
| 活动 | advertisingChannelSubType | 字符串 | \$1=, = | 
| 活动 | experimentType | 字符串 | \$1=, = | 
| 活动 | servingStatus | 字符串 | \$1=, = | 
| 活动 | biddingStrategyType | 字符串 | \$1=, = | 
| 活动 | domainName | 字符串 | \$1=, =, LIKE | 
| 活动 | languageCode | 字符串 | \$1=, =, LIKE | 
| 活动 | useSuppliedUrlsOnly | 布尔值 | \$1=, = | 
| 活动 | positiveGeoTargetType | 字符串 | \$1=, = | 
| 活动 | negativeGeoTargetType | 字符串 | \$1=, = | 
| 活动 | paymentMode | 字符串 | \$1=, = | 
| 活动 | optimizationGoalTypes | 列表 |  | 
| 活动 | date | 日期 | BETWEEN, =, <, >, <=, >= | 
| 活动 | averageCost | 双精度 |  | 
| 活动 | clicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | costMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | 展示 | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | useAudienceGrouped | 布尔值 | \$1=, = | 
| 活动 | activeViewMeasurableCostMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | costPerAllConversions | 双精度 | \$1=, =, <, > | 
| 活动 | costPerConversion | 双精度 | \$1=, =, <, > | 
| 活动 | invalidClicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | publisherPurchasedClicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | averagePageViews | 双精度 | \$1=, =, <, > | 
| 活动 | videoViews | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动 | allConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 活动 | allConversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| 活动 | conversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 活动 | conversionsValueByConversionDate | 双精度 | \$1=, =, <, > | 
| 活动 | valuePerAllConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 活动 | valuePerConversionsByConversionDate | 双精度 | \$1=, =, <, > | 
| 活动 | allConversions | 双精度 | \$1=, =, <, > | 
| 活动 | absoluteTopImpressionPercentage | 双精度 | \$1=, =, <, > | 
| 活动 | searchAbsoluteTopImpressionShare | 双精度 | \$1=, =, <, > | 
| 活动 | averageCpc | 双精度 | \$1=, =, <, > | 
| 活动 | searchImpressionShare | 双精度 | \$1=, =, <, > | 
| 活动 | searchTopImpressionShare | 双精度 | \$1=, =, <, > | 
| 活动 | activeViewCtr | 双精度 | \$1=, =, <, > | 
| 活动 | ctr | 双精度 | \$1=, =, <, > | 
| 活动 | relativeCtr | 双精度 | \$1=, =, <, > | 
| 活动 | updateMask | 字符串 |  | 
| 活动 | 创建 | 结构体 |  | 
| 活动 | 更新 | 结构体 |  | 
| 活动预算 | resourceName | 字符串 | \$1=, = | 
| 活动预算 | id | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | 状态 | 字符串 | \$1=, = | 
| 活动预算 | deliveryMethod | 字符串 | \$1=, = | 
| 活动预算 | 周期 | 字符串 | \$1=, = | 
| 活动预算 | type | 字符串 | \$1=, = | 
| 活动预算 | 名称 | 字符串 | \$1=, =, LIKE | 
| 活动预算 | amountMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | explicitlyShared | 布尔值 | \$1=, = | 
| 活动预算 | referenceCount | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | hasRecommendedBudget | 布尔值 | \$1=, = | 
| 活动预算 | date | 日期 | BETWEEN, =, <, >, <=, >= | 
| 活动预算 | costMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | startDate | 日期 | BETWEEN, =, <, >, <=, >= | 
| 活动预算 | endDate | 日期 | BETWEEN, =, <, >, <=, >= | 
| 活动预算 | maximizeConversionValueTargetRoas | 双精度 | \$1=, =, <, > | 
| 活动预算 | maximizeConversionsTargetCpaMicros | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | selectiveOptimizationConversionActions | 字符串 |  | 
| 活动预算 | averageCost | 双精度 | \$1=, =, <, > | 
| 活动预算 | costPerAllConversions | 双精度 | \$1=, =, <, > | 
| 活动预算 | costPerConversion | 双精度 | \$1=, =, <, > | 
| 活动预算 | videoViews | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | clicks | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | allConversions | 双精度 | \$1=, =, <, > | 
| 活动预算 | valuePerAllConversions | 双精度 | \$1=, =, <, > | 
| 活动预算 | averageCpc | 双精度 | \$1=, =, <, > | 
| 活动预算 | 展示 | BigInteger | BETWEEN, =, \$1=, <, >, <=, >= | 
| 活动预算 | ctr | 双精度 | \$1=, =, <, > | 
| 活动预算 | updateMask | 字符串 |  | 
| 活动预算 | 创建 | 结构体 |  | 
| 活动预算 | 更新 | 结构体 |  | 

 **对查询进行分区** 

 如果您想在 Spark 中利用并发，可以提供附加 Spark 选项 `PARTITION_FIELD`、`LOWER_BOUND`、`UPPER_BOUND` 和 `NUM_PARTITIONS`。使用这些参数，原始查询将被拆分为 `NUM_PARTITIONS` 个子查询，这些子查询可以由 Spark 任务同时执行。
+  `PARTITION_FIELD`：用于对查询进行分区的字段的名称。
+  `LOWER_BOUND`：所选分区字段的包含下限值。

   对于日期，我们接受 Spark SQL 查询中使用的 Spark 日期格式。有效值示例：`"2024-02-06"`。
+  `UPPER_BOUND`：所选分区字段的排除上限值。
+  `NUM_PARTITIONS`：分区的数量。

 基于实体的分区字段支持详细信息如下表中所示。


| 实体名称 | 分区字段 | 数据类型 | 
| --- | --- | --- | 
| 广告组广告 | date | 日期 | 
| 广告组 | date | 日期 | 
| 活动 | date | 日期 | 
| 活动预算 | date | 日期 | 

 **示例** 

```
googleads_read = glueContext.create_dynamic_frame.from_options(
    connection_type="googleads",
    connection_options={
        "connectionName": "connectionName",
        "ENTITY_NAME": "campaign-3467***",
        "API_VERSION": "v16",
        "PARTITION_FIELD": "date"
        "LOWER_BOUND": "2024-01-01"
        "UPPER_BOUND": "2024-06-05"
        "NUM_PARTITIONS": "10"
    }
)
```