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 -
How Do You Create an excel spreadsheet of all blog post content on a site?
Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
Competitive Research | | RonMedlin0 -
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 -
Where do we find a Keyword Discovery Tool in SEOmoz?
I've been looking for a way to compare keywords amongst my competition websites.
Competitive Research | | homesonthesound0 -
Excel workbook for SEO?
A while back someone on here posted a really good workbook for analyzing ranking factors for competitors. Unfortunately I lost it, and I am hoping someone might know what i'm talking about and hit me up with a link to it, or perhaps your favourite seo workbook for excel? Thanks!
Competitive Research | | adriandg0 -
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 -
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