CampaignSearchTermInsight
A Campaign search term view. Historical data is available starting March 2023.
Columns
| Name | Type | Behavior | Description |
| CampaignSearchTermInsightCampaignId | Long | ATTRIBUTE | Output only. The ID of the campaign. |
| CampaignSearchTermInsightCategoryLabel | String | ATTRIBUTE | Output only. The label for the search category. An empty string denotes the catch-all category for search terms that didn't fit into another category. |
| CampaignSearchTermInsightId | Long | ATTRIBUTE | Output only. The ID of the insight. |
| CampaignSearchTermInsightResourceName | String | ATTRIBUTE | Output only. The resource name of the campaign level search term insight. Campaign level search term insight resource names have the form: customers/{customer_id}/campaignSearchTermInsights/{campaign_id}~{category_id} |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| Clicks | Long | METRIC | The number of clicks. |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| ConversionsFromInteractionsRate | Double | METRIC | Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or website on the Google Network. |
| SearchVolume | String | METRIC | Search volume range for a search term insight category. |
| AdGroup | String | SEGMENT | Resource name of the ad group. |
| AssetGroup | String | SEGMENT | Resource name of the asset group. |
| Date | Date | SEGMENT | Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. |
| Period | String | SEGMENT | Predefined date range.
使用できる値は次のとおりです。TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN |
| SearchSubcategory | String | SEGMENT | A search term subcategory. An empty string denotes the catch-all subcategory for search terms that didn't fit into another subcategory. |
| SearchTerm | String | SEGMENT | A search term. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |