Power BI Connector for Google Ads

Build 24.0.9062

CustomerSearchTermInsight

A Customer search term view. Historical data is available starting March 2023.

Columns

Name Type Behavior Description
CustomerSearchTermInsightCategoryLabel 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.
CustomerSearchTermInsightId Long ATTRIBUTE Output only. The ID of the insight.
CustomerSearchTermInsightResourceName String ATTRIBUTE Output only. The resource name of the customer level search term insight. Customer level search term insight resource names have the form: customers/{customer_id}/customerSearchTermInsights/{category_id}
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.
Campaign String SEGMENT Resource name of the campaign.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062