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 -
Targeting City Geo-tags/Keywords for Clients with Multiple Locations
Hey everyone! What methods are best to use for SEO campaigns working with 1 website for a company which has 2, 3, 4, or more locations in order to get keywords for their services to rank well... in all their location cities? I feel we know the answer could be any one of the below notes, however, it's always nice to learn more about what all you other SEO's are doing or have done which saw success. Please note: We have heard about building microsites on sub-domains example city.domainname.com/keyword-or-service
Link Building | | WhiteboardCreations
We have heard about building sections off the root domain such as domainname.com/city/keyword-or-service
We have heard about just pushing more content to the blog which can target a wider range of keywords and cities
We have heard about building a new site for each city location replicating the main website and swapping out content for 100% originality
We have heard about just building more and more backlinks with different anchor text using the cities in the anchor text Thanks in advance and look forward to hearing from some other experts facing these same challenges!1 -
Website/blog list to get quality backlinks?
Hi Everyone says quality backlinks increase ranking of your website. Can you please suggest a list of good websites and blogs from where I can get quality backlinks and how to do that. I have one person at my disposal full time to do manual commenting or any manual tasks for getting backlinks but how should i approach this problem (of getting backlinks). Where do I start. For information, my website provides online services (its an ecommerce site) and also has a blog in subdirectory. refer to www.geekwik.com www.geekwik.com/blog Would like to become top ranker on search for these services (eg 'logo design services', 'website programming', 'content writing', 'hire virtual assistant' etc) Also anyone interested to become our SEO consultant or SEO service provider (of course paid) is most welcome 🙂 Thanks in Advance!
Link Building | | geekwik0 -
Linkbuilding to http/https
Hello, Last year we changed our domain name from http to https. In the .htaccess we included a 301 redirect from http to https. Nevertheless, some pages do not let you link to https, so for linkbuilding we sometimes need to use http://www.domain.ext in stead of https://www.domain.ext. Would this be a problem? I should expect with the 301 redirect that we don't have an issue here, but I would like to be sure. Although, I can make the site accessible without https too, but I don't think this is a good idea regarding duplicate content, is it? Thanks. Tom
Link Building | | Onlinq0 -
Can high SERPS and/or social signals minimize Google penalties and a back linking removal question
As I am continually sizing up my competition in the SERPS I have scanned their sites with a fine tooth and comb. I have found that these sites practice in the very things that I have practiced in the past and have removed thinking that may be some of the reasons I was hit with Penguin. Some of these factors are: Link Scheme with sites they own (C Blocks) Content for Search Engines (Keyword rich text) Exact anchor text in back linking profile Yet even though my competition practices in these methods (One site even places exact anchor text in the footer and header of every page for one of their other forum site) they seem to have not even been touched with any of the recent updates. In fact it seems their ranking have increased. In scanning these sites the only major difference that I have been able to see between them and I is that their SERPS are higher than mine and they have way more social signals than me. One site has about 73k facebook likes where I only have about 300. My question is Can Google ignore penalties for sites that have higher SERPS and /or social signals that would effect another site that had lower ones? My other question is related to back links My main site has links from another site I built a long time ago (Pre SEO and not knowing what I was doing) somewhere in the 73k range. Obviously a HUGE signal to Google that this might be spam and I am aware. I have removed the links from that site but unfortunately the average crawl rate per day is very low so it is taking a very long time for Google to find those pages and re-crawl them to find the links gone. Since that site I have than has those links pointing to my main site has very low traffic I am totally willing to kill that entire site with a 404. Can this help speed up the removal of those links from that site? I figure since the site no longer exists all links from that site will be removed almost immediately from my main site. Any thoughts?
Link Building | | cbielich0 -
Has anyone noticed no change is MOzRank since February?
When using Open Site Explorer, two of my clients have experienced no change in MozRank since February, but nothing has changed/stopped in their link building/optimisation programme. Has anyone else experienced a similar 'pause' - can anyone explain?
Link Building | | caroline19770 -
Submitting my URL on web/business/service directories
Does it make sense to submit a business URL in as many relevant web/business directories as possible when kicking off a link building campaign? Submitting a free listing is obviously better than nothing, but when does it make sense to pay extra for a premium listing profile on some of these directories? There are just so many and a lot of them appear spammy, even though some of my competitors are getting traffic from them. Any advice on this would be great!
Link Building | | TheSquareFoot1 -
Link-building / panda update!
Hi Mozers. WHat do you think, after panda-update, which is the best strategy to build links on Content, or blogspots, and it to website with a minimum PA40 and DA30 . . in which place is better to place, at the begining of article, or at the end of article, tell us some tips, if you are experiences on this section! Thanks,
Link Building | | leadsprofi0