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
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
-
Cant find any keyword for my site
I searched for keyword rank for shoreloop.com but couldn't find any. What could be the problem?
Competitive Research | | killerseo20200 -
Local Real Estate Site vs Larger National Sites
Hello all, I am a local realtor that created my website with an idx feed. I am on page one but at the bottom. Question is how can a local real estate website rank better in the SERPS than the larger national brands? Any tips out there from those who have worked with real estate websites and seo? I'm trying to out rank the larger sites for my main keywords. Thanks all.
Competitive Research | | bronxpad0 -
How hard could it be to outrank a huffington post article with PA:1 ?
or what would be the quick way to find out? Page Authority 1 mozRank 0.00 mozTrust 0.00 Total Links 0 Internal Links 0 External Links 0 Followed Links 0 Nofollowed Links 0 Linking Root Domains 0 On-Page Analysis Grade A Broad Keyword Usage in Title Yes Broad Keyword Usage in Document Yes Keyword Used in URL Yes KW in Domain No KW Exact Match No Exact Anchor Text Links 0 Linking Root Domains w/ Exact Anchor Text 0 Partial Anchor Text Links 0 Partial Anchor Text Root Doms. 0 Domain Authority 100 Domain mozRank 7.6 Domain mozTrust 7.9 DmT/DmR 1.0 External Links to this domain 40443657 Linking Root Domains to this domain 223797 Linking C-Blocks Domains to this domain 40697 Tweets 6 FB Shares 20 Google Plus One Shares 0
Competitive Research | | antoniorigo0 -
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 -
Is There Video Instruction on How To Use SEOMoz and Open Site Explorer?
Hi I have just signed up to use this software and would like to know how to use it properly. Is there a video tutorial on how to get the most out of the tools? I want to get the competition's backlinks but for some reason it's not openiing the page. I also want to know how the backlinks are assessed to find the real quality ones that I can link to. How are the backlinks assesed and what standards are used to asses backlink quality? Thank you Sunil.
Competitive Research | | sunilmuse0 -
Keywords in URL structure for Large Site
We are creating a national real estate website which will contain 2mil+ listings. Our aim is to compete with the National leaders in the field. We are trying to lock down a url structure and it basically comes down to if we should put a major keyword in the url structure or not. The structure would have regional keywords naturally. Its the addition of a more descriptive key word which is in question. Our domain name has no keywords in it. For the sake of this example, we would be targeting "city real estate"... oursite.com/real-estate/state/city/ or oursite.com/state/city/ Here is what the big sites use as an example: http://www.zillow.com/homes/for_sale/New-York-NY/ http://www.trulia.com/NY/New_York/ http://www.trulia.com/real_estate/New_York-New_York/ http://www.realtor.com/realestateandhomes-search/New-York Id love to not have to throw keywords in there and be as clean as possible but i also dont want to shoot myself in the foot. The big boys do add additional keywords in the url, does that mean we should? Id much rather be a leader than a follower but again, I dont want to mess this up from the start and these guys have probably tested this (or have they?). Input would be greatly appreciated.
Competitive Research | | cobbsfriedman0 -
How can my site not ranked on easy keyword while it currently ranked 1 on difficult keyword??
The site in question is http://ikt.co.id The site is perfectly optimized (or even over optimized) for keyword "Bikin Website Murah" (in Indonesia it means "develop an affordable website") currently if you search on both google.co.id AND google.com, it ranked on #10 (on google.co.id) and it ranked on #7 (on google.com), and both term only return 1.3 million results I have A LOT OF pages that started with 'bikin website' , or 'website murah' ... there are a lot of them, and i have had a lot of backlinks on those pages too (have been manually building a lot of links, starting from creating a tutorial article and blog submission and many other way) .. the site has been perfectly optimized for that keyword For example we have http://ikt.co.id/blog-category/bikin-website-murah-promo-terbaru.html (for newest promotion) http://ikt.co.id/blog/bikin-website-seo-murah-discount-40-sampai-31-juli-2011.html (for discount 40% promo that lasted untill 31 juli 2011) AND YET, if you search on google.co.id for keyword "2000 likes facebook" , our lone page that i created when our facebook likes reached that amount, RANKED #1!! , and please let me tell you this term return 400 million results++ (on google.com this keyword ranked #19, on 500 million results++). And let me tell you it take that SINGLE page (which has absolutely 0 backlinks) 2 days to ranked #1 .... and her brother if you searched "1000 likes facebook" also show similar result (though not better then the sister) How ?!? and Why ?!? , i dont understand this at all.... my domain does not contain any keyword, they uses the same engine and yet that lone pages which have absolutely no backlink ranked so well on a very competitive keyword, while my Target Keyword ranked poorly.... And what is even more bizzare? "Bikin website murah" might not rank good, but "bikin website" ranked better x_x ... arghh i dont get it... why my site ranked poorly on easy keywords and ranked high on difficult keywords :(( .... Why I am not smiling because those easy keyword is actually my primary keywords 😞
Competitive Research | | IKT0 -
Site in top 3 with a 1-day old domain and no backlinks
Hi everyone, I'm trying to understand some searchresults, when searching in the netherlands for 'online casino':
Competitive Research | | iwebdevnl
http://www.google.nl/search?sourceid=chrome&ie=UTF-8&q=online+casino&pws=0 You'll see as position 3 result this website: http://bit.ly/qhRsUT, it's obviously that this site is there because of blackhat. But how did it come there such high for a keyword with high competition? I don't see anything wrong in the website? It's not like Google did something wrong, because it happened already a few times for this keyword with different domains from that owner. Regards, Yannick0