bidding_strategy_simulation

Help me build a query

A bidding strategy simulation. Supported combinations of simulation type and simulation modification method are detailed below respectively. 1. TARGET_CPA - UNIFORM 2. TARGET_ROAS - UNIFORM

Attributed resources
bidding_strategy
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

bidding_strategy_simulation.bidding_strategy_id Field description Output only. Bidding strategy shared set id of the simulation. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

bidding_strategy_simulation.end_date Field description Output only. Last day on which the simulation is based, in YYYY-MM-DD format Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

bidding_strategy_simulation.modification_method Field description Output only. How the simulation modifies the field. Category ATTRIBUTE Data Type ENUM DEFAULT SCALING UNIFORM UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.SimulationModificationMethodEnum.SimulationModificationMethod Filterable True Selectable True Sortable True Repeated False

bidding_strategy_simulation.resource_name Field description Output only. The resource name of the bidding strategy simulation. Bidding strategy simulation resource names have the form: customers/{customer_id}/biddingStrategySimulations/{bidding_strategy_id}~{type}~{modification_method}~{start_date}~{end_date} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

bidding_strategy_simulation.start_date Field description Output only. First day on which the simulation is based, in YYYY-MM-DD format. Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

bidding_strategy_simulation.target_cpa_point_list.points Field description Projected metrics for a series of target CPA amounts. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v18.common.TargetCpaSimulationPoint Filterable False Selectable True Sortable False Repeated True

bidding_strategy_simulation.target_roas_point_list.points Field description Projected metrics for a series of target ROAS amounts. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v18.common.TargetRoasSimulationPoint Filterable False Selectable True Sortable False Repeated True

bidding_strategy_simulation.type Field description Output only. The field that the simulation modifies. Category ATTRIBUTE Data Type ENUM BID_MODIFIER BUDGET CPC_BID CPV_BID PERCENT_CPC_BID TARGET_CPA TARGET_IMPRESSION_SHARE TARGET_ROAS UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v18.enums.SimulationTypeEnum.SimulationType Filterable True Selectable True Sortable True Repeated False