As with other campaign types, you can use
to retrieve attributes and performance metrics for Smart campaigns.
Smart campaign metrics are available from the
search_term field contains any matching queries that generated
Impressions and clicks of Smart campaigns in last 30 days
The query below will retrieve impressions and clicks for each search term from the last 30 days for all Smart campaigns, segmented by date.
SELECT campaign.id, campaign.name, segments.date, metrics.impressions, metrics.clicks, smart_campaign_search_term_view.search_term FROM smart_campaign_search_term_view WHERE segments.date DURING LAST_30_DAYS
Top 10 search terms by impressions
The query below will retrieve the top 10 search terms that have generated the most impressions over the past 30 days, along with their cost.
SELECT campaign.id, campaign.name, segments.date, metrics.impressions, metrics.cost_micros, smart_campaign_search_term_view.search_term FROM smart_campaign_search_term_view ORDER BY metrics.impressions DESC LIMIT 10