Exporting Google and Bing Search Results
-
Is there away to get a spreadsheet of the pages indexed for a certain domain in google and bing? i.e. I search google for Site:www.domain.com and I want to export a .csv file of all those domains/pages.
Cheers
-
There is a chrome extension called "scrape similar" that is useful for doing small batches of stuff like this. However it does have a couple of limitations in that you have to view each page & google will not show you all pages of a large domain. However it is quite easy and effective for sites with under 1000 pages.
https://chrome.google.com/webstore/detail/mbigbapnjcgaffohmbkdlecaccepngjd
The process can be sped up using other tools. I use tool that is designed for black hat forum/comment spamming to do SERP scrapes like that. Even if I did such spamming (I don't), I don't actually think this is a very good tool to do it with. However it is rather good at scraping results from google. However, again you are limited to how many results Google/Bing choose to show you.
If you need a bigger list then log files might be the way to do. You can get a list of all crawled URLs for any particular agent (including the likes of googlebot) from your server logs. Some hosts limit the size of these, so it might be worth checking before you start. However the data does get collected. The downside here of course is that you need access to the logs.
Of course crawled is not the same as indexed. Once you have that list you might need a further step to see which is indexed. Possibly cross-referencing it against google analytics landing pages or querying the google cache for that page (SEOtools for Excel from Biels Bosma is good for this).
Similarly, if you have a definitive list of the URLs on site you could start with that list and query which are cached.
Harder than it seems isn't it? Hopefully one of those methods will put you on the right track.
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
-
Domain still not being found in search
Hi guys, I've been handed a client who needs some seo work. I've tweaked one of their pages to focus on a chosen keywords about 4 months back but still the site is not even visible using the new Domain Analysis tool from moz and it still won't rank at all for the keywords. Am I missing something here? Is there something blocking the SERP from listing the website? I've ran a site: search on Google and it returns 283 results on the website. It's puzzling me as there clearly is something stopping it from being ranked. The domain name in question is: https://cloud9inecommunications.co.uk Thanks in advance.
Moz Pro | | Easigrass1 -
Major Drop in URLs that Received Organic Search Visits
Hi there! I can't figure out this issue. We had a major drop in URLS receiving organic search visits (according to Koz) yet our traffic hasn't seemed to drop in correlation. Our site had a major issue at the end of may (*hence the drop in search traffic) but it seems to have recovered, yet URLs that Received Organic Search Visits has dropped dramatically. I've looked at Google updates but can't seem to find anything, what am I missing? NVun4Wq
Moz Pro | | DotP0 -
Yahoo and Bing
Hi All, my Bing and Yahoo search results pretty much all say not in 50, but for Google many are in the top 10. In the past I have seen the reverse...high search on Yahoo/Bing - low on Google. Any thoughts on why this is happening? Thank you!
Moz Pro | | BeeCHW0 -
I have a Forum, so as a result I have a lot of links Is that a problem?
I'm looking at my initial reports, and it says one of my problems is that I have too many links. should I be concerned? Because part of my site is a forum.
Moz Pro | | taychatha0 -
Loss of Google AdWords API
Since August, we've had intermittent access to the Google Adwords API. Like others in this space, they've let us know that our access has been revoked. We've been working to restore this access, but unfortunately, we have not been able to do so. In the meantime we are working hard to find a suitable replacement that is both stable and a good fit for our customers’ needs. We wanted to let our PRO members know, first to apologize, and second to explain how this has impacted your PRO access. We understand how important it is to have all your keyword data in one place, and we're sorry for any disruptions you've experienced from not having this data source in our app.We do want to clarify that this change does not affect your data from Google Analytics. The products affected by this change are our **Keyword Analysis tool and the keyword details and **keyword analysis pages within our web app. We removed this keyword query volume data within PRO a little earlier this year. You can still generate reports, but the metrics previously pulled from the Google Adwords data source is no longer there.The good news is, we don't actually use the Google AdWords data in our calculation of keyword difficulty, so these reports are still 100% accurate—they're just missing the information we usually pull from the API, which you can find on the Google AdWords Keyword Tool here. We're so sorry about this, and understand how frustrating the loss of this data is. We're hoping to have an alternative data source soon, and we will keep you posted as we make progress. Please feel free to comment, ask questions, and get help by replying to this post. Thank you!
Moz Pro | | AaronWheeler7 -
Can someone explain to me why OSE shows two different numbers for Linking Root Domains in the header and in the results area?
See Photo Below. 271 in the header, 500 plus in the results section. I just want an accurate number to chart my progress from here on out. Majestic numbers seem inflated too much. Google Webmaster Tools too. g58HX.png
Moz Pro | | DRPower0 -
Best way to rank an E-commerce site fast? [GOOGLE]
Does anyone have experience in ranking E-commerce sites? I'm trying to rank 1000+ subcategorys and 300+ products. All less than 1k Exacts some are just 20ish some go up to 1k. I've used Traffic Travis all keywords are ranked as [Easy] along with the tools here. My competition have 0 backlinks to there sites. Some sites have PR1-4 (only 2-3 per SERP rest are 0 so should be quite easy. However I'm up against Amazon and Google shopping for the products. Anyways what would you guys recommend me do?
Moz Pro | | InkCartridgesFast0