This year’s MozCon was, without a doubt, the best SEO conference I’ve ever been to. I’ve said that before and I’ll say it again – if you have the chance to go next year, and you’re a serious search marketer, you’d be insane not to attend.
Show, not tell
Big conference speaking is a little intimidating at times but I really enjoyed speaking about keyword research at MozCon. I gave a live demonstration of our adwords API extension, categorised some keyword data and learned so much about getting microphones attached correctly at the beginning of a session. I think I’ve learned with keyword research you have to show, not tell – the audience were so excited (and very kindly) gave me a round of applause (warm fuzzies).
“Wave your magic wand, Harry!”
Rand Fiskin, MozCon 2011 – Photo: Thomas Ballantyne
My favourite tools
In the session I shared a bunch of new, old, favourite and interesting tools to use in the keyword research process. If you haven’ seen the presentation, here it is:
Automating and Scaling Keyword Research
Follow Richard Baxter on Slideshare
Here are the tools from the presentation:
Google Adwords Plugin for MS Excel
Our Google Adwords plugin has been a huge success and the 700+ downloads (and counting) is a great start. It’s free and saves an infinite amount of time if you’re trying to get hold of web or mobile search volumes in your language and location. Just yesterday I used it to pull 17,000 search volumes for a client’s keyword research project. It took me half a day to build the same level of epic Excel spreadsheet that two years ago would have taken me a full week.
Here’s a short video if you’d like to see the tool in action:
SEO Tools For Excel
To capture lots of keyword inspiration, you might consider generating a keyword strategy based on a competitors site crawl (large site dynamic SEO can be so predictable). Neils Bosma made this process even easier with his amazing SEO tools for Excel plugin.
Gathering the H1, H2,
, meta description and keywords is so much easier thanks to the functions you see above. I know Neils has recently updated his plugin with even more features, so go check them out.<br />Alchemy API: VB Script for Excel<br /><br />For a few years I’ve had a VB script based Excel plugin to gather data via the incredible Alchemy API. You can download the Excel macro here. Process a list of URLs and receive a list of keywords – from which you can generate search volumes using the Adwords plugin above. What’s not to like?<br /><br /><br />Übersuggest<br /><br />Ubersuggest is the tool to generate thousands of potential keyword ideas. Just add a keyword, select your language and boom! Keywords. The latest incarnation of the tool also scrapes Google News suggest. Nice.<br /><br /><br />XPathBuilder<br /><br />XPathBuilder is built to make generating xpath queries easier for scraping services like Yahoo, Bing and Google search. It’s really easy to learn how to do this yourself, but I must admit I love the idea from a timesaving point of view – a specific query generator for a very specific task. I’d be very pleased to see this develop further.<br /><br /><br />Scraping QA services for inspiration<br /><br /><br /><br />This is a quick GDocs scrape hack I cobbled together to demonstrate how pulling data from QA services can be useful for inspiration. In the SEOmoz QA system you can gether data on who is answering, post titles, number of responses and the like. Very useful to see what’s popular, perhaps to justify a blog post! Here’s my Google Docs demo (head to “SEOmoz QA Blog Post Ideas”)<br />Mergewords<br /><br />The old classic – an insanely easy way to concatenate combinations of new keywords ready to go into your favourite search volume checker. It’s one of my personal favourites!<br /><br /><br />New and useful tools<br /><br />The tools above are amongst my favourite – obviously I wouldn’t be doing my job without giving SEOgadget keyword research a mention which gathers search volumes, rankings and categorises keywords on the fly. You could do a lot of what’s contained in this post with our toolset, but obviously you can do it for free with a bit of hard graft.<br /><br />If you’ve got any new tools you’d like to share I’d love to hear about them! Drop a comment below and say hi!</div><div class="clear"></div></div><span class="gensmall"></span></td></tr><tr><td colspan="2"><div class="fa_like_div"><p class="fa_like_list" style="display: none;"></p><button class="rep-button " data-href="" data-href-rm=""><svg width="15px" height="15px" viewBox="0 0 1792 1792" xmlns="http://www.w3.org/2000/svg"><path d="M320 1344q0-26-19-45t-45-19q-27 0-45.5 19t-18.5 45q0 27 18.5 45.5t45.5 18.5q26 0 45-18.5t19-45.5zm160-512v640q0 26-19 45t-45 19h-288q-26 0-45-19t-19-45v-640q0-26 19-45t45-19h288q26 0 45 19t19 45zm1184 0q0 86-55 149 15 44 15 76 3 76-43 137 17 56 0 117-15 57-54 94 9 112-49 181-64 76-197 78h-129q-66 0-144-15.5t-121.5-29-120.5-39.5q-123-43-158-44-26-1-45-19.5t-19-44.5v-641q0-25 18-43.5t43-20.5q24-2 76-59t101-121q68-87 101-120 18-18 31-48t17.5-48.5 13.5-60.5q7-39 12.5-61t19.5-52 34-50q19-19 45-19 46 0 82.5 10.5t60 26 40 40.5 24 45 12 50 5 45 .5 39q0 38-9.5 76t-19 60-27.5 56q-3 6-10 18t-11 22-8 24h277q78 0 135 57t57 135z" fill="#666"/></svg><span>Like</span><span class="rep-nb" style="display:none;"></span></button><button class="rep-button " data-href="" data-href-rm=""><svg width="15px" height="15px" viewBox="0 0 1792 1792" xmlns="http://www.w3.org/2000/svg"><path d="M320 576q0 26-19 45t-45 19q-27 0-45.5-19t-18.5-45q0-27 18.5-45.5t45.5-18.5q26 0 45 18.5t19 45.5zm160 512v-640q0-26-19-45t-45-19h-288q-26 0-45 19t-19 45v640q0 26 19 45t45 19h288q26 0 45-19t19-45zm1129-149q55 61 55 149-1 78-57.5 135t-134.5 57h-277q4 14 8 24t11 22 10 18q18 37 27 57t19 58.5 10 76.5q0 24-.5 39t-5 45-12 50-24 45-40 40.5-60 26-82.5 10.5q-26 0-45-19-20-20-34-50t-19.5-52-12.5-61q-9-42-13.5-60.5t-17.5-48.5-31-48q-33-33-101-120-49-64-101-121t-76-59q-25-2-43-20.5t-18-43.5v-641q0-26 19-44.5t45-19.5q35-1 158-44 77-26 120.5-39.5t121.5-29 144-15.5h129q133 2 197 78 58 69 49 181 39 37 54 94 17 61 0 117 46 61 43 137 0 32-15 76z" fill="#666"/></svg><span>Dislike</span><span class="rep-nb" style="display:none;"></span></button></div></td></tr></table></td></tr><tr class="post--424" style=""><td class="row1 browse-arrows" align="center" valign="middle" width="150"><a href="#top"><img class="sprite-arrow_subsilver_up" src="https://2img.net/i/empty.gif" alt="Back to top" loading="lazy" /></a> <a href="#bottom"><img class="sprite-arrow_subsilver_down" src="https://2img.net/i/empty.gif" alt="Go down" loading="lazy" /></a></td><td class="row1 messaging gensmall" width="100%" height="28"><table border="0" cellspacing="0" cellpadding="0"><tr><td valign="middle"> </td></tr></table></td></tr><tr align="right"><td class="catBottom" colspan="2" height="28"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="9%" class="noprint"> </td><td align="center" class="t-title"><a name="bottomtitle"></a><div class="cattitle">Favourite Keyword Research Tools From #MozCon</div></td><td align="right" nowrap="nowrap" width="9%" class="browse-arrows"><a href="#top"><img class="sprite-arrow_subsilver_up" src="https://2img.net/i/empty.gif" alt="Back to top" loading="lazy" /></a> </td></tr></table></td></tr></table><table class="forumline noprint" width="100%" border="0" cellspacing="0" cellpadding="0" style="margin: 0 0 1px 0; border-top: 0px;"><tr><td class="row2" valign="top" colspan="2" width="150"><span class="gensmall">Page <strong>1</strong> of <strong>1</strong></span></td></tr><tr><td class="row2" colspan="2" align="right" valign="top"><span class="gensmall"></span></td></tr></table><table class="forumline" width="100%" border="0" cellpadding="1" cellspacing="0" id="ptrafic_close" style="display:none;margin: 1px 0px 1px 0px"><tr><td class="catBottom" height="28"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top"><div class="cattitle"> Similar topics</div></td><td align="right" valign="middle" width="10"><span class="gensmall"><a href="javascript:ShowHideLayer('ptrafic_open','ptrafic_close');"><img class="sprite-tabs_more" src="https://2img.net/i/empty.gif" alt="+" align="middle" border="0" /></a></span></td></tr></table></td></tr></table><table class="forumline" width="100%" border="0" cellpadding="1" cellspacing="0" id="ptrafic_open" style="display:'';margin: 1px 0px 1px 0px"><tr><td class="catBottom" height="28"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top"><div class="cattitle"> Similar topics</div></td><td align="right" valign="middle" width="10"><span class="gensmall"><a href="javascript:ShowHideLayer('ptrafic_open','ptrafic_close');"><img class="sprite-tabs_less" src="https://2img.net/i/empty.gif" alt="-" align="middle" border="0" /></a></span></td></tr></table></td></tr><tr><td class="row2 postbody" valign="top">» <a style="text-decoration:none" href="/t1080-cong-cu-nghien-cuu-tu-khoa-affordable-keyword-research-software" title="Công cụ nghiên cứu từ khóa Affordable Keyword Research Software">Công cụ nghiên cứu từ khóa Affordable Keyword Research Software</a><br />» <a style="text-decoration:none" href="/t1069-keyword-position-checker" title="Keyword Position Checker">Keyword Position Checker</a><br />» <a style="text-decoration:none" href="/t251-long-tail-keywords-toi-uu-hoa-keyword-e-seo-tot-hon" title="Long tail keywords - Tối ưu hóa keyword để SEO tốt hơn ">Long tail keywords - Tối ưu hóa keyword để SEO tốt hơn </a><br />» <a style="text-decoration:none" href="/t408-google-keyword-tool-external-vs-beta-whats-the-difference" title="Google Keyword Tool [External vs Beta] – What’s the Difference?">Google Keyword Tool [External vs Beta] – What’s the Difference?</a><br />» <a style="text-decoration:none" href="/t415-using-vlookup-to-match-keyword-volume-rankings-data" title="Using VLOOKUP to Match Keyword Volume & Rankings Data">Using VLOOKUP to Match Keyword Volume & Rankings Data</a><br /></td></tr></table><table class="forumline noprint" width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td class="row2" colspan="2" align="center" style="padding:0px"><a name="quickreply"></a><br /></td></tr><tr><td style="margin:0; padding: 0;" colspan="2"><table border="0" cellpadding="0" width="100%" cellspacing="0" id="info_open" style="display:''"><tbody><tr><td class="row2" valign="top" width="25%"><span class="gensmall"><strong>Permissions in this forum:</strong></span></td><td class="row1" valign="top" width="75%"><span class="gensmall">You <strong>cannot</strong> reply to topics in this forum<br /></span></td></tr><tr><td class="catBottom" colspan="2" height="28"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="middle" width="100%"><span class="nav"><a class="nav" href="/">Diễn Đàn SEO Panda - SEO Panda Forum</a><a class="nav" href=""></a> :: <a href="/c3-search-engine-optimization" class="nav"><span>Search Engine Optimization</span></a> :: <a href="/f11-on-page-seo" class="nav"><span>On-Page SEO</span></a></span></td><td align="right" valign="middle"><span class="gensmall"><a href="javascript:ShowHideLayer('info_open','info_close');"><img class="sprite-tabs_less" src="https://2img.net/i/empty.gif" alt="-" align="middle" border="0" /></a></span></td></tr></table></td></tr></tbody></table></td></tr><tr><td style="margin:0; padding: 0;" colspan="2"><table border="0" cellpadding="0" cellspacing="0" width="100%" id="info_close" style="display:none;"><tbody><tr><td class="catBottom" colspan="2" height="28"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="middle" width="100%"><span class="nav"><a class="nav" href="/">Diễn Đàn SEO Panda - SEO Panda Forum</a><a class="nav" href=""></a> :: <a href="/c3-search-engine-optimization" class="nav"><span>Search Engine Optimization</span></a> :: <a href="/f11-on-page-seo" class="nav"><span>On-Page SEO</span></a></span></td><td align="right" valign="middle"><span class="gensmall"><a href="javascript:ShowHideLayer('info_open','info_close');"><img class="sprite-tabs_more" src="https://2img.net/i/empty.gif" alt="+" align="middle" border="0" /></a></span></td></tr></table></td></tr></tbody></table></td></tr></table><form action="/viewforum" method="get" name="jumpbox" onsubmit="if(document.jumpbox.f.value == -1){return false;}"><table class="noprint" width="100%" border="0" cellspacing="2" cellpadding="0" align="center"><tr><td align="left" valign="middle" nowrap="nowrap" ><span class="nav"></span></td><td align="right" nowrap="nowrap"><span class="gensmall">Jump to: <select name="selected_id" onchange="if(this.options[this.selectedIndex].value != -1){ forms['jumpbox'].submit() }"><option value="-1">Select a forum</option><option value="-1"></option><option value="-1">|</option><option txt="foro" value="c1">|--Admin</option><option txt="foro" value="f4">| |--Paid Ads</option><option txt="foro" value="f5">| |--General Discussions</option><option txt="foro" value="f3">| |--Forum News - Review Sites</option><option txt="foro" value="f1">| |--Questions&Answers&Feedbacks</option><option value="-1">| </option><option txt="foro" value="c5">|--Free Market</option><option txt="foro" value="f27">| |--PriceFive</option><option txt="foro" value="f16">| |--Link Trade & Link Exchange</option><option txt="foro" value="f17">| |--Domain Name & Website</option><option txt="foro" value="f18">| |--Affiliate Programs & Softwares</option><option txt="foro" value="f19">| |--Anything</option><option value="-1">| </option><option txt="foro" value="c2">|--Search Engines</option><option txt="foro" value="f6">| |--Introductions</option><option txt="foro" value="f7">| |--Google</option><option txt="foro" value="f8">| |--Yahoo & Bing</option><option value="-1">| </option><option txt="foro" value="c6">|--Search Engine Marketing</option><option txt="foro" value="f25">| |--Adwords - Adsense</option><option txt="foro" value="f26">| |--Social Sites</option><option value="-1">| </option><option txt="foro" value="c3">|--Search Engine Optimization</option><option txt="foro" value="f9">| |--General SEO</option><option txt="foro" value="f10">| |--Link Building</option><option txt="foro" value="f11">| |--On-Page SEO</option><option txt="foro" value="f12">| |--SEO Services Wanted</option><option txt="foro" value="f13">| |--SEO Services Offered</option><option txt="foro" value="f14">| |--SEO Tools & SEO Tips</option><option txt="foro" value="f15">| |--Black Hat SEO</option><option value="-1">| </option><option txt="foro" value="c4">|--Jobs</option><option txt="foro" value="f20">| |--Jobs wanted</option><option txt="foro" value="f21">| |--Jobs Offered</option><option txt="foro" value="f22">| |--Free Jobs</option><option value="-1">| </option><option txt="foro" value="c7">|--Money Online</option><option txt="foro" value="f23">| |--Tips</option><option txt="foro" value="f24">| |--Freelancers</option><option value="-1">| </option><option txt="foro" value="f2">|--Basket & Spam</option></select><input type="hidden" name="tid" value="6c62f5f122668b99e9800998ecf8427e" /> <input class="liteoption" type="submit" value="Go" /></span></td></tr></table></form><script type="text/javascript">//<![CDATA[
$(resize_images({ 'selector' : '.postbody', 'max_width' : 300, 'max_height' : 100 }));//]]></script></td><td valign="top" width="183"><div id="right"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td align="left"><div align="center" id="FM_widget_share"></div></td></tr></table><div style="height: 2px"></div><table class="forumline" width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td class="catLeft" height="25"><span class="genmed module-title">Watch 3D Products</span></td></tr><tr><td class="row1 genmed" align="left">
<a href="http://gamesonlinevui.com" target="_blank"><img src="https://i.servimg.com/u/f49/17/09/30/39/dichvu10.jpg" alt="banner" border="0" /></a>
</td></tr></table><div style="height: 2px"></div><table class="forumline" width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td class="catLeft" height="25"><span class="genmed module-title">Liên Kết Web</span></td></tr><tr><td class="row1 genmed" align="left"><a href="http://gameauditionmobile.net" title="game audition mobile">Audition Mobile</a> - <a href="http://dolottriumph.net" title="quan ao lot triumph">Do Lot Triumph</a>-<a href="http://gameditinhmobile.com" title="di tinh online">Di Tinh Online</a>-<a href="http://gamedaituong.com" title="game dai tuong mobile">Dai Tuong Online</a>-<a href="http://gunboundmobile.com" title="gunbound mobile">Gunbound mobile</a><a href="http://gopet122.com" title="gopet 122" rel="nofollow">tai gopet 122</a>-<a href="http://choica.net" title="choi ca" rel="nofollow">Game Choi Ca 3D</a>-<a href="http://taiavatarx.com/avatar-230" title="tai avatar 230">tai avatar 230</a><a href="http://ngudex.blogspot.com" title="tai ngu de">tai ngu de mien phi</a>-<a href="http://gamephongvantruyenky.blogspot.com" title="phong van truyen ky">phong van truyen ky mien phi</a>-<a href="http://diendangamemobile.com" title="dien dan game mobile">dien dan game mobile</a><a href="https://www.facebook.com/TayDuKyMobile" title="tay du ky mobile">Tay Du Ky Mobile</a>-<a href="http://tinhbinh.net" title="tinh binh">tinh binh</a>-<a href="http://iwiniphone.blogspot.com" title="iwin" rel="nofollow">iwin</a>-<a href="http://taiiwins.info/tai-iwin-260">iwin 260</a>-<a href="http://vuongquocgamemobile.com/tra-chanh-quan" title="tra chanh quan" rel="nofollow">tra chanh quan</a>-<a href="http://apps.vuongquocgamemobile.com/" title="game android mien phi">tai game android</a>-<a href="http://gameworldfun.gamesonlinevui.com/tai-iwin-257/" title="iwin">iwin</a><a href="http://taiiwins.info/iwin-may-tinh-pc/" rel="nofollow">Choi Iwin Tren May Tinh</a>-<a href="http://www.arcadetrick.com/" rel="nofollow">choi game online</a>-<a href="http://vietnambuyo.com" rel="nofollow">game mobile mien phi</a>-<a href="http://hotvideosgames.com" title="video game">home video game</a> - <a href="http://gamesonlinevui.com">game online vui</a> - <a href="http://ngocrongonline.biz" title="ngoc rong online">Game Ngoc Rong Online Mien Phi</a> - <a href="http://taiiwin290.com" title="tai iwin 290">iwin 290 mien phi</a> - <a href="http://devuongmobile.net" title="de vuong online">De Vuong Online</a></td></tr></table><div style="height: 2px"></div></div></td></tr></tbody></table></div></div><!--
close div id="page-body" --><div id="page-footer"><div align="center"><div class="gen"><strong><a href="https://www.forumotion.com/create-forum/phpbb3" target="_blank">Create a forum on Forumotion</a></strong> | <span class="gensmall">©</span><a href="https://www.forumotion.com/phpbb" target="_blank">phpBB</a> | <a name="bottom" href="https://help.forumotion.com/" target="_blank">Free forum support</a> | <a href="/abuse?page=%2Ft423-favourite-keyword-research-tools-from-mozcon&report=1" rel="nofollow">Report an abuse</a> | <strong><a href="https://www.forumotion.com" target="_blank">Forumotion.com</a></strong></div></div><div align="center"><div class="gen"><a name="bottom" class="copyright" href="http://raovat3d.org" rel="follow" target="_blank" title="rao vat">rao vat</a> | <a name="bottom" class="copyright" href="http://www.vieclamthuctap.com" rel="follow" target="_top" title="thuc tap sinh vien">thuc tap</a></div></div></div></td></tr></table><script type="text/javascript">$(document).ready( function() {$('div.ti-connect').attr({'data-loc' : 'https://connect.topicit.net/','data-login' : 'https://diendanseopanda.forumvi.com/topicit/index.php/connect','data-version' : '1','data-lang' : 'en'});(function(d, s, id) {var js, fjs = d.getElementsByTagName(s)[0];if (d.getElementById(id)) return;js = d.createElement(s); js.id = id;js.src = "https://connect.topicit.net/scripts/connect.js";fjs.parentNode.insertBefore(js, fjs);}(document, 'script', 'topicit-connect'));});</script><script type="text/javascript">//<![CDATA[
fa_endpage();//]]></script><script type="text/javascript">
var vglnk = { key: '0d80ae9fe71cec9484f682bd59232f9e' };
(function(d, t) {
var s = d.createElement(t); s.type = 'text/javascript'; s.async = true;
s.src = '//cdn.viglink.com/api/vglnk.js';
var r = d.getElementsByTagName(t)[0]; r.parentNode.insertBefore(s, r);
}(document, 'script'));
</script> <script type="text/javascript">window._taboola = window._taboola || []; _taboola.push({flush: true});</script></body></html>
Wed Feb 04, 2015 10:56 pm by tranvanchienhn