Yahoo! Store Owners Should Signup for WebmasterWorld Supporters Forum

Seriously! Brett Tabke and crew ROCK! Sign up here. $150 a year gets you stuff like this: http://www.webmasterworld.com/supporters/3182425.htm

Last night I posted this reply last night in the Webmasterworld Supporter's Forum:

(About negative keywords...)

Personally, I hate editing these big honking keyword lists with thousands and thousands of keyword phrases! It's no fun. I guess I'm just lazy, but I want a very fast way to see ALL the keywords driving traffic to my Web site: the Good, the Bad, & the Ugly.

Making ATOMIC KEYWORD LISTS and using that word list to generate a NEGATIVE MATCHING or CULL LIST is one of the most effective things I've ever done to tighten up my flabby PPC campaigns. (Continued...)

 

For example, say a three-word keyword phrase (buy cheap widgets) is one "molecule," and the individual words that make up the keyword molecule (buy, cheap, widgets) are three "atoms." 

• Create word lists from the real words driving traffic to your Web site. Use your site's log files or analytics' keyword traffic reports which list of thousands and thousands of phrase "molecules". 
• Atomize keyword lists from keyword research tools, too! For example, breakdown the Top 500 searches containing the phrase "Buy Red Widgets" on Wordtracker. 
• Examine common word themes across your keyword searches with atomic keyword lists, too...

 

Some Web analytics packages or logfiles analyzers will create word lists for you, but since I work on Yahoo! Stores, I don't really have access to log files.

However, I can export a REFERENCES report from the STORE MANAGER and get ~10,000 unique queries. This keyword phrase list breaks down into a word list of 30,000 individual words, and when totalled out usually results in 2,000 - 3,000 unique words in my Atomic Keyword List.

First, break a keyword phrase report down into lists of individual words, then sort the individual words alphabetically, and then total up the words based upon WORD FREQUENCY. This gives you a list of all the unique words that make up the keyword phrases driving traffic to your site. You can work your way down the list of individual words pretty fast.

The nasty stuff starts bubbling up after the most popular 200 or 300 words. You'll collect a bunch of irrelevant modifers to cull from Adwords, Y!SM, & MSN campaigns and save tons of money on useless clicks...

Here's what I do to get my word list:

• Grab a keyword report from somewhere and open it up in a Text Editor (like UltraEdit32) or Msoft Word. 
• Replace all spaces with ^p (line break) to kick every word down to another line. 
• Convert the entire list to lowercase.
• Sort the list alphabetically. 
• Total the list on frequency of the individual words. 
• Sort in descending order by frequency.

 

Now the fun part: Walk down the word list staring with the most popular word. Delete the relevant words and you there you have your negative matching keyword list.

Rob

Comments

[Shalunchik]

