Livre de recettes sur les requêtes

Ce guide fournit des requêtes en langage de requête Google Ads (GAQL) qui renvoient les mêmes données que les écrans courants de l'interface utilisateur Google Ads et recherchent des constantes géographiques. Utilisez ces requêtes sans modification ou adaptez-les à vos workflows de création de rapports.

Pour un mappage plus large des rapports de l'UI avec les ressources de l'API, consultez Rapports dans l'UI Google Ads. Utilisez l'extension de création de rapports de l'API Google Ads pour inspecter les ressources et les champs de l'API dans l'interface utilisateur de Google Ads. Utilisez le générateur de requêtes interactif pour créer et valider des requêtes personnalisées.

Définir les variables d'environnement curl

Les onglets curl envoient des requêtes de streaming compressées au point de terminaison REST searchStream. Avant d'exécuter une commande curl, définissez les variables d'environnement suivantes dans votre shell :

  • API_VERSION : numéro de version de l'API sans v au début (par exemple, 26).
  • CUSTOMER_ID : numéro client cible à 10 chiffres, sans tirets.
  • MANAGER_CUSTOMER_ID : ID de compte administrateur à 10 chiffres, sans tirets. Si vous vous authentifiez directement en tant que compte client cible, définissez MANAGER_CUSTOMER_ID sur CUSTOMER_ID ou omettez l'en-tête login-customer-id (voir Numéro client de connexion).
  • OAUTH2_ACCESS_TOKEN : jeton d'accès OAuth 2.0 valide.

Répliquer les écrans de l'UI Google Ads

Cette section présente des requêtes API qui renvoient les mêmes données que les écrans par défaut de l'interface utilisateur Google Ads. Si vous créez une application qui affiche des métriques et des données de la même manière que Google Ads, ces requêtes peuvent vous aider à extraire des données analogues de l'API.

Campagnes

Récupérez les données de l'écran de présentation par défaut Campagnes dans l'UI Google Ads.

GAQL

SELECT campaign.name,
  campaign_budget.amount_micros,
  campaign.status,
  campaign.optimization_score,
  campaign.advertising_channel_type,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  campaign.bidding_strategy_type
FROM campaign
WHERE segments.date DURING LAST_7_DAYS
  AND campaign.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT campaign.name,
      campaign_budget.amount_micros,
      campaign.status,
      campaign.optimization_score,
      campaign.advertising_channel_type,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      campaign.bidding_strategy_type
    FROM campaign
    WHERE segments.date DURING LAST_7_DAYS
      AND campaign.status != 'REMOVED'
  "
}
EOF

Groupes d'annonces

Récupérez les données de l'écran de présentation par défaut Groupes d'annonces dans l'UI Google Ads.

GAQL

SELECT ad_group.name,
  campaign.name,
  ad_group.status,
  ad_group.type,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM ad_group
WHERE segments.date DURING LAST_7_DAYS
  AND ad_group.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group.name,
      campaign.name,
      ad_group.status,
      ad_group.type,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM ad_group
    WHERE segments.date DURING LAST_7_DAYS
      AND ad_group.status != 'REMOVED'
  "
}
EOF

Annonces

Récupérez les données de l'écran de présentation Annonces par défaut dans l'UI Google Ads. Cette requête récupère les titres et descriptions des annonces responsives sur le Réseau de Recherche AdTextAsset, les URL finales et l'efficacité des annonces pour les colonnes Annonce et Efficacité de l'annonce.

GAQL

SELECT ad_group_ad.ad.responsive_search_ad.headlines,
  ad_group_ad.ad.responsive_search_ad.descriptions,
  ad_group_ad.ad.final_urls,
  campaign.name,
  ad_group.name,
  ad_group_ad.status,
  ad_group_ad.policy_summary.approval_status,
  ad_group_ad.ad.type,
  ad_group_ad.ad_strength,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM ad_group_ad
