get avg. target roas ,actual roas as per attached screenshot

[Vijaysinh Parmar]

Hi,

I am trying to get avg. target roas , actual roas, etc. fields for campaigns which are having bidding strategy "TARGET ROAS", as per the attached screenshot.

Could you please let me know from which report I can get this data?

I tried using the bid strategy report (see below query)but I did not find anything using that.

SELECT bidding_strategy.id,bidding_strategy.name,bidding_strategy.target_roas.cpc_bid_ceiling_micros, bidding_strategy.target_roas.cpc_bid_floor_micros,
            bidding_strategy.target_roas.target_roas, metrics.conversions_value,metrics.conversions,metrics.cost_micros FROM bidding_strategy WHERE segments.date = '{$date}';

Could you please help to get these data using API?

[Google Ads API Forum Advisor]

Hi Vijaysinh,

Thank you for reaching us out. I am Sherwin from Google Ads API support team. I hope that you are doing well today.

With regard to your concern on how to get the avg target roas, could you please provide us a full screenshot of the UI including the customer id so that we can check on our end what is the equivalent fields in the Google Ads API for the information that you've shown in the provided screenshot? If not, we can raise a feature request regarding this. You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

If you have other concerns, please do not hesitate to reply on this thread. Have a great day!

Warm regards,

Sherwin Vincent Google Ads API Team

ref:_00D1U1174p._5004Q2b78pV:ref