If you are familiar with Frank Kern’s Screw Google Method, you know that, even if it is one of the easiest methods to use, it requires quite a lot of time to implement. It is not because of the method, it is because of the Yahoo search marketing clumsy user interface.
This is of course true for every campaign you want to create in Yahoo search marketing. If you have to work with its web interface, and you have 5000 keywords to test, it becomes a nightmare.
It is especially useful when you create the keywords from domain names or when you use keyword misspellings. In this case, you have thousands of keywords and creating a campaign in Yahoo is a nightmare.
Say you have 5000 keywords. You have to manually and painfully create:
- 10 ad groups – one for every 500 keywords (this is a minimal number of ad groups, when you do not want to waste your time creating targeted ad groups)
- Say 2 ads per ad group (split test) – 20 ads in total
- And if you want to be fancy, you can add the negative keywords for every ad group (10 ad groups). Yes, you can put your negative keywords to the account and save some time.
I’m a lazy person, and I don’t want to spend hours building one campaign. I’m especially lazy when the work is boring and repetitive.
As you know, you must test at least 10 campaigns to find at a profitable one. If every campaign in Screw Google method has 5000 keywords (at least), you spend hours and hours creating campaigns.
That is why I created a script which generates the campaign automatically from the data I provide. This saves me a lot of time, and it works under Windows, Mac or Linux.
How it works?
All you have to do is to prepare your keywords and ads for your campaign. Then you put them in one simple text file and the script does the rest.
The script simply generates the import file for Yahoo. This file is then imported and your campaign is set up immediately.
Note, that you are able to import Yahoo campaigns only when you spend $200 with them. It can be done easily – just add $200 to your new Yahoo accounts and that is it.
Simple example
Say we’re promoting Registry Winner from Clickbank. We prepare two ads in Excel, so we can split test. It will look like on this picture.
Then we have a list of keywords. We name our campaign RegistryWinner, our ad groups are named RegWin and the default bid is 0.23.
The campaign definition file will look like this (see also file with all the examples and the script):
[campaign] name=RegistryWinner [adgroup] pattern=RegWin maxkws=500 bid=0.23 [ads] Registry Fix & Speed Up PC - Download Free Registry Scan, Fix Errors And Improve Performance. Rated 5 Stars. www.RegistryWinner.com http://redirect.tracking202.com/dl/xxx?t202kw= Registry Fix & PC Tune Up - Download Free Registry Scan, Fix Errors And Improve Performance. Rated 5 Stars. www.RegistryWinner.com http://redirect.tracking202.com/dl/yyy?t202kw= [negative-keywords] free cheap [keywords] registry cleaners cleaners registry cleaner registry registry cleaner windows registry repair registry registry repair
This file has several sections – campaign, ad group, ads, negative-keywords and keywords.
The campaign section defines the name of the campaign.
The ad group section defines the pattern for the ad group names. The pattern ‘RegWin’ means that the ad group will be named ‘RegWin 1′, ‘RegWin 2′ etc. ‘maxkws’ defines the maximum number of keywords per ad group. The ‘bid’ entry defines the default bid for all ad groups.
Ads section lists the ads to use in the campaign, one ad per line. This section is simply copied from Excel table (see above). Note that ad header, lines, display URL and destination URL are separated by tabs.
The last sections are negative-keywords and keywords – simply put all your keywords here.
When you are ready with the file, run the script. For a script to run you have to download Python interpreter here – http://www.python.org/download/ (version 2.6.x).
Put all your files in one directory (the scripts and the campaign definition file). Campaign definition file is named regwinnerdef.txt here.
If you are using Windows run this command:
c:\python26\python kws2ysm.py regwinnerdef.txt regwinnerdef.csv
The result is “regwinnerdef.csv” which you can take and import to Yahoo. All the files can be downloaded – see link below.
And that is it!
Download files for “Frank Kern’s Screw Google Method for a lazy marketer” here.
Let me know if it works for you, or if you have any challenges to run the script – just leave the comment below.
{ 1 comment… read it below or add one }
Hi Jozef
Just visiting site and reading your blog. Love any thing that Frank Kern does. He is right on the money – we all know that,
As you see my name is Sue McDonald and I live in Australia. I am at present doing the Newbie course with Mark Terrell who originally did the course with Alex a few years ago.
It’s interesting learning and like everyone that starts these types of courses we all want to make money and have more time to ourselves. I hope you are making a great living and if you have time over the next few weeks and you could take a look at my blog and leave a comment, I would certainly appreciate it.
Kindest regards
Sue
.-= Sue McDonald´s last blog ..Never Give Up! =-.