27 Feb, 2009  |  Written by  |  under AdWords

One of the big problems we see with clients’ campaigns is that they have keywords (or groups, or whole campaigns) that have excessively high bounce rates. Those should be taken out behind the barn and shot, but how do you separate the bad ones from the good ones? Analytics makes it easy!

Finding High Bounce Rate Keywords

Finding High Bounce Rate Keywords

Here’s how:

Continue Reading ->

24 Feb, 2009  |  Written by  |  under AdWords

I’ve been using Google Docs more and more lately, and wanted to use their Spreadsheet for some AdWords bulk writing, but needed a letter counter to be sure my titles and ad lines were short enough to work.

PPCProz.com has the code for Excel here: http://blog.ppcproz.com/2009/02/3-secrets-creating-adwords-ads.html

So it was just a question of converting it to Google’s spreadsheet. Google spreadsheet doesn’t support formulas in conditional coloring, so I had to embed the formulas in the cells, then apply conditional coloring. Not too much harder, and I tweaked it to show the number of remaining characters until you go over the limit, then turn red. Here’s how:

Continue Reading ->