How Do You Create an excel spreadsheet of all blog post content on a site?
-
Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
-
You can export your database to an excel spreadsheet, then you can retrieve the url based on your ids in database.
After you have your list of urls you can both do a crwal using screamingfrog or xenu and join the two lists with a vlookup or you can simply retrieve your title and meta description using seotools extension for excel from nielsbosma.se
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
-
Site Ranking for keywords that they haven't targeted in content
There is a site that I am constantly battling for the #1 spot for a particular keyword and I can't see that they are doing any link building, they are not using any anchor text for the keyword "at all" just their company name (not exact match) and their content doesn't even contain the keyword. I used Open site explorer to analyze their activity, but they are doing something I can't figure out from that data. Any other tools to use? I have higher quality links than them, post content nearly 5 times per week to my blog and their blog hasn't been updated in ages, I kill them in social media, there isn't one instance that they are better than my site and I only build quality driven links, no blog comment crap and get featured on lots of industry blogs for our work. I distribute my content very effectively, I just can't figure it out. They were no where about 5 months ago now they are tearing it up for lots of keywords in the industry top spots. I can build a few links and surpass them, but I have to do it every week or so and I think they are doing something fishy. I just want to figure out what they are doing and bury them. I don't want to post their url and mine here as I don't want them to see this post in search results.
Competitive Research | | photoseo10 -
How to check for Duplicate Content Locally
Hi All, Scenario
Competitive Research | | Mark_Ch
I have Instant Wordpress installed on my local machine.
I am in the process of redesigning my website; content, articles, etc.
I have internet access on my local machine. Question
I would like to cross check all internal links/pages against each other for duplicate content.
I would also like to check all internal pages against external www page instances for duplicate content. How can I achieve the following. Thanks Mark0 -
Our site is slow..
We have noticed that our site is much slower than many of our competitors and expect that this is affecting our organic ranking. We are on dedicated UK Fast server with [20/08/2013 16:44:35] Tony Jackson: Operating System: CentOS 6 64-bit
Competitive Research | | seanmccauley
CPU: 1x Intel Xeon E5-2620 @ 2.0GHz
Memory: 8x 8GB DDR3 RDIMM
Hard Drive: 4x 128GB SSD RAID10
[20/08/2013 16:46:28] Tony Jackson: Nginx, percona, tomcat/solr, Magento CE, cat: 25200 products I could really do with your thoughts on this page for example http://www.pretavoir.co.uk/sunglasses/ray-ban-sunglasses.html0 -
Could duplicate content be helpful to the original source?
Greetings Mozzers, I'm wondering if duplicate content could potentially function as a "link" in Google's eyes. Since they know I have content first and then someone else just uses it, Google could maybe think of that as a recommendation that the content is good? Reason I ask is, when I first starting going after a keyword for a company I wanted to go after two (2) separate regions, let's say "San Antonio" and "Dallas". My non-region based keyword started to rank for "San Antonio Keyword" because the content on the San Antonio page was too closely related. So i'm wondering if maybe having that content so close/duplicate may have boosted the original page because it was kind of like a recommendation? Thoughts, Information, Clarification, any and all are welcome and appreciated!
Competitive Research | | MonsterWeb280 -
Help! New site won't rank locally but should...
any help would be greatly appreciated... picked up a new client, a used car dealer in New Jersey. Have a VERY spammy site before, tons of keyword stuffing and lots of dupe content. also had a horrible design. (www.coopscars.com) We updated the design and the content, made it relevant and unique, fixed title tags, etc. Now he's not ranking for anything locally other than his business name. He's got a decent number of links, we've added relevant citations, his social signals are much stronger than they were... We do lots of SEO for car dealers, and we know that he should be ranking SOMEWHERE at this point - not saying he should be page 1, but he should at least be somewhere in the top 5... and yes, bing/yahoo are different, but he ranks over there... one page 1 for "used cars south river" - so why completely non-existant on Google? just as a test, he put up a free website at www.coopscars.net just last week - and it's already ranking for several local terms. I'm completely confused here - i'm not a noob, I know the tactics we've used on him work for other dealers. Thinking there's got to be something that's blocking him, especially since there aren't but maybe 15-20 car dealers to compete against locally and he still doesn't show up... thought i'd come over here and see if anyone has any ideas...
Competitive Research | | Greg_Gifford0 -
Duplicate content for www & non-www results
why would my campaign show duplicate content entries for www & non-www versions of my url? Here's an example I have a page called 'mydomain.com/resources/', and the campaign analysis shows it as being duplicate content, with the duplicate being 'www.mydomain.com/resources'. I don't know where I can adjust this or if it is perhaps related to some other setting, like Google Analytics or something else. /G
Competitive Research | | swdmedia0 -
Why my site is not crawled by open site explorer?
Hello friends, Im new here... I just create a campaign for my site www.electrosecurity.com.ec , but when I try to use open site explorer to see anything there... I receive a message saying that my site is not crawled... What can I do? I have a few links coming to my site.. but these links does not appears on my campaigns details.. for these links my site is PR3, but i can not see any of this links on the general view of my campaign. Sorry for my english....
Competitive Research | | lans27870