Archive for the 'PPC Tools' Category
Are You Paying the Google AdWords Tax?
Many experienced advertisers realize that there are many gotchas in the AdWords system…optimization tools and default setting which optimize to boost Google’s yield at the expense of unsuspecting advertisers, who don’t yet know what match types are or that their ads are syndicated to content sites by default.
To help new advertisers get past many of the gotchas we created the Google AdWords tax calculator – a free utility which highlights many stumbling blocks that catch new AdWords advertisers.
Given that each keyword market is unique it would be impossible to make a tool that was 100% accurate in every situation, but the goal of this tool was to simply highlight common issues, and help new advertisers address them. Individual efficiency gains may be greater or smaller than the rough initial estimates the tool provides.
Please let us know what you think, as we will gladly iterate this calculator to make it better if you have some great ideas you think we should include in it. Like all of Google’s products, our calculator is starting out in beta
Two New Free PPC Keyword Tools: WordStream’s Free Keyword Niche Finder & Free Keyword Grouper
Guest post by Tom Demers
At WordStream, we just launched a couple of free tools I think paid search marketers can get a lot of utility out of. I’ll walk through how both of them work and what you might be able to use them for.
The first tool is something we’re calling The Free Keyword Niche Finder. Basically the premise is that rather than offering you single keyword suggestions we’re showing you the pockets of keywords (or “keyword niches”) that are the most popular.
This is valuable for a few reasons:
- Keyword Niches Versus Single Keywords – It helps you prioritize your content, keyword targeting, and campaign/AdGroup creation based on an entire “keyword universe” surrounding your topic. Many times you’ll find the most popular keyword you could target will have the “longest tail,” but not always.
- Suggested Keyword Variations – It shows you popular variations within a given keyword cluster, or niche – this helps you to vary page content and anchor text: something real SEOs advocate – and it helps you to structure comprehensive PPC campaigns or Ad Groups
- Campaign Structure Suggestions – It helps you to create a nice semantically-themed campaign and/or Ad Group structure for paid search account creation
I’ll walk through each of these advantages, and then introduce another tool we’re introducing called The Free Keyword Grouper.
1. “Keyword Niches“ Versus Single Keywords
It’s interesting to compare the results of a traditional keyword tool to The Free Keyword Niche Finder.
Here is the list of results from our Free Keyword Tool:

Now let’s look at the results for the same topic using The Free Keyword Niche Finder:

The interesting thing here is in the difference between the two results, and the way that the two tools function. The Free Keyword Tool looks at the volume of results across a variety of sources (ISPs, search engines, and toolbars). The Free Keyword Niche Finder, meanwhile, takes the same data that The Free Keyword Tool is using (our own database) and then clusters that information semantically.
So what we’re seeing here is that some keywords have a longer or more substantial “tail”. Look:

The aggregated keyword “niches” are more centered around brands. If we dig deeper into the refurbished laptops – ibm cluster we get a pretty good idea of why the tail for brands is longer:

So while “used refurbished laptops” is a more popular single query than “refurbished laptops ibm”, the sum of the refurbished laptops keyword niche is actually greater, and it contains more specific, buy-focused terms.
By looking at the data side-by-side, it definitely appears that IBM refurbished laptops is a more profitable keyword niche to attack.
2. Suggested Keyword Variations Within a Group
The tool also shows you closely related variations, as you can see above, so that you can structure a single landing page and Ad Group/ad text to target a variety of phrases, allowing your campaigns to generate more ROI and to become more scalable.
3. PPC Campaign Structure Suggestions
One of the neatest things about this tool from a PPC standpoint is that if you’re starting a new paid search account or campaign, you can get some great suggestions for either high-level campaign ideas, or even for actionable Ad Groups (depending on the term you put in). Following our example from above, we might turn each of the top ten suggestions into high-level campaigns. From there, we could drill down to find specific Ad Groups for each of our campaigns. Let’s take one of the more popular niches, refurbished laptops – dell, and enter that keyword into the Niche Finder:

