Wordstream PPC and SEO Tool Review

May 20th

Wordstream Review

Wordstream Logo

Wordstream is a suite of online marketing tools which cover Keyword Research and Management for PPC and SEO Campaigns. They also offer a Firefox plug-in which we'll cover in a bit. Wordstream gives you access to three free tools:

  • Free Keyword Niche Finder
  • Free Keyword Suggestion Tool
  • Free Keyword Grouper

While there are many free and paid keyword tools on the market Wordstream does offer more in the way of integration with industry leading products like Google AdWords and Google Analytics. Recently Wordstream earned the Editor's Pick award in the Google Analytics Application Gallery:

Google Marketplace Award

Wordstream's keyword data is produced via "blended" data which they acquire from multiple sources. The discuss their data sources on the FAQ section of the Free Keyword Tool. It's important to note that they do not simply pull keyword data from Google like many other "keyword research" tools do.

Both PPC and SEO campaigns can fall victim to poor organization which leads to poor site or campaign architecture which eventually leads to poor results as data becomes more and more difficult to accurately manage. Wordstream aims to aid in your keyword research, PPC campaign management, and SEO execution.

Free Tools

Free Keyword Niche Finder

Keyword Niche Finder

The Keyword Niche Finder attempts to find niches of a core keyword. In this example I chose insurance. Usually, I've had better results with this tool by using really broad keywords. The longer you get into the tail the less associations the tool can perform hence the less niches available for you to analyze. Keyword Niche FInder Insurance Results

