Need help replicating Richard Baxter's Keyword research
-
A few years ago(maybe it was last year?), Richard Baxter gave a live demo of some fancy keyword research techniques at MozCon. I've been using those methods for a while,but can't figure out how to pull all the keywords from a list that match keywords in a table. I know it's either a VLookup or an Array formula. Does anyone here remember that presentation? Able to help out?
Thanks in advance,
Chris
-
He has an awesome post here on Moz about matching keywords using an array formula - the info is here - http://moz.com/blog/keyword-research-using-categories
formula template is =IF(SUM(NOT(ISERROR(FIND('Keyword Types'!$A$2:$A$7,$A2)))*1)>0,P$1,"Non-"&LOWER(P$1))
then hold shift, CTRL, and enter - refer to the post for what to do - I love this method and find it very helpful for lots of stuff.
Good luck,
Mark
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Need to fill out supplier form to pay for Moz Con
First of all, I wish there was an email I could contact for this. I am planning on attending Moz Con next month with my company. However the policy internally is that in order for my company to cover the conference, I need to get someone from Moz to fill out our new supplier form. Is there anyone that can help out with this? Any insight or answers would be much appreciated.
Industry Events | | Fabianne1 -
Need some rescue tips
Hi guys I set up a website about 8 months back with the intention to bring in visitors who were after DIY advice & product reviews. To start it was bringing in decent levels of traffic. However since the Google Algorthym updates around October-time the levels of traffic have noticeably nose dived. if you're on your lunch break and have 5 mins to hand I'd really appreciate any advise you guys have on how to rescue this trend. Here's the website in question: www.diyu.co.uk Any constructive feedback welcome 🙂 Thanks in advance
Industry Events | | DHS_SH0 -
Google keywords in Webmaster Tools
While analyzing the Google Webmaster, we found several keywords that are ranked in the top 10 search results with words such as: they, was, mai, and chiang. .. After reviewing the pages shown under the keyword "they", we did not find that keyword or its variant "them" repeated in the content of the page even once. I am not sure why "they" is ranking so high and of course, the word "they' is not effective for finding significant content. Also the words Chiang Mai are never used separately but yet the two words are ranking far apart from each other? Mai is ranked at 5 and chiang is ranked at 11? Impossible it would seem? I would think that the rankings would be very close together since the two words are usually used in conjunction with one another. Can anyone please help explain what may be happening please?
Industry Events | | jimmyzig0 -
Need MOZCON link
MOZ Peepz ~ Michelle here - MozPro customer. I was at MOZCON in Seattle. I am looking for the link to all of the power point presentations from the conference. I cannot find it anywhere - - can you please send me the link. I have several connections to follow up on & things I need to look up. Thanks so much for your help!
Industry Events | | LeapOfBelief0 -
Keyword Penalised
We have never had a warning from WMT but our main keyword has dropped quite a lot over the two years, we made the mistake of using this in our anchor text, we have signed up to removeem.com, rather than ask other websites to remove the links would it be wiser just to ask if they will change the anchor text maybe to our domain name, a lot of the links appear in directories and some are on non revelant sites?
Industry Events | | Palmbourne0 -
RSS feed to Google App Field Trip'- how to maximise SEO?
Hi guys, quick question- I have a bar review website and google field trip app asked us to be partners. I guess this can only be positive but how can I make sure i optimise SEO from this partnership? I have to submit info via rss feed. Any suggestions on this?thanks
Industry Events | | HolyPenguin0 -
Web page is showing up on Google but doesn't show when it was cached, so is it indexed?
I was working on the structure and content on the new site and I set the robots.txt to disallow. When i finished i set the robots.txt file to allow again but its been a week but someone the changes are not been index in google and when i check the cached it say 404 error in google, i think the robots.txt file it ok but not sure why my old pages got indexed and why its taking a long time for the new pages to get index. On webmaster in my sitemap it show 26 submited and 1 index, and on block url it shows that it has downloaded the robots.txt file 12 hours ago. i cant figure out if there is some issues with the site , Can anyone have a look at it please. http://www.willowstairlifts.co.uk/robots.txt
Industry Events | | conversiontactics0 -
I'm trying to track down Jessica Bowman's Keyword Research ROI Excel template from this year's MozCon. Does it exist?
This presentation was awesome - and I've just encountered a pitch that would be ideal for this type of analysis. In looking through my notes from MozCon I don't see a download link - nor can I find one in the presentation. It was the 11:30 - 12:00pm timeslot on day 3 of MozCon: http://www.seomoz.org/mozcon-live/agenda Can someone point me in the right direction? Cheers, J
Industry Events | | JonClark151