Assuming were using Refurbished Dell Laptops as a campaign, these would make for a series of pretty tight Ad Groups, ranging from around 10 keywords to around 35, and allowing us to write a very targeted ad and create a very specific, compelling landing page for each group.
The Free Keyword Grouper – Finding Keyword Niches in Your Own Lists and Data
Our other free tool, The Free Keyword Grouper, offers pretty similar functionality, but instead of asking for a keyword as input, it groups your existing data (whether you generated a list from a keyword suggestion tool like the SEO Book Keyword Suggestion Tool or WordStream’s Free Keyword Tool), or allows you to export data from your analytics or a search query report, drop it into the tool, and then The Free Keyword Grouper segments that data for you:

If you drop in a list of keywords, it’ll spit back a list of results similar to what you would find with The Free Keyword Niche Finder. This is a nice way to look at either a list you already have, or to examine historical data on a client site or an existing site you may be taking over. You can then leverage the same advantages The Free Keyword Niche Finder offers.
So What’s the Catch?
As with anything, our new free tools are imperfect. While they’re free, you do have to spend a few seconds creating a free WordStream account to use them, and once you do we’ll occasionally send you relevant Email communications about the tools themselves, or about some of our products you might be interested in.
The Free Keyword Niche Finder works off our own database, and as with any keyword tool, you have to be careful not to be over-reliant upon keyword suggestion data. That’s one of the neat things about The Free Keyword Grouper, though: you can take blended data from multiple tools, or even your own log file or analytic data (which you know to be accurate) and run the tool against that.
Finally: this is just a start. If you’re going to develop really effective paid search campaigns, you need to do a lot more work building out specific Ad Groups and then monitoring their performance to have a really effective paid search account structure. That said these tools are free and easy to use, and we think you’ll find a good deal of utility in them. If you have questions, feedback, or future feature requests, please leave them in the comments!
Google Bid Simulator
Google have announced a new Adwords feature called Bid Simulator.
From the Google Adwords blog:
Bid Simulator takes some of the guess work out of cost per click (CPC) bidding by estimating the number of clicks or impressions you could have received if you had used a different maximum CPC bid.
Google have also provided a tutorial video showing you how to work out your value per click, and how to use this value to maximize your profits.
This video provides a great overview of the economics of PPC bidding, then goes onto show you how to use the Bid Simulator tool to arrive at the most profitable bid.
In summary:
- Determine your max profitable CPA
- Determine your conversion rate
- Calculate your value per click
- Adjust your bids so value per click = ICC (Inceremental Cost Per Click)
This tool, whilst useful in terms of taking a lot of trial and error out of bid setting, will provide marginal benefit in areas where the keyword auction is fierce. If the auction is busy above you, then you’re still going to need to raise you bid a lot for minor increases in volume.
Indeed, some of the recommended bid prices seem very high. The danger is that some people may see this as a helpful autopilot, when really it’s just another “suggestion” tool. Be wary.
The tool is possibly most useful when there is moderate activity in the bid range. Andrew Goodman suggests that Bid Simulator might help a lot in terms of saving cash on the low side:
Case by case, it gets interesting. Take, for example, an account where you figure you’ve done a great job whittling average CPC’s down to 23 cents. Now on a lot of the keywords that you’re getting for 15 cents, you’re not doing great ROI-wise, but you’re reasonably content since the price is low by historic and industry standards, you don’t feel like risking the effort to go down to 11 cents. I think the bid simulator may be helpful in helping advertisers decide when to take risks like that. Shaving those few pennies on lukewarm keywords, across several hundred keywords and a thousand clicks a day, can add up to a lot of saved cash you can then turn around and devote to better performing keywords or channels (or simply, profitability).
Also, as it is a simulator, your actual mileage out on the real Google may vary.
Here’s a presentation on how to use the bid simulator within your Adwords account.
New Pay Per Click Tools
A couple weeks back we created a few new tools that I think I forgot to mention here.
People also send us lots of links to new tools. A couple of them that were sent in recently are a French company’s ad copy brainstorming tool, a cool City Concatenator tool, and a cool neighborhood Concatenator tool.
The Pay Per Click Search Engine Marketing Flowchart
Aaron recently showed me his cool flowchart software and I made a flow chart for PPC.
Let me know what you think.
Why You Must Test & Change Your PPC Bid Strategy
Years ago some noted PPC experts like Perry Marshall recommended bottom fishing AdWords for deals in some competitive markets, claiming that as searchers moved down the listings they were more pre-qualified to make a purchase.
Google’s ad quality score algorithms, bid prices, editorial standards, and the competitive landscape of paid search have changed to where it is much harder to find deals with nickel and dime clicks. Google favors smaller tight lists of keywords over broad mix and match ad groups. And, in an attempt to kill off many forms of ad arbitrage, they made a decision to recycle leading ads against the long tail vs letting longtail advertisers get those clicks for cheap.
27 minutes into this video Dan Thies claims that their sales per click dropped off as their ads moved down the page.

