報表
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
dynamic_search_ads_search_term_view
資源會根據搜尋字詞提供動態搜尋廣告 (DSA) 統計資料。search_term
欄位包含產生結果的任何相符查詢。
在下列範例中,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
搜尋字詞 |
點擊 |
曝光 |
日期 |
費用 |
到達網頁網址 |
mars luxury |
0 |
20 |
2024 年 2 月 20 日 |
0 |
http://example.com/LuxuryMarsCruises |
mars luxury |
0 |
14 |
2024 年 2 月 21 日 |
0 |
http://example.com/LuxuryMarsCruises |
低成本火星任務 |
0 |
24 |
2024 年 2 月 20 日 |
0 |
http://example.com/MarsOnABudget |
低成本火星任務 |
0 |
18 |
2024 年 2 月 21 日 |
0 |
http://example.com/MarsOnABudget |
火星地標 |
0 |
130 |
2024 年 2 月 21 日 |
0 |
http://example.com/MajorTouristSpots |
火星搞笑臉 |
0 |
44 |
2024 年 2 月 21 日 |
0 |
http://example.com/MajorTouristSpots |
太空旅行安全 |
1 |
3 |
2024 年 2 月 20 日 |
0.05 |
http://example.com/ButIsItSafe |
火星出發點 |
0 |
11 |
2024 年 2 月 21 日 |
0 |
http://example.com/HowToGetToMars |
火星海灘 |
0 |
24 |
2024 年 2 月 20 日 |
0 |
http://example.com/MarsBeachVacations |
火星海灘 |
0 |
39 |
2024 年 2 月 21 日 |
0 |
http://example.com/MarsBeachVacations |
火星峽谷 |
0 |
23 |
2024 年 2 月 21 日 |
0 |
http://example.com/DayTripsAndActivities |
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2025-08-26 (世界標準時間)。
[null,null,["上次更新時間:2025-08-26 (世界標準時間)。"],[[["\u003cp\u003eThe \u003ccode\u003edynamic_search_ads_search_term_view\u003c/code\u003e resource provides statistics for Dynamic Search Ads (DSAs) based on user search terms.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003esearch_term\u003c/code\u003e field shows the queries that triggered your ads and led to impressions or clicks.\u003c/p\u003e\n"],["\u003cp\u003eYou can use GAQL queries to retrieve performance data, like clicks, impressions, cost, and landing page, for specific periods, such as the last month, based on search terms.\u003c/p\u003e\n"],["\u003cp\u003eThe example provided demonstrates how to use a GAQL query to retrieve DSA performance metrics for the previous month.\u003c/p\u003e\n"]]],[],null,["# Reporting\n\nThe [`dynamic_search_ads_search_term_view`](/google-ads/api/fields/v21/dynamic_search_ads_search_term_view)\nresource provides Dynamic Search Ads (DSAs) [statistics based on search\nterms](//support.google.com/google-ads/answer/9054156). The `search_term` field\ncontains any matching queries that generated results.\n\nIn the following example, the GAQL query retrieves performance for the last\nmonth: \n\n SELECT\n dynamic_search_ads_search_term_view.search_term,\n metrics.clicks,\n metrics.impressions,\n segments.date,\n metrics.cost_micros,\n dynamic_search_ads_search_term_view.landing_page\n FROM dynamic_search_ads_search_term_view\n WHERE segments.date DURING LAST_MONTH\n\n| Search term | Clicks | Impressions | Date | Cost | Landing Page URL |\n|-----------------------|--------|-------------|-----------|------|------------------------------------------|\n| mars luxury | 0 | 20 | 2/20/2024 | 0 | http://example.com/LuxuryMarsCruises |\n| mars luxury | 0 | 14 | 2/21/2024 | 0 | http://example.com/LuxuryMarsCruises |\n| low cost mars | 0 | 24 | 2/20/2024 | 0 | http://example.com/MarsOnABudget |\n| low cost mars | 0 | 18 | 2/21/2024 | 0 | http://example.com/MarsOnABudget |\n| mars landmarks | 0 | 130 | 2/21/2024 | 0 | http://example.com/MajorTouristSpots |\n| mars funny face | 0 | 44 | 2/21/2024 | 0 | http://example.com/MajorTouristSpots |\n| space travel safety | 1 | 3 | 2/20/2024 | 0.05 | http://example.com/ButIsItSafe |\n| mars departure points | 0 | 11 | 2/21/2024 | 0 | http://example.com/HowToGetToMars |\n| mars beaches | 0 | 24 | 2/20/2024 | 0 | http://example.com/MarsBeachVacations |\n| mars beaches | 0 | 39 | 2/21/2024 | 0 | http://example.com/MarsBeachVacations |\n| mars canyoning | 0 | 23 | 2/21/2024 | 0 | http://example.com/DayTripsAndActivities |"]]