Can I edit RSA via Script based on a Google Sheet?

496 views
Skip to first unread message

Gunther Hofmann

unread,
Dec 20, 2022, 4:43:16 PM12/20/22
to Google Ads Scripts Forum
Hello,
is it possible to edit components (e.g. Headline1) of an existing Responsive Search Ad (RSA) via Ads Script?

My idea is to create a Google Sheet in which I have, among others, the following columns: "Promotion Headline1" "Start Date" "End Date" (whether for all RSAs or selected RSAs in specific adgroups or campaigns doesn't matter for now).

For example, the spreadsheet will have 31 rows for the coming month of January 2023 and in each row there will be a different text in the field "Promotion Headline1", because there will be a new promotion every day. Via the start and end date I notify the script when each promotion Headline1 should be active.

I don't want to create a new RSA for each promotion/day (which is then only active for this day and then useless), but only one promotion RSA, in which I change the Headline1 daily via script.

I know how to create a RSA by script, but I haven't found a way to change a component (e.g. Headline1) of an existing RSA by script (with Ads Editor it's no problem, but there I can't time it).

Thanks and greetings,
Gunther

Google Ads Scripts Forum Advisor

unread,
Dec 21, 2022, 1:57:54 AM12/21/22
to adwords...@googlegroups.com

Hi Gunther,

 

Thank you for reaching out to us. This is Yasmin from the Google Ads Scripts Team.

 

I'm afraid it is not possible to edit the components of an existing Responsive Search Ad via Google Ads Scripts. You may check this link from our documentation on the available methods that can be done for Responsive Search Ads. If you are encountering issues in the Ads editor, you may instead raise this concern in the Google Ads API's respective public forum for further assistance.

 

Let me know if you have questions or other concerns.

 

Best regards,

 

Google Logo
Yasmin Gabrielle
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2hM8sx:ref

Sigurd Fabrin

unread,
Dec 21, 2022, 4:28:51 AM12/21/22
to Google Ads Scripts Forum
Hi Günther,

"it is not possible to edit the components of an existing Responsive Search Ad via Google Ads Scripts"
Well, technically correct. However..

I have done what you describe for years, and it works beautifully.

Use ad customisers in your RSAs and upload a file with your sales messages via bulk upload (this can be done via scripts, schedule or manually)

Unfortunately, Google have removed the possibility to use start- and end date in the feed itself. So you need to update the feed whenever you wish to change the ads. Or just update e.g. daily and if there's no changes, it will just import the same data again and again.


Sigurd

Gunther Hofmann

unread,
Dec 21, 2022, 6:11:06 AM12/21/22
to Google Ads Scripts Forum
Hello Sigurd,
thank you very much for your feedback.
Ad Customizer was my first idea too, but I didn't solve it without errors on the first try. The "edit by script" solution seemed less complex and error prone, so I didn't want to let that untried :-).
I will now try again via the way you described.
Thanks and greetings,
Gunther

Gunther Hofmann

unread,
Dec 21, 2022, 7:21:15 AM12/21/22
to Google Ads Scripts Forum
Brief feedback:
I have created a Google spreadsheet. This contains the columns Attributes, Data type and Account Value.
Then I created an "Ad Customizer data for text ads" in Google Ads and specified the Google spreadsheet as source (with Googlebot as user).
Everything looks ok in the preview, but when I press apply, an error message comes up:

Failed
Action not permitted
Invalid feed for this account setting

Does anyone have any idea how to solve this? Or should I push the promotion texts directly via a script instead of bulk upload?

preview.jpgerror.jpg

Google Ads Scripts Forum Advisor

unread,
Dec 22, 2022, 2:01:53 AM12/22/22
to adwords...@googlegroups.com

Hi All,

 

@Sigurd - Thank you for sharing your knowledge and practices in this community forum as well as for the clarification.

 

@Gunther - I'm afraid our team will be unable to comment with regard to the error you had experienced as it appears that you are bulk uploading via Google Ads UI. I would suggest you reach out to their Product Support Team for further insights on this as they would be better equipped to address it. Echoing Sigurd's previous response, you may need to update the feed whenever you wish to change the ads or just update e.g. daily and if there's no changes. It will just import the same data again and again. In the event that you do bulk uploading via Google Ads Scripts and encounter an issue on your end, please let us know along with your Google Ads Account ID and script name so we're able to further investigate and assist you.

Reply all
Reply to author
Forward
0 new messages