You can choose to have the niches emailed to you (you'll get a zip file of all the niches shown on the screen, not all the available ones so be sure you've got the ones you want, and they come as separate .csv's within the .zip) and you can get started sorting through the niches shown to get an idea of what part of the insurance market you may want to pursue. Let's say I'm not interested in travel insurance. So I click the X to get rid of that and another niche pops up, "uk" insurance. Note the number of niches has gone down and I'm left with a new niche to evaluate, "UK", within the insurance market.

Keyword Niche FInder Arrows

So after sorting through the available niches I've narrowed it down to the following niches:

Keyword Niche Finder Trimmed

So I've decided to pursue the life insurance market so I click on the bucket and I'm shown 774 keywords for that niche. As you can see, there is a filtering option but that is available to paid subscribers. Relative frequency refers to their "blended data" approach meaning the term life insurance quote typically is searched more often than life insurance exam in aggregate.

If this is the only niche you want to target simply remove the other niches and request the emailed .csv (need to leave at least 2 active niches for export though). This way you'll receive the keywords you want for further processing in whatever spreadsheet application you use. This tool is somewhat limited as it is a free tool but it can be a pretty useful way to get a broad view of niches available in a specific market when first starting out.

Plus, it's a pretty slick way to bounce back and forth between different niches without having to re-query a keyword tool every time you want to look at a different market.

Free Keyword Grouper

Keyword Grouper

Wordstream's Keyword Grouper tool where you can enter up to 10,000 keywords and have Wordstream group them by category and word/modifier association.

This tool can be quite useful when you pull data from something like your web analytics or PPC programs and receive a variety of new keywords back. The Keyword Grouper tool will group using modifiers (cheap, free, buy, etc) which helps you identify new market segments or new keywords you may have been missing out on initially.

I think the idea behind the tool is solid but I also think you'd want to spend some time going through your own results to further refine your data. The following screen shot was produced after entering the following data:

  • home insurance 88
  • auto insurance 39
  • home insurance company 33
  • auto insurance quote 28
Keyword Grouping Results

The groupings are mostly sensible and they also filtered in some modifiers that I didn't originally include but ones that I know are valuable in this industry. Aligning your keywords to your site's structure is always a good idea when doing SEO and this tool can help a bit in that area. The tool (free) is not perfect but it does provide useful, actionable data.

Wordstream put out a helpful Keyword Grouping white paper as well.

 

Free Keyword Tool

Free Keyword Tool

Wordstream's Free Keyword Tool does exactly what you would expect it to, it gives you keyword data. Their "blended" method of aggregating data can be found here.

My Favorite Feature

When you export the keywords you are given the top 10,000 sorted from the highest relative frequency to the lowest! Car insurance returned over 45k results and I am now able, for free, to download the top 10k keywords in order of search volume. This is a killer feature for any keyword tool, much less a free one. Consider that:

  • Wordtracker goes up to 1k
  • Google AdWords is less than Wordtracker
  • Even some Competitive Research Tools do not offer the ability to export 10k results with sorting enabled!

Keyword Tool Results

So that about sums it up for their free tools. I personally like how Wordstream keeps feature bloat out of these tools. So many times you see these keyword tools come out and start making up their own custom metrics which at some point involve:

  • Total number of competing pages
  • Some form of KEI
  • Some made up metric to distract you from the fact that all they are doing is pulling data from Google and recycling it :-(

A keyword tool, which pulls data from sources other than Google, has some inherent value as we know that Google's data often has disagreements within their own tools so it's important to have one or three third party sources of data.

Paid Tools

Wordstream's toolset is broken down into 4 groups of tools:

  1. Discover Keywords
  2. Manage Keywords
  3. Create PPC Campaigns
  4. Create SEO Content

Discover Keywords

Keyword Suggestion Tool

A simple keyword tool where you enter your desired keywords and get up to 10,000 results for your search. Wordstream also provides an area where they suggest related words and synonyms which you can easily add to your keyword search by clicking the check mark adjacent to the modifier.

The keyword results section offers up your selected results with the following options pertaining to how deep your results will go:

  • 15
  • 50
  • 100
  • 200
  • 500
  • 1,000
  • 5,000
  • 10,000

Keyword Suggestion Tool DW

From here you can whittle down to the keywords you want to add to your campaign (you can add these keywords to your Wordstream database from inside the tool).

The speed and depth at which these keywords are returned at are both very impressive compared to other keyword tools.

Spy on the Competition Tool

Similar to how the Google AdWords Keyword Tool operates, you can place a URL + check all the pages on a website or just a specific page in the search bar and get keywords relevant to whatever site/page you searched on.

Wordstream Spy Tool

Where I think this tool falls short is in the categorization data that the AdWords tool returns when you place a URL in their search box. The AdWords tool basically gives you a nice head start into potential site structure options via how they break down the categories and keywords within a URL that you search on. You can use Wordstream's organization capabilities after you are done adding the keywords into your database but I think having the initial breakdown that AdWords provides is slick and something Wordstream may want to consider as they continue to develop their toolset.

Enable Continuous Keyword Discovery

In a world filled with buzzwords used simply to sell you on recycled products or feature bloat you may look at this as say "riiiiiight". However, this is actually a unique point of differentiation between Wordstream and every other keyword tool on the market.

Continous Keyword Discovery

This tool gives your Wordstream keyword database real time access into keywords that are bringing you traffic from either your Google Analytics account or, if you don't use Google Analytics, a custom Wordstream tracking code you can embed on your website.

If you make the decision to utilize Wordstream to manage your keyword database then this is a killer feature. No other keyword tool offers such a feature, that I'm aware of anyway. So if you are not overly interested in combing through your analytics reports frequently in order to find additional keywords to target, then this feature will be beneficial to you as the new keywords automatically pop up into your Wordstream database.

It's also useful for transitioning these keywords into a PPC campaign you may be managing in Wordstream either as a new keyword to bid on *or* as a negative keyword. So this tool is also handy for being a negative keyword finder as well.

Other Ways to Import Keywords

Wordstream allows you to copy and paste keywords into your account and initially tag them as either "Paid", "Organic", or "Suggested" keyword sources.

Copy and Paste Keywords

You can also download a tool which analyzes your web server logs for keywords

Server Log Keywords

You can also upload a CSV or TSV file...

Upload CSV/TSV

So those are the ways you can initially find and upload keywords with Wordstream. The second function of Wordstream's workflow is actually managing those keywords.

Manage Keywords

Wordstream puts out three options for keyword management:

  1. Organize Keywords
  2. Find Negatives
  3. Prioritize Workflow

Organize Keywords

At first glance it seems a bit overwhelming, but it's not. You have the following features/options available to you:

  • Automated keyword grouping suggestions on the left side, which you can accept, show, hide, or decline
  • Keywords in your campaign sorted by paid, organic, or suggested (based on tagging you control), new keywords found via your analytics or AdWords tie in, date filtering options, view by keywords that are grouped and ones that are not grouped.
  • The ability to add buckets of filtered keywords to a PPC campaign
  • The ability to use their new SEO Content feature to tie into your CMS and create content for a specific keyword
  • Goals and Action data, available for customization within your settings options
  • Export keywords

Organize Keywords

Keyword Group Explorer

The Keyword Group Explorer gives you keyword grouping suggestions based on your keywords. The buckets in yellow are ones which have been accepted by the user as groups and the ones in gray have not been. You can decline the grouping by clicking the gray X or accept it by clicking the check mark. You can hide these suggestions by clicking the light bulb in the bottom of the sidebar.

keyword group explorer

So I'll investigate the puppy suggestion. I click on the suggestions and I'm shown keywords specific to puppy or puppies.

puppy grouping

This groups all the keywords containing puppy or puppies into one bucket. You can rename the group by clicking "create keyword group" in the right corner. You can also hover over any individual word in the keyword group to delete it and filter out any other keywords containing that modifier.

I renamed the group "Puppy Stuff" just to illustrate the ability to customize your groups. So back to the Keyword Group Explorer, turned off other suggestions for now and ta-da, there is Puppy Stuff.

puppy group explorer

 

The little arrow indicates the sub-groups Wordstream automatically created with the keywords in the Puppy Stuff bucket (I named this pretty horribly as you'll see in a second). So if you click on the arrow you'll see the sub-groups Wordstream automatically created (I should have left it as Puppy!):

 

Puppy Sub Groups

Similar to the main groupings you can click on the check to accept, the X to decline, or the keyword to see the keywords within that group for further grouping and refinement. Hover over a group and see the following:

Puppy Hover Stats

This gives you the top keyword in that sub-group. The stats are as follows:

  • 15.2% represents how much traffic this group could produce, saying the keywords within the puppy stuff training group accounts for 15.2% of the traffic for the main group Puppy Stuff.
  • 16.5% represents the % of keywords in this group accounting for that same percentage in the parent group Puppy Stuff. So this group has 16.5% of the keywords in the entire group.

If you right click on a group you get the following options (applies to groups and sub-groups as well)

Rollover Options

Some of these items are self-explanatory but the de-duplicate option is pretty sweet. Click on that and you'll see duplicate keywords across your groups. This is handy because it really lets you refine your lists pretty quickly and efficiently. You can choose which group to remove duplicates from:

de duplicate

Another neat feature is if you click on the jack looking icon in the keyword results you can get options to search Google Trends, the Google Search Results, Bing's xRank, and Bing's search results:

Google Bing Integration

Google Bing Search Box

You can use this method to keep creating more and more sub-groups if desired but usually 1-2 levels deep is good enough. You don't want to integrate so tightly that someone has to click 17 times to get to an article that could have been easily served on a sub-page within a top-level category.

Negative Keyword Selection

This tool allows you to search for negative keywords at the group and sub-group levels. It highlights the words that might be irrelevant to your campaign and gives you the option to accept the modifier or deny the modifier via a yes/no option. So what you are saying yes/no to is the highlighted word, not the phrase itself.

negative keywords

They also have a checkbox option which keeps potential negative keywords out of this report IF they have previously resulted in conversions (via your AdWords/analytics tie-in data).

Once you add a negative keyword in there you can choose phrase, broad, or exact match as negative keyword options. You can manually add negative keywords as well.

One option I'd like to see is "add full keyword/phrase or just highlighted modifier" rather than just adding the modifier.

They also offer a feature which tries to associate a selected negative keyword with other ones that appear in this report. So for instance, I checked off Chesapeake and hit yes, then I was presented with this:

Related Negative Keywords

 

Prioritize Workflow

Wordstream's products play to agency type accounts and workflow is a big part of what they offer. The Prioritize Workflow tool allows you to review workflow information at the group, sub-group, and account level.

workflow

From here you can:

  • Segment groups with no sub-groups into sub-groups
  • Associate an ad group with a keyword group
  • Associate a landing page with a keyword group or groups
  • Cleanse a group (takes you to the negative keyword tool)
  • De-duplicate groups

The columns are as follows:

  • Relevance - A custom score which is derived initially from the amount of keywords within a group and how many visits they have driven. Typically the higher the relevance the more important the group to your traffic levels.
  • Visits - Total number of visits per group of keywords
  • Keywords - Total number of keywords within a group
  • Group Size - If you get the triangle it means you've exceed the group size you set (or was set by default) in the Wordstream Settings panel which is found under the Settings Tab - Wordstream Settings
  • AdWords/Landing Pages - Shows whether or not a group is associated with a landing page or an AdWords account
  • Filthiness - Shows (based on settings that can be modified in Settings - Wordstream Settings) if you've exceed limits set for negative keyword candidates as a percentage of the keyword group.

The Relevance field has some customization options:

Keyword relevancy

So you can play with this a bit and throw in goals and value of goals as variables as to show which groups are not only driving the most traffic, but are also producing the most goals. Usually you'll find custom keyword performance metrics are not so great because they don't use any relevant data. Here though, Wordstream is using 3 of the most relevant pieces of data when it comes to keywords and keyword importance

  • Actual Traffic
  • Actual Conversions
  • Value of Conversions

That was an overview of what Wordstream can do for finding and managing your keywords both on the paid search and organic search side. The third piece of Wordstream's suite of tools is the PPC Campaign Management option.

PPC Campaign Management

Wordstream's Create PPC Campaign tab takes you right into a nice, clean (dare I say Google like) interface. Here you can pretty much do everything you can do with the AdWords Editor.

You can do all of the following here:

  • Download an existing campaign
  • Create a new campaign (for uploading or exporting later)
  • Set your campaign name
  • Set your campaign budget
  • Adjust your campaign status
  • Choose Search and/or Content Network
  • Work with Content Network bids
  • Set a start and end date
  • Work with language and location targeting
  • Assign ad groups to campaigns
  • Interface with Google's Conversion Optimizer

Moving Keyword Groups to Ad Groups

It is very easy to move one of your existing Wordstream Keyword Groups into Ad Groups. All you need to do is go to Manage Keywords - Organize Keywords right click on the ad group (we'll go with Puppy Stuff) and select "Create Google AdWords Ad Group"

keyword group adwords group integration

Then you are brought to a screen where you select the campaign you want to add it to:

Create Ad Group

Then the group is added to the Create PPC Campaign interface where you can work with just about everything you are use to working with within AdWords.

Currently you can only work directly with the AdWords interface but you can export your campaigns in both Yahoo and Microsoft AdCenter format.

Landing Page Assignment

In the same way you export Keyword Groups to AdWords AdGroups you can associate landing pages by simply clicking "Associate Landing Page with Keyword Group" in the Manage My Keywords - Organize Keywords area or in the Prioritize Workflow Area.

Adding Conversion Goals

If you tie into Google Analytics this is already added automatically added (each time you add a Goal to analytics).

Conversion goals

You can manage them here and add ones manually. This is managed in the Settings - Conversion Goals tab.

So this feature is pretty sweet on the SEO side of the house because with that custom Relevancy data we discussed earlier you can get a real, honest picture of which set of keywords are performing well and perhaps where more sub-groups of that keyword need to be investigated for more content and hopefully more conversions.

The goals can be viewed right in the Organize Keywords area and keywords can be sorted by completed goals which is handy when you are refining your campaign.

So this is really another piece of their unique feature which we talked about earlier, Continuous Keyword Research. If you choose to manage your campaign within Wordstream it is really a slick set up for SEO (and PPC) and they are looking to beef up the SEO side of things in the near future which is exciting.

Create SEO Content and Wordstream Firefox Plug in

seo firefox

Wordstream's Create SEO Content feature within your account is a tie in with the Firefox Plug-in. The plug-in is really useful if you utilize blog software for web publishing and especially if you have multiple content authors.

The firefox plug-in loads in the left side of your browser and ties into your existing Wordstream database giving you the option to do keyword research as well as create blog entries right from the plug-in in either:

  • Wordpress
  • Blogger
  • Drupal
  • Typepad

If you are self-hosting the blogs/sites on WP, Drupal, or Typepad you'll have to provide your login URL and the URL for adding content. You can use your own CMS as well, but you'll need to manually log in to these CMS's/Blogs.

The image below shows you how the keywords are presented (in groups similar to the Wordstream tool), the content tie-in to the right, and the keyword options on the bottom:

  • Top Ten Keywords
  • Longer Tail Variations
  • Questions associated with your selected bucket

Seo Plug-in Overview

And when you are writing your content the tool will show you instances of the longer tail keywords in your copy as you write it!

Seo Plug In Content Creator

In the first image the second tab shows "My Keywords". This is the tie in to the existing Wordstream database (your private database) and allows you to start building out your site structure, pretty cool stuff. The "associate content" link indicates that you have not associated a page with your keyword(s).

You can also right click on any keyword and get direct access to the following queries:

Search Features

 

I stole these images from Wordstream's great piece on their plug-in as they do a great job of showing the CMS integration:

Wordstream's Firefox Plug-in

A Handy Dashboard Ties it Together

In your account you have access to a dashboard that shows the following stats in one spot:

  • Top New Search Queries (from Analytics)
  • My Search Query Database Size
  • New Negative Keyword Possibilites
  • Best Performing Search Queries
  • Search Query Conversions
  • Possible Grouping Options Based on Queries
  • Worst Performing Queries
  • Best Performing Groups

dashboard

Great Wordstream resources can be found here:

About Wordstream

Wordstream User Guide

So What Do You Think?

Wordstream certainly has lots and lots of features as well as some nice features not present in any other quality keyword tool (that I'm aware of) such as:

  • Continuous research (being able to bounce from keyword set to keyword set right in the same interface and managing those keywords as well)
  • Being able to research keywords in clusters/groups with a click of the mouse, then automatically showing sub-categories
  • Their database, likely because it pulls from many sources, does a solid job with long tail keywords
  • Using your analytics and AdWords reports to automatically pull in new keywords for you to act on, to track goals on, and so forth is a fantastic feature as we discussed earlier (being able to truly see the more valuable keyword sets within your site's architecture)

Overall Wordstream has a robust PPC offering along with a strong SEO toolset offering. In discussing their future plans on the SEO side they did state that they are continuing to improve their UI (which I quite like) as well as continue to add SEO features and tools to their current offering. Their current SEO offering is on par, price wise, with many of the other non-Google tools out there, and offers just as many features as some and more features than others.

They have a 7 day free trial available and I think it's worth spending some time with their toolset to see if it fits in with your current workflow. You can manage multiple sites (profiles) so long as you own and operate the sites. You can also get an agency account with Wordstream so you can manage client accounts as well. Each type lets you add multiple users to the account to assist with whatever your workflow needs happen to be.

Check Out Wordstream

Wordstream Pricing Options

Published: May 20, 2010

New to the site? Join for Free and get over $300 of free SEO software.

Once you set up your free account you can comment on our blog, and you are eligible to receive our search engine success SEO newsletter.

Already have an account? Login to share your opinions.

Comments

May 21, 2010 - 7:58am

Aaron,

Is this the longest post till date in seobook.com?

Wordstream is great. I do use it.

October 17, 2013 - 2:28pm

Ok so let's see if seobook.com is paid by wordstream or if seobook.com posts real honest posts:

So I'm in a contract with this company for 6 mo. My 4 year old company fell on hard times for the first time ever. To the point where we dropping our server, office, everything. I even have to cancel our health insurance for my family to keep from getting upside down during these rough times. Wordstream has absolutely NO SYMPATHY and does not CARE or VALUE CUSTOMERS. All they want is your MONEY. The kicker is, I'm learning that their software actually hurt my campaigns in the short and long term! So their promises are empty because I can't find the performance they claim and now that we're at our worst state ever, they add insult to injury by offering PIP or product improvement program where I test their freaking software each month. Or I can buy out for a small fortune. How am I suppose to test the software when I don't have an adwords account anymore? Absolutely NO HELP from this machine company. All I can say is STAY AWAY FROM THIS COMPANY AT ALL COSTS!!!!

May 21, 2010 - 6:28pm

Now that we have a bit more editorial help I thought the only way it made sense to invest on that front is if we made sure we went deeper than competing sites do. :)

I don't think this is the longest post by word count, but images do make it appear quite quite long.

January 19, 2012 - 6:19pm

either they gave you all for free, or they gave you a lot of money - no offence !
in hours of support and few days/month using it I haven't got all what you are saying, but instead here it is my experience with them:

until you begin paying they are very nice, but they know why : because after you become a bit addicted and think that you have discovered the world you are theirs ...

after few payments you optimize some costs but the results are not coming as expected (maybe for the very big clients they do ...) - they say it needs 6 months ...

you cannot pause or interrupt the account - you are forced to pay even if you don't use; and even of you say this they are just saying pay pay pay ...

i have not ever see a subscription that you cannot interrupt or pause for a while, so be very carefull because once you start paying the there is no turning back - you either pay and have some results or you stop and then you are kicked no matter how many thousands of usd you gave them ...

my performance grader (their calculation) is above 97% - so i have scored better then most of their graded adwords accounts - and this wasn't coming from their software because I used it only 1-2 days a month when I had time.

the account was allready optimized before I got to them and I really thought it will help me do more ... it didn't and I wasted lots of money ... and I could use only QUERRYSTREAM because all the other tools are not working in my native language ...

as a conclusion, if your website is in english, maybe using all their tools it will be worthy ... but if you don't, then stay away !!

November 22, 2013 - 6:01pm

If you want to throw your money out of the window go ahead with Wordstream.

The software is slow and does nothing you can't do yourself.

They will prosecute you if you don't pay and threaten you with collection agencies if you don't pay. 1.5% interest on unpaid balance is due if you are late with payments.

If you want to cancel your subscription, there is a 6 month notice and they go after you for the money.

If you want to get nothing but frustration for your money go for it. Otherwise, stay away from this SCAM !!!!!!

New to the site? Join for Free and get over $300 of free SEO software.

Once you set up your free account you can comment on our blog, and you are eligible to receive our search engine success SEO newsletter.

Already have an account? Login to share your opinions.

  • Over 100 training modules, covering topics like: keyword research, link building, site architecture, website monetization, pay per click ads, tracking results, and more.
  • An exclusive interactive community forum
  • Members only videos and tools
  • Additional bonuses - like data spreadsheets, and money saving tips
We love our customers, but more importantly

Our customers love us!






    Email Address
    Pick a Username
    Yes, please send me "7 Days to SEO Success" mini-course (a $57 value) for free.

    Learn More

    We value your privacy. We will not rent or sell your email address.