A Great SEO Competitor Research Using Excel

Google +1 and SEO - eWebResults | Internet Marketing Houston SEO Company | eWebResults Houston internet marketing
Click Play to Listen to Podcast Now[podcast]http://ewebstyle.podomatic.com/enclosure/2010-08-30T17_02_20-07_00.mp3[/podcast] A Great SEO Competitor Research Using Excel
Get a FREE Website/SEO AnalysisClick Here

Click to Subcribe atSubcribe at iTunes now

Sixty-eighth Internet Marketing Podcast July 9th 2010. Third page of Transcription

A Great SEO Competitor Research Using Excel

Chris: Minneapolis, Minnesota and Funwatercraft looks like a blast. They’ve got — I think they’re like the bicycles. You can actually ride bicycles on the water.

Paul: On the water.

Chris: And then they’ve got some other things with big tubes that are rolling in the water. Looks like —

Paul: That’s pretty sweet.

Chris: Yeah. So hey, we get to actually give some link love. That is Funwatercraft.com. Go check them out. It’s pretty cool.

Paul: Was that Hardcore that —

Chris: Yeah, it was iHardcore, yeah.

Paul: That’s what’s up, iHardcore. Thanks for that, man.

Chris: Very cool.

Paul: We appreciate that.

Chris: We do. What do you got? You got —

Paul: Okay. I found a tool or I found — here it is. I found an article that I thought was really cool and it had a tool on it and I want to give this guy a lot of credit because I thought it was awesome. Now, I’m going to butcher this name.

Chris: Yoav.

Paul: Yoav, Y-O-A-V, as Ezer?

Chris: Ezer.

Paul: Ezer? The last name was E-Z-E-R. So I’m going to call him Yo. So what’s up, Yo?

Chris: Didn’t we have another Yo?

Paul: I don’t know if we have another Yo?

Chris: No, we had a Jo — Jojo.

Paul: I don’t know. [Laughter] I’m sorry about butchering everybody’s name so we don’t forget.

Chris: We just lost half our users. [Laughter]

Paul: I know.

Chris: Listeners.

Paul: Yo came up — I found him on Search Engine People and I didn’t write down the URL because it was super long, but the title of his blog is “How to perform SEO competitor research with Excel.” If you Google that, “How to perform SEO competitor research with Excel,” the very first thing that comes up is his article, and I found it. Yo, it was an awesome article. I’m actually going to respond on your blog and let you know that we talked about this on the podcast. And he basically talks about SEO is part of your job. You know, if you’re doing SEO, it’s important for you to do the SEO for your website with your clients but it’s also important for you to look at their competitors to know who’s there, you know, who’s new that just came into the market or to the online market and who —

Chris: Or who just bumped you down —

Paul: There you go.

Chris: — or who did you just pass.

Paul: There you go. And you can get — and we do this, we can get tips from other — from competitors. Maybe he’s doing this. We need to focus on this. This is a good idea. Oh, that’s a bad idea. And so it’s good to know what other people are doing and he came up with this really simple tool that will tell you what’s happening. So if you go to the article and you scroll through it, he says how to use it. You download an Excel spreadsheet and this Excel spreadsheet will actually reference Google search results and display them for you on an Excel spreadsheet. So he tells you how to use it. You enter in — somebody’s sending in a fax.

Chris: Maybe that’s Yoav —

Paul: Maybe it’s Yo. [Laughter]

Chris: — telling us how to say his name. [Laughter]

Paul: You enter in your website, your competitor’s website, and a couple of keywords and then it will search the keywords and it will populate a list of your competitors and it will tell you where you are in comparison to them. I thought this was an awesome tool. I wish I would have printed something else so I could show it to you but look at it and download it. I thought it was awesome. Yo, I give you a lot of credit for this. And this is important. This is very, very — I mean I can’t explain how important it is to know what else is happening in your industry.

You need to keep abreast of who’s ahead of you, who’s below you, and to me I think this is very important, who’s new, who just came into the market because that’s you. If you’re doing some SEO, you know, if you’re just starting on a website, you’re going to be one of the new guys coming into the market and people are going to be watching you so it’s important to find out what other people are doing on the SEO. Yo, this was an awesome tool. Now, everybody, I’ve only played with this sucker for this morning so I’ll be honest. So I haven’t actually fully tested it. I probably give another review of it maybe next week but I thought like it was an awesome tool —

Chris: And it’s fast just lightning fast.

Paul: It is lightning fast.

Chris: Being lightning fast does draw some concerns. Some of the software — most of the software that we use here will do searches and have delays because Google, if it sees rapid fire searches of its search engine will sometimes ban IP addresses. That is the concern. I’ve never actually heard of it happening. In fact, if anybody is out there who’s had that happen to them, let us know. Google is really looking — does keep an eye on things that look like automated which that would clearly look automated. Although for each keyword, it’s only one search, right?

Paul: Yeah.

Chris: Yeah, and then he just orders the ones that are ahead of you and the ones that are behind you. So don’t worry about that unless you’ve got thousands of keywords that you want this analysis for then you’re going to have some — you can potentially have the software rapid firing to Google so we can maybe fire — maybe when you send us a comment to Yo, ask him if he’s addressed that or if that’ any concern.

Paul: I will. I will. Yo, so I’m going to ask you — Yo, if you’re listening or weeks later after I tell you that, I’m going to record this and put them on podcast. If you’re listening let me know. I’m going to respond to you anyway. But it was an awesome article and — now, I can’t show you the search results but here’s kind of how it works. What it does is you put your website in, like I said before, your competitor’s website, you enter in a couple of keywords.

