從 Google Ads 實體中讀取

先決條件

您想要從中讀取的 Google Ads 物件。請參閱以下支援的實體表格，以檢查可用實體。

支援的實體

實體	可以篩選	支援限制	支援排序依據	支援選取 *	支援分區
廣告群組廣告	是	是	是	否	是
廣告群組	是	是	是	否	是
行銷活動預算	是	是	是	是	是
帳戶預算	是	否	是	是	否
Campaign	是	是	是	是	是
帳戶	是	否	是	否	否

範例


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

Google Ads 實體和欄位詳細資訊

實體	欄位	資料類型	支援的運算子
帳戶	resourceName	String	!=, =
帳戶	callReportingEnabled	Boolean	!=, =
帳戶	callConversionReportingEnabled	Boolean	!=, =
帳戶	callConversionAction	String	!=, =
帳戶	conversionTrackingId	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	crossAccountConversionTrackingId	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	payPerConversionEligibilityFailureReasons	清單
帳戶	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	currencyCode	String	!=, =, LIKE
帳戶	timeZone	String	!=, =, LIKE
帳戶	autoTaggingEnabled	Boolean	!=, =
帳戶	hasPartnersBadge	Boolean	!=, =
帳戶	manager	Boolean	!=, =
帳戶	testAccount	Boolean	!=, =
帳戶	date	日期	BETWEEN, =, <, >, <=, >=
帳戶	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	acceptedCustomerDataTerms	Boolean
帳戶	conversionTrackingStatus	String	!=, =, LIKE
帳戶	enhancedConversionsForLeadsEnabled	Boolean
帳戶	googleAdsConversionCustomer	String
帳戶	status	String	!=, =
帳戶	allConversionsByConversionDate	Double	!=, =, <, >
帳戶	allConversionsValueByConversionDate	Double	!=, =, <, >
帳戶	conversionsByConversionDate	Double	!=, =, <, >
帳戶	conversionsValueByConversionDate	Double	!=, =, <, >
帳戶	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
帳戶	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	點按數	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	invalidClicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	costPerAllConversions	Double	!=, =, <, >
帳戶	costPerConversion	Double	!=, =, <, >
帳戶	轉換	Double	!=, =, <, >
帳戶	absoluteTopImpressionPercentage	Double	!=, =, <, >
帳戶	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	topImpressionPercentage	Double	!=, =, <, >
帳戶	averageCpc	Double	!=, =, <, >
帳戶	activeViewMeasurableCostMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶	averageCost	Double	!=, =, <, >
帳戶	ctr	Double	!=, =, <, >
帳戶	activeViewCtr	Double	!=, =, <, >
帳戶	searchImpressionShare	Double	!=, =, <, >
帳戶	conversionAction	String	!=, =
帳戶	conversionActionCategory	String	!=, =
帳戶	conversionActionName	String	!=, =, LIKE
帳戶預算	resourceName	String	!=, =
帳戶預算	status	String	!=, =
帳戶預算	proposedEndTimeType	String	!=, =
帳戶預算	approvedEndTimeType	String	!=, =
帳戶預算	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶預算	billingSetup	String	!=, =
帳戶預算	name	String	!=, =, LIKE
帳戶預算	approvedStartDateTime	DateTime	BETWEEN, =, <, >, <=, >=
帳戶預算	proposedSpendingLimitMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶預算	approvedSpendingLimitMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶預算	adjustedSpendingLimitMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
帳戶預算	amountServedMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	resourceName	String	!=, =, LIKE
廣告群組	status	String	!=, =, LIKE
廣告群組	type	String	!=, =, LIKE
廣告群組	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	name	String	!=, =, LIKE
廣告群組	行銷活動	String	!=, =
廣告群組	cpcBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	targetCpaMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	cpmBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	cpvBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	targetCpmMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	effectiveTargetCpaMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	date	日期	BETWEEN, =, <, >, <=, >=
廣告群組	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	useAudienceGrouped	Boolean	!=, =
廣告群組	effectiveCpcBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	allConversionsByConversionDate	Double	!=, =, <, >
廣告群組	allConversionsValueByConversionDate	Double	!=, =, <, >
廣告群組	conversionsByConversionDate	Double	!=, =, <, >
廣告群組	conversionsValueByConversionDate	Double	!=, =, <, >
廣告群組	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
廣告群組	valuePerConversionsByConversionDate	Double	!=, =, <, >
廣告群組	averageCost	Double	!=, =, <, >
廣告群組	costPerAllConversions	Double	!=, =, <, >
廣告群組	costPerConversion	Double	!=, =, <, >
廣告群組	averagePageViews	Double	!=, =, <, >
廣告群組	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	點按數	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	allConversions	Double	!=, =, <, >
廣告群組	averageCpc	Double	!=, =, <, >
廣告群組	absoluteTopImpressionPercentage	Double	!=, =, <, >
廣告群組	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組	topImpressionPercentage	Double	!=, =, <, >
廣告群組	activeViewCtr	Double	!=, =, <, >
廣告群組	ctr	Double	!=, =, <, >
廣告群組	searchTopImpressionShare	Double	!=, =, <, >
廣告群組	searchImpressionShare	Double	!=, =, <, >
廣告群組	searchAbsoluteTopImpressionShare	Double	!=, =, <, >
廣告群組	relativeCtr	Double	!=, =, <, >
廣告群組	conversionAction	String	!=, =
廣告群組	conversionActionCategory	String	!=, =
廣告群組	conversionActionName	String	!=, =, LIKE
廣告群組	updateMask	String
廣告群組	建立	Struct
廣告群組	update	Struct
廣告群組	primaryStatus	String	!=, =
廣告群組	primaryStatusReasons	清單
廣告群組廣告	resourceName	String	!=, =
廣告群組廣告	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組廣告	status	String	!=, =
廣告群組廣告	labels	清單
廣告群組廣告	adGroup	String	!=, =
廣告群組廣告	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組廣告	approvalStatus	String	!=, =
廣告群組廣告	reviewStatus	String	!=, =
廣告群組廣告	adStrength	String	!=, =
廣告群組廣告	type	String	!=, =
廣告群組廣告	businessName	String	!=, =, LIKE
廣告群組廣告	date	日期	BETWEEN, =, <, >, <=, >=
廣告群組廣告	allConversionsByConversionDate	Double	!=, =, <, >
廣告群組廣告	allConversionsValueByConversionDate	Double	!=, =, <, >
廣告群組廣告	conversionsByConversionDate	Double	!=, =, <, >
廣告群組廣告	conversionsValueByConversionDate	Double	!=, =, <, >
廣告群組廣告	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
廣告群組廣告	valuePerConversionsByConversionDate	Double	!=, =, <, >
廣告群組廣告	activeViewMeasurableCostMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組廣告	averageCost	Double	!=, =, <, >
廣告群組廣告	costPerAllConversions	Double	!=, =, <, >
廣告群組廣告	costPerConversion	Double	!=, =, <, >
廣告群組廣告	點按數	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組廣告	averagePageViews	Double	!=, =, <, >
廣告群組廣告	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組廣告	allConversions	Double	!=, =, <, >
廣告群組廣告	averageCpc	Double	!=, =, <, >
廣告群組廣告	topImpressionPercentage	Double	!=, =, <, >
廣告群組廣告	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
廣告群組廣告	absoluteTopImpressionPercentage	Double	!=, =, <, >
廣告群組廣告	activeViewCtr	Double	!=, =, <, >
廣告群組廣告	ctr	Double	!=, =, <, >
廣告群組廣告	conversionAction	String	!=, =
廣告群組廣告	conversionActionCategory	String	!=, =
廣告群組廣告	conversionActionName	String	!=, =, LIKE
廣告群組廣告	updateMask	String
廣告群組廣告	建立	Struct
廣告群組廣告	update	Struct
廣告群組廣告	policyValidationParameter	Struct
廣告群組廣告	primaryStatus	String	!=, =
廣告群組廣告	primaryStatusReasons	清單
Campaign	resourceName	String	!=, =
Campaign	status	String	!=, =
Campaign	baseCampaign	String	!=, =
Campaign	name	String	!=, =, LIKE
Campaign	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	campaignBudget	String	!=, =, LIKE
Campaign	startDate	日期	BETWEEN, =, <, >, <=, >=
Campaign	endDate	日期	BETWEEN, =, <, >, <=, >=
Campaign	adServingOptimizationStatus	String	!=, =
Campaign	advertisingChannelType	String	!=, =
Campaign	advertisingChannelSubType	String	!=, =
Campaign	experimentType	String	!=, =
Campaign	servingStatus	String	!=, =
Campaign	biddingStrategyType	String	!=, =
Campaign	domainName	String	!=, =, LIKE
Campaign	languageCode	String	!=, =, LIKE
Campaign	useSuppliedUrlsOnly	Boolean	!=, =
Campaign	positiveGeoTargetType	String	!=, =
Campaign	negativeGeoTargetType	String	!=, =
Campaign	paymentMode	String	!=, =
Campaign	optimizationGoalTypes	清單
Campaign	date	日期	BETWEEN, =, <, >, <=, >=
Campaign	averageCost	Double
Campaign	點按數	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	useAudienceGrouped	Boolean	!=, =
Campaign	activeViewMeasurableCostMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	costPerAllConversions	Double	!=, =, <, >
Campaign	costPerConversion	Double	!=, =, <, >
Campaign	invalidClicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	publisherPurchasedClicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	averagePageViews	Double	!=, =, <, >
Campaign	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign	allConversionsByConversionDate	Double	!=, =, <, >
Campaign	allConversionsValueByConversionDate	Double	!=, =, <, >
Campaign	conversionsByConversionDate	Double	!=, =, <, >
Campaign	conversionsValueByConversionDate	Double	!=, =, <, >
Campaign	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
Campaign	valuePerConversionsByConversionDate	Double	!=, =, <, >
Campaign	allConversions	Double	!=, =, <, >
Campaign	absoluteTopImpressionPercentage	Double	!=, =, <, >
Campaign	searchAbsoluteTopImpressionShare	Double	!=, =, <, >
Campaign	averageCpc	Double	!=, =, <, >
Campaign	searchImpressionShare	Double	!=, =, <, >
Campaign	searchTopImpressionShare	Double	!=, =, <, >
Campaign	activeViewCtr	Double	!=, =, <, >
Campaign	ctr	Double	!=, =, <, >
Campaign	relativeCtr	Double	!=, =, <, >
Campaign	updateMask	String
Campaign	建立	Struct
Campaign	update	Struct
行銷活動預算	resourceName	String	!=, =
行銷活動預算	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	status	String	!=, =
行銷活動預算	deliveryMethod	String	!=, =
行銷活動預算	period	String	!=, =
行銷活動預算	type	String	!=, =
行銷活動預算	name	String	!=, =, LIKE
行銷活動預算	amountMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	explicitlyShared	Boolean	!=, =
行銷活動預算	referenceCount	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	hasRecommendedBudget	Boolean	!=, =
行銷活動預算	date	日期	BETWEEN, =, <, >, <=, >=
行銷活動預算	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	startDate	日期	BETWEEN, =, <, >, <=, >=
行銷活動預算	endDate	日期	BETWEEN, =, <, >, <=, >=
行銷活動預算	maximizeConversionValueTargetRoas	Double	!=, =, <, >
行銷活動預算	maximizeConversionsTargetCpaMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	selectiveOptimizationConversionActions	String
行銷活動預算	averageCost	Double	!=, =, <, >
行銷活動預算	costPerAllConversions	Double	!=, =, <, >
行銷活動預算	costPerConversion	Double	!=, =, <, >
行銷活動預算	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	點按數	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	allConversions	Double	!=, =, <, >
行銷活動預算	valuePerAllConversions	Double	!=, =, <, >
行銷活動預算	averageCpc	Double	!=, =, <, >
行銷活動預算	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
行銷活動預算	ctr	Double	!=, =, <, >
行銷活動預算	updateMask	String
行銷活動預算	建立	Struct
行銷活動預算	update	Struct

分區查詢

如果想要在 Spark 中使用並行，可以提供其他 Spark 選項 PARTITION_FIELD、LOWER_BOUND、UPPER_BOUND、NUM_PARTITIONS。使用這些參數，原始查詢會分區為可由 Spark 任務並行執行的子查詢的 NUM_PARTITIONS 數目。

PARTITION_FIELD：用來分區查詢的欄位名稱。
LOWER_BOUND：所選分區欄位的包含下限值。

對於日期，我們接受 Spark SQL 查詢中使用的 Spark 日期格式。有效值的範例："2024-02-06"。
UPPER_BOUND：所選分區欄位的唯一上限值。
NUM_PARTITIONS：分區數目。

實體分區欄位支援詳細資訊如下表所示。

實體名稱	分區欄位	資料類型
廣告群組廣告	date	日期
廣告群組	date	日期
Campaign	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"
    }
)

您的瀏覽器已停用或無法使用 Javascript。

您必須啟用 Javascript，才能使用 AWS 文件。請參閱您的瀏覽器說明頁以取得說明。

文件慣用形式

設定 Google Ads 連線

Google Ads 連線選項