Sep 18

AdWords Editor Checklist

By charles kirkland | Adwords

AdWords Editor

AdWords Editor is a free downloadable application to manage your AdWords campaign. You can make bulk changes by importing all of the account data and then uploading the campaigns back into the account for the changes to take effect. Here you can even work offline and make changes. When you go online you can upload the same. You can download the AdWords Editor for Mac or Windows from here: Google AdWords Editor.

Upon opening the application you will see the above shown interface. To add an account you need to click on Add, as shown in the screenshot above.

Next a dialogue box will appear where you have to sign in with your AdWords account.

In the next dialogue box, you can either download all the campaigns or choose which ones to download.

Upon clicking the Open button you can see all of the campaigns. You can also click on Ad groups on the left hand side and see all of the Ad groups that are on that account. You can even see the keywords and ads by clicking on them on the left sidebar.

Now let's make some sheets from where we can upload the data by copying it into the Editor.

This is a campaign sheet where you have to include the Campaign name, Budget, Status and Campaign type. Make sure you use the same column names, otherwise Editor won’t pick it up. Copy this to your clipboard.

Now select Campaigns on the left side bar and then click on Make Multiple Changes.

As you click on Make Multiple Changes, a new dialogue box will appear wherein you have to put the excel sheet data. I hope you already have copied the campaign sheet. Now click on Paste from Clipboard button and wait for the data to populate. Look over the data, and if everything looks good, then click Process.

Here in this dialogue box you have to review the data that you have imported. Take a look at the number of campaigns you have made and the number of campaigns that are processed. If they are same, then just hit the Finish and Review changes button.

On the next screen, you would see the changes that you have made in highlighted in green. Analyze everything and then click on the Keep button that is at the top.

You have now created the campaigns in much less time when compared to making campaigns manually on the AdWords Interface.

This is the AdGroup sheet which contains three columns. These are Campaign, Ad Group and Max CPC. If there are 5 Ad Groups in a single campaign then write that campaign 5 times under Campaign and all 5 different Ad Groups against the campaign rows. You can put in the Max CPC as you wish. Copy the sheet.

Now click on Ad Groups on the left sidebar and then click on Make Multiple changes.

Do not forget to click on the radio button that says “My data includes columns for campaigns and/or ad groups” on the upper left corner. If you don't check this radio button, then the process results might be drastic. Paste all of the data by clicking the “Paste from clipboard” button. Finally, click on Process.

We have now inserted all of the campaigns and their Ad Groups in Editor. Now we have to add keywords.

I have taken a new topic for the keyword sheet just to show you that only the keyword sheet can be used to load the campaigns, Ad Groups and Keywords all at one time. You just have to add all the columns that we have discussed above into one sheet, copy it and put it in Editor (discussed in the next step). Do make sure that there are no duplicate columns. You can consider Campaign, Ad Group, Keywords, Match Type, Max CPC, Campaign Status and Columns.

As you can see in the screenshot above, we have included all of the columns so that we don't have to create the Ad Group and Campaign sheets. However, it is recommended to make a Campaign sheet as we cannot include the Campaign budget and Campaign type column in this sheet. You can find this sheet here for your reference: https://docs.google.com/spreadsheets/d/1Sgm8np39dCLptf0ObqgGaoHwee7nwEptpxCPKKVTZXs/edit?usp=sharing

To import this sheet on Editor you have to click on Keywords on the left sidebar and then on the Make Multiple Changes button on the top.

Do not forget to click on the radio button that says “My data includes columns for campaigns and/or ad groups” on the upper left corner. If you don't check this radio button, then the process results might be drastic. Then paste all the data by clicking on the paste from clipboard button. Lastly, click on Process.

After reviewing the changes, Keep them if everything is okay or select Revert if something wrong has happened. You will get a warning that the ad groups don't have any ads in them. Ignore that warning as of now. If there are any errors rectify them.

NOTE: If you are using just the Keywords sheet to input all of the data, then you have to insert your budget in the selected campaign, which will show a error. Also, after posting all the changes in your account, you need to change the Campaign type of your campaigns to Search Only.

This is the Ad sheet which includes columns for Campaign, Ad Groups, Headline, DL1, DL2, Destination URL and Display URL. If you want to make two ads in a single Ad Group, you can just make a duplicate row with the Campaign and Ad Group and input a different Headline, DL1 and DL2. You can find the sheet here: https://docs.google.com/spreadsheets/d/1_sVcSev-UPjfTFvtgVV-bvY0qDWdnXun91qNWU4SfZ4/edit?usp=sharing

To input the ads into Editor you need to click on Ads in the left sidebar and then click on Make multiple changes. The same procedure is followed as discussed in the Adding Keywords section.

After adding all of the data into the AdWords you have to click the Post button, which is situated at the top, to post all the changes into your AdWords account.

NOTE: Whenever you start working on AdWords Editor do keep in mind to click on the Get Recent Changes button.

Adding data through AdWords Editor is pretty easy and it saves a lot of time.

Sep 12

Should We Bid on our Competitor’s Brand?

By charles kirkland | Marketing

This is an extremely loaded question.

One everybody has to decide for themselves if it's worth it.

Google gives you the ability to show your ad when you search for your competition’s brand name.

While this may seem like a great idea, it could turn into a disaster if you're not careful.

Before you go down this path let me ask you a few questions.

Do you look at these businesses as your competition or potential JV partners?

If they're potential JV partners, you can really get on their bad side fast. You may get way more sales as JV partners.

Do you think there's enough search volume to justify creating a ad set for your competition's name?

Let's face it; if they only have one search a day you'll end up with a low quality score for ads that are seldom seen...which leads to a very high CPC.

Are you prepared for your competition to start bidding on your brand name and do you have the budget to fight them?

Bidding wars don’t help anybody except the ad networks.

There are a lot of things to consider with branded PPC searches.

So am I saying that bidding on your competition is bad?

No, there are plenty of times it makes total sense, and it comes down to ROI.

Every campaign needs to prove itself with ROI.

But what is the ROI from bidding on your competitor’s brand and is it worth it when you factor in the potential fallout?

Each person needs to make that decision.

Reply and let me know what your thoughts are on bidding on your competitor’s brand.

Thanks,
Charles Kirkland

Get More Leads, Better Clients, And Higher Profits For Your Digital Marketing Agency

Create Your Free Media Buyer Association Account And Join 25,638 Other Members Learning How Stay Ahead Of The Competition.

1 2 3 25