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
-
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 -
SEOMoz bar shows competitors ranking higher in SERPS with less Moztrust and Mozrank?
We are targeting the term "wholesale fireworks" we are currently on page two and just completed some on page optimization. I noticed using the Mozbar that the SERP results on the first page show a site with near zero page rank, Moztrust, domain trust, etc.. It is steadily number two in SERPS. Our site is just as strong or stronger on these ratings as anyone on the first page. How is it possible that we are still hanging out on page 2?
Competitive Research | | devonkrusich0 -
8500+ seomoz errors and still rank one for high traffic keywords
I plugged a competitor into the campaign manager that is ranking #1 for many target keywords like "sprinkler parts" (18k broad, 720 exact) and "sprinklers"(550k broad, 4400 exact) and #2 for "sprinkler"(1mil broad, 8100 exact). This site has over 8500 errors on SEOmoz - I have spent a good deal of time fixing errors on all of our client websites and have gotten them down to 0 errors. I am just wondering if I have been wasting my time and if the errors that SEOmoz reports on even make a difference. How can a site rank for such high traffic keywords when it has 4k duplicate content and 4k duplicate page title errors? The site has 75 linking root domains according to opensiteexplorer. any help on this would be greatly appreciated!
Competitive Research | | Splashme-1391910 -
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 -
Ive been busy link building for about 3 months and my seomoz account says i have no links?
Wondering why none of my links are showing in my dashboard altho many were accepted 3 months ago? many Thanks, Zoe.
Competitive Research | | zozzer0 -
SEOmoz total links fluxuations
I'm analyzing my clients and competitor back links and are noticing alot of up and down fluxuations. For example last month we had 1400 back links, last week 1350 back links, and today 1450 back links. Also, one competitor went from 25,000 to 2,700 in the space of a few weeks. My question is how can I explain to the client that their back links are going down when they are paying for a back link building service (100 back links per month). Thank you for your time.
Competitive Research | | SharpKiwi0 -
Excel Concatenate Function for Google Places?
I'm trying to expedite my research by using the concatenate function. How should the search URL be modified to trigger a google places search as opposed to a normal search. Thanks!
Competitive Research | | BlueFountainMedia0 -
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