How to build a PPC Campaign

Request A Free Website Analysis

January 14th, 2008 by Click Consult

Building PPC campaign can be very frustrating, especially when you don't have basic Excel skills. But let me tell you- even average level of excel won't necessary provide you with easy solution either.

So what can you do?

In order to start building any camping you have to:

Identify what products or services you are going to advertise.
Build you basic keywords list.
Make keyword research using Google/Yahoo/MSN/WordTracker keyword tool.
Download the list and identify which phrases or words could be added to your expanded keywords list & the rest are going to be negatives.
Build you keywords by grouping keywords into campaigns & adgroups
Build your negatives list
Create you ads.

As you can see it’s all looks pretty simple, but there are a few pitfalls which may take a lot of time and cause many mistakes, especially when you are dealing with a large number of keywords. So here my tips:

Stages 1-3 are quite straight forward and only in case of a large number of keywords can take a considerable amount of time.
At stage 4 , when you have a large list of expended search phrases and words returned by a keyword tool you may:

Use SUMIF function to eliminate your basic keywords list, so you’ll stay with a smaller non duplicated list.

Go through the smaller non duplicated list and identify more keywords and negatives that should be on exact of phrase match.

When you have a completed list of keywords, use FILTER functions to sort your keywords and name your adgroups. Adgroup name should reflect characteristics of the keywords within it.
Check that you have plurals and singulars in you keywords list together with synonyms and misspellings by using COPY, PASTE and FIND & REPLACE functions.
Using TEXT TO COLUMNS and SUMIF functions on both keywords and the rest of negatives, create a list of negatives on a broad match.
Create you ads by using adgroups names (which are a common description for keywords within it) in your ads together with current promotion or offer & call to action.
Use CONCATENATE function to join cells or cells & text together.
Use LEN function to check lengths of your ads components.

If you are not just using one of the functions but create a logical symbiosis between a few of them, you campaign building will become a strategic game which you can enjoy.

Find Your Negatives
On a regular basis you should run search query reports using MSN and AdWords to pull off all the queries that result in unqualified clicks or impressions and add them to your list of negatives. By doing this, you can…...
Yahoo update their negative keyword policy – finally!
One of the most important areas in building a pay per click campaign is often neglected by many people. It can really cut down on irrelevant traffic that you're receiving and for those on a limited budget it can really…...
Yahoo races into the 21st Century with Negative keywords
One of the most important areas in building a pay per click campaign is often neglected by many people. It can really cut down on irrelevant traffic that you're receiving and for those on a limited budget it can really…...
The importance of PPC Search Query Reports
Optimisation of a pay per click campaign comes in many different guises from bid changes to keyword matching options. One important way of improving quality of traffic is to add more and more negatives to an account as you see…...
Quality Score Crunch
Google always has been telling us that Relevancy and hence Quality Score… should be the main campaign objective. It’s even introduced an improved magnifying glass tool to assist in doing so. But after a few years of long battles for...