Script to assign campaign to portfolio strategy

[Valentin Berne]

Hi,

I'm looking to find a script that can assign the correct portfolio strategy to a campaign based on its performance.

I have 3 tROAS portfolio strategies (one set to 100%, one to 200% and the last one set to 300%).

Each of the portfolio strategy has a number of campaigns.

Let's say campaign XYZ, currently within the tROAS portfolio strategy set to 200%, had an actual ROAS of 275% in the past X days. Is there a script that can assign campaign XYZ to the tROAS portfolio strategy set to 300%?

Thanks for the help.

[Google Ads Scripts Forum Advisor]

Hello Valentin,

I’m James from the Google Ads scripts support team. Thank you for reaching out to us.

Could you please provide more details about your concern so that we can have a clear understanding on what you are trying to achieve via Google Ads scripts? By mentioning “portfolio strategy”, do you mean bidding strategy? 

Moreover, can you also share some screenshots of your Google Ads account UI showing the data that you’re pertaining to, so that we can accurately guide you with your concern? Kindly send the requested screenshots via “Reply privately to author” option or through this email alias <googleadsscr...@google.com>.

Regards,

James Howell Google Ads Scripts Team

ref:_00D1U1174p._5004Q2eOLNN:ref

[Valentin Berne]

Thanks for the answer, James.

Yes, I do mean portfolio bidding strategies.

What I'm trying to achieve is to reproduce something that is doable in SA360 by setting campaign rules with conditions. Here's how it look like in SA360:

The aim of this rule is to add a campaign to a bidding strategy based on that campaign's performance in the past x days. 

E.G: 

If actual ROAS for campaign XYZ in the past 14 days is less than x%, then add campaign XYZ to portfolio bidding strategy ABC

and: If actual ROAS for campaign XYZ in the past 14 days is between x% and y%, then add campaign XYZ to portfolio bidding strategy DEF.

and: If actual ROAS for campaign XYZ in the past 14 days is greater than y%, then add campaign XYZ to portfolio bidding strategy GHI.

Is there a way to do that via a script?

Thank you very much for your help.

On Thursday, 15 September 2022 at 09:12:52 UTC+2 adsscripts wrote:

Hello Valentin,

I’m James from the Google Ads scripts support team. Thank you for reaching out to us.

Could you please provide more details about your concern so that we can have a clear understanding on what you are trying to achieve via Google Ads scripts? By mentioning “portfolio strategy”, do you mean bidding strategy? 

Moreover, can you also share some screenshots of your Google Ads account UI showing the data that you’re pertaining to, so that we can accurately guide you with your concern? Kindly send the requested screenshots via “Reply privately to author” option or through this email alias <googleadsscripts-support@google.com>.

Regards,

[Google Ads Scripts Forum]

Hi,

This is Yasmin from the Google Ads scripts team. Kindly excuse us as your message failed to be routed in our support queue. On that note, please refrain from posting information which includes private information as this forum is public. With this, I've redacted your latest message and included a copy below without the screenshot.

Would you be able to confirm if you are doing bulk uploads via Google Ads scripts or the Google Ads UI? Please note that we only provide support to bulk uploads via Google Ads scripts. 

Regards,
Yasmin
Google Ads Scripts Team

---

Hi you guys I know this is an older thread and (I dont know if this is even the right spot) But Idk how to get in contact with anyone else. I need your help, please. You all are far more advanced than me. So all I am trying to do is download a CSV file from my downloads folder into my google campaign  more advanced so hopefully this will be a simple one for you. I'm in the Campaign level I go to the three dots where it says more. I click upload from computer. I select CSV File I want to import. I Hit apply. And every time I get 100% fail rate 0 successful due to error message that reads "No header row found in this sheet"  but I do have a headers on my CVS sheets. I've tried uploading a google spreadsheet also with no luck. I've made sure that there is a header but this problem still continues. If anyone can help me or has any advise at all on how to get these files to upload It will be greatly appreciated. 

On Thursday, September 29, 2022 at 6:13:26 PM UTC+8 Google Ads Scripts Forum wrote:

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/HzOxMLiP-VE/m/9sLXvNNbAwAJ) from the forum as it wasn't routed to our support queue.

Regards,
Yasmin
Google Ads Scripts Team

On Tuesday, September 20, 2022 at 7:37:47 AM UTC+8 deshu...@gmail.com wrote:

Hi you guys I know this is an older thread and (I dont know if this is even the right spot) But Idk how to get in contact with anyone else. I need your help, please. You all are far more advanced than me. So all I am trying to do is download a CSV file from my downloads folder into my google campaign  more advanced so hopefully this will be a simple one for you. I'm in the Campaign level I go to the three dots where it says more. I click upload from computer. I select CSV File I want to import. I Hit apply. And every time I get 100% fail rate 0 successful due to error message that reads "No header row found in this sheet"  but I do have a headers on my CVS sheets. I've tried uploading a google spreadsheet also with no luck. I've made sure that there is a header but this problem still continues. If anyone can help me or has any advise at all on how to get these files to upload It will be greatly appreciated. 

Moreover, can you also share some screenshots of your Google Ads account UI showing the data that you’re pertaining to, so that we can accurately guide you with your concern? Kindly send the requested screenshots via “Reply privately to author” option or through this email alias <googleadsscr...@google.com>.

Regards,