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
-
What to do about one site dominating search results? (multiple pages ranking)?
Anybody have thoughts on dealing with search results where the same site gets listed multiple times? "weebly vs wix" is one example (same site #1-3, repetitive articles, not crazy high authority), but I see this now and then. I know Google likes variety, so it's weird for me to see results like this dominating search results. Thoughts? What gets these sites to take over the top rankings for a specific term? Any way to rise up in this situation, outside of the usual? Any tips on duplicating this kind of success?
Competitive Research | | davidwaring0 -
How on Earth are These Sites Outranking Us?
Hello all, My colleague and I have been doing a lot of work to optimise our companies site (www.allseasonshire.eu/). The project is still massively work in progress. While we've been analysing the SERPs for KW's we're trying to rank for we've noticed two sites that are outranking us and we can't work out why. The sites in question are www(dot)nationwide-boilerhire(dot)co(dot)uk & and www(dot)nationwideboilerhire(dot)com. They're both very small sites, with hardly any content and basically zero external links pointing to them. When we compare the root domains in OSE our site comes out on top on every single competitive metric as well, most of them by a long shot. I'm just wondering if anyone can help shed some light on why these two sites would be appearing so high in SERPs and why they would be outranking us? Any input anyone has is greatly appreciated. Thanks, Ryan Edit: Keyword in question is 'boiler hire'. Thanks for your answer Nishadha, would that alone really be enough though?
Competitive Research | | allseasonshire0 -
Why is this site ranking #1?
I've done extensive research into http://www.maggiesottero.com/ and cannot come up to any definitive conclusions as to why this site is ranking #1 for the term "wedding dresses." The page is not optimized for the keyword. **Any thoughts? **
Competitive Research | | craigsmith3330 -
Best way to check a sites traffic that you dont own. (Canadian Site)
We are looking for a way to get the estimated traffic for some sites in our niche. Usually we use compete.com or spyfu, but they only track traffic in the US. Does anyone know a way we can get traffic estimates in Canada? Thanks in advance.
Competitive Research | | ClaytonKendall0 -
Is there a way to establish how old a link to a site is?
I wonder if anyone has any insight on the above question.
Competitive Research | | InTouchMarketing560 -
Sites With Duplicate Content Ranking Way Higher
The site I am writing about is easendtorontohomes.com I don't get it. I see that some of my competitors have more inbound links and have been around longer. Their SEOmoz trust etc is also higher. But I don't get how many could possibly be ranking higher since they're sites are all template based site via Web Tech Design and the content is duplicated from one to the other. The other weird thing is that they do everything wrong - they stuff their keywords tag, some of them use the same keywords/meta data on every single page, some of them don't even have meta tags, some of them don't even have a blog with ANY original content. Apart from listings EastEndTorontoHomes.com has TONS of original, well-researched, and keyword rich content. I just don't get it. Is it possible that google has some sort of relationship with that company? Or am I totally missing something? Some of these sites include: tinasmith.ca, mikeclarke.com, teamkassen.com
Competitive Research | | annasus0 -
Is it possible to see bounce rate on external sites?
Are there any tools that will let you see your competitor's bounce rates?
Competitive Research | | nicole.healthline0 -
Government Sites Cluttering Results?
Hi Guys, Have you ever come across government sites that are cluttering up SERP's that you're trying to rank for? For a new site that I'm working on one of the keyword terms is "driving test cancellations" and is in the UK. 3 of the top 4 results are government related sites which have verry little (if not nothing) to do with the keywords. Whilst these government sites are (very) loosley related to the keyword terms, and understandably have high pa/da, what would be the best way to try and rrank higher than these sites. I'm in the process of building links and social profiles - I'm really just wondering if there's something I'm missing that is an "easy fix" for jumping ahead of these sites - or getting them removed due to their lack of relevence. Gary...
Competitive Research | | perfectweb0