Using Google Ads Editor for Bulk Uploading Ads

Why use Google Ads Editor?

We are pleased to present the expert opinion of Atomic Leap’s ppc specialists. For individual ads, when adding just a couple of new ads into an account, you can do it straight from the Google Ads interface. However, when uploading many ads across multiple campaigns and ad-groups, it can be much easier to use the Editor. This is because you can create ads much quicker in Excel, then upload them all in one go using the editor.

5 Google Ads Editor Benefits

  1. The editor can also let you see how everything will upload before putting it into the account, avoiding mistakes.
  2. The editor makes it easier to visualise the account structure.
  3. It makes it easier to edit settings and add items such as keywords and ads.
  4. It allows you to copy and paste items easily.
  5. It doesn’t set anything live until you post, so you can create campaigns, ads etc and check over the structure before actually setting it live – overall just giving you much more control compared to the browser interface.

What is bulk uploading with the google ads editor?

Bulk uploading is using a sheet of data to import an array of items the into google ads editor, making it much quicker and easier than using the browser interface.

How To Use Excel To Create Google AdWords Campaigns?

For the google ads editor to convert your Excel sheet into ads, you will need the necessary column headers. The required ones will be:

  • Campaign
  • Ad-group
  • Headline 1
  • Headline 2
  • Headline 3
  • Description 1
  • Description 2
  • Final URL

However, we recommend you also add:

  • Headlines 4-15
  • Descriptions 3-4
  • Path 1
  • Path 2
  • And if you need it, Labels
  • Headline and description positions (such as “Headline 1 position”)

What should my sheet look like?

Here is an example of how the sheet should look

Once you have your headers, you can create an ad per row. You can drag the rows down to get the same ad sections across multiple rows for your list of ad-groups. From here you can change the parts that need to be unique to the ad-group.

You can also put in an extra column with =LEN(cell) to see the lengths of each part, so that you can check that there aren’t too many characters.

What issues can I prevent at this stage?

In the sheet you want to make sure that the data you have is correctly formatted and is acceptable for Google, here are a few points to look out for:

  • Final URL must have https at the start of it
  • Ad copy lengths must be within the limits – this is 30 for headlines, 90 for descriptions and 15 for Paths
  • Make sure there are no editorial issues, such as phone numbers. Google have a page on this:

I have created the ads in Excel, how do I get this into Google Ads Editor?

Before you add the ads into the editor, its best to download the whole account first. This makes sure that when you post changes, it doesn’t revert any changes since you last downloaded the account. A shortcut for this is Ctrl-Shift-T.

Importing into the Google Ads Editor:

Now for adding the ads into the editor – which they have made a very simple and easy process now that you have the sheet with the data.

At the bottom left of the editor, in the Manage section under the ads dropdown, click on “Responsive search ads”. Then you can click on the “Make multiple changes” button at the top.

This box will appear, the first thing to change is the Destination, select “My data includes columns for campaigns and/or ad groups.”

Now go to your sheet, select your table of data (you can use Ctrl + A if the current selected cell is within the table) and in the editor click the option for “Paste from clipboard”.

When it’s finished processing, it will give you a summary of what’s been added, make sure that they all say added instead of modified. If you find that it is modifying existing ads instead, you can stop this by adding a column in Excel called “Headline 1#Original”. Put any value in for this column and it will force the editor to create a new ad instead of modifying an existing one.

My ads are in Google Ads Editor, how do I post them?

Before you post you will want to check that everything is ready to go. 

Processing the data:

Now click Process, this will bring up a “changes made” box, showing you what was Updated, Added or Skipped, plus any errors for your data. If everything is as expected, you can finish and do a last check through in the editor before posting your new ads!

Here is a small list of things to look out for:

  • Errors – these come up as red or yellow and will tell you want the issue is when you click on them. If they are red, the editor won’t even attempt to upload them.
  • That the ads have imported to the correct places. You can see how many ads are in each ad-group/campaign and see if it matches with your plan.
  • That no new campaigns or ad-groups were made. If the names were typed wrong in Excel, then it will create a new campaign or ad-group. Anything new is highlighted in bold in the editor.
  • That you have paused previous ads if you are replacing any.

If you had errors, you can revert and cancel and make sure the data you are importing from the sheet is corrected before trying again.