Page Summary
-
The smart campaign search term view provides details about search terms that served in Smart campaigns.
-
Attributed resources for this view include campaign and customer, whose fields can be selected or used in WHERE clauses but will not segment metrics.
-
This page lists all metrics and segments compatible with
smart_campaign_search_term_viewin the SELECT clause, with a filter available to show only those usable whensmart_campaign_search_term_viewis in the FROM clause. -
Key fields available include the campaign the term served in, the resource name for the view, and the search term itself.
-
Available segments allow for breaking down data by date, day of week, month, month of year, quarter, week, and year.
-
Metrics that can be selected include clicks, cost in micros, and impressions.
A Smart campaign search term view.
| Attributed resources |
|---|
| campaign |
| customer |
Fields from the above resources may be selected along with this
resource in your SELECT and WHERE clauses. These fields will not segment
metrics in your SELECT clause.
Fields/Segments/Metrics
This page shows all metrics and segments that can be put in the same SELECT clause as the fields of smart_campaign_search_term_view.
However, when you specify smart_campaign_search_term_view in the FROM clause, some metrics and segments
cannot be used.
Use the following filter to show only the fields that can be used when smart_campaign_search_term_view is specified in the FROM clause.
Is smart_campaign_search_term_view specified in the FROM clause of your query?
| info_outline Resource fields |
|---|
| campaign |
| resource_name |
| search_term |
| layers Segments |
|---|
| date |
| day_of_week |
| month |
| month_of_year |
| quarter |
| week |
| year |
| show_chart Metrics |
|---|
| clicks |
| cost_micros |
| impressions |
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||