Power BI Connector for Google Ads

Build 24.0.9062

CampaignBidModifier

Represents a bid-modifiable only criterion at the campaign level.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

Columns

Name Type Behavior Description
CampaignBidModifierBidModifier Double ATTRIBUTE The modifier for the bid when the criterion matches.
CampaignBidModifierCampaign String ATTRIBUTE Output only. The campaign to which this criterion belongs.
CampaignBidModifierCriterionId Long ATTRIBUTE Output only. The ID of the criterion to bid modify. This field is ignored for mutates.
CampaignBidModifierInteractionTypeType String ATTRIBUTE The interaction type.

使用できる値は次のとおりです。CALLS, UNKNOWN, UNSPECIFIED

CampaignBidModifierResourceName String ATTRIBUTE Immutable. The resource name of the campaign bid modifier. Campaign bid modifier resource names have the form: customers/{customer_id}/campaignBidModifiers/{campaign_id}~{criterion_id}
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
InteractionEventTypes String METRIC The types of payable and free interactions.

使用できる値は次のとおりです。UNSPECIFIED, UNKNOWN, CLICK, ENGAGEMENT, VIDEO_VIEW, NONE

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