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 -
Is It Possible To Use Multiple Promotional Codes for Google AdWords?
I am managing two separate Google AdWords accounts and with one I was able to add 3 different promotional codes so I got $300 of Google AdWords for free. I signed up for Google AdWords for another business with a separate login e-mail address. I used the code that I was able to generate and a few days later I recieved an additional code in the mail. I tried to use this code and it said I was only able to use one promotional code per account. Does anyone know why Google has this inconsistency? Was I just lucky the first time or is it possible to use multiple vouchers? Thanks
Industry Events | | DR700950 -
[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