Script to automatically change the target ROAS in TROAS campaign

[Kate Bushell]

I am trying to find a way to change a Smart Bid ROAS at the campaign level perhaps linked to a google sheet like this.

In the code of the script, we could call out the name of the campaign.

In the google doc is a Hour of day / Day of week script.

https://docs.google.com/spreadsheets/d/1hYtZLSxksroLasg-90VkLvQ7FJ8pywnHmwUShQv4W2k/edit?usp=sharing

Any help would be greatly appreciated!

Thanks

[Google Ads Scripts Forum Advisor]

Hi Kate,

Thanks for reaching out. Harry here, from the Google Ads Scripts Team.

With the current script's version, may only retrieve Campaign level Target ROAS via GAQL reports (see campaign.target_roas.target_roas). Fortunately, through the new Google Ads Scripts Beta, you can now update the Campaign level Target ROAS via the setTargetRoas method (See AdsApp.​CampaignBidding). For shopping campaigns, please see AdsApp.​ShoppingCampaignBidding but video campaigns are currently not supported in beta. Please see Beta information for your reference. 

For the spreadsheet part that you would like, there's no reference currently on how to integrate the Spreadsheet Service with scripts beta but it should be possible and supported as described here. However, I believe you can still you use the examples in this link as reference to implementing the same service in beta.

Let me know how I can assist you further.

Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q2QFmE2:ref

[Kate Bushell]

Thank you for the quick reply, 

We would like to develop this script. Are there any channels we can utilize with you to help build this script out?

Thanks, 

Kate

[Google Ads Scripts Forum Advisor]

Hi Kate,

I work along with Harry. Allow me to assist you in this.

With regard to your concern, I'm afraid that this forum channel does not provide implementation support. However, if you encounter any issues/error while developing your script, please let us know. We'll be happy to assist you.

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

 

ref:_00D1U1174p._5004Q2QFmE2:ref