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
-
Is my client's site penalized and if not, why are other lesser quality sites ranking with lower metrics than my client's?
Hello, I'm trying to explain to a client, as to why certain websites that appear in the top 50 listings for a keyword are there when they don't have very good backlink profiles, and for this keyword, seems you need a high PA above 20 or DA above 25, just to page for page 2 - 3. Running a full SERPs report, I have seen that backlinks to the page that's ranking seems to be as high of a factor as PA, followed by DA and overall backlink profile. Having a high score in one of these 4 areas seems to increase your ranking. However, going into page 3 and beyond, seems that things kinda take a weird turn. After comparing the client's site to those ranking on page 2 I could see that all of them had better PA and more links to the page ranking for that keyword, so page 2 I understand why we don't rank on yet. However, looking at page 3, I see that the client's site in question has better PA, DA, links to page and overall links to domain. Which leaves me to think we have a penalty that's keeping us ranking 50 or beyond. Since our metrics across the boards for what MOZ is showing as ranking factors. The more odd issue is that looking at the line graph, shows right at the time we implemented sitewide https our ranking for this one keyword dropped, while rankings for our other keywords increased. Am I to assume it's a keyword density penalty? What penalties are there with a outcome of ranking limits?
Competitive Research | | Deacyde0 -
Outranked for own content
One of my clients has a travel site and is syndicating apartment listings to the likes of tripadvisor and flipkey. I've just done an SEO audit for them and noticed that when searching for snippets of text from within an apartment listing, these aggregator sites outrank my client by miles (which is the original creator of the content). How would you suggest tackling this issue? We can't give up the aggregator sites as they're bringing in sales. The first solution that comes to mind is send different descriptions to aggregator sites than the content on our site, however this would mean rewriting a ton of content. Any other suggestions on how to treat aggregator/comparison shopping sites?
Competitive Research | | bogdan_c0 -
How on earth is this site ranking so highly?
I'm trying (& struggling) to rank for the keyword property in italy. Yet in the past 5 weeks I've seen this site -- betterpropertyitaly (dot) com -- rocket from about #30 to #2 for the keyword and am trying to figure out why. The obvious is that it's in the domain name, but that can't be the be-all-and-end-all, surely? It's a 2 yr 9 mth old site, so why the sudden spurt? I look in Open Site Explorer and the metrics look pretty weak: Domain Authority: 17 Page Authority: 29 Linking Root Domains: 9 Absolutely zero social shares. Good luck to him and all -- but I'm trying to figure out what he's doing right and I'm not. My site apart, he's beating some pretty big-hitters.
Competitive Research | | Jeepster0 -
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 -
How can a site rank higher when you beat them by A LOT on virtually every SEOMOZ factor?
Any insight into what's driving these results would be appreciated. Another site ranks #6 and we rank #22 on a keyword that scores 67% for "Keyword Difficulty", but we score significantly higher than them on almost every ranking factor including having nearly 10 times more backlinks along with higher PA and DA scores,etc. Here is a comparison from the Keyword Difficulty Tool report. Question: What could be going on? Factor and ranking comparison (us v. them) with our higher rankings are listed first. PA: 61 v. 39, mozRank 5,85 v. 4,54, mozTrust 6.00 v. 5.49, mT/mR = 1.0 v. 1.2, total links = 4,198 v. 90, internal links = 4198 v 90, external links = 275 v. 57, followed links = 4171 v 85, no follow links = 27 v 5, linking root domains = 46 v 30 on-page grade = A v B broad keyword usage in title: yes v yes broad keyword usage in document: yes v yes keyword used in url = no v no keyword used in domain = partial v no KW exact match - no v no exact anchor text links = 2373 v 13 %links w/ exact anchor text = 56% v 14% linking root domains w/ exact anchor text = 7 v 8 % linking root domains w/ exact anchor text = 15% v 26% partial anchor text links = 0 v 0 Domain Authority = 54 v 27 Domain mozRank = 5.4 v 3.2 Domain mozTrust = 5.8 v 3.7 DmT/DmR = 1.1 v 1.2 External links to domain 9261 v 63 Linking root domains to this domain = 355 v 33 linking c- blocks domains to domain = 267 v 30 tweets = 4 v 3 FB shares = 13 v 11 Google Plus one shares = 1 v 0
Competitive Research | | rickt0070 -
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 -
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 -
How many Page Rank 8 sites are there?
Anyone have any estimate of how many Page Rank 8 sites are out there? Best, Steve
Competitive Research | | Aggie0