SSIS Components for Google Ads

Build 24.0.9062

AdGroupSimulation

An ad group simulation. Supported combinations of advertising channel type, simulation type and simulation modification method is detailed below respectively. 1. SEARCH - CPC_BID - DEFAULT 2. SEARCH - CPC_BID - UNIFORM 3. SEARCH - TARGET_CPA - UNIFORM 4. SEARCH - TARGET_ROAS - UNIFORM 5. DISPLAY - CPC_BID - DEFAULT 6. DISPLAY - CPC_BID - UNIFORM 7. DISPLAY - TARGET_CPA - UNIFORM

Columns

Name Type Behavior Description
AdGroupSimulationAdGroupId Long ATTRIBUTE Output only. Ad group id of the simulation.
AdGroupSimulationCpcBidPointListPoints String ATTRIBUTE Projected metrics for a series of CPC bid amounts.
AdGroupSimulationCpvBidPointListPoints String ATTRIBUTE Projected metrics for a series of CPV bid amounts.
AdGroupSimulationEndDate Date ATTRIBUTE Output only. Last day on which the simulation is based, in YYYY-MM-DD format
AdGroupSimulationModificationMethod String ATTRIBUTE Output only. How the simulation modifies the field.

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

AdGroupSimulationResourceName String ATTRIBUTE Output only. The resource name of the ad group simulation. Ad group simulation resource names have the form: customers/{customer_id}/adGroupSimulations/{ad_group_id}~{type}~{modification_method}~{start_date}~{end_date}
AdGroupSimulationStartDate Date ATTRIBUTE Output only. First day on which the simulation is based, in YYYY-MM-DD format.
AdGroupSimulationTargetCpaPointListPoints String ATTRIBUTE Projected metrics for a series of target CPA amounts.
AdGroupSimulationTargetRoasPointListPoints String ATTRIBUTE Projected metrics for a series of target ROAS amounts.
AdGroupSimulationType String ATTRIBUTE Output only. The field that the simulation modifies.

使用できる値は次のとおりです。BID_MODIFIER, BUDGET, CPC_BID, CPV_BID, PERCENT_CPC_BID, TARGET_CPA, TARGET_IMPRESSION_SHARE, TARGET_ROAS, 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