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
-
Duplicate Content - Multiple URL's
I know a few of these problems come from products being in the same categories but I have no idea how to get rid of the url's that are showing duplicate content when the product is in the exact same place. Hard to explain, but here are URL examples. http://www.ocelco.com/store/pc/www.ocelco.com/store/pc/Bathtub-Floor-Corner-Stainless-Steel-Grab-Bar-Right-Hand-left-hand-pictured-688p3308.htm http://www.ocelco.com/store/pc/www.ocelco.com/store/pc/Bathtub-Floor-Corner-Stainless-Steel-Grab-Bar-Right-Hand-left-hand-pictured-696p3308.htm http://www.ocelco.com/store/pc/Bathtub-Floor-Corner-Stainless-Steel-Grab-Bar-Right-Hand-left-hand-pictured-p3308.htm http://www.ocelco.com/store/pc/Bathtub-Floor-Corner-Stainless-Steel-Grab-Bar-Right-Hand-left-hand-pictured-688p3308.htm Any Idea's how to fix / get rid of these URL's? Thanks!
Moz Pro | | Mike.Bean0 -
Duplicate content on SearchResults.asp
hi guys. I'm currently working through the reported crawl errors in Moz Analytics, but an unsure what to do about some of them. for example... Searchresults.asp?search=frankie+says+relax is showing as having duplicate page content and page title as SearchResults.asp?searching=Y&sort=13&search=Frankie+Says+Relax&show=24 There's all sorts of searchresults.asp page being flagged. Is this something i can safely ignore or is it something i should endeavour to rectify? I'm also getting errors reported on shoppingcart.asp pages as well as pindex.asp (product index). I'm thinking i should maybe add disallow/ shoppingcart.asp to my robots text file, but am unsure as to whether i should be blocking robots from the search results pages and product index (which is essentially a secondary sitemap). Any advice would be greatly appreaciated. Thanks, Dave 🙂
Moz Pro | | giddygrafix0 -
What are the restrictions/limitations to running SEO/Adwords in these countries?
What are the limitations or restrictions to running SEO/Adwords campaigns in countries such as China, South Korea, Japan, Brazil, Portugal, Spain, and Mexico?
Moz Pro | | ThomasCenterInc0 -
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 -
Noindex/nofollow on blog comments; is it good or bad ?
Hi, I changed the design of one my wordpress website at the beginning of the month. I also added a "facebook seo comments" plugin to rewrite facebook comments as normal comments. As most of the website comments are facebook comments, I went from 250 noindex/nofollow comments to 950; URL's are ?replytocom=4822 etc. Moz campaign noticed it and I'm asking myself : is it good to have comments in noindex/nofollow ? Should I do something about this ? Erwan.
Moz Pro | | johnny1220 -
<bs>Will someone give me a "thumbs up" so I can become an Authority and get my SEOMOZ T-Shirt?</bs>
<bs>I have helped many people (probably 100s) here in the forums. My fingers are swollen and I can't answer questions right now. I want my SEOmoz t-Shirt for becoming an Authority, but I'm a few points shy. Any help would be appreciated.</bs> Watch people give me a thumbs down. LOL
Moz Pro | | Francisco_Meza3 -
Duplicate page content due to Sort By dropdown
Hi there, I have over 150 Duplicate Page Title errors showing up in SEOMoz but on closer inspection these are related to the 'Sort By:' functionality on our ecommerce site that allows customers to sort our products by Price, Alphabetically etc. To give an example: http://www.parklanechampagne.co.uk/park-lane-champagne/special-occasions/easter Is showing as being duplicated by this page: http://www.parklanechampagne.co.uk/park-lane-champagne/special-occasions/easter?productlisting_page=1&sortorder=Price Does anyone know how I can resolve this? Any help greatly appreciated. Kind regards, Jon CDFyp.jpg
Moz Pro | | jonmorse860 -
Campaign status stock in status "Next Crawl in Progress!
Has anyone else had an issue laetly where the campaign status was stock in _ **"Next Crawl in Progress!" **_? One of our campaigns has been in this status for the page 2 1/2 days and this has not happened in the past as there are only 597 pages for this campaign to crawl. I send a help ticket request to the SEOMOZ team but was wondering if this is an isolated issue or if other community members have also experienced it? Thanks.
Moz Pro | | DRTBA0