David Rothwell

How to Manage and Optimize All Your AdWords Keyword Bids with Just the AdWords Editor & a Spreadsheet

Feb 3rd, 2009 | By David Rothwell | Category: ADWORDS

AdWords Bid Management Made Easy – My Story

How I Discovered a Simple 3-Step, Copy and Paste System Using Only a Spreadsheet and the FREE AdWords Editor, which Adjusts ALL Your Individual Keyword Bid Prices to Save You Money and Get More Clicks.

With this fast, easy, and automated system, you can now rapidly set all your keyword bids to show your ads at whatever position you choose, and weed out the most expensive ones, saving you time and money.

If like me you are a small to medium size AdWords advertiser or Agency managing your own or client accounts, frustrated by the workload of constantly managing keywords, this could be just what you need!

Before this System, my life as a Professional AdWords Manager had become difficult, time-consuming – and boring!

And, as I reveal, even the Product Specialists at Google use this spreadsheet technique…

AdWords Bidding Strategy – the old way

My AdWords bidding strategy used to be like this:

  • Put related keywords into an Ad Group
  • Set an Ad Group default bid price
  • Log in to my account periodically
  • If an Ad Group was showing a high position, set a lower bid
  • If an Ad Group was at a low position, consider raising my bid to a maximum acceptable amount
  • If my Ad Group bid was as high as I could go, still at too low a position, consider moving keywords to a different Ad Group with a new Ad

What I learned was, you can manage all your bids at the Ad Group level, but that’s not accurate enough as all keywords have different clickthrough rates and Ad positions.

The situation is even worse now than it used to be, since Google introduced keyword Quality Score and Minimum First Page bids.

Keywords and Ad Groups

Ideally, all keywords would be in an Ad Group of their own, with a dedicated Ad carrying that keyword somewhere in the headline, and good descriptive Ad text, with a Good Quality Score.

But with large lists of keywords, that’s very difficult to do, and many advertiser accounts have grown over time into a disorganised structure. (Actually, I developed an Ad Group Optimisation System for that, which you can get more information on at the bottom of the page).

The AdWords Editor Changed Everything

Then, over two years ago, I started using the Free Google AdWords Editor, and have been using it all day, every day, ever since.

It’s got quite a steep learning curve, and many people have told me they’ve struggled with it too, but believe me – the investment of your time is well worth it! (I provide Online AdWords Editor Training and support to fast-track you through it, see end of page).

Using the Editor, you can easily copy, paste, drag and drop, and rearrange your entire AdWords Account, including Campaigns, Ad Groups, Keywords and Ads, and set filters to only see what you need to work on.

You can also see a top-level view of the entire AdWords Account, and see minimum first page bids, and Quality Score, across your entire keyword inventory, so you can make important decisions and changes quickly.

Keep a Backup of your account on your PC

And by keeping a local backup copy of your account on your PC, with all the Campaigns, Ad Groups, Ads, and Keywords, you can be confident of never losing anything and even being able to work on your account without Internet access.

So then it became drastically easier to take on and manage many more, and larger accounts – I now have over 100 in My Client Centre, with 3 sub-MCC’s to help group Accounts together for easier Reporting.

(Reporting is an absolutely crucial, and largely ignored area that can provide a treasure trove of information you never even realised you had access to, so be sure to use the form at the bottom to ask for more information about the Report Centre).

Removing Account Restrictions

During 2008 I was able to develop a way to build, organise, maintain, filter, view and manage Ad Group bids, and keyword reorganisation, much more easily using the AdWords Editor.

For example, one account I recently set up with the AdWords Editor contains:

  • 13 Campaigns
  • 4,484 Ad Groups
  • 8,880 Ad texts
  • 106,733 Keywords

(Yes, I can get AdWords accounts expanded beyond their usual constraints just by asking nicely!)

But, as more Advertiser accounts came along, the workload started to increase again, so once more, I started to look for ways to make the job easier.

And, as good as it is, the AdWords Editor has a surprising amount of deficiencies, and is not helped by the continual improvements Google keeps making to the AdWords system – which is why it is continually being updated.

My Google Support Team

For about a year and a half now, I have had a personal Account Management Team at Google’s European H.Q in Dublin Ireland, and last October I was invited to meet my team there at Google’s “Above and Beyond” Conference (only 100 of the top European Agencies were invited).

