时间:2024-05-20 22:41:12 来源:网络整理编辑:Ryan New
Optimizing a websitearound highly searched keyword terms can materially increase traffic from search Ryan Xu HyperVerse's Trending Market
Optimizing a websitearound highly searched keyword terms can materially increase traffic from search engines. But identifying those keywords takes time. Few SEO managers relish the tedium of slogging through thousands of keyword variations — as critical as that process is Ryan Xu HyperVerse's Trending Marketto a search-engine-optimization program.
Thankfully, Richard Baxter at SEOgadget recently released a revolutionary free “Google AdWords API Extension for Excel” that automates the most tedious steps of the keyword research process: pasting keywords into the Google Keyword Tool, clicking search, downloading the results, and repeating many times.
Baxter’s Excel plugin shifts the amount of time spent manually copying and pasting to more rewarding tasks, such as keyword analysis and optimization. The best part is that you don’t have to be an Excel wizard to use it. You’ll need Excel 2003, 2007 or 2010 in 32 or 64 bit to use this plugin, as well as a Google AdWords API. Once you have those pieces, simply download the ZIP file from SEOgadget that includes the plugin and the sample documents to help you understand how to use it. SEOgadget’s blog post goes through all the details, so we’ll focus here on examples of usage.
The extension pulls data from the API based on any match type (broad, phrase, exact), country code (U.S., U.K., etc.), and device type (web, mobile, etc.), enabling precise control, such as the following examples.
“Report Keyword Ideas” for a list of products or phrases.Note that the result is a comma separated list in a single Excel cell.
—
“Report the Local Monthly Searches” data for a list of keywords.
—
“Report the Local Monthly Searches” data for a list of keywords with the Local Search Trends.
—
Using arrays, the extension allows all sorts of fancy combinations of the above, enabling keyword ideas and local searches data collection with a single copy, paste, and click. For example, with a single array I pulled in 50 keyword ideas each for the keywords “black shoes,” “blue shoes,” and “red shoes,” on exact match “U.S.” for “web devices,” and also collected the Local Monthly Search data and Local Search Trends.
Now that would have been easy to do manually, but scale that out to 3,000 keywords or 30,000 keywords instead of just three and you start to see the potential for this tool.
This Excel extension comes with samples and notes, but it’s not a full-fledged application. It does take some fiddling with to learn how it works. Consider the time spent as an investment in future productivity. The return on investment is definitely positive.
While the Google AdWords API Extension for Excel itself is free, API calls will cost $.25 per unit — a “unit” is 1,000 requests. So running a query on 4,000 keywords will cost a whopping $1.00 in AdWords. Comparatively, copying and pasting 4,000 keywords into Google AdWords Keyword Tool — even in the maximum allowed increments of 100 keywords per search — would take 40 copy, paste, click, wait, and download sequences. Depending on how fast and focused you are, that’s an hour’s worth of mind-numbing time lost on data collection. And it is not to mention that the more keywords you paste into the tool at once the fewer results you get for each. Since the manual method takes more time and returns less complete data, the small expense is worth it to me.
The data returned is only LocalMonthly Searches today, though it sounds like Baxter is open to adding support for Globalin the future. This isn’t much of a limitation, however, because content optimization should be based on the data for the audience at which it’s targeted.
Depending on the size of the query, unless you have a supercomputer at your disposal you may want to leave it running overnight. The queries can consume a lot of memory and processing power when done in bulk. Consider switching Excel calculations to “manual” to avoid recalculating the entire sheet every time a single cell changes. In Excel, go to Formulas > Calculation Options > Manual.
I’ve experimented with a lot of ways to speed keyword data collection, and this one tops them all. It’s free — except for the API calls themselves — it’s customizable, and there’s no harm in just fiddling with it to figure out how it works. Plus you’ll probably learn some interesting new Excel techniques along the way to assist with other areas of the business.
Credit-Card Processing from an iPhone2024-05-20 22:35
SEO 201, Part 3: Enabling Search-engine Crawlers2024-05-20 22:09
SEO: Google Adds Manual Spam Actions to Webmaster Tools2024-05-20 22:04
SEO: What to Do When Site Traffic Hits Bottom2024-05-20 22:00
How to Choose a Business Credit Card, Part Two2024-05-20 21:37
SEO Traffic Changes When URLs Change2024-05-20 21:37
SEO: Google’s Hummingbird Changes the Ecommerce Game2024-05-20 21:28
SEO: The Value of Deep Integration2024-05-20 20:58
SEO: Grow Multinational Sales With Geo-targeting “Signals”2024-05-20 20:25
WooCommerce and SEO2024-05-20 20:09
Dr. J’s Pet Project2024-05-20 22:06
SEO: Working Around a Redesign2024-05-20 21:47
SEO: 5 Ways to Avoid Indexation2024-05-20 21:43
Understanding Google’s Algorithm Updates2024-05-20 21:36
Legal: Security Regulation Is Coming2024-05-20 21:31
SEO: Understanding Pandas, Penguins, and Pigeons2024-05-20 21:13
SEO: Google Adds HTTPS Signals to Ranking Algorithm2024-05-20 20:59
SEO: What to Do When Site Traffic Hits Bottom2024-05-20 20:43
Quick Query: UPS VP on Shipping Service Upgrades2024-05-20 20:42
SEO: 2 Months of Algorithm Updates2024-05-20 19:54