Getting future X points between two tRoas values for a bidding simulator

46 views
Skip to first unread message

Elad Ben-David

unread,
Nov 17, 2022, 12:58:31 PM11/17/22
to AdWords API and Google Ads API Forum
Hi

As seen on the UI:



Will this GAQL bring the desired results?


SELECT

bidding_strategy_simulation.bidding_strategy_id,

bidding_strategy_simulation.target_roas_point_list.points

FROM bidding_strategy_simulation

WHERE

bidding_strategy_simulation.type = 'TARGET_ROAS'

AND bidding_strategy_simulation.bidding_strategy_id = 1234

AND bidding_strategy_simulation.start_date > '2022-11-17'
AND bidding_strategy_simulation.start_date > '2022-11-27'
AND bidding_strategy.target_roas.target_roas IN (400.0, 410.0)





because some fields are output only, but I think we can filter by them:

bidding_strategy_simulation.end_date
Field description Output only. Last day on which the simulation is based, in YYYY-MM-DD format

--

•  Elad Ben-David (He / Him)

 Customer Solutions Engineer

•  el...@google.com

•  Google EEM

Available: Sun - Thu

  • New external solutions we offer.
  • Always: go/nohi



Google Ads API and AdWords API Forum

unread,
Nov 18, 2022, 4:55:46 AM11/18/22
to Google Ads API and AdWords API Forum
Re-posting the last inquiry  [https://groups.google.com/g/adwords-api/c/RLPDhGmoVNs] from the forum as it wasn't routed to our support queue.

Regards,
Carmela
Google Ads API Team

Google Ads API Forum Advisor

unread,
Nov 18, 2022, 9:45:02 AM11/18/22
to adwor...@googlegroups.com
Hi Elad,

Thank you for reaching out to our API support team.

As per this guide, bidding simulation time ranges are always in the past and would return results based on past performances with different bids. From the said guide it states :
  • Key Point: The time range is always in the past, as bid simulations predict how your ads would have performed at those times and under the same conditions, but with different bids.
Also, if you are referring to the bidding_strategy_simulation.start_date and/or bidding_strategy_simulation.end_date, these are listed and documented as Filterable = True.

Best regards,

Google Logo
Peter Laurence
Google Ads API Team
 


ref:_00D1U1174p._5004Q2gQHgY:ref
Reply all
Reply to author
Forward
0 new messages