How to create a "Google Slap Revenge" campaign:

The first thing you need to do is take your list of keywords and set up a spreadsheet. Then, you can copy and paste the contents of the spreadsheet in Adwords Editor - so that the software creates your campaign.

Let's say you have 1000 keywords. To import them in Adwords Editor, you would create an excel spreadsheet. You would type the name of the campaign in the first column and copy it down until line 3000 (you will need (1000 X 3) lines because the keywords will be added in all three matches).

In the second column, which is the adgroup column, paste your 1000 keywords 3 times too (one below the other). Next is the keyword column. Basically copy the adgroup column and replicate it under the keyword column.

Next is the match column.
Leave the first 1000 lines empty (or type: Broad).
For lines 1001-2000 type: Phrase
For lines 2001-3000 type: Exact.

For example, if you had these three keywords:

weight loss pills
buy weight loss pills
best weight loss pill

...your excel spreadsheet would look something like:

You would only copy and paste from line 3 and under. I just included the names of the columns here so you understand what I'm talking about. It doesn't matter if you want to add 3 adgroups or 500. It shouldn't take you more than 1-2 minutes to paste these keywords and set up the excel spreadsheet.

You would then paste this in Adwords Editor under:
 
Keywords ==> Make Multiple Changes ==> Add/Update Multiple Keywords

