Jan 272008

Free Tool To Cluster PPC Phrases Into Related AdGroups -- RKG Duck

Last week, we released RKG Duck, a Windows Clipboard Filter. I described some simple uses in an introductory video demo. I wanted to make a second video to show how write your own filters.

With George's post on the limitations of AdGroups still fresh on the blog, (AdGroups as a Barrier to Success), I decided to write a RKG Duck filter which approximates AdGrouping. That is, given a list of keywords, write a filter which yields a signature which clusters similar phrases.

I chose a rudimentary algorithm: for each phrase, remove stop words, stem, alphabetize, and crush into a signature. It took me just under ten minutes to code it.

Here's a 90 second preview video showing the filter in action:

And here's a link to the full 10 minute video. It covers installing RKG Duck, using CPAN modules, and writing the stemming AdGroup filter.

Video Link: RKG Duck II: Google AdGroups And Stemming

Note: this example is a demonstration of what one can do with RKG Duck. This isn't how our firm builds AdGroups -- we don't recommend building out phrases then AdGrouping later. Rather, the right approach to build campaigns is to go through every relevant URL on the site; build out rich keywords for each URL; assign targeted copy, smart match types, and sensible initial bids; then adgroup them appropriately. As George mentioned, there's significant benefit in databasing ads in a richer taxonomy than the simple Campaign >> AdGroup >> Term hierarchy.


9 Responses to "Free Tool To Cluster PPC Phrases Into Related AdGroups -- RKG Duck "
Jeff says:
Hey, this looks great. I installed the duck, grabbed Perl active state and have the built in .pl files working properly...but I can't get the adgroup filter to work. The Youtube video was a bit distored - can you confirm this code? use strict; use Text::English; my %stop = map {$_=>1} qw( a about an are as at be by for from how i is it of on or that the this to was what when where who will with the); while () { chomp; my @w=split( /\s+/. $_); @w = grep { ! $stop{ $_} } @w; @w = Text::English::stem(@w); print join(''. $ @w), "\n"; }
Jeff says:
I found a few errors, now it just pastes what I copied, but the result is noting.
Hi Jeff -- You shouldn't need to install Perl. You do need to install Text::English. Did you look at the longer video: http://www.youtube.com/watch?v=SK7xaTV3D2c You can't run the tool thru a Windows shortcut link, as it looks in "." for filters. If the window turns red, there's an error. Are you seeing red? As a test, can you get a simpler filter to work? say, the uppercase filter? Cheers -- Alan
Daniel says:
Hi. I downloaded your duck tool however the software does not capture the filters that come along with the download, ie: on the left side of the user-interface, there are no filters which I can click on, there is just an empty white space. I thought I was doing something wrong however a friend with strong technical skills also had the same problem. Any advice?? Thanks so much!
mike says:
Thank you for offering this tool, but I also can't make out the code in the adgroup stemming video. Any chance you could post this for download? I would love to experiment with it.
Rob says:
I'm having the same problem as Daniel, when I load Duck there are no filters in the sidebar. What's the fix?
Rob says:
Just an update for anyone experiencing the problem I mentioned above, the fix is to install Active Perl. However, now I'm having the same problem as Jeff... I have the script right and all the pre-packaged scripts work but the text in the window turns red when I turn it on. I have "Text" as a subfolder in the folder rkg-duck.exe is in, and English.pm in the "Text" folder. Some more detailed instructions that didn't involve trying to figure out what's going on in the video would be a big help, would love to use this tool but just can't get it to work..
Alan says:
Sorry if the video instructions were terse. In the simplest case, the duck tool takes a stand-alone perl filter, no modules, and so there's no issue of include paths. If you need a module, the easiest fix is to install activeperl on the local machine, then install the module using ppm (or ppm3?). Once you can run the filter on a dos command line, it should work fine in the Duck tool too. Hope that helps! Alan
Vertical Return says:
Hmm, the adgroup filter turns red for me too but all the other "pre-made" filters work just fine... strange indeed.

Leave A Comment