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
-
Roger, Can You Please Help Get Me in Mozcon?
I am a newbie to amazing tools like Moz! Yup, I joined in December and there is no looking back and no regrets. Well, until now. Here’s my sad story. I have been hearing about Mozcon for months. And I have told a number of colleagues that I am definitely going to that! Especially since I have two reasons to go all the way to the Northwest in July… My 21YO son is a competitive snowboarder and video blogger living at Mt. Hood during the summer. I can visit him and go to Seattle for Mozcon.
Industry Events | | TFinder
When I checked the site for cost and tickets, the early bird incentive had already expired, so I figured I would pick up my ticket in July. I went ahead and booked the hotel and airfare from North Carolina. So, I am all set.
At the beginning of the month, I go to buy the ticket and they are SOLD OUT!
OMG!
I am already coming and there are no tickets for sale.
I had no idea that a workshop at the big Seattle convention center would sell out.
I know you guys are cool and that you have a super connected following, but SOLD OUT?
I had no idea. I wait listed myself, but I have heard nothing.
So… I am at the crossroads here…
ROGER! Can you please find just one more ticket for the newbie in North Carolina??
Please...
Please help if you can. So disappointed in NC~ Terry0 -
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 | | LeapOfBelief
0 -
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 -
Can anybody help me to remove my website link from wikipedia Spam list ???
My website www.giftbig.com went to spamlist on wikipedia. Can anybody help me to remove it from spam list. I can do all you need to remove from there. Please help me out on this.
Industry Events | | joydeepdas0 -
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 -
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