--- title: RSA Migration Script --- [![02-Primary-Word-Mark--Dark--1](https://hs.optmyzr.com/hubfs/02-Primary-Word-Mark--Dark--1.png)](https://www.optmyzr.com/) # Free Google Ads Script for Migrating to RSAs ![script output](https://hs.optmyzr.com/hubfs/script%20output.jpg) #### Get a spreadsheet with suggested ads The script generates a Google Sheet with suggested RSA ads, making it easy to apply your own changes before uploading the new ads to Google. ![ETA ad migrator](https://hs.optmyzr.com/hubfs/ETA%20ad%20migrator.jpg) #### Use ETAs to Generate RSAs The script uses your existing ad texts to suggest new RSA assets including headlines and descriptions. ## Create RSA ads from ETA ads Simply taking your existing text from expanded text ads and adding them to new RSA ads in your existing ad groups can boost conversions 7% at a similar CPA or ROAS. Use this free script from Optmyzr to make sure all ad groups have RSAs. The script builds a bulk sheet with new RSAs for your entire account. It pulls text from existing ads and adds them as assets to suggested new RSAs. After reviewing the proposed RSAs and making any changes you want in the spreadsheet, you can bulk upload it in the Google Ads UI. [Download the script code](https://gist.github.com/siliconvallaeys/9b3967340f58738e62329b777e33c6fd) ## Instructions Step 1 ### Copy the code Copy the [script code](https://gist.github.com/siliconvallaeys/9b3967340f58738e62329b777e33c6fd) and add it as a new script in your Google Ads account.  Step 2 ### Create the spreadsheet Create a [copy of this spreadsheet](https://docs.google.com/spreadsheets/d/1rLYAFkZDtoyB6bQPJ2eniF-Od-3YSoUXxTb4ZfglQ50/copy) in your Google Drive.  Step 3 ### Customize the script Add the URL to the spreadsheet you created in step 2 to line 23 of the code you copied into your Ads account in step 1. Step 4 ### Run the script Run the script so that it will fill your spreadsheet with new RSAs from your existing ETAs. Step 5 ### Review your ads Make any edits you want to the suggested RSAs in the spreadsheet Step 6 ### Upload your RSAs Use the bulk upload feature in Google Ads to upload the new RSA ads from your spreadsheet. RESOURCES ## More PPC Resources #### Script for Putting Google Ads Data in a Spreadsheet A free Google Ads scripts that lets you write a simple GAQL query and add the resulting data to a tab in a Google Sheet. Ideal for automating your raw Google Ads reports. [Read more](https://www.optmyzr.com/blog/a-script-to-put-any-adwords-data-in-a-spreadsheet/) #### Bid by Weather Use Optmyzr as an automation layer to change bids based on weather conditions. [Read more](https://www.optmyzr.com/blog/thinking-outside-the-box-2-bid-by-weather/) #### Google Ads Reporting Fields A list of all the data points available in the Ads API for inclusion in your own script-based automations [Read more](https://developers.google.com/google-ads/api/fields/v9/overview) #### PPC Town Hall Watch PPC experts discuss current issues in online advertising. New episodes twice per month! [Read more](https://www.optmyzr.com/ppctownhall/) [![10 Secondary Wordmark (white)](https://hs.optmyzr.com/hubfs/10%20Secondary%20Wordmark%20(white).png)](https://www.optmyzr.com/) 282 San Antonio Road Mountain View CA 94040 ### PPC Town Hall - [Browse Library](https://www.optmyzr.com/ppctownhall/) ### Paid Media Blog - [Explore Articles](https://www.optmyzr.com/blog/) ### Case Studies - [Read Stories](https://www.optmyzr.com/case-studies/) ### Product Comparisons - [Compare Optmyzr](https://www.optmyzr.com/compare/) © 2013-2024 Optmyzr Inc. All rights reserved. Read our: [Data Processor Agreement](https://www.optmyzr.com/information/data-processor-agreement/) • [Privacy Policy](https://www.optmyzr.com/information/privacy-policy/) • [Terms of Use](https://www.optmyzr.com/information/terms-of-use/) [Powered by Atlas - a B2B SaaS HubSpot theme](https://www.kalungi.com/atlas-hubspot-theme-for-b2b-saas-software)