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!
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 pages not lining up with my website/listing
Hi! Newbie here... 🙂 On my Moz report and I have been told that my social sites are not lining up with my webpage. Any tips on getting this done? Also on my Moz Analytic report, I've added my social sites but only facebook is coming up... Any tips would be appreciated!!! Thanks!
Moz Pro | | fullerton0 -
Massive Rank Changes in Bing/Yahoo Only - What's up w/ Rank Tracker?
I'll be honest, it's pretty shameful how little attention I give Bing and Yahoo. But something recently caught my eye - I have a client who according to rank tracker is all over the place in yahoo/bing...up 20 positions for some kw's, down 12 for others...meanwhile Google's holding steady, and Google data seems mostly accurate - with one exception of showing 46th position for an exact match branded search that they're #1 for. I know Rank Tracker has been going through some fine tuning, right? I don't manually check Yahoo/Bing - I can't imagine those #'s are accurate though. Am I right to assume it's incorrect data? Just curious, any insight would be much appreciated. Thanks
Moz Pro | | SVmedia0 -
Opensite explorer not showing facebook/twitter other sites
hello i have had my site live and indexing for 3 months however open site explorer doesn't show the facebook or twitter linkback from my corporate sites. any ideas why this would not show in opesite? it doesn't show in google WMT either. my site: http://cheap-airport-taxis.com/
Moz Pro | | smashseo0 -
Duplicate Page Content and Title - Miva - How to fix?
Hi, I'm new to SEOmoz and just diving into it. I'm feeling a bit overwhelmed. I use Miva Merchant as my storefront interface. SEMOz is returning a bunch of duplicate page content and duplicate page titles and I can't figure out what to do about it. It seems it may have something to do with Miva shortlinks. I click on the dup URL's in SEMOz and it brings me to a dead page. I can't figure out where it's coming from. I know without seeing the actual information it'll probably be tough to help me but any suggestions would be appreciated. I try to fix them and come to a point (after about three hours of getting nowhere) it becomes too frustrating. Thanks!
Moz Pro | | musicforkids
Gary0 -
How do we use SEOmoz to track Local Searches? Is there a way to set the location from which the campaign tracker is "searching"?
It seems that there is no way to set a parameter for location. In Places, I'm able to define my targeted region. How does SEOmoz mimic that localization? Thank for any help! -- Chris
Moz Pro | | ChrisPalle1 -
Duplicate Content
I have tried searching for an exact example of the issues I am seeing, but didn't come up with anything. I decided to post my own question so I can get a direct answer on what I am experiencing. I recently took over a website and its' existing SEO practices with it. Upon placing the site on SEOmoz, I received many (LOTS) of duplicate content warnings. Pretty much, this is how the website is setup: domain.com/keyword-is-here/ but it is also coming up as domain.com/keyword-is-here/index.htm - Should I setup a redirect so domain.com/keyword-is-here/index.htm points to domain.com/keyword-is-here.htm or should I just leave it alone since it's pointing to the same exact? Any information on this questions is greatly appreciated in advance.
Moz Pro | | EQ-Richie0 -
"Duplicate Page Title" and "Duplicate Page Content" issue
Hi I am having an issue with my site showing duplicate page title and content issues for www.domain.com and www.domain.com/ Is the trailing slash really an issue? Can someone help me with a mod_rewrite rule to sort this please? Thanks,
Moz Pro | | JoeBrewer
Joe0 -
Anyway to Verify MozRank & MozTrust Scores w/alternate method?
Hey everyone, I am wondering if there is a way to confirm or reinforce what am i seeing on a webpage using the Moz Toolbar? When I go to this website here: abilogic.com they have a high page/domain trust rank. However, when I filter down to the niche category I would be interested in submitting too abilogic.com/dir/Home/Gardens/ - Then everything, including PageRank, drops to zero. The question I have, is I am not sure if this is really just a poorly constructed and untrustworthy page as identified in the Moz Toolbar. Or is it possible that these page categories have recently been redeveloped or something like that, and that's why the deeper pages are not showing any benefits? Thanks for any help or tips!
Moz Pro | | JerDoggMckoy0