Improving Productivity When Working With AdWords




Recently I was asked by name some of our businesses ‘PPC tools we couldn’t live without’ – my answers contributed to this valuable article here 43 Best PPC Management Tools as Voted By Experts.

Our choices for this article were essentially about productivity, and as every seasoned AdWords professional will know, the setup and structure of an account is the most critical step to ensuring the long term interpretation of data and overall success of any campaign. The next most important thing is being able to react to the data you have gathered and make smart optimisations to the account.

There are certainly slow ways of doing things when it comes to AdWords, and by slow, I don’t mean that as ‘attention to detail’ or ‘care’ I mean slow as ineffective. Once of the biggest mistakes in AdWords accounts comes from the lack of understanding on how to do things at SCALE and implement campaign builds and changes in minutes, not hours. Many marketing specialists have little idea of how to effectively do this and are largely unaware or do not take the time to learn about all of the tools and features available that can carve hours out of AdWords tasks.

Below are some tips to help you improve productivity when working with AdWords.

Use Excel

Newbies tend to try and create a campaign via the AdWords interface, usually adding Adverts, Adgroups and Keywords one at a time. Even for a tiny campaign this can be extremely time consuming – and by doing it this way, you do not have a ‘master plan’ in place.

Before uploading anything to AdWords you should open a new excel file and create a list of all campaigns and adgroups. Then expand on this list by adding keywords and adverts including variations and ad extensions. This should look something like this:


excel in adwords structure

Writing ads in excel might not seem as easy as the interface, but you can easily add a column that counts the character limits in each cell via the LEN function. You can even format the cells in Excel to look like the live ads if that helps.

The other extremely important function in excel is the CONCATENATE function. This is one of the core benefits to working with excel for your campaigns, where you are able to merge large keywords lists. This can make a large location target keyword list easy, for example “find a plumber”, then all you’d need to do is create a column containing all of the locations you want matched with the keyword. From there, all you need to do is create a formula in the column next to your locations that looks something like this – “=concatenate(“Find a plumber “,A1)”. You now have a list of location-specific keywords.

You can also use the CONCATENATE function for your Ad Text variations and creating keyword specific headline texts keeping your ads highly relevant to your keyword. This will help improve your ads CTR (Click Through Rate) and therefore boost traffic and account quality scores.

Excel in AdWords

Excel in AdWords building keyword list

Use AdWords Editor

AdWords Editor is a free tool from Google that allows you to login to your AdWords account, retrieve data in an offline-setting, make changes and then re-upload the new version of your campaigns into your AdWords account. This saves you time in a number of ways:

Quick Navigation: You can easily navigate around your account without having to wait for load times experienced in the AdWords interface – especially with large accounts.

Bulk Changes via Select All: As an example, if you needed to update the destination urls of all adverts within a campaign, all you need to do is open AdWords editor, select all the adverts then enter the new destination URL in the “Destination URL” box and then upload changes. This is way faster than manually changing the URL and much safer than using the bulk update feature in the interface as you get a chance to check it all before uploading.

Importing Data from Excel: Once you create you campaign structures or changes in Excel you can use AdWords editor to upload straight from the excel file. It’s a simple matter of copying and pasting rather than spending hours on changes or campaign builds. This task will literally only take a few minutes.


AdWords Editor screenshot

You can download AdWords editor here:

Plan your Research

A lot of times you can get caught up in the research stage of a campaign building keyword lists. Taking a systematic approach to this stage can dramatically improve your productivity. While the Google keyword planner is a valuable tool, this should really only be used once you have a base list to expand on and look for anything you may have missed.

The best approach is to do the following

  1. Check primary data if available – if the campaign has history go over all the keywords and performance, you can also go through Analytics and Webmaster tools to find keywords that may be performing already.
  2. Go over the website in detail – Look over the site and check headings, page titles and map keywords to each page of the site.
  3. Check your secondary data – one of the key tools we use here is SEMRUSH, this tool provides advertising insights on competitors. Gather all these keywords into your list as well.
  4. Use Excel’s concatenate to expand your lists – If your campaign is targeting multiple locations then add these to the keyword list. You can also use concatenate to commercially quality your broader keywords with terms like “buy” and “online”.
  5. Head to Google Keyword Planner – Once you have all the above now you can head over to Google Keyword Planner and find anything you may have missed. This can also help trim out terms that may seem too broad or too narrow. Once you have your traffic estimate you can start separating your AdGroups and Campaigns in your Excel campaign structure.