WHERE segments.date DURING LAST_7_DAYS
  AND ad_group_ad.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group_ad.ad.responsive_search_ad.headlines,
      ad_group_ad.ad.responsive_search_ad.descriptions,
      ad_group_ad.ad.final_urls,
      campaign.name,
      ad_group.name,
      ad_group_ad.status,
      ad_group_ad.policy_summary.approval_status,
      ad_group_ad.ad.type,
      ad_group_ad.ad_strength,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM ad_group_ad
    WHERE segments.date DURING LAST_7_DAYS
      AND ad_group_ad.status != 'REMOVED'
  "
}
EOF

Mots clés de recherche

Récupérez les données de l'écran de présentation par défaut Mots clés pour le Réseau de Recherche dans l'UI Google Ads.

GAQL

SELECT ad_group_criterion.keyword.text,
  campaign.name,
  ad_group.name,
  ad_group_criterion.system_serving_status,
  ad_group_criterion.keyword.match_type,
  ad_group_criterion.approval_status,
  ad_group_criterion.final_urls,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM keyword_view
WHERE segments.date DURING LAST_7_DAYS
  AND ad_group_criterion.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group_criterion.keyword.text,
      campaign.name,
      ad_group.name,
      ad_group_criterion.system_serving_status,
      ad_group_criterion.keyword.match_type,
      ad_group_criterion.approval_status,
      ad_group_criterion.final_urls,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM keyword_view
    WHERE segments.date DURING LAST_7_DAYS
      AND ad_group_criterion.status != 'REMOVED'
  "
}
EOF

Termes de recherche

Récupérez les données de l'écran de présentation par défaut Termes de recherche dans l'UI Google Ads.

GAQL

SELECT search_term_view.search_term,
  segments.keyword.info.match_type,
  search_term_view.status,
  campaign.name,
  ad_group.name,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  campaign.advertising_channel_type
FROM search_term_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT search_term_view.search_term,
      segments.keyword.info.match_type,
      search_term_view.status,
      campaign.name,
      ad_group.name,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      campaign.advertising_channel_type
    FROM search_term_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Audiences

Récupérez les données de l'écran de présentation par défaut Audiences dans l'UI Google Ads.

GAQL

SELECT ad_group_criterion.resource_name,
  ad_group_criterion.type,
  campaign.name,
  ad_group.name,
  ad_group_criterion.system_serving_status,
  ad_group_criterion.bid_modifier,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  campaign.advertising_channel_type
FROM ad_group_audience_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group_criterion.resource_name,
      ad_group_criterion.type,
      campaign.name,
      ad_group.name,
      ad_group_criterion.system_serving_status,
      ad_group_criterion.bid_modifier,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      campaign.advertising_channel_type
    FROM ad_group_audience_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Âge (données démographiques)

Récupérez les données de l'écran de présentation par défaut des données démographiques Âge dans l'interface utilisateur Google Ads.

GAQL

SELECT ad_group_criterion.age_range.type,
  campaign.name,
  ad_group.name,
  ad_group_criterion.system_serving_status,
  ad_group_criterion.bid_modifier,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  campaign.advertising_channel_type
FROM age_range_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group_criterion.age_range.type,
      campaign.name,
      ad_group.name,
      ad_group_criterion.system_serving_status,
      ad_group_criterion.bid_modifier,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      campaign.advertising_channel_type
    FROM age_range_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Genre (données démographiques)

Récupérez les données de l'écran de présentation par défaut des données démographiques Sexe dans l'UI Google Ads.

GAQL

SELECT ad_group_criterion.gender.type,
  campaign.name,
  ad_group.name,
  ad_group_criterion.system_serving_status,
  ad_group_criterion.bid_modifier,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  campaign.advertising_channel_type
FROM gender_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group_criterion.gender.type,
      campaign.name,
      ad_group.name,
      ad_group_criterion.system_serving_status,
      ad_group_criterion.bid_modifier,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      campaign.advertising_channel_type
    FROM gender_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Zones

Récupérez les données de l'écran de présentation Zones géographiques par défaut dans l'UI Google Ads.

