查詢教戰手冊

本指南提供 Google Ads 查詢語言 (GAQL) 查詢，可傳回與常見 Google Ads UI 畫面相同的資料，並查詢地理常數。您可以直接使用這些查詢，也可以根據報表工作流程進行調整。

如要進一步瞭解使用者介面報表與 API 資源的對應關係，請參閱「Google Ads 使用者介面中的報表」。使用 Google Ads API Reporting Extension，在 Google Ads UI 中檢查 API 資源和欄位。使用互動式查詢建立工具建構及驗證自訂查詢。

設定 curl 環境變數

「curl」分頁會將壓縮的串流要求傳送至 REST searchStream 端點。執行 curl 指令前，請在殼層中設定下列環境變數：

• API_VERSION：API 版本號碼，不含開頭的 v (例如 26)。
• CUSTOMER_ID：10 位數的目標客戶代理 ID，不含連字號。
• MANAGER_CUSTOMER_ID：10 位數的管理員帳戶 ID (不含連字號)。如果您直接以目標客戶帳戶的身分進行驗證，請將 MANAGER_CUSTOMER_ID 設為 CUSTOMER_ID，或省略 login-customer-id 標頭 (請參閱「登入客戶 ID」)。
• OAUTH2_ACCESS_TOKEN：有效的 OAuth 2.0 存取權杖。

複製 Google Ads UI 畫面

本節介紹的 API 查詢，傳回的資料與 Google Ads UI 預設畫面相同。如果您正在建構的應用程式會顯示類似 Google Ads 的指標和資料，這些查詢可協助您從 API 擷取類似資料。

注意：除非另有說明，否則本指南中所有含日期的查詢，預設都會傳回過去七天的資料。如果 Google Ads UI 工作區列不含已移除的上層實體，請在子實體查詢中加入 AND campaign.status != 'REMOVED' 或 AND ad_group.status != 'REMOVED'。

提示：如要省略未使用的 resource_name 欄位並縮減 searchStream 酬載，請附加 PARAMETERS omit_unselected_resource_names = true 子句 (請參閱 omit_unselected_resource_names 參數)。

廣告活動

在 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

廣告群組

在 Google Ads UI 中，從預設的「廣告群組」總覽畫面擷取資料。

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

廣告

從 Google Ads UI 的預設「廣告」總覽畫面擷取資料。這項查詢會擷取回應式搜尋廣告AdTextAsset廣告標題和說明、最終到達網址，以及「廣告」和「廣告優異度」欄的廣告優異度。

注意：其他類型未移除的廣告仍會顯示，且 responsive_search_ad 欄位未設定。如要將結果限制為回應式搜尋廣告，請在 WHERE 子句中加入 AND ad_group_ad.ad.type = 'RESPONSIVE_SEARCH_AD'。

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

搜尋關鍵字

從 Google Ads UI 的預設「搜尋關鍵字」總覽畫面擷取資料。

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

搜尋字詞

從 Google Ads UI 的預設「搜尋字詞」總覽畫面擷取資料。

注意：search_term_view 資源會在廣告群組層級匯總，並排除最高成效廣告活動。如要查詢最高成效廣告活動搜尋字詞，請改用 campaign_search_term_view 資源 (請參閱「搜尋字詞成效」)。

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

目標對象

從 Google Ads UI 的預設「目標對象」總覽畫面擷取資料。

重點：Reporting API 會依條件 ID 傳回目標對象。如要取得顯示名稱，請在「代碼和格式」頁面提供的參考表格中查詢 ID。您可以根據 ad_group_criterion.type 欄位，判斷要使用哪種條件類型表格。

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

年齡 (受眾特徵)

從 Google Ads UI 的預設「年齡」客層總覽畫面擷取資料。

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

性別 (客層)

從 Google Ads UI 的預設「性別」客層總覽畫面擷取資料。

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

位置

