I have FOUND another great Free PPC tool

I Have FOUND Another Great Free PPC Tool

I have just ‘FOUND’ a very useful PPC Tool – The Ultimate PPC Concatenation Tool – and I wanted to share it! There are lots of Free PPC tools out there online, but occasionally you come across a hidden little gem – and this is one great example. I want to say thank you to the guys and gals at found.co.uk for creating this.

http://www.found.co.uk/ppc-keyword-tool/

{ By the way, I also plan to add this tool to my Best FREE PPC Tools and Resources Online post, if I haven’t already by the time you read this! }

What does concatenate mean?

So what does concatenate (or ‘concatenation’) mean, I hear you all asking?! The official definition of concatenate is : “To connect or link in a series or chain”.

I expect that most of the normal people on the street (non-PPC geeks) will not have heard of this term, or likely ever have used it in speech or written word. It is not a ‘common’ word. But PPC geeks, like me, are well practised in the art of concatenation. And without the ability to concatenate easily, our life would be that little bit harder.

How does concatenate work in respect to PPC Marketing?

PPC Marketing is (often) heavily related to ‘keywords’, right? Right! Larger accounts involve the organisation of a large series of keywords. Yes! So, concatenate is famously a simple but powerful function in Excel, which enables you to link the contents of a series of cells. Matches the definition, right!

So lets look at how concatenate works in Excel, and then compare it to the found.co.uk Ultimate PPC Concatenation Tool. But before we do that, lets look at some use cases.

Use cases

One of the best use cases is where you need to add a location modifier keyword to a list of seed keywords. For instance, lets assume you are a plumber covering all areas of Greater London. You may have a list of seed keywords including:

Plumber

Emergency Plumber

Best Plumber

Recommended Plumber

You may wish to append the following location modifier keywords to the above, in front and after the seed keywords:

North London

West London

East London

South London

Hammersmith

Westminster

Paddington

So in this small example we have 4 seed keywords, and 7 location modifiers. We want the location modifiers to be appended front and end. So all in all, we have 56 variations.

To manually type out (or even to copy and paste) 56 variations would take a considerable amount of time. Certainly it would take numerous minutes. As we all know, time is money and we only have a finite amount of time in our lives. So any process which helps to save time without degrading quality is always beneficial, especially for those of us who want to be the creators of amazing PPC accounts.

The Excel concatenate function explained

Excel makes this process pretty easy, you only need to remember :

  1. the concatenate formula ( =concatenate(xx,xx,xx) )
  2. copy function
  3. paste special function (values only)

Here is an example walk through:

a) arrange the first set of keywords in the first column (A), add a space in each cell in the next column (B) and then add the second set of keywords in the following column (C)

Capture

b) add the concatenate formula in column D ( =concatenate(A1,B1,C1) )

Capture2

 

c) hit return to activate the calculation of the formula

Capture3

d) copy the formula down

Capture4

e) copy and paste special, values only. This removes the formula and leaves the values only in the applicable cells

Paste_Special

In order to get these concatenated keywords into [Exact], “Phrase” and +Modified +Broad format – the match types I generally favour – I would need to utilise further Excel formulas or another tool such as : http://www.mikes-marketing-tools.com/keyword-tool/

Comparing the found.co.uk app to the Excel concatenate function

In the found.co.uk app, using the example above, you simply follow these steps:

Add the seed list of keywords in column A and add the location modifier list of keywords in column B.

Capture5

You then click Exact, Phrase and Modified Broad. You then also select Output Permutations A,B and B,A.

Capture6

Then click the big purple CONCATENATE button.

Capture7

Done!

This is why I love this tool. It takes a few steps of the process away, making it a quick and simple copy, paste and click process.

Bookmark it now!

So, like me, bookmark this free ppc tool now (or bookmark my blog post The Best Free PPC Tools And Resources Online), and use it. If you are a PPC professional spending your days building and evolving campaigns – this will help. If you are a business owner wanting to find ways to improve efficiency – then this tool presents a great way for you to save time whilst expanding your keyword reach.

Leave me a comment

Leave me a comment and let me know what you think of this PPC tool, and please share any other useful Free (or paid) PPC Tools with me for the benefit of everyone reading this blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>