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
-
In-depth/longform content DEFEAT backlink, DA/Trust score!
Hi all, There is a new way to defeat the big boys. Build a releated topic with minimum 4000 words and focus on in-depth content and use the target keywords more than 2,5% of each content. So its game over for linkbuilders and happy end for the copywriters? Ofcourse every factor of seo is important, but its better to focus on in-depth content. To score good with your target keywords in SERP. What are the challenges for a big webshop? Create a related deeply content? that separated from your webshop?
Link Building | | Dreamgame2016
Because it will be coatic with a lot of deeply contents on your webshop Is there more additional advice for a webshop with a big assortiment? Ps. Specifiec, the big webshops sells game/software keys.0 -
Puzzled by high ranking page (#2 in SERPs) with zero/low page or domain authority
So, I get the smoothie that is page authority and domain authority and the link metrics that Moz uses to predict how well a page will rank for a certain keyword. I can look at a specific search term where we are on say, page 2 or 3, with a page authority of 1 and domain authority of 26, I get why competitors rank above us. But then I look at a keyword that is much more competitive, where we rank #2, which is awesome, where the landing page is also showing a page authority of 1, and domain authority of 26. How can we rank higher than competitors with a page authority of 56 and domain authority of 65? Their onpage optimization for the keyword is no worse, and sometimes better that ours but we maintain this ranking. By the way the competition also have hundreds if not thousands more linking root domains than our page. Any ideas why one keyword is a rockstar and one is a dud, with the same poor PA and DA?
Link Building | | seo-lab1 -
GWT Best For Link Checking?
Even though GWT's Links to your site is about a month behind I am finding that it reports new links faster than either OSE or Majestic. Has anybody found anything more current than GWT?
Link Building | | waynekolenchuk0 -
Blog traffic / link ratio? (Esimated of how much traffic will result in a link)
Hi, Was wondering if people could please tell me some estimates of how much traffic is likely to gain links to a blog post? For example 1,000 hits = 1 link, Hence 10,000 hits = 10 links to a blog post? I understand there is no magic ratio I just want to know what people have achieved. I’m after averages not just a one off really successful blog post too. Please specify the topic you achieve this in e.g. SEO, photography, business, heath... etc.
Link Building | | charles10 -
Are there content swap tools/forums for linkbuilding?
Anyone know any besides myblogguest? I have a pipeline of content at the moment and not enough distribution. I also have web properties that can take posts etc Cheers S
Link Building | | firstconversion0 -
List of free directories for building / real estate website.
Hi Any suggestion where to source a list of free directories for a property / real estate company which gives reasonable linkback juice Thanks Peter
Link Building | | peterds0 -
Charity / Donation - Website and SEO
I have a prospective client looking to do SEO- they are a charity and have a fixed one time budget. (The budget is surprisingly high) They are looking to have their site ranked for "charities in (our city)" and "dental charities" and any keyword variations. Adwords shows significant search volume and ranking difficulty is moderate per SEOmoz keyword difficulty tool. On page will be fairly simple and well handled, but am looking more towards the authority and link building. I am going to tackle 3 top quality directories, Yahoo, BOTW, and Business.com (as well as DMOZ but i've never had luck). But was wondering if there were any other nationally recognized sources that mozzers know about that would be a good place to start to get some links to the site. The organization is a clinic that provides free dental work to veterans. I have never handled SEO for a charity before, and my first instinct is that getting a link to the site will be much easier to get than if I ask them to give money to the foundation, so they would be glad to do it. Any other guidance would be appreciated. And I can give more details if necessary. Any other tips and insight would be appreciated. Thank you! Ian
Link Building | | itrogers0 -
Links from Nextag/PriceGrabber
I have a eCommerce store over BigCommerce platform. It is possible to sell via Shopping Comparison Sites like: Nextag, PriceGrabber, Bizrate, Shopping.com, If I decide to advertise my products over those sites, will it be consider a trust link for Google? Our store is new and we don't have links referring to us, I need solutions. Also, there is a yellow pages site, http://www.yellowpages.ca/ that ask for monthly fees to advertise on there web site, advertising will be business name, addressee, phone number and web site, will it be a positive link for Google or just a paid link? This is our store: Furnace Filters Canada Thank you for your help and support, BigBlaze
Link Building | | BigBlaze2050