Quick Responsive Search Ad Builder

Overview

This is a Google Sheet tool that creates one Responsive Search Ad for each Ad Group using nothing other than each existing unique Headline and Description Line within that Ad Group. Obviously, there will be some redundant copy that comes through (nothing exactly the same, but both the Headlines "Summer Camps In NJ" and "NJ Summer Camps" would be eligible to enter the RSA), but it will spit out RSAs for every Ad Group with relevant copy in just a few minutes that you can just paste directly into Ads Editor to upload to the account. Instructions below!

Setting Up The Sheet

1. Make a copy of the sheet using the link above...you can also just use the sheet directly. But there's no need to use this as a one-sheet-per-client if you don't want to. You can just overwrite the content of the Input sheet when you want to use it for a new client.

2. For all Ad Groups that you want to add RSAs to, just download the Ad Report from Google Ads and format the sheet into the structure of the "Input" tab (Campaign, Ad Group, Headlines 1-3, Descriptions 1-2)

3. Delete existing content from rows 2-1000.  Then paste that sheet into the Input tab – DON'T include the Headers. The Header row is protected, so if you try and paste over it it will show a warning. Just paste in rows 2 and on from your report.

4. Go to the Assign Final URLs tab. An auto-generated list of all unique Ad Groups will be shown in Columns B & C.  In Column D, delete existing content and place in the Final URL that you'd like each Ad Group's RSA to direct traffic to.

5. Once URLs are assigned, go to the Output.csv tab. You can either download this as a CSV or just Copy & Paste directly from this sheet into the Google Ads Editor (under the Responsive Search Ad Page on the left-hand navigation).

6. Done! You should now have one RSA in every Ad Group in your account, and you can do a quick once-over to clean up redundant fields, etc. if desired!