Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

SEOMOZ EXCEL PLUGIN ARRAY FORMATTING

Competitive Research

493

Sugartheagency last edited by

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.
1 Reply Last reply
Reply Quote 0

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

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 | | remkoallertz

0
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 | | adriandg

0
What do the following metrics in the SEOMoz toolbar stand for: PA, mR, MT & DA?

I just downloaded the SEOmoz toolbar and found out several metrics that I need help to understand: PA mR mT DA Can anyone help with this?
Competitive Research | | amtnezschez

0
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-139191

0
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 | | SharpKiwi

0
How due I take the advanced report that i have exported as a excel file and recreate your online color coded version with the data.

In the keyword difficulty screen how do I recreate your beutiful color coded spreadsheet in the exported excel file based on the advanced reports.
Competitive Research | | bmcfarlane

0
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 | | Cybernautic

0
My client has shown me a similar site, though not a competitor. He wants to know what sites they are linked from that give them such a good Google rank for certain kewords. Can SEOMoz tell me this?

When using google.com.au and searching for "travel to france", www.frenchtravel.com.au is the 3rd organic result. (the 1st two are not travel businesses, they are non profit travel guides) My client, who runs www.visituk.com.au, an Australian site that organises tours of the UK, said "so we just need to add these sort of words to the site?" I said, yes, but it doesn't end there. The real task is to have a link to your site on other sites surrounded with the words "travel" and "UK". He asked if he could see a list of the sites the french site was being referred by relevant to the search phrase. Is there an SEOmoz tool for this? Or is there another way I can generate that list? Thanks Simon
Competitive Research | | electrik

0