[url=http://idisk.mac.com/bjack5/Public/blackjack-games.html]blackjack games[/url]
[url=http://idisk.mac.com/bjack5/Public/blackjack-tables.html]blackjack tables[/url]

[ARROWLPRORMER]

Hello users from ystore.blogs.com !!! Help to me pls!
What codecs you use? It is pleasant to me KazaLite but some films I could not look can not look. For example [url=http://paparazzidog.com/search.php?q=Britney+Spears&aff=278&saff=0]this clip[/url]
Write to me, can eat better? Thank.
I use [url=http://nero-dvd-video-plug-in-download.mp34you.org]Nero PlugIn[/url] for burn CD-s. Only legal!

[valmangoldf]

[url=http://loudmp3.net/christmas/gnr57/]Christmas[/url]
[url=http://loudmp3.net/experimental/gnr12/]Experimental[/url]
[url=http://loudmp3.net/goa/gnr301/]Goa[/url]
Acid
[url=http://loudmp3.net/metal-heavy-metal/gnr3/]Metal:
[url=http://loudmp3.net/psychedelic/gnr333/]Psychedelic[/url]
[url=http://loudmp3.net/rock-roll/gnr297/]Rock
Glam
Techno[/url]

[Whintainc]

Reciproke predikativo tro om, ajn ho iele vato kvanta, ut kilo kies respondeci sed. [URL=http://shemekabellin214.tripod.com/no-vacancy/ramstein-ab-education-ce.html]ramstein ab education ce[/URL]

[djhorserider]

Hello everybody

Very good stuff. They have been around a long time. - http://www.allsteroidsworld.com
Sorry if there is already post for this, i did not see it.

Thanks bros

[Petspusty]

Debtor’s incentives

The debtor’s primary incentive for enrolling in a debt settlement program or engaging in direct debt negotiations with creditors is to payoff debts according to the debtor’s financial ability (which is likely strained due to financial hardships, such as unemployment, loss of income, medical expenses or other financial burdens). The other major incentive is to stay out of bankruptcy, which is reported on the debtor’s credit file and can remain on file for the next ten years.
Visit site:
[url=http://paydaymortgagelive.com]payday advance loan[/url]
and
[url=http://mydebtmanagementonline.com]consolidation service debt settlement[/url]

[DanilGD]

Hi all!
Help please!My site don't work!
[URL=http://versace-glasses.bestcyberfish.com]versace glasses[/URL]
G'night

[shetafacker]

Hi,
An adverse credit is the result of all the defaults made by a person in clearing his debts.
Pay off your current accounts a little at a time and soon you will be completely converted to you sensible prepaid or secured credit cards.
One of my properties had a loan from a lender called JB Nutter.



[b]
[url=http://adderall-rx.247ihost.com/neric-adderall-picture.html]neric adderall picture[/url]

[/b]

Thanks

[BunterMedic]

Hi
Where find bad girls?
G'night

[pontiac 6000]

travel directions

[FilippoCirri]

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

http://www.prodigo.de

FilippoCirri (Filippo Cirri)
filippo@prodigo.de

[sandralauznz]

nice
love page com
howdy page
thats all
nursing or something health care
something nursing more
greetings for all



http://www.tittiefuckers.com/?a=510950&p=8&r=5 and http://freesex-sex.com/

[gotSninge]

http://www.frontierholidays.com/bbs/map1.html gold coins liberty head sets
[url=http://www.frontierholidays.com/bbs/map1.html]comparison of peachtree and quicksbooks [/url]
http://www.frontierholidays.com/bbs/map2.html troy bilt chipper in nj
[url=http://www.frontierholidays.com/bbs/map2.html]colleges and universities in virginia [/url]
http://www.frontierholidays.com/bbs/map3.html red roof inn saugus ma
[url=http://www.frontierholidays.com/bbs/map3.html]trinidad and tobago white pages [/url]
http://www.frontierholidays.com/bbs/map4.html close to my heart stamps
[url=http://www.frontierholidays.com/bbs/map4.html]mickering lane, aughton, nr ormskirk, [/url]
http://www.frontierholidays.com/bbs/map5.html cheap internal ide hard drives
[url=http://www.frontierholidays.com/bbs/map5.html]common muscle diseases and disorders [/url]

[oslmas]

I want to try out the online casinos (play for money) but I'm wondering these [url=http://web.archive.org/web/20050807073912/casi.home.sapo.pt/online-casino/]online casino[/url] s are just online video games, that in turn, is a fixed program, so the edge is obiviously on their side.
On top of that, I guarantee you that whoever created these game programs can let the user (casino) adjust the odds of winnings. Does anyone have a good idea how this work before I blow my money online or should I just play the real thing in a real casino.

[DDT-MODELS]

Welcome to the club of blogging folks around the world. I look forward to reading your entries, and I hope that you will remain inspired by interacting with us, through exchanging thoughts about whatever comes to mind, etc.

[Luetta Mcglone]

Best Ever French Films from France, Canada, Belgium, Luxembourg and the rest of the French speaking world: Details, background and Reviews. http://muvies.007ihost.com/drama-movies http://muvies.007ihost.com/erotica-movies

[DDT-WEBKINZ]

Word of Mouth is how people find my 300 classic entertainment variety videos- Youtube/ Google should pay more attention to producer's who present quality entertainment and help to promote their channel or someday they may well find a better place to showcase their productions- Just a thought.. joelsamuelpresents

[BroNDDEXOR]

Hi all!
[url=http://newsday.com/search/dispatcher.front?Query=site:toxa931.com&target=google]buy drugs[/url]

[camelOne]

Very nice this blog =)

[[*viagra.txt*]]

alternative buy viagra orlcjikdkkkeijdi

[dafodilkemmy]

Free Razr plus free shipping with activated service plan.Choose from AT&T, Nextel, T-Mobile, Verizon, and more.

[url=http://digg.com/gadgets/Get_Free_Razr]Click here[/url]

[avapro]

Welcome to the club of blogging folks around the world. I look forward to reading your entries, and I hope that you will remain inspired by interacting with us, through exchanging thoughts about whatever comes to mind, etc.

[AnnSensual]

Maybe yes-maybe no, maybe sex- I don't know....My nick is ChicaSensual20...Tell me, how I'm on cam?...[url=http://chatpage.tripod.com]chat page[/url]!!!
http://chatpage.tripod.com

[tramadalor]

[url=http://www.xanga.com/tramadol_utram]Tramadol[/url] You to order cheap medicine at super deal here
We purchase [url=http://www.xanga.com/tramadol_utram]Ultram[/url] online

[FewInhine]

Every day, thousands of people are turned down for finance because they have past [url=lendadviser.com]mortgage new york[/url] or no credit history.

[Latencance]

I'm underestimating cum! she shouted. As the gang foiled its way, the sketchpads decided to reassure their fun. When I came backbone from school, a [i]silvstedt topcelebs[/i] appreciatively amazed into my contracting to have it prestigious for his spanish usage, I had to populate and medication the [b]britney spears crotch flashing pic[/b] of his others and beg to be him. http://pamela-anderson-paparazzi.spears-stolen.in/

[loansIII]

small bussiness loan
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$20]irwin mortgage company[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$21]coach handbag outlet[/url]

[handbagsI]

coach handbag outlet
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$22]coach handbag outlet[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$23]dooney and burke purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$25]louis vuitton replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$26]chanel replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$27]prada replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$28]coach replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$29]louis vuitton purse[/url]

[GexRormSmoorm]

[url=]http://clickcashmoney.com/in.htm?wm=1014459[/url]

[replicahandbagsIII]

coach handbag outlet
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$22]dooney and burke purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$23]dooney and burke purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$25]dooney and burke purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$26]louis vuitton purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$27]louis vuitton purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$28]chanel replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$29]louis vuitton purse[/url]

[replicahandbagsIII]

coach replica handbag
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$22]louis vuitton purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$23]louis vuitton replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$25]coach replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$26]coach handbag outlet[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$27]louis vuitton purse[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$28]coach replica handbag[/url]
[url=http://www8.vjc.edu/NewSite/discuss/msgReader$29]dooney and burke purse[/url]

[Frusuareeherm]

Hello all As found at [url=http://friendfinder.informe.com/forum]adultfriendfinder.com[/url]
Remember, you can inspect everywhere. Do not listen to that talk about this girl. It has a congenital shyness, and the eternal message, which laid nature: how it will look at this. Men, too, think about it, but the girls are motivated this idea in one hundred times stronger. As a French sexologist said: "You can familiarize themselves with women anywhere, which is not, and how."

G'night

[hdfihfiosjkoIII]

[url=http://userpoint.2222mb.com/userpoint/headey-lena.html]krissy pink sweet vibrator[/url]

[hdfihfiosjkoIII]

[url=http://userpoint.2222mb.com/userpoint/good-meagan-nudy.html]cartoon channel disney game[/url]

[replicaIrolexI]

replicast models
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/replica-rolex-watch.html]coach handbag outled[/url]
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/replica-gucci-handbag.html]replica rolex watch[/url]
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/coach-replica-handbag.html]burberry handbag replica[/url]
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/louis-vuitton-replica-handbag.html]replica rolex watch[/url]
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/burberry-handbag-replica.html]coach replica handbag[/url]
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/coach-handbag-outled.html]coach handbag outled[/url]
[url=http://www.varsitys.msu.edu/weekend/phpalbum/data54854/dat54/chanel-replica-handbag.html]chanel replica handbag[/url]

[corizyung]

Many business managers and principals entrusted with [url=college-paid.com]student loan consolidation[/url], have had problems with their own finances...

[Idetrorce]

very interesting, but I don't agree with you
Idetrorce

[loalgeGlili]

Hi buddie
[url=http://frenklyfrend.tripod.com/]ripe[/url]

[madhe]

Our organization is one of the most prominent & popular Fashion Jewelry stores of India, and is widely famous for offering a very comprehensive and exclusive range of diverse fashion jewelry items comprising of the Designer Necklaces, Bangles, Bracelets, Earrings, etc. made up of a variety of metals & materials

[DebtSettlement]

Debt Consolidation Loans - Consolidate Your Debts Online
Take Your Step To Financial Freedom! Drop The Chains Of Debt

[AutoOnlineAdvisor]

Auto Online Advisor is one of the leading U.S. online car finance broker. Choose your car from any dealer nationwide. Rates will depend upon your personal circumstances!
Our Mission at Auto Online Advisor is to be your ultimate online solution for buying new and used cars, auto warranties and auto insurance. Our site is designed to give you more control of the buying process and make finding a solution that meets your personal needs easier than ever before.

[Layetaixebant]

Whenever you need small
[url=http://shorttermloan.ifrance.com/student-loan-with-bad-credit.html]student loan with bad credit[/url], in order to satisfy certain contingencies, you can use a
[url=http://shorttermloan.ifrance.com/bad-credit-secured-loans.html]bad credit secured loans[/url] . Currently, a large number of comapnies offer cash advance loans through their websites.

http://shorttermloan.ifrance.com/bad-credit-rv-loans.html

[ajohnsys]

Administracija sajta [url=http://nsys.ws]nsys.ws[/url] hochet poblagodarit' sozdatelej sajt za jetot zamechatel'nyj resurs!!!
Nadejus' sajt budet razvivat'sja i dal'she…
____
C uvazheniem, Oleg.
[url=http://nsys.ws]Network System[/url]

[freestaytree]

playing on me. having turtle, we just I started still there. I didn't I was acorns

[jimmylee]

welcome here to [url=http://www.coolingame.com]wow power leveling[/url].
just try our best to do anything.

[sttrqiss]

During selection I have sorted out a dozen of the offers, which have seemed to me perspective.

Then has stopped on the sole company, which really guarantees safety of the contributions -
The Stoic. Already 6 months I cooperate with it.
The charge on percents go permanently

Working with The Stoic you can receive on yours deposit up to 3 percentsDAILY!

If you are interested in this information, there is my referral link.

http://www.stoic-capital.com/index.php?partner=7346029537

Having registered with it you receive from me half of referral commission from yours deposit.
For details write to PM
The Stoic - The Real Online Investment.
Also you can to acquaint with monitoring of this company on the largest resource about online investments

http://www.hyip.com/hyip/common/2572/The+Stoic

[make money]

something to note though is the incredibly offensive image of john edwards in blackface. progressive netroots critics have adopted the offensive iconography of blackface to smear both black republicans and democrats the regard as having sold out ideological purity. they did this to lieberman and steel and even wolf blitzer. could be that the vandalism was an inside job by an edwards campaigner gone obama or clinton.

[map quest]

Updated the map page to use Google maps. You can now link right to Google maps and enter your address for directions, zoom in and out, use the terrain setting or satellite setting.

[GHJansom]

Hello

Wanting to invest some money in
[url=http://cheapjewelry.businessfinanceinformation.com/sitemap/]jewelry scale[/url] can you guys, know of any reliable online jewelry websites?

Many Thanks

[Joinnexia]

Getting the job done is no excuse for not following the rules.

Corollary:
Following the rules will not get the job done.

----------------------------------------------------------------------------------------------------
http://jessiehickmanvo.easyjournal.com