| Title: | Free Tool To Cluster PPC Phrases Into Related AdGroups — RKG Duck |
| URL: | http://www.rimmkaufman.com/rkgblog/2008/01/27/duck-stemming/ |
| Printed: | March 20, 2010 |
| Source: | The Rimm-Kaufman Group Blog, info@rimmkaufman.com |
- January 27, 2008
- 9 comments
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.
If you like this post, consider subscribing to our RSS feed. You can also have new posts sent to you via email.
Related Posts
No related posts.


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”;
}
I found a few errors, now it just pastes what I copied, but the result is noting.
Hi Jeff —
Cheers –
Alan
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!
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.
I’m having the same problem as Daniel, when I load Duck there are no filters in the sidebar. What’s the fix?
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..
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
Hmm, the adgroup filter turns red for me too but all the other “pre-made” filters work just fine… strange indeed.