Power BI Connector for Google Ads

Build 24.0.9062

CampaignSimulation

A campaign simulation. Supported combinations of advertising channel type, simulation type and simulation modification method is detailed below respectively. * SEARCH - CPC_BID - UNIFORM * SEARCH - CPC_BID - SCALING * SEARCH - TARGET_CPA - UNIFORM * SEARCH - TARGET_CPA - SCALING * SEARCH - TARGET_ROAS - UNIFORM * SEARCH - TARGET_IMPRESSION_SHARE - UNIFORM * SEARCH - BUDGET - UNIFORM * SHOPPING - BUDGET - UNIFORM * SHOPPING - TARGET_ROAS - UNIFORM * MULTI_CHANNEL - TARGET_CPA - UNIFORM * MULTI_CHANNEL - TARGET_ROAS - UNIFORM * DISCOVERY - TARGET_CPA - DEFAULT * DISPLAY - TARGET_CPA - UNIFORM * PERFORMANCE_MAX - TARGET_CPA - UNIFORM * PERFORMANCE_MAX - TARGET_ROAS - UNIFORM * PERFORMANCE_MAX - BUDGET - UNIFORM

Columns

Name Type Behavior Description
CampaignSimulationBudgetPointListPoints String ATTRIBUTE Projected metrics for a series of budget amounts.
CampaignSimulationCampaignId Long ATTRIBUTE Output only. Campaign id of the simulation.
CampaignSimulationCpcBidPointListPoints String ATTRIBUTE Projected metrics for a series of CPC bid amounts.
CampaignSimulationEndDate Date ATTRIBUTE Output only. Last day on which the simulation is based, in YYYY-MM-DD format
CampaignSimulationModificationMethod String ATTRIBUTE Output only. How the simulation modifies the field.

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

CampaignSimulationResourceName String ATTRIBUTE Output only. The resource name of the campaign simulation. Campaign simulation resource names have the form: customers/{customer_id}/campaignSimulations/{campaign_id}~{type}~{modification_method}~{start_date}~{end_date}
CampaignSimulationStartDate Date ATTRIBUTE Output only. First day on which the simulation is based, in YYYY-MM-DD format.
CampaignSimulationTargetCpaPointListPoints String ATTRIBUTE Projected metrics for a series of target CPA amounts.
CampaignSimulationTargetImpressionSharePointListPoints String ATTRIBUTE Projected metrics for a specific target impression share value.
CampaignSimulationTargetRoasPointListPoints String ATTRIBUTE Projected metrics for a series of target ROAS amounts.
CampaignSimulationType 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