Negative Keyword Lists: Negative keywords are essential to achieving a good ROI from any campaign – As you do more and more AdWords work you should keep lists of negative keywords that apply to most campaigns. For a commercial AdWords campaign these are usually terms like ‘job’, ‘video’, ‘how to’ etc. Saving these generic negative keyword lists can save you heaps of time when launching or optimising an AdWords account.


Hopefully this post can save you time when working with your AdWords account in the future. If you have any questions please feel free to reach out!

Every Client is a Partner

Every Client is a Partner

We Create Happy Business Owners, See For Yourself

Click Click Media has been such a pleasure to work with over the past few years. They have cut our CPA by over 70% over 1 year. Very easy to communicate with and they are always available to answer any questions that we have. Such a friendly, honest and reliable team and I highly recommend them!
Martin Perelman
SILK Laser Clinics
I have used Click Click Media as a retainer for multiple clients and I have to say, at a time where we thought we would lose business, we gained a lot through the marketing expertise of Click Click Media. They were very responsive towards requests and advice and allowed myself and my team to have our highest growth ever in the 2020/2021 period.
Bassam Saleem
Kirana Education
The team at Click Click Media have always provide excellent service and have achieved superior results when benchmarking against other companies in the same field.
Craig Kenchington
Crown Forklifts
I have found the team at Click Click Media to be friendly, passionate and responsive to our online marketing requirements. They have proven they know their stuff and I highly recommend them.
Rebecca Hunt
Click Click Media have transformed the way we work with our digital media. They provide a very solid and transparent service with incredibly knowledgeable people who are always available. Results speak for themselves and our digital marketing increase can be directly attributed to the work undertaken since June by Click Click Media. Highly recommended.
Kevin Peters
1300 Smiles
We've been working with Click Click for over 5 years now. They've created 6 of our sites and manage all of our SEO. Every project has been delivered exactly to our requirements and they let us work exactly how we want. They remove all the jargon and have become an integral extension of our Marketing team, I cannot recommend them highly enough.
Sarah Gonzalez
Redback Conferencing
Click Click Media make for a great one-stop-shop when it comes to online marketing. With their knowledge of SEO, SEM, Adwords and web design, Click Click Media come highly recommended.
Michael Burford
The team at ClickClick Media are always so helpful and extremely good at what they do. I had several issues with web developers until I came across ClickClick, they are honest and very fair with their pricing. After setting up an awesome landing page they then setup an ad words campaign that literally saved our business. There after sale service is second to none. Looking forward to using Click Click for all my future online projects. Thanks to Ben, Rik, Adriel & the rest of the team
Leon Wills
Lamb Finance
We’ve had several different marketing teams before coming across Click Click Media and were never quiet satisfied with the process or the outcome. Until we started working with Click Click Media, Ricky and his team are amazing at what they do and deliver exactly what they say they would and beyond! From website to SEO management and to SEO work! We are in really good hands. We have never been this satisfied with such an outstanding work, communication and great outcome from a marketing company. Thank you Click Click Media!
Alessandro Poon
Sydney Paws Pet Doors
Click Click designed and setup my website a few years ago after a rebranding. They manage my SEO and website content to ensure i get as many new leads as possible and i have seen great results and increased customer enquiries.. They constantly update and check my site, and keep me posted with any new ideas. Highly recommend!
Darren Kerr
Appleseed Gardening
Sydney CBD
Level 35, Tower One International Towers
100 Barangaroo Avenue, Sydney, NSW, 2000, Australia
Level 35, Tower One International Towers
100 Barangaroo Avenue, Sydney,
NSW, 2000, Australia
Lakeside Corporate Centre
307, 29-31 Solent Circuit
Norwest NSW 2153
307, 29-31 Solent Circuit
NSW 2153
Google Rating