Talking with a Keyword Specialist, I was pleasantly surprised to find that even they have to make continual use of Excel spreadsheets alongside the AdWords Editor, to manipulate and update accounts.

And if it’s good enough for Google …?

 google uses excel

Even Google uses Excel spreadsheets internally

So late last year, I looked into ways to get access to more data in my accounts, to see what it looked like and how it could be manipulated using a spreadsheet.

The Report Centre Unleashed

I found that the Report Centre was the way to do this, and that you can extract, filter and manipulate an amazing amount of highly revealing account data – automatically.

And then I discovered a surprisingly easy way to eliminate the drudgery of repetitively managing keyword bids by hand.

The Bid Management Solution

  1. Set up a scheduled AdWords report to send you a text file of data as an e-mail attachment
  2. Import the file into excel (any version) and run a simple macro for desired bid price and Ad position
  3. Copy and paste the results into the AdWords Editor, take a local PC backup of your account for security, and upload to Google — that’s it!

(The system also warns you if your bid is below the recently introduced minimum first page amount, and if it gets too high you can choose to pause or delete it)

With the AdWords Editor, you’re not working live on your account, and you can undo all your changes whenever you want.

You will also have a full backup of your account on your PC for security, so nothing can go wrong.

This system has helped me so much, I am now going to make it available to any AdWords user, by developing a range of DIY Guides and Managed Services. All these carry my Personal Guarantee, and have Lifetime Upgrades.

Please use the enquiry form below to indicate your interest.

Thanks for reading my story – I hope you found it interesting and useful!

STOP PRESS!

Conversion tracking and Conversion Optimizer Update.

As I write this, Google has reduced the eligibility threshold for Conversion Optimizer to just 30 conversions in 30 days – that’s just one conversion per day!

If you are able to track conversions in your campaigns, and assign them a true profitability value in what they cost and earn you – this is very important and exciting news.

The Free Google Conversion Optimizer service really works – I’ve tested it and found some great results, as have other professionals I work with.

There has never been a more important time for you to ensure you are tracking conversions.

This system is a true, fully automated bid price management service – which can place and monitor the performance of your ads in front of 80% of the world’s online population 24 hrs a day. And it’s FREE!

Beware, however – organising and managing your Campaigns is very different to all the normal best working practices, so if you need to know how to use it properly, please request the Special Report below.

AdWords Bids Management System – the Options

All options carry my 100% Satisfaction Guarantee, and Free Lifetime Upgrades

  1. Standard: the AdWords Bid Management System described in full detail for you to implement (pdf)
    1. $97 Regular | Pre-Launch $67
  2. Premium: The pdf and a 30-minute support call by Skype (recorded to mp3) where I teach you and others the method
    1. $197 Regular | Pre-Launch $157
  3. Executive: the pdf and a 30 minute one-to-one personal remote access session (video recorded) where you log in to my PC while I teach you the full method and anything else you want to know
    1. $297 Regular | Pre-Launch $247


  4. Monthly Plan: done for you every month with no contract and 30-day renewal $147 Regular | Pre-Launch $97

What happens next? When each is ready, I will notify you and provide a payment link for the full product., and the Pre-Launch promotion price will expire.

So DON’T DELAY, enquire today!


Other Products and Services you may be interested in:

  • Free AdWords campaign audit to save money and improve performance
  • AdWords Editor support for drastically easier and more powerful management of your accounts
    • Getting started with AdWords Editor
    • Advanced AdWords Editor
  • The Ad Group Optimization System splits your existing keyword list up into separate ad groups per individual keyword with matching Ad headline for maximum CTR achievable
  • How to use Negative Keywords to suppress undesirable ad impressions boosting your CTR immediately to reduce bids even further
  • Advanced Reporting
  • Managing MCC’s for easier Reporting of related accounts
  • Conversion Tracking
  • Conversion Optimizer Special Report
  • The AdWords Keywords Club – get new keywords and negatives every month, as revealed by your own clickthroughs!

 

  1. Bid Management System
  2. (required)
  3. (valid email required)
  4. (required)
  5. Please check any other items of interest!
 

cforms contact form by delicious:days

  • Share/Bookmark

Comments are closed.