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/2020 | 0 | http://example.com/LuxuryMarsCruises |
| mars luxury | 0 | 14 | 2/21/2020 | 0 | http://example.com/LuxuryMarsCruises |
| low cost mars | 0 | 24 | 2/20/2020 | 0 | http://example.com/MarsOnABudget |
| low cost mars | 0 | 18 | 2/21/2020 | 0 | http://example.com/MarsOnABudget |
| mars landmarks | 0 | 130 | 2/21/2020 | 0 | http://example.com/MajorTouristSpots |
| mars funny face | 0 | 44 | 2/21/2020 | 0 | http://example.com/MajorTouristSpots |
| space travel safety | 1 | 3 | 2/20/2020 | 0.05 | http://example.com/ButIsItSafe |
| mars departure points | 0 | 11 | 2/21/2020 | 0 | http://example.com/HowToGetToMars |
| mars beaches | 0 | 24 | 2/20/2020 | 0 | http://example.com/MarsBeachVacations |
| mars beaches | 0 | 39 | 2/21/2020 | 0 | http://example.com/MarsBeachVacations |
| mars canyoning | 0 | 23 | 2/21/2020 | 0 | http://example.com/DayTripsAndActivities |