Power BI Connector for Google Ads

Build 26.0.9655

CampaignSearchTermInsight

This report provides a high-level view of search demand at the campaign

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
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.
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
ConversionsFromInteractionsRate Double METRIC Conversions from interactions divided by the number of ad interactions
ConversionsValue Double METRIC The value of conversions. This only includes conversion actions which
Ctr Double METRIC The number of clicks your ad receives (Clicks) divided by the number
Impressions Long METRIC Count of how often your ad has appeared on a search results page or
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.
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
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) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655