Lecture à partir d’entités Google Ads

Prérequis

Un objet Google Ads à partir duquel vous souhaitez lire. Reportez-vous au tableau des entités prises en charge ci-dessous pour vérifier les entités disponibles.

Entités prises en charge

Entité	Peut être filtré	Limit prise en charge	Order by prise en charge	Select prise en charge*	Partitionnement pris en charge
Ad Group Ad	Oui	Oui	Oui	Non	Oui
Ad Group	Oui	Oui	Oui	Non	Oui
Campaign Budget	Oui	Oui	Oui	Oui	Oui
Account Budget	Oui	Non	Oui	Oui	Non
Campagne	Oui	Oui	Oui	Oui	Oui
Compte	Oui	Non	Oui	Non	Non

Exemple


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

Détails des entités et des champs Google Ads

Entité	Champ	Type de données	Opérateurs pris en charge
Compte	resourceName	Chaîne	!=, =
Compte	callReportingEnabled	Booléen	!=, =
Compte	callConversionReportingEnabled	Booléen	!=, =
Compte	callConversionAction	Chaîne	!=, =
Compte	conversionTrackingId	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	crossAccountConversionTrackingId	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	payPerConversionEligibilityFailureReasons	Liste
Compte	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	currencyCode	Chaîne	!=, =, LIKE
Compte	timeZone	Chaîne	!=, =, LIKE
Compte	autoTaggingEnabled	Booléen	!=, =
Compte	hasPartnersBadge	Booléen	!=, =
Compte	manager	Booléen	!=, =
Compte	testAccount	Booléen	!=, =
Compte	date	Date	BETWEEN, =, <, >, <=, >=
Compte	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	acceptedCustomerDataTerms	Booléen
Compte	conversionTrackingStatus	Chaîne	!=, =, LIKE
Compte	enhancedConversionsForLeadsEnabled	Booléen
Compte	googleAdsConversionCustomer	Chaîne
Compte	status	Chaîne	!=, =
Compte	allConversionsByConversionDate	Double	!=, =, <, >
Compte	allConversionsValueByConversionDate	Double	!=, =, <, >
Compte	conversionsByConversionDate	Double	!=, =, <, >
Compte	conversionsValueByConversionDate	Double	!=, =, <, >
Compte	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
Compte	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	clicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	invalidClicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	costPerAllConversions	Double	!=, =, <, >
Compte	costPerConversion	Double	!=, =, <, >
Compte	conversions	Double	!=, =, <, >
Compte	absoluteTopImpressionPercentage	Double	!=, =, <, >
Compte	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	topImpressionPercentage	Double	!=, =, <, >
Compte	averageCpc	Double	!=, =, <, >
Compte	activeViewMeasurableCostMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Compte	averageCost	Double	!=, =, <, >
Compte	ctr	Double	!=, =, <, >
Compte	activeViewCtr	Double	!=, =, <, >
Compte	searchImpressionShare	Double	!=, =, <, >
Compte	conversionAction	Chaîne	!=, =
Compte	conversionActionCategory	Chaîne	!=, =
Compte	conversionActionName	Chaîne	!=, =, LIKE
Account Budget	resourceName	Chaîne	!=, =
Account Budget	status	Chaîne	!=, =
Account Budget	proposedEndTimeType	Chaîne	!=, =
Account Budget	approvedEndTimeType	Chaîne	!=, =
Account Budget	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Account Budget	billingSetup	Chaîne	!=, =
Account Budget	name	Chaîne	!=, =, LIKE
Account Budget	approvedStartDateTime	DateTime	BETWEEN, =, <, >, <=, >=
Account Budget	proposedSpendingLimitMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Account Budget	approvedSpendingLimitMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Account Budget	adjustedSpendingLimitMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Account Budget	amountServedMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	resourceName	Chaîne	!=, =, LIKE
Ad Group	status	Chaîne	!=, =, LIKE
Ad Group	type	Chaîne	!=, =, LIKE
Ad Group	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	name	Chaîne	!=, =, LIKE
Ad Group	campaign	Chaîne	!=, =
Ad Group	cpcBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	targetCpaMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	cpmBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	cpvBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	targetCpmMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	effectiveTargetCpaMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	date	Date	BETWEEN, =, <, >, <=, >=
Ad Group	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	useAudienceGrouped	Booléen	!=, =
Ad Group	effectiveCpcBidMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	allConversionsByConversionDate	Double	!=, =, <, >
Ad Group	allConversionsValueByConversionDate	Double	!=, =, <, >
Ad Group	conversionsByConversionDate	Double	!=, =, <, >
Ad Group	conversionsValueByConversionDate	Double	!=, =, <, >
Ad Group	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
Ad Group	valuePerConversionsByConversionDate	Double	!=, =, <, >
Ad Group	averageCost	Double	!=, =, <, >
Ad Group	costPerAllConversions	Double	!=, =, <, >
Ad Group	costPerConversion	Double	!=, =, <, >
Ad Group	averagePageViews	Double	!=, =, <, >
Ad Group	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	clicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	allConversions	Double	!=, =, <, >
Ad Group	averageCpc	Double	!=, =, <, >
Ad Group	absoluteTopImpressionPercentage	Double	!=, =, <, >
Ad Group	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group	topImpressionPercentage	Double	!=, =, <, >
Ad Group	activeViewCtr	Double	!=, =, <, >
Ad Group	ctr	Double	!=, =, <, >
Ad Group	searchTopImpressionShare	Double	!=, =, <, >
Ad Group	searchImpressionShare	Double	!=, =, <, >
Ad Group	searchAbsoluteTopImpressionShare	Double	!=, =, <, >
Ad Group	relativeCtr	Double	!=, =, <, >
Ad Group	conversionAction	Chaîne	!=, =
Ad Group	conversionActionCategory	Chaîne	!=, =
Ad Group	conversionActionName	Chaîne	!=, =, LIKE
Ad Group	updateMask	Chaîne
Ad Group	créer	Struct
Ad Group	mise à jour	Struct
Ad Group	primaryStatus	Chaîne	!=, =
Ad Group	primaryStatusReasons	Liste
Ad Group Ad	resourceName	Chaîne	!=, =
Ad Group Ad	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group Ad	status	Chaîne	!=, =
Ad Group Ad	labels	Liste
Ad Group Ad	adGroup	Chaîne	!=, =
Ad Group Ad	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group Ad	approvalStatus	Chaîne	!=, =
Ad Group Ad	reviewStatus	Chaîne	!=, =
Ad Group Ad	adStrength	Chaîne	!=, =
Ad Group Ad	type	Chaîne	!=, =
Ad Group Ad	businessName	Chaîne	!=, =, LIKE
Ad Group Ad	date	Date	BETWEEN, =, <, >, <=, >=
Ad Group Ad	allConversionsByConversionDate	Double	!=, =, <, >
Ad Group Ad	allConversionsValueByConversionDate	Double	!=, =, <, >
Ad Group Ad	conversionsByConversionDate	Double	!=, =, <, >
Ad Group Ad	conversionsValueByConversionDate	Double	!=, =, <, >
Ad Group Ad	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
Ad Group Ad	valuePerConversionsByConversionDate	Double	!=, =, <, >
Ad Group Ad	activeViewMeasurableCostMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group Ad	averageCost	Double	!=, =, <, >
Ad Group Ad	costPerAllConversions	Double	!=, =, <, >
Ad Group Ad	costPerConversion	Double	!=, =, <, >
Ad Group Ad	clicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group Ad	averagePageViews	Double	!=, =, <, >
Ad Group Ad	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group Ad	allConversions	Double	!=, =, <, >
Ad Group Ad	averageCpc	Double	!=, =, <, >
Ad Group Ad	topImpressionPercentage	Double	!=, =, <, >
Ad Group Ad	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Ad Group Ad	absoluteTopImpressionPercentage	Double	!=, =, <, >
Ad Group Ad	activeViewCtr	Double	!=, =, <, >
Ad Group Ad	ctr	Double	!=, =, <, >
Ad Group Ad	conversionAction	Chaîne	!=, =
Ad Group Ad	conversionActionCategory	Chaîne	!=, =
Ad Group Ad	conversionActionName	Chaîne	!=, =, LIKE
Ad Group Ad	updateMask	Chaîne
Ad Group Ad	créer	Struct
Ad Group Ad	mise à jour	Struct
Ad Group Ad	policyValidationParameter	Struct
Ad Group Ad	primaryStatus	Chaîne	!=, =
Ad Group Ad	primaryStatusReasons	Liste
Campagne	resourceName	Chaîne	!=, =
Campagne	status	Chaîne	!=, =
Campagne	baseCampaign	Chaîne	!=, =
Campagne	name	Chaîne	!=, =, LIKE
Campagne	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	campaignBudget	Chaîne	!=, =, LIKE
Campagne	startDate	Date	BETWEEN, =, <, >, <=, >=
Campagne	endDate	Date	BETWEEN, =, <, >, <=, >=
Campagne	adServingOptimizationStatus	Chaîne	!=, =
Campagne	advertisingChannelType	Chaîne	!=, =
Campagne	advertisingChannelSubType	Chaîne	!=, =
Campagne	experimentType	Chaîne	!=, =
Campagne	servingStatus	Chaîne	!=, =
Campagne	biddingStrategyType	Chaîne	!=, =
Campagne	domainName	Chaîne	!=, =, LIKE
Campagne	languageCode	Chaîne	!=, =, LIKE
Campagne	useSuppliedUrlsOnly	Booléen	!=, =
Campagne	positiveGeoTargetType	Chaîne	!=, =
Campagne	negativeGeoTargetType	Chaîne	!=, =
Campagne	paymentMode	Chaîne	!=, =
Campagne	optimizationGoalTypes	Liste
Campagne	date	Date	BETWEEN, =, <, >, <=, >=
Campagne	averageCost	Double
Campagne	clicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	useAudienceGrouped	Booléen	!=, =
Campagne	activeViewMeasurableCostMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	costPerAllConversions	Double	!=, =, <, >
Campagne	costPerConversion	Double	!=, =, <, >
Campagne	invalidClicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	publisherPurchasedClicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	averagePageViews	Double	!=, =, <, >
Campagne	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campagne	allConversionsByConversionDate	Double	!=, =, <, >
Campagne	allConversionsValueByConversionDate	Double	!=, =, <, >
Campagne	conversionsByConversionDate	Double	!=, =, <, >
Campagne	conversionsValueByConversionDate	Double	!=, =, <, >
Campagne	valuePerAllConversionsByConversionDate	Double	!=, =, <, >
Campagne	valuePerConversionsByConversionDate	Double	!=, =, <, >
Campagne	allConversions	Double	!=, =, <, >
Campagne	absoluteTopImpressionPercentage	Double	!=, =, <, >
Campagne	searchAbsoluteTopImpressionShare	Double	!=, =, <, >
Campagne	averageCpc	Double	!=, =, <, >
Campagne	searchImpressionShare	Double	!=, =, <, >
Campagne	searchTopImpressionShare	Double	!=, =, <, >
Campagne	activeViewCtr	Double	!=, =, <, >
Campagne	ctr	Double	!=, =, <, >
Campagne	relativeCtr	Double	!=, =, <, >
Campagne	updateMask	Chaîne
Campagne	créer	Struct
Campagne	mise à jour	Struct
Campaign Budget	resourceName	Chaîne	!=, =
Campaign Budget	id	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	status	Chaîne	!=, =
Campaign Budget	deliveryMethod	Chaîne	!=, =
Campaign Budget	point	Chaîne	!=, =
Campaign Budget	type	Chaîne	!=, =
Campaign Budget	name	Chaîne	!=, =, LIKE
Campaign Budget	amountMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	explicitlyShared	Booléen	!=, =
Campaign Budget	referenceCount	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	hasRecommendedBudget	Booléen	!=, =
Campaign Budget	date	Date	BETWEEN, =, <, >, <=, >=
Campaign Budget	costMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	startDate	Date	BETWEEN, =, <, >, <=, >=
Campaign Budget	endDate	Date	BETWEEN, =, <, >, <=, >=
Campaign Budget	maximizeConversionValueTargetRoas	Double	!=, =, <, >
Campaign Budget	maximizeConversionsTargetCpaMicros	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	selectiveOptimizationConversionActions	Chaîne
Campaign Budget	averageCost	Double	!=, =, <, >
Campaign Budget	costPerAllConversions	Double	!=, =, <, >
Campaign Budget	costPerConversion	Double	!=, =, <, >
Campaign Budget	videoViews	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	clicks	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	allConversions	Double	!=, =, <, >
Campaign Budget	valuePerAllConversions	Double	!=, =, <, >
Campaign Budget	averageCpc	Double	!=, =, <, >
Campaign Budget	impressions	BigInteger	BETWEEN, =, !=, <, >, <=, >=
Campaign Budget	ctr	Double	!=, =, <, >
Campaign Budget	updateMask	Chaîne
Campaign Budget	créer	Struct
Campaign Budget	mise à jour	Struct

