Dividing Adwords keyword list into 2000 per group

Is there a script to divide huge kw lists into 2000 per group

[1Spirit]

Hi,

does anyone know of a script or program that will automatically divide a keyword lists into smaller parts?

I want to use it specifically for adwords and their 2000 kw/group limit.

Thanks,
Murray

[cline]

When I want to calve out a new adgroup from a larger one I put the keyword list into Excel and use =search(text,a1) to flag cells that have the keywords I want to extract. Sorting by this field gets them all in a row.

[1Spirit]

That's a good idea.

I already have them sorted alphabetically using the keyword counter that comes with Traffic Equalizer.

The way I ended up sorting them into 2000kw groups is by putting them into the code of an html page in Dreamweaver. The code lines are numbered so I just went by that.

[PPCBidder]

Just a tip, I would stay a fraction below the 2000 limit just in case you want to add more keywords or similar keywords to the group in the future. "Breathing Room" so to speak.

[PPCBidder]

...chances are you will have some underperforming keywords as well though, so you can always delete those to free space too.

[1Spirit]

Another good tip thanks

[gopi]

Ok , here is a crude perl program i just wrote to spilit a keyword file (keyword.csv) into files each with 2000 entries . The output files will be generated as 1.csv ,2.csv etc

#!/usr/bin/perl
require IO::Handle;
open(INP,"keywords.csv");
@inp = <INP>;
$i=1;
$j=1;

foreach $in (@inp) {

chomp($in);
$i =$i +1;
open (OUT, ">>$j.csv");
print OUT "$in\n";
close OUT;

if ($i%2000 == 0)
{
$j =$j +1;
}

}

[1Spirit]

Awesome, wish I could do that.
Murray

[bcc1234]

gopi, there is a utility called split that does just that.

[1Spirit]

where is it found?

[gopi]

>> there is a utility called split that does just that

I think you mean the age old DOS spilit utility thats was used to slice files to fit into floppy disks!

Anyway 1Spirit's is a simple requirement which we can achive with the above script...1Spirit ,if you dont have a unix/linux box just download activeperl to your windows pc and run this program in command prompt as "perl spilit.pl"

[bcc1234]

I think you mean the age old DOS spilit utility

I think that utility was around long before DOS.

[1Spirit]

Would be I be able upload it to my server and use it online?

[AdWordsAdvisor]

I want to use it specifically for adwords and their 2000 kw/group limit.

1Spirit, I just wanted to jump in with a point of clarification. Unless things have changed recently, the suggested keyword maximums are as follows:

* Suggested max for a single Ad Group = 750

* Suggested max for a campaign, inclusive of all Ad Groups = 2000

These are suggested limits, and many on this forum routinely exceed them by a large margin. Still, be aware that is possible for account navigation to slow, once you're over these limits.

(And while not in response to this thread in particular, I'll also jump on my soap box for a few seconds - and say that usually, IMO at least, 100 really carefully chosen targeted keywords are far more valuable than 5000 random untargeted ones.)

AWA

[stuntdubl]

Suggested max for a campaign, inclusive of all Ad Groups = 2000

Is this primarily for management performance reasons?

Or will going beyond these suggested limits effect the distribution of your ads as well?

[AdWordsAdvisor]

Is this primarily for management performance reasons?

Or will going beyond these suggested limits effect the distribution of your ads as well?

Not sure I follow you, stuntdubl. Could you be more specific with your question? ;)

AWA

[stuntdubl]

If I have 3 groups within a campaign that all have 1500 keyphrases (for a total of 4500 phrases within the campaign), will the distribution of the last 2500 phrases be effected negatively in any way?

-rephrased again-
Is the suggestion of 2000 phrases per ad campaign only to keep MANAGEMENT easier, or will it effect the quality or quantity of distibution for the keyphrases above the 2000 threshhold?

Clear as mud now?

[AdWordsAdvisor]

Clear as mud now?

Hehehe. Ok, I think I've got you now. ;)

Is the suggestion of 2000 phrases per ad campaign only to keep MANAGEMENT easier, or will it effect the quality or quantity of distibution for the keyphrases above the 2000 threshhold?

At the core of the question, it seems as if you're either asking if there is a 'penalty' of some sort, or if there is a technical limitation - either of which could affect ad delivery. Right?

The short answer is 'no': no penalty, and no particular technical problem that, as a non-engineer, I'm aware of that would impact delivery.

However, I will say that the more keywords one has the more critical it becomes to carefully monitor daily budget, which is absolutely connected with ad delivery.

Caution: I am now about to stray off topic a bit! :)

It is worth saying that the Max Keyword suggestions are ultimately in place to protect the AdWords system from being slowed down with zillions of (very often untargeted) keywords.

As I've mentioned in the past, there appears to be a trend in which many advertisers simply dump tens of thousands (if not hundreds of thousands) of almost randomly chosen keywords into an account - and let the system sort out the winners and losers.

This is not particularly good for anyone involved, and if you multiply that by just a few thousand advertisers, you're into some pretty big numbers, pretty quickly.

So, I am pretty big supporter of the idea of advertisers using keywords because they make sense, not simply because it is technically possible.

AWA

[stuntdubl]

Thanks for that response AWA...had me worried there a bit.

As a QC suggestion, why not disable any KW's that have been on for say 3 months and have never received a click (or even impression for that matter)?

...scurries off to delete some of those phrases

[eWhisper]

As a QC suggestion, why not disable any KW's that have been on for say 3 months and have never received a click (or even impression for that matter)?

[adwords.google.com...]

[AdWordsAdvisor]

Hehe.

From suggestion to reality in just over a half hour. Not bad. ;)

AWA