Today George Michie published a blog entry on Search Engine Land about why position bidding wastes money, claiming that the value of traffic doesn’t vary by position (though stating it does vary by time of day and day of week).
The next time someone tries to engage you in a discussion about “finding the right position” for a particular term, remind them that the value of the traffic is measurable; but the cost of a position is unknown, and unknowable, changing based on the whims of your competition. Bottom line: don’t let your competitors run your search program.
Mr. Michie linked to a PDF titled An Empirical Study of Search Engine Advertising Effectiveness – though that statistical study focused on one advertiser in the automotive group. None of these citations should give you a clear optimal bid position strategy, but all should give you encouragement to test your market and find out what works best for you.
Free Self-Hosted Analytic PPC Tool and More
This giving away a fully functional, leave on your server, analytic software started with a hosted program called tracking 202. I guess the fact that tracking 202 was hosted caused a bit of confusion at one of the marketing forums. It really sucks to create tools from your own pocket and then get accused of potentially stealing keywords.
That’s when Wesley Mahler, CEO of prosper 202, listened to his user-base feedback and immediately developed a free self hosted analytics software. I liked tracking 202 because it’s easier to set up. However, after playing with the self hosted program on Wesley’s Mac, I was instantly sold on the product. The weird thing is that the product is free. You can download here. This is not mandatory but if you like the product you can help out by donating here.
Aaron did this something similar to this two years ago by creating an entire suite of search marketing tools and not charge a penny for it. I honestly feel that our seo tools and prosper 202 are better than some of paid and expensive products in the market.
Take advantage of these tools. They will save you time, money and help you gather the right data so that you make more.
Review of Google Ad Planner: Site Targeting Cheat Sheet
I recently spent hours playing with Ad Planner Beta, Google’s newest Adwords tool. If you thought Adwords Editor made your life easier, consider being spoon fed with Ad Planner. The program is amazing, especially if you site target on Google’s content network. It’s a lot like Quantcast, only much more accurate.
Google Does the Work for You

Demographic Filters
Just type in any URL and the tool will group it with other relevant sites. To get even more laser targeted, there is a demographics option where you choose:
- location
- language
- age
- education,
- income and
- gender
Site & Category Filters
After getting the results, you can sort through the data according to
- impressions
- page views
- unique visitors
- index
- category
You can find sites with audiences related to any particular site. Here are sites related to seobook.com

And for any particular site you can find audience details, similar to those provided in Google Website Trends, but with the addition of demographics information.

Filter by AdSense Formats
Here’s the fun part – You can easily handpick relevant sites that are involved in the Google content network. It even allows you to choose the types of media available.

Tons of Great Opportunities
While site targeted advertising tends to be less profitable than keyword targeted ads, if you’re using the content network for brand exposure or e-commerce, the Ad Planner can help you research and reach your target market.
And there are a variety of great non-AdWords related uses for this tool
- compare your traffic levels to competing sites
- find sites worth doing direct ad deals with
- find affiliate sites worth emulating
- find sites worth pitching stories to or writing guest columns for
- find sites worth buying links from or buying outright
Database of US Town Names & Zip Codes
Recently the zip code guy blog highlighted a huge database of USA cities, towns, and counties in a wide array of formats. The database includes lists of
- All US Cities
- All US Counties
- All US Zip Codes
- Latitude and Longitude of Cities/Zip Codes
- States and State Abbreviations
For $25 this database is a great investment if you are run geo-local AdWords campaigns using tools like Speed PPC.
This video offers more background on the United States zip code database.