Check the second radio button ("My keyword information below includes columns for campaign
and adgroup names").

Click "Next" and proceed with the wizard until you click "finish" and wait for the popup window to disappear. This means that Adwords Editor finished processing your request.

What we just did is that we created one new campaign and some adgroups with keywords in them. You need to go to the campaigns tab and change the settings of your campaign (for example, change your geotargeting, add a daily budget etc).

Have we forgotten anything?

Yes -- we also need to add our ads in the adgroups we created. Otherwise the campaign will not work.

Then you will need to add the ads in your adgroups. If I had 1000 adgroups, I would create 1000 ads (1 per adgroup). Yes, I know that you should always split test two ads. You can worry about that later, after you see which adgroups get more traffic. You can add a second ad there manually, if you wish.

Ok, here's how to add the ads: Like above, create an excel spreadsheet. In the first line, type the campaign name and copy it down until line 1000.

In the second column which is the adgroup name column, copy your 1000 adgroups (ie keywords).

In the third column, type the headline for your ad. We need to strike a good balance between
relevancy and automation here. There's no way we will type 2000 ads by hand. We can write
custom ads later in the process after we see which adgroups receive the majority of the traffic.

For the headline, I like using keyword insertion so that the keyword will be in the headline. But
many keywords will be over 25 characters. So, we need some relevant alternative text.

Besides, Google calculates the quality score from the alternative text.

For example:

{KeyWord:Debt Consolidation Loan?}

That's exactly what I would do. The main market term with a question mark. People online skim
scan and scroll. A bolded headline with a question mark is the best way to grab their eyeballs to your ad and away from your competitors' ads.

Just copy the headline in all 1000 lines.

Next column is Description line #1.

Create description line 1 and paste it in the first 1000 columns.

Next column is Description line #2.

Create description line 2 and paste it in the first 1000 columns.

Just use descriptions that have benefits and that "always sound good and make sense" (no matter what the exact headline). If you are targeting very related keywords, you won't have a problem with it.

Next is the description Url. Type your domain name in capitalized first letters without the www.
Like so: DebtConsolkwationLoansUSA.com

Copy it down in all 1000 lines.

Finally, we have the destination URLs. As I mentioned earlier, every keyword (adgroup) will point to an individual landing page.

To create your 1000 unique landing pages, open a NEW spreadsheet, copy in the first column of your landing page URL until line 1000 like so:

http://www.YourSite.com/LandingPage.php?kw=

(note the ?kw= in the end: this is necessary).

Next to that column, paste your keyword list. Select that keyword column and then replace [space] with %20 (you will find that option under Edit==> Find and replace).

The %20 is the equivalent of spaces in URLs and is necessary , because Google will not allow you any spaces in the destination URL. Your visitors of course will not see  "Debt%20Consolidation%20Loan%20California" on your page.

They will see "Debt Consolidation Loan California".

Then, copy both your collumns (your landing page URL column along with the keyword collumn
with the %20), paste them in an Empty Notepad file and replace the "tab" (the gap between the charcters) with [nothing]. That will merge everything.

This would create 1000 query strings that would look like this:

http://www.YourSite.com/LandingPage.php?kw=Debt%20Consolidation%20Loan%20California
http://www.YourSite.com/LandingPage.php?kw=Debt%20Consolidation%20Tips

This whole process is really ten times easier than it sounds on paper. It wouldn't take more than a couple of minutes -- especially if you get used to doing it. A picture is worth a thousand words -- so here's an example:

Again, if I had the three keywords:

weight loss pills
buy weight loss pills
best weight loss pill

...the AD spreadsheet may look something like:

I have actually split up the screenshot in three pieces to fit everything in this document.

Copy everything and paste it in Adword editor under the Text Ads tab:

Text Ads ==> Make Multiple Changes ==> Add/Update Multiple Text Ads etc...

It makes no difference if you have 10 or 1000 keywords. The process is exactly the same and
automated.

If you find yourself doing ANY campaign creation task with Adwords Editor and having it take
more than a few seconds or a few minutes, you are probably doing something wrong.

Practically  every task can be automated and "done en masse" with Adwords Editor. For example, you can select all your Campaign adgroups and add Max CPC bids to all of them in a few secs -- rather than adding bids one by one. \

How to create variations of your landing page quickly

So, we have our campaign ready to upload. But what about our 1000 landing pages? You will
basically create one landing page that will change dynamically and "morph" depending on which
keyword triggered it.

Remember the "kw" variable we added at the end of our landing page earlier?

The landing page should have the extension ".php" (just rename your "landing.html" to
"landing.php") and your keyword will appear on your landing page. This will give you a higher
quality score which will allow you to get more traffic at a lower cost per click.

For example, if you have created two adgroups:

Weight Loss Pills
Fast Weight Loss

... you can create just one landing page and use these respective destination URLs in your ads for each adgroup:

http://www.YourSite.com/WeightLoss.php?kw=Weight%20Loss%20Pills http://www.YourSite.com/WeightLoss.php?kw=Fast%20Weight%20Loss

So, how do you make your desired term appear on your page? You just put the code below
wherever you want the term to appear:

<?php
$kw = (isset($_GET['kw']))?$_GET['kw']:'default value';
echo $kw;
?>

For example, you could put it in the title tag of your page:

<title><?php
$kw= (isset($_GET['kw']))?$_GET['kw']:'default value';
echo $kw;
?></title>

And, in the description and keywords tags:

<META NAME="description" CONTENT="PHP CODE GOES HERE">
<META NAME="keywords" CONTENT="PHP CODE GOES HERE>

And, at the top of your landing page so people see it and say "Aaahh, yes, that's exactly what I'm looking for. Let's play with this site for a while."

And, in the alt tags of your images.

This is really nothing new -- just old-school SEO. You just help the search engine figure out what your page is about.

Where it says "default value" in the code above, you would replace it with the default text you would like to appear in case for some weird reason the URL variables will not be parsed. For
example, if you are running a weight loss campaign, instead of "default value", you could say
"weight loss".

So, that's how you create multiple landing pages on the fly. This is a time saver.

Even if you have 1000's of keywords, your landing page will be super targeted to those keywords.

If you don't believe me, just take any one of your new destination URLs and paste it in the URL tab of the Adwords keyword tool:

http://www.adwords.google.com/select/KeywordToolExternal

You will see that Google generates keywords that are extremely relevant to the keyword that destination URL "belongs" to.

More things you can do to improve your quality score and avoid getting slapped

First of all, no I'm NOT going to tell you to add a ton of "content" to your landing page. Heck, I use lead generation pages (or "squeeze pages" as they are better known) all the time and I still haven't had ONE that got slapped. The methods outlined in this report help me achieve this.

So, here are some tips:

Include the term on your page in a <h1> tag like so: <h1>golf clubs</h1>. You can include that on the top or even the bottom of the page.

You can also include your term in the alt tag of your images. Remember: When I say "include your keyword here and there", I mean you will include the php code I mentioned earlier. That code will change every time depending on the keyword you bid on.

Another important point: If you haven't noticed, many pages that rank high on Google for certain terms don't have much more going for them other than their name.

A page called StopMyDogFromBarking.html would have a distinct advantage over a page called
MuscleBuildingWorkouts.html for the term "stop my dog from barking".

Common sense - and nobody's doing it. Stop naming your pages "page.html" or "landing.html." In our case of course, our pages will look something like: page.php?kw=stop%20my%20dog%from%20barking -- which makes the query string very relevant to the keyword itself.

Google also gives importance to incoming links to your site when deciding the quality score of your site. This is not necessary but, if you can get a few good links to your page (from CLEAN sites), do so.

Don't build link farms or spam networks. You may get away with it for a while but sooner or later Google's discounting mechanism will kick in and you'll start getting paid less per click.

If possible, add some "related keywords" on your page. LSI or Latent Semantic Indexing has been all the rage lately.

Don't be confused by it. Just go to Wordtracker.com, type your main keyword and do a lateral
search. Note down some of the added keywords that appear. For example, for the term "seduce women" you can add on your page some keywords like "pick up artist", "dating" etc.

Google basically wants to see pages where the content looks natural and is "how you talk". Yes, you will be paying for the traffic instead of driving it organically. But Google would rather see you use their general quality guidelines anyway.

Use Terms of service, disclaimer, contact us and privacy policy links on your page. Yes, these will  result in a higher landing page quality score, when a human Google editor comes in to check your page.

A sneaky trick to add content behind your landing page on the fly

Many times, adding some pages full of relevant content behind your landing page can result in a higher quality score. But how can we add content, if we are lazy?

What if we could link dynamically to the Google results for our keyword? For example, if our
keyword is " best natural weight loss pills", our landing page would have a link with the anchor
text "best natural weight loss pills" that would link to the Google search results for "best natural weight loss pills."

If our keyword is "weight loss exercises", our landing page would have a link with the anchor text "weight loss exercises" that would link to the Google search results for "weight loss exercises."

Here's the code to use on your page:

<a href="http://www.google.com/search?q=<;?php
$kw = (isset($_GET['kw']))?$_GET['kw']:'default value';
echo $kw;
?>"><?php
$kw = (isset($_GET['kw']))?$_GET['kw']:'default value';
echo $kw;
?></a>

You can just put this code at the bottom of your page.

If you also want to link to Yahoo results to get a different source of content, then use this code:

<a href="http://search.yahoo.com/search?p=<;?php
$kw = (isset($_GET['kw']))?$_GET['kw']:'default value';
echo $kw;
?>"><?php
$kw = (isset($_GET['kw']))?$_GET['kw']:'default value';
echo $kw;
?></a>

Nice trick, eh?

I guess that's all for now. I have to say "a few" more things about Adwords but I will let those for another report. For now, just focus on these tips and save money, time and frustration!