Reporting

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