dynamic_search_ads_search_term_view 资源提供按搜索字词细分的动态搜索广告 (DSA) 效果指标。search_term 字段包含生成结果的匹配搜索查询,以及动态选择的 landing_page、headline、page_url(如果从 DSA 网页 Feed 中投放)和关键字或网址匹配指示器(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
响应示例
下表展示了查询返回的值(segments.date 采用 YYYY-MM-DD 格式,metrics.cost_micros 采用账号币种的百万分之一):
search_term |
clicks |
impressions |
date |
cost_micros |
landing_page |
|---|---|---|---|---|---|
| 火星豪华 | 0 | 20 | 2024-02-20 | 0 | https://example.com/LuxuryMarsCruises |
| 火星豪华 | 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 |
| 火星鬼脸 | 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 |