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/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