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