How to check Mozrank and/or Moztrrust in Bulk
-
Hi guys,
I've been scouting the web and the SEOmoz forum to look for a way to check the Mozrank and/or Moztrust of urls in Google docs or Excel. I know Chris Le wrote a post about this but I want to check ~ 2000 links. Is there a way to do this easily in a spreadsheet?
Regards.
-
Thanks guys, very helpful advice.
-
Thanks for your answers It worked!
-
Hi,
Yeah I seem to not be able to get past 100 now for some reason. I remember I had some luck with this excel add-on in the past. I think it limits to 1 request every 10 seconds so if you have a big list better to leave it run over night, but it does the job and gets the data into excel so worth a shot!
http://www.businesshut.com/seo/seomoz-mozscape-add-in-for-excel/
You could also check out the seogadget excel for the moz api, I have not managed to give it a good go through, but it should also be able to do the job:
http://seogadget.com/mozscape-api-extension-for-excel/
Hope one of them helps!
-
Thanks for your help. It works but somehow I can't check it for more then 50+ links. So I manually copy paste all the urls. Is this because of my pro membership level? I have a normal PRO membership. I hope there is an other way because I want to check it for around 1980 links :-).
Thanks for your patience.
-
Hi,
So if you have a list of urls in the A column and the A1 field has a title 'urls' or similar then you select the B1 field and in the formula box (fx) up top you can put something like
=getLinkscape(A2:A92)
Which will pull the data for the urls listed from the fields A2 - A92.
I have found that you have to have a multiple of 10 so you don't get a timeout error, I think the script bunches the urls into groups of 10 and it seems to have an issue if there is an odd number. So if you have 99 urls, add another one to make a round multiple of 10!
You can see some more tips here: http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs
Hope that helps! Its a really useful tool.
-
Hi Lynn,
I know how to add the Api credentials but how do I make a code that shows me the mozrank, DA, PA and moztrust in bulk?
-
In Google Docs you can do this using the (awesome) Seer Interactive Toolbox, check it out here:
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
-
Should we get link from dated page with high PA/DA?
We have an unlinked mention on a page that has dated content about an old event but the page and site have a good PA and DA score. Is it worth it to go for the link? Thanks.
Link Building | | rdoty0 -
Totally puzzled by link building/content marketing
Hey Mozzers! 🙂 I'm going to be starting link building for a website soon and I am having some trouble wrapping my head around a couple of things. First of all, in the current world of SEO, where should I be looking to generate links? Is it as simple as reaching out to bloggers and trawling through competitors links? Or is there something more? In relation to this, if I were to generate a good number of links from high authority sites, how would this effect my ranking for keywords (assuming the anchor text for those links is the website URL)? The other thing I'm a little puzzled by is, if I were to write a great article on the websites blog and it gains traction in social media circles, people would (I assume) only share a link to the blog post instead of the actual article itself. How would this effect the ranking of keywords that I have optomised (anchor text etc.) for in the article? I assume this is where guest blogging would come in? Any help would be HUGELY appreciated. I've been trying to logic this one out the last couple of days and just can't do it 😕 Thanks a lot to anyone who replies 🙂
Link Building | | CD_20161 -
Can you get "link juice" from an outside company's/organization's intranet?
Will you get the same "link juice benefits" from a University, Government Org, or public company's intranet that are linked to your webpages – vs the benefits that you would get from links from their public webpages? Assume that the external webpages have very high Domain Authority, MozRank/Trust etc.
Link Building | | MLR0 -
Networking sites / paid links
A national networking company charges its members, say, a few of hundred pounds to become part of their network, which involves offline networking events and online in forums and a directory. All the links of the directory and forum sigs etc are all do-follow. While it's not just a directory, how beneficial a link is this likely to be? The site itself has a DA of 60 and a PR rank of 4. 1k likes on their cnnected FB page and 21 likes on the G+. At the networking meetings they tell new recruits that being a member gives them a very valuable backlink and everytime they participate in the forums they get another do follow backlink. Ive checked and they are dofollow. Is this likely to be a great value link?
Link Building | | littlesthobo0 -
1and1 - Ever had any problems? Link Analysis / SEO
Hi there guys, I have a website (www.advanced-incarcamerasystems.com) that I built quickly using the 1and1 service in the UK. I have been an SEOmozzer since about the beginning of June/July time and still not seeing any link info. It also seems to be struggling in terms of SEO. 1and1 have their own built in tools such as modifying certain SEO parts of a website but it really doesn't seem to do much. Our main site (www.advanced-incar.co.uk) has gone from strength to strength since using SEOmoz so im at a bit of a loss. Any help / advice anybody can throw my way would be great! Tim
Link Building | | timborrill0 -
Do http:// links to a http://www. site count the same to Google?
In terms of links to one's site helping your position on Google, if your site defaults to http://www.example.com (automatically adds "www." even if it isn't typed), does Google count links that appear as http://example.com (without the www.) with the same "weight"? Thanks.
Link Building | | celife0 -
Where to start on building links for a news website? Should I focus on promoting individual articles or create linkbait and create friends with influencial bloggers/editors/ and news websites in the same niche?
Where to start on building links for a news website? Should I focus on promoting individual articles or create linkbait and create friends with influential blogger/editors/ and news websites in the same niche?
Link Building | | purch0 -
Link building tools/sites
I am looking for a way to share my content in multiple locations to build back links without having to upload one at a time per location. For example- if i write an article and i upload it to ezine articles and then post it over on my blog- it will then post over on my twitter and facebook and linked in. However- how i can also get this article with back links into shared sites, bookmark sites, and other locations online to help build my inbound marketing for back links. I'm trying to find a way to save time while building out the links.
Link Building | | LauraThomas0