Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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
-
Attending MozCon 2015 and Interested in Connecting with Marketing Professionals
Specifically interested in meeting other real estate marketing professionals. Would love to start a forum for the guest list here. Let's connect!
Industry Events | | jonathanboatwright
Brittanie Flegle
@brittanieflegle also posting as @realtyaustin
brittanie@realtyaustin.com2 -
How to increase pageviews for a news website when all the most common SEO strategies were already used, and they´ve reached a plateau of visits?
These clients are regional news’ websites which have already reached their apex of visits - most of these results were linked to the SEO strategies developed by our team in the past few years. But now, the most common SEO strategies don't show the same effect: a higher number of pageviews. What kind of strategies you suggest to increase this number? Thank you!
Industry Events | | Kenaum1 -
Going to Mozcon - what to do in Seattle
Hi I know this isn't technically an SEO question, but wanted people's advice. As I am flying half way round the world I am actually arriving on the Friday and have Friday evening, Saturday and Sunday to go and explore Seattle. I plan on going to watch a baseball game and visit the home of Starbucks (and I hate coffee, but thought might as well visit), but what else would people recommend doing / seeing in Seattle. Thanks in Advance Andy
Industry Events | | Andy-Halliday2 -
[UPDATED] Any Q&A Regulars Attending MozCon Next Week?
[Update] Between here and the MozCon Facebook Group we've got a number of folks interested, so we're going to grab a table together for lunch on Tuesday at the conference. I'll try to mark it with something noticeable, or you can tweet me @thompsonpaul and I'll let you know where to find us. Hope to see lots of us there! [/Update] Hey gang - I'm wondering which Q&A regular (or irregular!) contributors are coming to MozCon next week? I know Dana Tan and Marie Haynes are for sure. So who else is coming? If there's a bit of a gang of us, it would be fun to connect up for a lunch table or a drink at some point during the event to meet each other face-to-face. Let me know in the comments, and if there are enough of us, I'll set something up. Paul
Industry Events | | ThompsonPaul1 -
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 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 -
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 -
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