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:
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
-
I have domains that have a / on the end and no / what is correct
Hi have a number of links going to 2 different pages https://www.caffeienmarketing.co.uk/bristol and https://www.caffeienmarketing.co.uk/bristol/ (with a / on the end). they both have different PA and links are being reported separately to both (this issue goes right through my website. What should teh default be, how do I fix it and how do I get the benefit of both sets of links for one of the pages? thanks
Link Building | | Caffeine_Marketing0 -
Is there any SEO value of an HTML Sitemap, or is it strictly UI/UX?
We have an xml sitemap that generates daily, and our site and navigation is strong. Is there any added SEO value in either the links, or content of an html sitemap? I only see answers from several years ago so not sure if things have changed that would increase or decrease the importance. Thanks
Link Building | | Education4Life0 -
Link Building/ Off page strategy. Do we have already have a 'hook' or should we create more specific content.
Hi Guys. As part of our link building campaign I've been creating a database of people who might link to our site. We're a diary company. So I’ve been focusing on people interested in stationary, paper, pens, etc who also blog. We have a unique product at TOAD diaries, it's essentially an online tool that allows you to design your own diary. You can choose size, colour, duration, etc and also personalise the cover. So the product (we think) is very compelling and interesting. First of it’s kind. Check it out here: http://www.toaddiaries.co.uk/designer/diary/a5/everyday-diary-week-across-2-pages/coil-bound/toad-plum/12/1/8/2014 So.... question. Do you think that the site itself would considered 'good content'? i.e) It's already a very interesting idea that's worth linking to. Or Would it be better to create a high quality engaging blog (with info-graphics etc) that really speaks to that community of people? Say, about our love of the humble paper diary, and why it's still useful. Then use that blog content to try get links? You thoughts would be really appreciated. Thanks in advance. Isaac.
Link Building | | isaac6630 -
Honest thoughts needed about link building / removal.
I have a small online business that has suffered through Google updates over the past year. Turns out that the links built by a previous SEO were harmful - yes, it's the usual story, I know. I've been in touch with an SEO about link removal/link building and have had a proposal. It's not cheap and I would need to dig deep, but it'll certainly be worth it if things work out. If it doesn't, it'll probably become impossible to continue the business. Personally speaking, it's a sorry situation. For link removal, the SEO's proposing to contact the webmasters followed by disavowing, if needed. There's 15k links, but I think a high percentage of these are from industry blogs that I sponsor that have site wide links. Have you heard many success stories about outsourced link removal? For link building, they will be targeting industry websites and blogs. The thing is, I know most of the industry bloggers anyway, and can probably reach out to them myself, if I can develop the right high quality content that they will want to feature. Call me a cynic, but I'm not sure how the SEO can do this. The quality of content on these blogs is extremely high as it's a very creative/visual industry that I'm involved in. I'm just not sure how much scope there is for a third party (with no knowledge of the industry) to do this effectively. That said, there's blogs that aren't directly related to my niche, and I suppose there's possible opportunity there. Maybe??! If the link removal is a good idea, am I better off trying to build links myself and combine that with the link removal service?
Link Building | | Coraltoes770 -
Best Back Links (paid/unpaid) Real Estate
Where can I get the best backlinks for Real Estate? I don't care if it is paid/unpaid. As long as it's not the kind of paid link Google would go after. Paid directories are A OK. Please help 🙂 Keywords: property management, vacation rentals, real estate, real estate agent, realtors
Link Building | | JML11790 -
Is there a tool I can use to check backlink profiles against each other
Hi, Does anyone know of a tool where I can compare 2 (or more) backlink profiles to check common linking domains. It is one of those things that I know I have seen somewhere before but cant remember for the life of me where! Thanks
Link Building | | rickv1010 -
Should I optimize/link build all my pages at once?
I'm currently starting to optimize about 30 area specific pages for a property maintenance company and was wondering, what's the best way to link build multiple pages at once? Should I link build for all of the 30 the pages at once, or maybe focus on 5 individual pages - get them ranking well, then focus on the next 5 and so on?
Link Building | | guy_andrews0 -
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