dynamic_search_ads_search_term_view 資源提供按搜尋字詞區隔的動態搜尋廣告 (DSA) 成效指標。search_term 欄位會顯示產生結果的相符查詢,以及動態選取的 landing_page、headline、page_url (從動態搜尋廣告網頁動態饋給放送時),以及關鍵字或網址相符指標 (has_matching_keyword、has_negative_keyword 和 has_negative_url)。您也可以使用 segments.webpage 依觸發條件區隔,或查詢 webpage_view,取得依動態廣告目標 (webpage 條件) 匯總的成效。
查詢示例
在下列範例中,GAQL 查詢會擷取上個月的動態搜尋廣告搜尋字詞成效:
SELECT
dynamic_search_ads_search_term_view.search_term,
metrics.clicks,
metrics.impressions,
segments.date,
metrics.cost_micros,
dynamic_search_ads_search_term_view.landing_page
FROM dynamic_search_ads_search_term_view
WHERE segments.date DURING LAST_MONTH
回應範例
下表說明查詢傳回的值 (YYYY-MM-DD 格式的 segments.date,以及以帳戶幣別的百萬分之一為單位的 metrics.cost_micros):
search_term |
clicks |
impressions |
date |
cost_micros |
landing_page |
|---|---|---|---|---|---|
| mars luxury | 0 | 20 | 2024-02-20 | 0 | https://example.com/LuxuryMarsCruises |
| mars luxury | 0 | 14 | 2024-02-21 | 0 | https://example.com/LuxuryMarsCruises |
| 低成本火星 | 0 | 24 | 2024-02-20 | 0 | https://example.com/MarsOnABudget |
| 低成本火星 | 0 | 18 | 2024-02-21 | 0 | https://example.com/MarsOnABudget |
| 火星地標 | 0 | 130 | 2024-02-21 | 0 | https://example.com/MajorTouristSpots |
| mars funny face | 0 | 44 | 2024-02-21 | 0 | https://example.com/MajorTouristSpots |
| 太空旅行安全 | 1 | 3 | 2024-02-20 | 50000 | https://example.com/ButIsItSafe |
| 火星出發地點 | 0 | 11 | 2024-02-21 | 0 | https://example.com/HowToGetToMars |
| 火星海灘 | 0 | 24 | 2024-02-20 | 0 | https://example.com/MarsBeachVacations |
| 火星海灘 | 0 | 39 | 2024-02-21 | 0 | https://example.com/MarsBeachVacations |
| 火星峽谷 | 0 | 23 | 2024-02-21 | 0 | https://example.com/DayTripsAndActivities |