從 Google Ads 使用者介面的預設「地區」總覽畫面擷取資料。

重點：Reporting API 會依條件 ID 傳回地區。如要取得顯示名稱，請在指定地理區域資料中查詢 campaign_criterion.location.geo_target_constant 欄位，或使用 API 查詢 geo_target_constant 資源。如要查詢「位置」>「地理區域報表」中的使用者實際位置或感興趣的位置，請查詢 geographic_view 資源。

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

刊登位置

在 Google Ads 使用者介面中，依序前往「內容」>「刊登位置」畫面，然後查詢 managed_placement_view 資源，擷取明確指定刊登位置的資料。

重點：如要選擇 managed_placement_view、group_placement_view、detail_placement_view 和 performance_max_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

廣告顯示位置

在 Google Ads UI 中，依序前往「內容」>「廣告顯示位置」畫面，然後查詢 group_placement_view 資源，擷取網域、行動應用程式和 YouTube 頻道刊登位置資料。

注意：API 會省略未達最低活動門檻的刊登位置，而不會傳回 UI 的「總計：其他」摘要列。請參閱「總計：其他」列和不提供刊登位置詳細資料的資料列。

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

刊登位置詳細資料

在 Google Ads 使用者介面中，依序前往「內容」>「廣告顯示位置」>「查看詳細資料」，然後查詢 detail_placement_view 資源，擷取網址層級和影片層級的刊登位置指標。

注意：由於 detail_placement_view 資源會評估每個網址或影片的活動門檻，因此其資料列總計可能低於 group_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

最高成效廣告活動刊登位置

如要從「洞察和報表」>「報表編輯器」中的「最高成效廣告活動刊登位置」預先定義報表擷取刊登位置曝光次數，請查詢 performance_max_placement_view 資源。

注意：performance_max_placement_view 資源只會公開 metrics.impressions 指標。在 v24 以上版本中，請新增 segments.ad_network_type 欄位，依聯播網區隔曝光 (請參閱最高成效廣告活動刊登位置檢視)。

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

到達網頁

查詢 landing_page_view 資源，從 Google Ads UI 的預設「到達網頁」畫面擷取資料。

注意：campaign 和 ad_group 資源會區隔 landing_page_view 指標，選取 ad_group 欄位會排除最高成效廣告活動。如要取得帳戶層級的網址總數，請省略 campaign.name 欄位。如要查詢 ValueTrack 替代和最終到達網址擴展後的網址，請查詢 expanded_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

素材資源群組

在 Google Ads 使用者介面中，查詢 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

產品

在 Google Ads 使用者介面中，查詢 shopping_performance_view 資源，從購物和最高成效廣告活動的「產品」畫面擷取產品層級指標。

注意：製作最高成效廣告活動報表時，請勿選取 ad_group 欄位，因為 ad_group 資源會區隔 shopping_performance_view 指標，並排除最高成效資料列。如要區分多個動態饋給中的商品，請新增 segments.product_merchant_id、segments.product_channel、segments.product_language 和 segments.product_feed_label 欄位。如要檢查目前的產品資格、診斷問題或曝光次數為零的商品目錄，請改為查詢 shopping_product 資源 (請參閱「購物廣告的產品報表」)。

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

隨手查地理區域常數

「代碼和格式」頁面提供 API 中大多數常數的參考表格。不過，您也可以使用 Google Ads 查詢語言，動態查詢部分常數。

以下範例說明如何依資源名稱或顯示名稱查詢位置。

依資源名稱

依資源名稱 geoTargetConstants/1014044 查詢 Mountain View, CA。

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

依顯示名稱

查詢美國的城市名稱「Mountain View」。

注意：依名稱查詢地點時，可能會收到多個相符結果。 依 geo_target_constant.country_code、geo_target_constant.target_type 和 geo_target_constant.status 篩選，並檢查 geo_target_constant.canonical_name，以區分用戶端程式碼中的結果清單。

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