Now, what it will do is it will give you a list, not only of the competitor that you, put in but it will give you a list of competitors and it will say for these four or five — let’s say you’re entering four words and they return 10 competitors, the one at the top, let’s say it’s AandB.com will have above me. There’s two columns. It will have the competitors above me then below me and above me and below me it have a number. So let’s say AandB was your competitor and in the above column it was number 4. What that means is for the four keywords that you typed in —

Chris: AandB was above you on all of them, yeah.

Paul: All four of them and ABC.com is the next one and let’s say it has two. It means that two of those words it is above you. So it’s a good way to really — and it ranks them in order of importance. This guy has 10 spots above and the guy at the bottom has one spot above you. So that way you can really know — it will tell you hey, A and B has got 10 spots above me and you need to take a really good look at them because for all the keywords that are important to me this guy is knocking it out of the park. A just quick simple tool among the millions that, you know, tons of tools that we talk about. I thought this one was definitely worth mentioning. I’m going to play around with it a little bit and I hope I will give you more next week.

Chris: We have a listener in Saint Croix. I mentioned that, right?

Paul: That’s what’s up, Saint Croix.

Chris: Okay. Cool. Saint Croix.

Paul: I think that’s awesome though.

Chris: Send us a picture.

Paul: I really like —

Chris: That’s a great idea.

Paul: Don’t send me a picture of you, not your feet and — like you — a laptop on your lap with your feet hanging out and like a Corona, like the Corona commercials, don’t send that kind of picture ’cause I know it’s really nice down there and I don’t want to see you doing SEO on the beach. That’s not cool.

Chris: Yeah.

Paul: Real quick.

Chris: What a great concept that is.

Paul: Yeah. Tell me about it.

Chris: [Laughter]

Paul: Why are we even here? We got to move this operation in Saint Croix.

Chris: Yeah. [Laughter]

Paul: Do we have time?

Chris: Is there any good — yeah, we got about five more. Hey, the listener in Saint Croix, if there’s any good properties you know of that will have high speed internet access call us.

Paul: Call us ’cause that would be awesome. Yo had another tool that I thought was really cool. I found one and I was messing around with his blog and then I found some more tools that he had. It’s title, “How to automatically track your Google positions in Microsoft Excel.” If you Google that, “How to automatically track your Google positions in Microsoft Excel,” it will be the first thing that comes up. Yoav Ezer, Yo is what I’m going to call him. It’s a spreadsheet. You download it. It’s the exact same concept. You enter in your website. There are some preloaded dates in there, clear the dates and it will tell you, you enter in a couple search terms and then it will tell you what position you have on this particular date. It only runs one date so I ran it today and it — I did one keyword one day —

Chris: How did you use it? Control something to run it or –

Paul: Yeah, control —

Chris: Control+Shift+U.

Paul: Control+Shift+U and it will automatically pull the search results off the search engine. Another tool — and he goes and explains how it works, the macro code which I have absolutely have no interest. I mean Chris probably would want to read that.

Chris: I do.

Paul: I have no interest in that. I don’t even understand it.

Chris: Chris would probably want to read that crap. [Laughter]

Paul: I mean, I don’t know. It’s like — I mean this is like 1’s and 0’s. It’s like, you know, I don’t understand that like — I think it’s very cool. I’d give up my hat to this guy.

Chris: It’s a cool tool.

Paul: Anyone that’s understands how this works ’cause I don’t. I’m just like awesome, it works. But it’s cool and I’m sure you’ll be able to make it work better or something but this is two awesome tools that I thought and it will — for this last tool, you enter in this a couple of different search terms and it will run those terms and find out where you are on that site. Now, we use other software to do this exact same thing. What do we use for that?

Chris: You mean Advanced Web Ranking.

Paul: Advanced Web ranking to do it. This is just another quick fast easy way if I want to know something quick. I don’t think we’re going to go away from Advanced Web Ranking but I just thought this was cool.

Chris: We use it augment and — yeah, Web Ranking has cost, this doesn’t. So if you do an SEO on a string, this may be something that you should use.

Paul: This was free. I personally, I like — I thought this was cool. Oh, I have a question for this guy. Excuse me. I just answered by looking at it. Oh, wait, the title was “Track your Google positions.” So this only does Google, okay. Advance Web Ranking does Yahoo! and Bing.

Chris: Also known as Binghoo!

Paul: Binghong! Yeah.

Chris: We’re still going to use that. [Laughter]

Paul: Nobody’s listening to this like, “You guys are dorks.” [Laughter]

Chris: And we agree. We are a bunch of dorks.

Paul: We are a bunch of SEO dorks.

Chris: And we are the hosts of the most popular SEO podcast on iTunes. Do you have any more?

Paul: Oh, that’s it, man.

Chris: Excellent.

Paul: Check those out. If you have any questions, send us an e-mail at —

Chris: Podcast@e-webstyle.com.

Paul: ‘Cause I didn’t even know.

Chris: [Laughter] You just —

Paul: I don’t know, support@e-webstyle like —

Chris: — the e-mail works. Yeah.

Paul: Okay, ’cause I don’t even know.

Chris: PaulNeedsHelp@e-webstyle.

Paul: Yeah.

Chris: Thank you guys for listening. Thank you for watching. We really appreciate it. 9:15 Central Standard Time. Next Thursday, not next Friday, so if you’re tuning in — plan on tuning in on Thursday, I do tweet about it right before we broadcast so if follow us on Twitter, twitter.com/ewebstyle, there’s no dash in that ewebstyle. Until the next podcast. This is the end of podcast number 68. We really appreciate you listening. My name is Chris Burres.

Paul: And I’m Paul Hanson.

Chris: Bye-bye for now.

Author: eweb-admin



Print