SEOMOZ EXCEL PLUGIN ARRAY FORMATTING
-
Morning All,
I have followed along, and am trying to build my own " dashboard", SEOmoz API in Excel, to get the Domain Authority and MozRank for a bunch of URLs. I have a list of competitor sites / related competitors, and I want to pull in the moz url metrics so I can decide who to investigate further.
I'm using this array SEOMOZ_URKMETRICS_toFit(A2,"Cols=128" and it keeps listing the results vertically.
All the tutorials show this lovely link data in horzontal rows to the right of the url in question, but mine doesn't want to behave.
PS. I do know the bit data is wrong, I'll fix that.
Thanks in advance to anyone who can help.
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
-
Social plugin and do follow
Hi just wondering if there is any good free wordpress plugin for social liking that follows you even when you scroll down to read the article on the side? and one silly question which i cant get answer to, are facebook social plugin for commenting on blogs a do follow? can you add anchor text into facebook comment on blogs?
Competitive Research | | andzon1 -
Majestic gives me a 24 situation and 24 trust flow. Seomoz just a total number of 7\. How come the difference? My ranking is still bad, so is Majestic crawling faster then google?
Hi, my total domain value number on SEOmoz is 7. In Majestic it is 24 situation and 24 trust flow. My ranking is still bad (page2) and my competitors have a lower trust/ situation flow in Majestic. But in Seomoz the're better. Is the conclusion that Majestic is more up to date then Google itself and that Seomoz is more inline with the google crawling? Because Majestic doesnt reflect my ranking. (ps I started with the domain for a month, and I only have some history in registration)
Competitive Research | | remkoallertz0 -
Why do keyword competition rankings differ between Google and SeoMoz?
I am a novice at keyword ranking etc. so I appreciate your patience! I checked a longtail keyword - how do i get out of this relationship - in Google AdWords and it came back 'low competition.' When I entered it in SeoMoz it came back as 'very competitive.' Any thoughts? I appreciate your help.
Competitive Research | | UncleTodd0 -
Trouble Exporting Xenu Crawl to Excel
I'm trying to export a Xenu file to Excel, but Xenu is only giving me the option to save as a Xenu or txt file...which I can't open with Excel. What am I missing? Thanks!
Competitive Research | | BrittanyHighland0 -
How can a site rank higher when you beat them by A LOT on virtually every SEOMOZ factor?
Any insight into what's driving these results would be appreciated. Another site ranks #6 and we rank #22 on a keyword that scores 67% for "Keyword Difficulty", but we score significantly higher than them on almost every ranking factor including having nearly 10 times more backlinks along with higher PA and DA scores,etc. Here is a comparison from the Keyword Difficulty Tool report. Question: What could be going on? Factor and ranking comparison (us v. them) with our higher rankings are listed first. PA: 61 v. 39, mozRank 5,85 v. 4,54, mozTrust 6.00 v. 5.49, mT/mR = 1.0 v. 1.2, total links = 4,198 v. 90, internal links = 4198 v 90, external links = 275 v. 57, followed links = 4171 v 85, no follow links = 27 v 5, linking root domains = 46 v 30 on-page grade = A v B broad keyword usage in title: yes v yes broad keyword usage in document: yes v yes keyword used in url = no v no keyword used in domain = partial v no KW exact match - no v no exact anchor text links = 2373 v 13 %links w/ exact anchor text = 56% v 14% linking root domains w/ exact anchor text = 7 v 8 % linking root domains w/ exact anchor text = 15% v 26% partial anchor text links = 0 v 0 Domain Authority = 54 v 27 Domain mozRank = 5.4 v 3.2 Domain mozTrust = 5.8 v 3.7 DmT/DmR = 1.1 v 1.2 External links to domain 9261 v 63 Linking root domains to this domain = 355 v 33 linking c- blocks domains to domain = 267 v 30 tweets = 4 v 3 FB shares = 13 v 11 Google Plus one shares = 1 v 0
Competitive Research | | rickt0070 -
Is There Video Instruction on How To Use SEOMoz and Open Site Explorer?
Hi I have just signed up to use this software and would like to know how to use it properly. Is there a video tutorial on how to get the most out of the tools? I want to get the competition's backlinks but for some reason it's not openiing the page. I also want to know how the backlinks are assessed to find the real quality ones that I can link to. How are the backlinks assesed and what standards are used to asses backlink quality? Thank you Sunil.
Competitive Research | | sunilmuse0 -
Does SEOMoz (or anyone) offer a measurement of "overlapping" links between 2+ domains?
I'm trying to judge how much incremental value we'd see from 301'ing an old domain vs. revitalizing the old domain's content. My gut feeling is that most of the links to the two sites are from the same set of websites so it wouldn't add much value to 301 the old domain. I've seen the opposite of this done with Competitive Link Analysis (e.g show links that you don't have that your competitor does have). Is there a tool available that can take 2 or more sites and tell me for instance - 72% of the inbound links or linking root domains are the same?
Competitive Research | | Jeff_DomainTools0 -
Keyword Ranks reported by SEOMOZ don't match actual searches
SEO Moz reported that various keywords I was tracking were not in the top 50 results on Yahoo or Bing, yet when I did a Yahoo or Bing search for those keywords (from multiple computers and not logged into any Yahoo or MSN/Bing account) I found the keywords easily. What's the scoop?
Competitive Research | | Cybernautic0