Anyone know of a phrase counter method? (keyword grouping)

Status
Not open for further replies.
L

lylaster

New member
Aug 1, 2007
91
1
0
Currently I'm using the adwords editor keyword grouper to organize my KW lists. It takes me about an hour to group a 10k KW list. I do this by "eyeballing" the keyword groupers the editor spits out, and going to the previous screen to break the large groups into smaller ones.

I'm looking for a method that can help me display a list of highest occurring common phrases in a KW list so I can do this faster.

For Ex. If I had a 10k ringtones keyword list I'd like to use a program of some sort that sorts out the most common occurring phrases.

verizon ringtones
cingular ringtones
tmobile ringtones
and so on....

I can then take the list of common phrases and put it in AW editor keyword grping function and have it spit out small,tight groups.

Anyone got any ideas?
 


could you be slightly more specific?
I mean, the 10k ringtone keyword list has 10k lines each with different keywords on them, and they are all unique? Or do the items repeat, like you have 50 entries for verizon ringtones?

So from your example, you have:
verizon ringtones
cingular ringtones
tmobile ringtones
and you want:
ringtones:3?
 
hi,

The keyword list would have 10k unique keywords. What I'm looking for is a way to count the most common phrases, see how many times it appears. Here's how I envision it.

10k dating keywords , it would return

christian dating (400)
online christian dating (26)
free online christian dating (20)

The number after means that there are XXX amount of keywords containing the phrases. So it would count 26 longtails containing the term "online christian dating." If I had a method of doing this then I could just plug the list into the adgroups grouper and it'll group them together. "online christian dating" would be the adgroup, and there would be 20 words in it.

The benefit would be tight, focused adgroups. Done within 10-15 minutes even if the list of like 10k keywords. I'm wondering if this could be done in excel or access somehow.


argh01 said:
could you be slightly more specific?
I mean, the 10k ringtone keyword list has 10k lines each with different keywords on them, and they are all unique? Or do the items repeat, like you have 50 entries for verizon ringtones?

So from your example, you have:
verizon ringtones
cingular ringtones
tmobile ringtones
and you want:
ringtones:3?
Click to expand...
 
aah I could see writing a script that would take each line and split it into words and then reassemble phrases out of that. Do that for each line and then count up the phrases in each.

for instance, free online christian dating would become
free
free online
free online christian
free online christian dating
online
online christian
online christian dating
christian
christian dating

and then you could do that for each line, and at the end output a csv and load it into excel.

Is that conceptually right?
 
argh01 said:
aah I could see writing a script that would take each line and split it into words and then reassemble phrases out of that. Do that for each line and then count up the phrases in each.

for instance, free online christian dating would become
free
free online
free online christian
free online christian dating
online
online christian
online christian dating
christian
christian dating

and then you could do that for each line, and at the end output a csv and load it into excel.

Is that conceptually right?
Click to expand...

Yep, something simliar to that. "Free Online dating" has 9 different phrases which could be counted in a database. In the end it would count that
out of 10k I'm estimating

online (1,500)
online christian dating (60)

Obviously I'm not that interested in making a group out of words containing "online" as it's not targeted with 1,500 words. What I could do is use excel or something to filter out all the phrases containing one term. That way in the end I'll only use groups that have 2+ words in common.

I'm pretty sure this can be done, i'm just looking to see if something out there already exists or if there's an easy way to do it with excel or something.
 
If you have access to a system that'll run perl, try this...
It'll read a file named "input_file" and output a file called "output.csv". From there, open the csv up in excel and sort it based on the first column.

Code: 
#!/usr/bin/perl

$input='input_file';

open( FH, "< $input ");

while( <FH> ) {
        chomp;
        @holder=split / /;

        while( scalar @holder > 0 ) {
                @tmp=@holder;
                @left=();
                while ($foo=shift @tmp ) {
                        push( @left, $foo );
                        $seen{"@left"}++;
                }
                shift @holder;
        }
}

close( FH );
open( FH, ">output.csv");
foreach $foo ( keys %seen ) {
        print FH $seen{$foo}.",\"$foo\"\n";
}
close( FH );

Caveat: I'm not really a perl pro :) And I have a squirmy three year old on my lap. But it seems to work in testing.
 
hi,

I'm not really familiar with PERL but I just got activeperl installed. I'm confused as to what the "input_file" is. I made a file called input_file.txt that contains a list of my keywords. I ran the program and it created a output.csv file but contained nothing.
 
Change the line that says
Code: 
$input="input_file";
to
Code: 
$input="input_file.txt";

Basically, I was too lazy to look up how to use arguments.

My test file looked like this:
dating
online dating
adult dating
dating service
sex dating
adult dating services
free adult dating site
internet dating
adult personals dating
dating site

And if yours doesn't match let me know.
 
Status
Not open for further replies.
Top Bottom