GAQL

SELECT campaign_criterion.location.geo_target_constant,
  campaign.name,
  campaign_criterion.bid_modifier,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM location_view
WHERE segments.date DURING LAST_7_DAYS
  AND campaign_criterion.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT campaign_criterion.location.geo_target_constant,
      campaign.name,
      campaign_criterion.bid_modifier,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM location_view
    WHERE segments.date DURING LAST_7_DAYS
      AND campaign_criterion.status != 'REMOVED'
  "
}
EOF

Emplacements

Récupérez les données des emplacements explicitement ciblés à partir de l'écran Contenu > Emplacements de l'interface utilisateur Google Ads en interrogeant la ressource managed_placement_view.

GAQL

SELECT ad_group_criterion.placement.url,
  campaign.name,
  ad_group.name,
  ad_group_criterion.status,
  ad_group_criterion.bid_modifier,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM managed_placement_view
WHERE segments.date DURING LAST_7_DAYS
  AND ad_group_criterion.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT ad_group_criterion.placement.url,
      campaign.name,
      ad_group.name,
      ad_group_criterion.status,
      ad_group_criterion.bid_modifier,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM managed_placement_view
    WHERE segments.date DURING LAST_7_DAYS
      AND ad_group_criterion.status != 'REMOVED'
  "
}
EOF

Où les annonces ont été diffusées

Récupérez les données d'emplacement des domaines, des applications mobiles et des chaînes YouTube à partir de l'écran Contenu > Où les annonces ont été diffusées dans l'UI Google Ads en interrogeant la ressource group_placement_view.

GAQL

SELECT group_placement_view.display_name,
  group_placement_view.target_url,
  group_placement_view.placement_type,
  campaign.name,
  ad_group.name,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM group_placement_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT group_placement_view.display_name,
      group_placement_view.target_url,
      group_placement_view.placement_type,
      campaign.name,
      ad_group.name,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM group_placement_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Détails de l'emplacement

Récupérez les métriques d'emplacement au niveau de l'URL et de la vidéo à partir de Contenu > Où les annonces ont été diffusées > Afficher les détails dans l'interface utilisateur Google Ads en interrogeant la ressource detail_placement_view.

GAQL

SELECT detail_placement_view.display_name,
  detail_placement_view.target_url,
  detail_placement_view.group_placement_target_url,
  detail_placement_view.placement_type,
  campaign.name,
  ad_group.name,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM detail_placement_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT detail_placement_view.display_name,
      detail_placement_view.target_url,
      detail_placement_view.group_placement_target_url,
      detail_placement_view.placement_type,
      campaign.name,
      ad_group.name,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM detail_placement_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Emplacements Performance Max

Récupérez les impressions d'emplacement à partir du rapport prédéfini Emplacement des campagnes Performance Max dans Insights et rapports > Éditeur de rapports en interrogeant la ressource performance_max_placement_view.

GAQL

SELECT performance_max_placement_view.display_name,
  performance_max_placement_view.target_url,
  performance_max_placement_view.placement_type,
  campaign.name,
  metrics.impressions
FROM performance_max_placement_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT performance_max_placement_view.display_name,
      performance_max_placement_view.target_url,
      performance_max_placement_view.placement_type,
      campaign.name,
      metrics.impressions
    FROM performance_max_placement_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Pages de destination

Récupérez les données de l'écran Pages de destination par défaut dans l'UI Google Ads en interrogeant la ressource landing_page_view.

GAQL

SELECT landing_page_view.unexpanded_final_url,
  campaign.name,
  metrics.mobile_friendly_clicks_percentage,
  metrics.speed_score,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM landing_page_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT landing_page_view.unexpanded_final_url,
      campaign.name,
      metrics.mobile_friendly_clicks_percentage,
      metrics.speed_score,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros
    FROM landing_page_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Groupes de composants

Récupérez les données de l'écran Groupes de composants pour les campagnes Performance Max dans l'interface utilisateur Google Ads en interrogeant la ressource asset_group.

