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 -
Can deceptive ads help sites to rank? Pogosticking effect involved...
Hello,
Competitive Research | | fablau
I have a question for you. I have noticed that many music sites that appear in the first top results for keywords our users search for, include all the same ads that deceive people by inviting them to "Download" or get the "Full Album" of what people may be search for. Look at the following websites that are often displayed at the first spots for keywords like "Christmas Sheet Music" (just an example): [....] They all have, most of the times, the same ads. Look at the following screenshots taken from the sites above (the ads are at the top of the page): http://www.virtualsheetmusic.com/storage/google/Shot1.jpg
http://www.virtualsheetmusic.com/storage/google/Shot2.jpg Those deceptive ads could engage users more than legitimate websites not showing those ads or not showing ads at all, making Google think that people are more engaged on those website showing those deceptive ads. If it is quality that Google is looking for, shouldn't they do something to avoid having sites ranking well just because of some deceptive ads that take users into action, but without any useful result? I am eager to know your ideas on this issue. Thanks! Fab.0 -
What are the pros and cons of putting all content under directory named after target keyword?
The question sounds complicated but is actually quite simple. We want to rank high for the keyword "publicity". Here are some facts: Google Keyword Research: Competition 0.02 & Global monthly searches: 22,200 SEOMoz Keyword Difficulty Tool: highly competitive We are producing plenty of editorial content every day on our online magazine which right now resides under http://mag.publiseek.com and we are thinking of renaming the magazine: "Publicity" and moving it to http://publiseek.com/publicity That way every new article will be under the publicity subdirectory. Of course we would redirect all the existing articles under the old structure to the new one using 301's. And we're hoping that with time we get the top position for the keyword publicity. I am interested to hear from the experts out there what are the pros and cons of this approach?
Competitive Research | | davhad0 -
How can I obtain analytics and social data for a site that I'm not authorized on?
I'd like to get traffic information and facebook /twitter stats for a company. Don't know their ua, logins or have access to any of their pages. Where can I find this information? Any help would be greatly appreciated!
Competitive Research | | brandonschultz0 -
Tracking blog, call to action and landing pages (forms) functionality?
Can you complete Mozrank with tracking functionality for blogs, call to action and landing pages (forms)?. Driek Geurtsen, Oned4marketing
Competitive Research | | Picoleta0 -
Site Ranks Better than Comp...but why?
My site is ranking better than some of the competition sites even though the Moz Rank and Moz Trust are lower, anyone know why?
Competitive Research | | CalgaryRealtor390 -
Image only site on top of Google
Hi Everyone, I'm trying to rank in Google for 'Hid xenon' in the netherlands, but there is one site above all results: http://bit.ly/qlsjne As you can see the site almost has no backlinks, and has not a single word in it's content, all images. it's a keyword only domain, and that's probably the only reason why it's ranking that high, but that means then that i can never get higher then him in Google because of it's domainname? Even when it's such a shitty site? Thank you, regards yannick
Competitive Research | | iwebdevnl0