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. The editor can also let you see how everything will upload before putting it into the account, avoiding mistakes.
For the editor to convert your Excel sheet into ads, you will need the necessary column headers. The required ones will be:
However, we recommend you also add:
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. The limits are 30 for headlines and 90 for descriptions. If you are including Paths in your ad too, then the limit is 15 for them.
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.
Once data is downloaded, you can go to the expanded text ad section, and click “Make multiple changes” at the top.
From there you can copy your table from Excel and click the “paste from clipboard” button, which can then be processed into the account.
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.
Before you post you will want to check that everything is ready to go.
Here is a small list of things to look out for:
Now you can click ‘post’ to upload all of your changes.