GAQL

SELECT asset_group.name,
  campaign.name,
  asset_group.status,
  asset_group.ad_strength,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  metrics.conversions
FROM asset_group
WHERE segments.date DURING LAST_7_DAYS
  AND asset_group.status != 'REMOVED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT asset_group.name,
      campaign.name,
      asset_group.status,
      asset_group.ad_strength,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      metrics.conversions
    FROM asset_group
    WHERE segments.date DURING LAST_7_DAYS
      AND asset_group.status != 'REMOVED'
  "
}
EOF

Produits

Récupérez les métriques au niveau du produit à partir de l'écran Produits pour les campagnes Shopping et Performance Max dans l'interface utilisateur de Google Ads en interrogeant la ressource shopping_performance_view.

GAQL

SELECT segments.product_item_id,
  segments.product_title,
  segments.product_brand,
  campaign.name,
  campaign.advertising_channel_type,
  metrics.clicks,
  metrics.impressions,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros,
  metrics.conversions
FROM shopping_performance_view
WHERE segments.date DURING LAST_7_DAYS

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT segments.product_item_id,
      segments.product_title,
      segments.product_brand,
      campaign.name,
      campaign.advertising_channel_type,
      metrics.clicks,
      metrics.impressions,
      metrics.ctr,
      metrics.average_cpc,
      metrics.cost_micros,
      metrics.conversions
    FROM shopping_performance_view
    WHERE segments.date DURING LAST_7_DAYS
  "
}
EOF

Rechercher des constantes géographiques

La page Codes et formats fournit des tableaux de référence pour la plupart des constantes utilisées dans l'API. Toutefois, vous pouvez également rechercher de manière dynamique certaines constantes à l'aide du langage de requête Google Ads.

Cet exemple montre comment rechercher un emplacement à l'aide de son nom de ressource ou de son nom à afficher.

Par nom de ressource

Recherchez Mountain View, CA, par son nom de ressource geoTargetConstants/1014044.

GAQL

SELECT geo_target_constant.canonical_name,
  geo_target_constant.country_code,
  geo_target_constant.id,
  geo_target_constant.name,
  geo_target_constant.status,
  geo_target_constant.target_type
FROM geo_target_constant
WHERE geo_target_constant.resource_name = 'geoTargetConstants/1014044'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT geo_target_constant.canonical_name,
      geo_target_constant.country_code,
      geo_target_constant.id,
      geo_target_constant.name,
      geo_target_constant.status,
      geo_target_constant.target_type
    FROM geo_target_constant
    WHERE geo_target_constant.resource_name = 'geoTargetConstants/1014044'
  "
}
EOF

Par nom à afficher

Recherchez "Mountain View" en tant que nom de ville aux États-Unis.

GAQL

SELECT geo_target_constant.canonical_name,
  geo_target_constant.country_code,
  geo_target_constant.id,
  geo_target_constant.name,
  geo_target_constant.status,
  geo_target_constant.target_type
FROM geo_target_constant
WHERE geo_target_constant.country_code = 'US'
  AND geo_target_constant.target_type = 'City'
  AND geo_target_constant.name = 'Mountain View'
  AND geo_target_constant.status = 'ENABLED'

curl

curl --compressed --fail-with-body --request POST \
  "https://googleads.googleapis.com/v${API_VERSION}/customers/${CUSTOMER_ID}/googleAds:searchStream" \
  --header "Content-Type: application/json" \
  --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \
  --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \
  --data @- <<'EOF'
{
  "query": "
    SELECT geo_target_constant.canonical_name,
      geo_target_constant.country_code,
      geo_target_constant.id,
      geo_target_constant.name,
      geo_target_constant.status,
      geo_target_constant.target_type
    FROM geo_target_constant
    WHERE geo_target_constant.country_code = 'US'
      AND geo_target_constant.target_type = 'City'
      AND geo_target_constant.name = 'Mountain View'
      AND geo_target_constant.status = 'ENABLED'
  "
}
EOF