Reporting
Stay organized with collections
Save and categorize content based on your preferences.
The dynamic_search_ads_search_term_view
resource provides Dynamic Search Ads (DSAs) statistics based on search
terms. The search_term field
contains any matching queries that generated results.
In the following example, the GAQL query retrieves performance for the last
month:
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
| Search term |
Clicks |
Impressions |
Date |
Cost |
Landing Page URL |
| mars luxury |
0 |
20 |
2/20/2024 |
0 |
http://example.com/LuxuryMarsCruises |
| mars luxury |
0 |
14 |
2/21/2024 |
0 |
http://example.com/LuxuryMarsCruises |
| low cost mars |
0 |
24 |
2/20/2024 |
0 |
http://example.com/MarsOnABudget |
| low cost mars |
0 |
18 |
2/21/2024 |
0 |
http://example.com/MarsOnABudget |
| mars landmarks |
0 |
130 |
2/21/2024 |
0 |
http://example.com/MajorTouristSpots |
| mars funny face |
0 |
44 |
2/21/2024 |
0 |
http://example.com/MajorTouristSpots |
| space travel safety |
1 |
3 |
2/20/2024 |
0.05 |
http://example.com/ButIsItSafe |
| mars departure points |
0 |
11 |
2/21/2024 |
0 |
http://example.com/HowToGetToMars |
| mars beaches |
0 |
24 |
2/20/2024 |
0 |
http://example.com/MarsBeachVacations |
| mars beaches |
0 |
39 |
2/21/2024 |
0 |
http://example.com/MarsBeachVacations |
| mars canyoning |
0 |
23 |
2/21/2024 |
0 |
http://example.com/DayTripsAndActivities |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[null,null,["Last updated 2025-08-25 UTC."],[[["\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 |"]]