Requêtes de partitionnement

Les options Spark supplémentaires PARTITION_FIELD, LOWER_BOUND, UPPER_BOUND et NUM_PARTITIONS peuvent être indiquées si vous souhaitez utiliser la simultanéité dans Spark. Avec ces paramètres, la requête d’origine serait divisée en NUM_PARTITIONS nombres de sous-requêtes pouvant être exécutées simultanément par les tâches Spark.

PARTITION_FIELD : le nom du champ à utiliser pour partitionner la requête.
LOWER_BOUND : une valeur limite inférieure inclusive du champ de partition choisi.

Pour le champ Date, nous acceptons le format de date Spark utilisé dans les requêtes SQL Spark. Exemples de valeurs valides : "2024-02-06".
UPPER_BOUND : une valeur limite supérieure exclusive du champ de partition choisi.
NUM_PARTITIONS : nombre de partitions.

Les détails relatifs à la prise en charge des champs de partitionnement par entité sont présentés dans le tableau suivant.

Nom de l’entité	Champ de partitionnement	Type de données
Ad Group Ad	date	Date
Ad Group	date	Date
Campagne	date	Date
Campaign Budget	date	Date

Exemple


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"
    }
)

Avertissement JavaScript est désactivé ou n'est pas disponible dans votre navigateur.

Pour que vous puissiez utiliser la documentation AWS, Javascript doit être activé. Vous trouverez des instructions sur les pages d'aide de votre navigateur.

Conventions de rédaction

Configuration des connexions Google Ads

Options de connexion Google Ads