SSIS Components for Google Ads

Build 24.0.9062

BiddingSeasonalityAdjustment

Represents a bidding seasonality adjustment. See 'About seasonality adjustments' at https://support.google.com/google-ads/answer/10369906.

Columns

Name Type Behavior Description
BiddingSeasonalityAdjustmentAdvertisingChannelTypes String ATTRIBUTE The seasonality adjustment will apply to all the campaigns under the listed channels retroactively as well as going forward when the scope of this adjustment is CHANNEL. The supported advertising channel types are DISPLAY, SEARCH and SHOPPING. Note: a seasonality adjustment with both advertising_channel_types and campaign_ids is not supported.

使用できる値は次のとおりです。DEMAND_GEN, DISPLAY, HOTEL, LOCAL, LOCAL_SERVICES, MULTI_CHANNEL, PERFORMANCE_MAX, SEARCH, SHOPPING, SMART, TRAVEL, UNKNOWN, UNSPECIFIED, VIDEO

BiddingSeasonalityAdjustmentCampaigns String ATTRIBUTE The seasonality adjustment will apply to the campaigns listed when the scope of this adjustment is CAMPAIGN. The maximum number of campaigns per event is 2000. Note: a seasonality adjustment with both advertising_channel_types and campaign_ids is not supported.
BiddingSeasonalityAdjustmentConversionRateModifier Double ATTRIBUTE Conversion rate modifier estimated based on expected conversion rate changes. When this field is unset or set to 1.0 no adjustment will be applied to traffic. The allowed range is 0.1 to 10.0.
BiddingSeasonalityAdjustmentDescription String ATTRIBUTE The description of the seasonality adjustment. The description can be at most 2048 characters.
BiddingSeasonalityAdjustmentDevices String ATTRIBUTE If not specified, all devices will be included in this adjustment. Otherwise, only the specified targeted devices will be included in this adjustment.

使用できる値は次のとおりです。CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN, UNSPECIFIED

BiddingSeasonalityAdjustmentEndDateTime String ATTRIBUTE Required. The exclusive end time of the seasonality adjustment in yyyy-MM-dd HH:mm:ss format. The length of [start_date_time, end_date_time) interval must be within (0, 14 days].
BiddingSeasonalityAdjustmentName String ATTRIBUTE The name of the seasonality adjustment. The name can be at most 255 characters.
BiddingSeasonalityAdjustmentResourceName String ATTRIBUTE Immutable. The resource name of the seasonality adjustment. Seasonality adjustment resource names have the form: customers/{customer_id}/biddingSeasonalityAdjustments/{seasonality_adjustment_id}
BiddingSeasonalityAdjustmentScope String ATTRIBUTE The scope of the seasonality adjustment.

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

BiddingSeasonalityAdjustmentSeasonalityAdjustmentId Long ATTRIBUTE Output only. The ID of the seasonality adjustment.
BiddingSeasonalityAdjustmentStartDateTime String ATTRIBUTE Required. The inclusive start time of the seasonality adjustment in yyyy-MM-dd HH:mm:ss format. A seasonality adjustment is forward looking and should be used for events that start and end in the future.
BiddingSeasonalityAdjustmentStatus String ATTRIBUTE Output only. The status of the seasonality adjustment.

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

CustomerId Long ATTRIBUTE Output only. The ID of the customer.

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