campaign_simulation

Help me build a query

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

Attributed resources
campaign
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.

campaign_simulation.budget_point_list.points Field description Projected metrics for a series of budget amounts. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v18.common.BudgetSimulationPoint Filterable False Selectable True Sortable False Repeated True

campaign_simulation.campaign_id Field description Output only. Campaign id of the simulation. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

campaign_simulation.cpc_bid_point_list.points Field description Projected metrics for a series of CPC bid amounts. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v18.common.CpcBidSimulationPoint Filterable False Selectable True Sortable False Repeated True

campaign_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

campaign_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

campaign_simulation.resource_name Field description 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} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

campaign_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

campaign_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

campaign_simulation.target_impression_share_point_list.points Field description Projected metrics for a specific target impression share value. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v18.common.TargetImpressionShareSimulationPoint Filterable False Selectable True Sortable False Repeated True

campaign_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

campaign_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