Feedback on Content Ideation / "Skyscraper" Spreadsheet Template
-
Hi All -
I've been getting a ton of use out of the MOZ API for discovering the popularity of content - which I'm using for content ideation or to implement the Skyscraper concept. I built a spreadsheet template that combines MOZ with some other APIs to apply this to new topics of my choosing, and my friends encouraged me to clean it up a bit and share with the broader community. So, here it is - fire away!
I'd love any and all feedback about the spreadsheet - it's a prototype still so it could stand to pull back more results. For example: would you want to include Domain Authority in the results? Focus more or less on the social sharing elements - or let you choose the thresholds?
Would love to know if there other methodologies for which you'd be interested in seeing spreadsheet templates produced. Cheers!
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
-
Authority from Linking Root Domains: youtube.com / wikipedia.org / adobe.com
Hi there, Presently doing competitor analysis and note two competitors who have a way higher 'moz domain authority' than my client. Using moz tools I notice their top 5 linking root domains all have a score of 100. Refer to screen shot. Of note, both list youtube.com and _wikipedia.org. _ Similarly, my client's domain is ALSO linked from their user profile on youtube.com. They also have a published wiki page with their URL linked. BUT, youtube.com or wikipedia.org are not listed in their "top 5 linking root domains". Their highest scoring linking root domain is prweb.com - with a score of 97. If my client has links on these top domains why would they not be listed in my client's top five domains list like they are listed in their competitors top five? Researching for reasons I came across this old post (2009) here - http://moz.com/blog/followed-links-from-four-unexpected-sources - and wonder if the competitor's links are 'followed' links - even though all resources suggest wiki and youtube are definitely 'no follow' links? Other interesting "Top 5" domains that are listed for my competitors as top "linking root domains" are microsoft.com, adobe.com and europa.eu - again, refer to screenshot. Questions are IF these top linking root domains are in fact 'followed' links/valuable links and help with domain authority scores calculated by the moz tool then 1) HOW do I get these links to show/provide the same value? AND 2) How are my competitors, who are simply travel products, getting links from top domains like adobe.com? I do hope all the above makes sense and that I'm using/interpreting the moz comparative tool correctly! Cheers iGe864i.jpg?1
Moz Pro | | catherineh0 -
SEOmoz giving duplicate content that does not exist.
My problem is similar, and SEOmoz add campaign is giving me several pag. Duplicate, and he's giving me links pag. That do not exist. Look below. My site has 115 pages and the extent SEMOZ gave me 250. Duplicate Page Content ... pages / Alexandra / Clarisse / Clarisse.html
Moz Pro | | Slash-RJ
... pages / Alexandra / Clarisse / Clarisse / Clarisse.html
... pages / Alexandra / Clarisse / Clarisse / Clarisse / Clarisse.html
.... pages / Alexandra / Clarisse / Clarisse / Clarisse / Lizie / Lizie.html When the verade this link does not exist, there is only. ... pages / Alexandra / Alexandra.html
... pages / Clarisse / Clarissehtml
And so on. How to Solve?0 -
Geo / Location-Based Local or City Level Rank Tracking in SEOmoz
Is location-based rank tracking going to be a feature in SEOmoz any time soon? I've seen in a few other company's tools that I can select a city in which to center the search around, for example... if I track the keyword "pizza" and set it to check rankings for "Seattle", it would give me different results than I've I selected "Milwaukee". The reason for the variation in results is due to maps listings in the results sometimes. So, my question is, will location-based rank tracking be coming to SEOmoz soon? Scott
Moz Pro | | OrionGroup0 -
I've got quite a few "Duplicate Page Title" Errors in my Crawl Diagnostics for my Wordpress Blog
Title says it all, is this an issue? The pages seem to be set up properly with Rel=Canonical so should i just ignore the duplicate page title erros in my Crawl Diagnostics dashboard? Thanks
Moz Pro | | SheffieldMarketing0 -
Quote "There is no SEO software that can help optimize a site"
Hi all I am a developer for a small agency in the UK. I am using SEOmoz for a couple of our clients and I am also using it to learn from. So far I am finding it a great tool and this forum is also incredibly helpful. Now I also visit another forum called HighRankings.com and this months newsletter is a list of points that are defined as "SEO Mistakes". In it, point number 2 reads: "Repeat after me: There is no specific number of times a keyword phrase should be used in my content. There is no magic number of words that my pages should have written on them. And there is no best number of words or phrases that belong in a Title tag. And most of all: There is no SEO software that can optimize my website (despite the claims of their creators). Use your common sense to optimize your site! Learn how your target audience searches for products, services and information such as yours, and write about it accordingly on your website. Then write to make an emotional connection with your visitors so that they'll convert into happy customers." Now as a user of SEOmoz I wondered what others thought of this comment? Many thanks for reading. Kris
Moz Pro | | yousayjump0 -
Can the link acqusition tool / web directory list be used for non-english language enquiries?
Hi there, We are currently in the trial period of seomoz pro and have been testing all of the availiable tools. We are very happy with OSE and the other professional tools however we have discovered a barrier in our research methods. 1, Does anyone know how can you use the link acqusition assistant for non-english enquiries? The suggested search queries that are automatically generated are "submit site" "submit url" etc, but this has almost no use for a non-english keyword. - Also are the results only displayed for google.com - is there no localization at all of search enquiries? 2, The list of directories provided by seomoz link: http://www.seomoz.org/directories are anglo-centric. What are the availiable options for non-english speaking directories / local directories NOT based in the United States? Any help that can be provided would be greatly appreciated!
Moz Pro | | deliveryhero0 -
OSE Social Signals Affect PA/DA?
I've looked through the Open Site Explorer documentation and can't find the answer so am posting here... I noticed a web page I work on showing a PA 30 but OSE is showing 0 links from 0 root domains. It is a page that has no internal links to it and no external links to it (that I know of) but has stumbles, tweets, and Diggs. Are these social factors the reason it has a PA of more than 0 or 1? If so, is there a link to documentation that shows how OSE handles social signals? Thanks, Evan
Moz Pro | | eBoost-Consulting0 -
Mozbar export of serp overlay as csv not opening on Mac OS w/FF.
Its works on my (virtual) Window based machine in FF. And when I open that same file on my Mac OS, it works! However, when downloading the overlay data to csv on my Mac OS in FF, i get a super long file name & then the file won't open? Shows -5000 error? Both in Excel and Open Office. Any ideas? Both new version of Excel & Mozbar.
Moz Pro | | josey1