Sort by domain name.
Export to Text.
Find replace / with tab character.
Put back into Excel.
Do a count of domain names.
Compress at totals.
You'll have a list of unique domains.
![RyanPurkey RyanPurkey](/community/q/assets/uploads/profile/1929-profileavatar-1619582383766.png)
Best posts made by RyanPurkey
-
RE: Filtering OSE Results
-
RE: How Can I move a site higher in Google Places?
http://www.davidmihm.com/local-search-ranking-factors.shtml This is an excellent break down of the factors that go in to local search. David Mihm is also on the SEOmoz website so if you need an expert in the field you can contact him.
As you can see from the article there are at least 58 positive indicators and 11 negative indicators that all influence your localized ranks, being a combination of localized content and regular ranking factors. Hopefully by scanning through this article you'll be given several ideas of where you can improve your results.
-
RE: Can you do strict CPC advertising on Facebook?
Hi Rosemary. CPC campaigns should only be counting clicks sent from Facebook to your target website. See: https://www.facebook.com/help/659185130844708 and https://www.facebook.com/help/336724533157327
If they're not you'd be able to report the non-visit charges as fraudulent and likely have them removed from your billing.
-
RE: Sharing Facebook Comments Across Other Social Sites. Is It Okay?
It'd be a good idea to contact the customer and ask for their permission first, and if everything is a go it's fine to promote the positive review. It could also make a nice addition to a page where you collect them, if you have something up and running like that. Cheers!
-
RE: IPhone usage by Continent
Sean, the percentages are the Statistic divided by Country/Region. So if you select Mobile OS and Worldwide the 31.56% percentage for April 2011 on SymbianOS means 31.56% of the World's Mobile OS uses SymibainOS. If you switch Country/Region to the United States the percentage will indicate that area's usage for that Statistic. Remember though, it's only measuring Mobile OS in this instance so it's not a percentage total of all web surfing traffic, just mobile web surfers.
You'd have to reverse engineer this data and plug in some statistics form another location on specific device usage or purchases in order to get a guestimate on the number of iPhone users, by device, within your countries of interest.
-
RE: Domain Authority Question
You'll want to look at more than just domain authority and instead address things more granularly. Look at your top pages according to OSE of your site and compare how they're aligned with your targeted keywords. Also, check the backlinks of those competitors and see where they're getting links that you're not. (http://www.seomoz.org/labs/link-intersect) On site, you should check things like navigation (do you have clearly labeled, keyword targeted navigation, or is it locked up in flash), does your site load without javascript turned on, do you have any weird redirects in place (302, javascript, etc), are your site URLs full of session variables, and so on.
-
RE: What tool can I use to evaluate the domain authority of a competitor?
Hi Derick. https://moz.com/researchtools/ose/comparisons is great for back of the envelope calculations as is the Moz toolbar. If you want to get really in-depth you'll likely want to run some full reports, export, and go through the data in a spreadsheet.
The http://moz.com/labs/link-finder Competitve Link Finder is also nice for seeing areas to gain lift that your competitors have already found.
-
RE: Weird situation with our local listing.
Solution #2: They should hire you as their SEO.
-
RE: Franchise Business: In competition with... itself!
Is there a contract in place that explains what you do and how it's equitable amongst the franchises? Do the franchisees have the option of doing their own work in addition to what you're doing? If so you can say, "Hi angry franchise owner. Why yes, I've been working on your site's presence as per XYZ in the contract. Oh, you see franchise owner #2 in the search results? Yes, I did XYZ for him too. It looks like he's been really active in getting reviews though..." If there isn't something in writing you might have a lot cat herding on your hands.
-
RE: Google Analytics - April Search Report Data Gone For All Clients - Anyone Else Seeing This?
Ah. Thanks Dan, now I got the same results. This definitely appears to be a Google-based bug and is happening gloabally: http://www.analyticsevangelist.com/google-analytics/google-analytics-segmentation-data-missing-for-april-2011/
-
RE: HUGE spike in Google Analytics Traffic
Ah, is your embedded blog on a different domain and being iframed in? The analytics would be more detailed looking at the direct blog data. It sounds like something within the blog went mini-viral and is producing the spike.
-
RE: Via this intermediate link?
HI Gerard. I think what you're seeing is the redirect on your own site. See the discussion here: https://productforums.google.com/forum/#!topic/webmasters/mGA6ygCUtWE, noting this part of the thread, "someblog.com/post-1 links to mysite.com/page1, however mysite.com/page1 redirects to mysite.com/otherpage".
Maybe your competitors just linked to your hosting of the PDF instead of downloading and hosting their own.
-
RE: A question on keywords that rank 51+
Hi. Typically you should have some idea of the keywords a page is targeting, i.e. What is it called? What's the title tag say? What's the content of the page? And so on. Also, in general, you can model your pages using a break down of Moz' http://moz.com/learn/seo/on-page-factors where applicable for your content. If you have a list of keywords that you're trying to rank for, have you associated that list with different pages on your site? That would at least give you a start.
-
RE: How Fast Is Too Fast to Increase Page Volume of Your Site
Sometimes you see a bit more organic (in terms of people just naturally linking to things) indexation of content if pages are dynamically generated by a user selecting the amenity, location, etc, and then the database creates the page on the fly and then someone links to that. Still it's nice to have a bit more control over page URLs and give them a bit more established, static presence ahead of time.
I wouldn't worry about their release in regards to amount. Just make sure they function, have sitemaps indicating the new content, and try to drum up a press blitz on the new amount of pages in social and conventional space. Google does well with large increases if it sees a correlated increase in search or press.
-
RE: How to Interpret results in OSE?
Hi Mike. Regarding your questions...
- No, having Google index your site's search results pages is contrary to their guidelines, specifically, "Use robots.txt to prevent crawling of search results pages or other auto-generated pages that don't add much value for users coming from search engines." From: https://support.google.com/webmasters/answer/35769. If you did it, you'd run the risk of having your site reported as webspam here: http://www.google.com/webmasters/tools/spamreport.
- Plenty of other strategies could help your site. You might also find ways to increase your links internally by a healthy amount; you can link out to highly reputable sites pertaining to your pages; you can get social signals referencing your pages; and on and on. Lots you can do!
- The Internet is kind of big. This specific site, and these specific results are like a few blips in the trillions of other signals Google handles.
It sounds like you're working on your site the right way. Focus on being a better user experience like you are and even if you're getting a few less visits by ranking a little lower than your competitor currently you're still going to have much better results. Cheers!
-
RE: Linking domain dropped followed by significant decrease in Domain Authority
Did that site add "noindex" somewhere? It sounds like something that dramatic for it to leave the index suddenly like that. Maybe check robots.txt and other indexing issues.
-
RE: Brand Name Cratering - possible N-SEO or Black Hat Attacks
All great finds Dirk! Thumbs up on this. Jake should have plenty of things to add to the list now.
-
RE: New pages on my web site
You'll want to contact your hosting company or look at their FAQ on how to edit robots.txt. Cheers!
-
RE: What is the best method for segmenting HTML sitemaps?
You might benefit form a visualization program as well like Visio, Mindjet, or Mindmiester to figure out some of the more intricate details. Also JoelHit's suggestion of using Apple.com as an example is a good one. Even though their main sitemap is smaller than what you're describing there are some subtle takeaways when looking at it as an example (http://www.apple.com/sitemap/).
- All their top level categories are H2 tagged major categories of their site.
a. "Apple Info" emphasizes the brand
b. Mac, iPod, iPhone, iPad all emphasize product sales
c. iTunes, Downloads, Support emphasize sales and an ongoing customer relationship. - Precedence is given to the core aspects of their business via their sitemap.
a. As outlined above, this is elegant and functional.
Also, you'll certainly want to back up the work you do with an HTML sitemap with XML sitemaps for large scale sites and as Richard suggested register them all with Google Webmaster.
- All their top level categories are H2 tagged major categories of their site.
-
RE: How to Interpret results in OSE?
You're in the clear using a Google custom search box because Google is the one delivering the results so they know not to double up on those. You're right that the pages that are getting indexed in Google on the other site are from a different process and an attempt to trick the engine with sparse, dynamically generated content.
Hint? Huh? I'm not nearly that clever. Cheers!
-
RE: Save a Google Analytics account
I don't think you'll want to transfer ownership (unless it's to the client from a previous company working on their site). But you'll have to go through Google's password recovery process to get it. Ideally it will send the client an email at that step and they can follow up then.
-
RE: Brand Name Cratering - possible N-SEO or Black Hat Attacks
Jake, I wouldn't rely on Google's presentation of the one-box bio and map in the search results as a yes or no indicator of negative SEO. I just ran the search for the company name (no quotes; lowercase; without the LLC) and got the box... I also wouldn't use the ability to rank a company homepage for the company brand name searches as indicator of ranking strength. With consistent NAP, domain registration, and registration via GWT most any web software--flash, html, php, asp, whatever--that simply loads should do the same within a short time frame after launch.
I also get the companies contact us page when running a search as you described.
This means so far the only consistent thing to note is that Google's display of the company search is similar to how it handles other company searches (not an N-SEO indicator) and the use of flash on the site is in conflict with recommendations Google has made public, and made public shortly prior to some of the changes you've seen. (Late 2014). Correcting those on your site would be beneficial.
As for the ROR, yes those are annoying! Hopefully with more positive press and presence on high strength domains (Hoovers, et al, mentioned earlier) you can get it so far from the front page as to make no impact. The disavow tool remains an option for the links you've been getting from suspect domains. In the meantime, change what you have ready access to (the issues Dirk mentioned) to ensure that's not a part of the larger picture. Best of luck!
-
RE: New to Moz, need some probably basic answers about Keywords, Linking, Competitors and General SEO
Hi Max. Welcome. It sounds like you've gone through some of the materials within the "Learn" section here so that's a good start, so on to your questions...
- The competitive niche keywords represent where you want your site to be when it's as powerful as your competitors. No site is going to have a lasting presence in the search engines that finds some loop hole to exploit and suddenly pops up near the top with thin content and zero engagement, so think of the competitive core keywords also as a guide to finding other sites where you're not just getting a link, but getting exposure for your brand or business. For example, a sub-reddit could drive tons of traffic / sales to your site if you're engaged in the community there. Sites with active readership that are writing regularly about your niche are likewise important. You get the idea. For niche competitiveness look at the whole picture.
- For keywords, don't bog yourself down. You need to develop your site and content in a way that would make sense for someone searching for that keyword. Put it together from the searchers perspective for the given keyword(s). What do they find if they're researching or shopping for something they've put into search? Does your site solve their problem quickly and easily? Does it give them confidence in their purchase? Etc. Closely related keywords and derivatives can all target one page, while the amount of keywords you research should be limited to how much content your site contains.
- See search ranking factors for an extensive breakdown of rankings: http://moz.com/search-ranking-factors. Search and inbound marketing is a huge business. You'll be will on your way though if you're highly focused on making a site and product people use and love (and link to naturally) than trying to learn every aspect of search.
- Moz shows the page that ranks in your selected search engine as the page that is targeting that keyword. So if your keyword doesn't rank, there's no page associated.
- Use that data in Moz to help you find even more connections than you would on your own. Remember the Moz tools are like your sleepless robots that are collecting way more information than any one person ever could just working on their own.
- As much as possible, don't think of your future relationships with other websites as 'link partners' instead think about how the aspects of your business mesh well with what they're doing. If they write an entire well-read article saying they love your business but the link is just to the homepage and a nofollow at that, it still should be considered an outstanding link.
Connect with people in your niche that aren't competitors and put your passion into your business and relationships with them and the links and rankings will come with it. Good luck with your venture!
-
RE: How Can I move a site higher in Google Places?
Google pulls reviews from across the web, not just Google accounts.
-
RE: .ca for Canada-specific business currently using .com?
If all your marketing materials reflect the .com I'd keep that; however, you can consider rolling out the .ca for localized branches. Still, there are trade offs there as well, for example, if you're currently hosting your local branches on the .com main site they're likely experiencing a boost from its domain trust and authority. Things like that would be in play specifically for the branches. For corporate I'd leave it at .com. Cheers!
-
RE: Google News Bug
You should be able to see the google news page in more detail within Analytics by clicking through to it's details. That referrer should still have your article on it, well a blurb of your article.
-
RE: Brand Name Cratering - possible N-SEO or Black Hat Attacks
Hearty thumbs up to Dr. Pete's (and Dirk's) analysis here.
Jake, you might not like the conclusions but their leaps and bounds better than what you'd find from most other sources. Please heed their advice.
-
RE: How often is the Moz Local report data updated?
I think Moz Local is still on a weekly update schedule at this time.
-
RE: Managing 404 errors
Also, be sure to have a user friendly 404 page. 404 is unavoidable due to typos, silliness and random acts of God, so it's always wise to have a highly functional page as a catchall for anything that you can't 301 redirect.
Examples
http://www.apple.com/gljasdlj
http://pages.ebay.com/gljasdlj
http://www.cnn.com/gljasdlj -
RE: Is Google Knowledge Graph in Other Countries?
Sure. Use a VPN to place your IP in the country you want to test, create a new browser instance with the language set to the target countries language (or language within that country you want to test), and then search the location specific version of Google, i.e. google.co.uk instead of google.com.
While not all inclusive of what users will be seeing from within that country, that should give you at least a more informative snapshot. Cheers!
-
RE: Google News Bug
I agree with Linda. Google Search and Google News are two different things with two different user types. High bounce rates are more common with people scanning headlines and skimming articles. I've never heard of a site popping into Google News causing a Google Search penalty.
-
RE: Best practices to rank a new website that does not produce much content.
You're welcome. Great insights as usual. And this just further emphasizes the importance of content as well as how it relates to organic rankings. If a company has no interest in using words written well, search doesn't have much interest in it.
-
RE: MOZ Local
This blog post covers the details on their network pretty well: http://moz.com/blog/announcing-moz-local You can also see current status on business listings just by trying one out in the Check Listing tab: https://moz.com/local/search
-
RE: Will swear words present on my pages affect my rankings?
Since Google leaves SafeSearch Off for its text based results, it's rare that you'll see a difference. In some cases if people have SafeSearch set to moderate or strict you may notice your listing removed. Pretty easy to test though.
-
RE: 302 redirect on http but not on https
Hi Ram. If Jon's fix above doesn't work, you might want to post the link(s) you're testing with Screaming Frog so that people here can see what's going on and give you specific recommendations. It sounds like there's a 302 in place on the http version of your site, but people will need details to see where exactly. Cheers!
-
RE: 404 figures started reflecting in goals overview
Hi Dan. That's where Google keeps goals within its reporting structure. They shuffle things around from time to time and made several changes just a few weeks ago. To catch your 404s, check out GWT for crawl errors, run a tool like Xenu Link Sleuth, and check the details of Analytics. Cheers!
-
RE: Missing Title tags
On the page you cite you have a
tag which could be causing the error: <title>Heat Press, Transfer Machine Comparison Chart For<strong><br></strong>Hix, Geo Knight, Stahls Hotronix, Maxx, Insta, Panther & More!</title> -
RE: Can reporting be whitelable with Pro version on our site for clients?
With Medium levels and above you can have "Branded Reports" which allow you to add your own logo to the reports. See: http://moz.com/products/pricing.
-
RE: Redirecting multiple websites to a single website
Hi Andy. If your 30 websites are all similar content and a similar template you can probably just go ahead and redirect them straight away to the community website, especially if they haven't been performing up to your expectations.
If your 30 websites already have some of their own traction you'll probably want to redirect them piecemeal in order to see how users react to the new, singular website; and to see how the new website measures up in analytics.
-
RE: Do Pages That Rearrange Set Off Any Red Flags for Google?
It sounds like the scenario you're describing isn't an issue of the URLs changing, but more so content shuffling within given URLs. This is VERY common. Google even promotes this with the Website Optimizer as they understand that a users experience with a website can vary from user to user, and having the flexibility to change to meet a specific user's needs is a good thing not bad. Unless the shuffling is dramatically affecting your own search traffic goals, I wouldn't be too concerned with it. Mostly I'd recommend strong categories for your pages that target your key search demographics and the archival of pages that have come and gone in their voting cycle. That way you'll have plenty of static content to work with as well.
-
RE: Visits from Google with ccTLD are showing as referrals
You'll notice that a measurable amount tagging in Analytics can be hit or miss. For example you'll also find a lot of referrals from places that are clearing clicks from someone's online email account (lots contain 'webmail' or 'email' in the referring domain) but you could filter these to be counted as organic / email channels respectively. You just have to write up the rule that does so or adjust them on the back end when working with the data in a spreadsheet.
-
RE: Keyword Difficulty Popup
I saw this too, although my version has the "Get Keyword Difficulty" button in green to the right of Google Search. Were you typing in the nav bar?
-
RE: My client just updated his Google physical address. It shows up as unverified now. How long until Google verifies?
It'll be either verified by postcard or phone call. The post card option takes 1 to 2 weeks, while the phone call is same day. See: https://support.google.com/business/answer/2911778 There Google lays out the entire verification process. Cheers!
-
RE: Why isn't my uneven link flow among index pages causing uneven search traffic?
If you're speaking in terms of just organic search visits it doesn't seem to be a problem, but "traffic" in your example is a little broad. There could be paid search being targeted to those pages, or some sort of social media mechanism that causes people to visit their specific page, or so on.
A segmented look at your analytics for the site (or site section) will give you a good idea of whether or not the pages have a problem getting organic search traffic. If they don't I wouldn't worry about link flow. Really the main reason to adjust it is if you're lacking indexation or rank, and so far from what you've described you're not.
-
RE: What do you use for test rendering your dev site?
Hi Tyler. You can use a text browser like Lynx as that's a close approximation of how Google "sees" your site. From: https://support.google.com/webmasters/answer/40349...
Use a text browser, such as Lynx, to examine your site. Most spiders see your site much as Lynx would. If features such as JavaScript, cookies, session IDs, frames, DHTML, or Macromedia Flash keep you from seeing your entire site in a text browser, then spiders may have trouble crawling it.
And a more robust list of guidelines is available here: https://support.google.com/webmasters/answer/35769.
-
RE: Two of Four Google Analytics Views Not Showing Data
Sorry, but there are too many variables at play that could be causing this. Since they're brand new views though there isn't much to lose in deleting them and starting with new copies of the original view. I'd go through, duplicate from the original, and then modify them one setting at a time to see what triggers what.
-
RE: Moz Tool Bar Annoyance - How do I make the green keyword difficulty box go away?
Hmm. Could be a bug because for me it stays off while using Chrome as a browser. Can you share your browser and OS specs? Staff should be able to better trouble shoot after that. Cheers!
-
RE: Moz Local users: Specs for Images?
Right. Moz Local uses the matching verifired Google + and Facebook listings to verify those locations. So what you have there is what gets applied to the myriad of others. See: https://moz.com/local/how and:
Moz Local takes the time and hassle out of managing your listings across multiple sites and directories. When you submit a listing on Moz Local, it must match an existing Google Places or Facebook listing across all of the following attributes: Business Name, Address, Phone Number, and Website. Because you've already gone through the phone or postcard verification process with Google and/or Facebook, your Moz Local listings will be validated if they exactly match Google or Facebook.
Some of our partners—such as Infogroup and Best of the Web—may call or email to confirm your listing information is accurate, but no postcard or PIN entry is required.
-
RE: Why isn't my uneven link flow among index pages causing uneven search traffic?
Yes, an even distribution of organic search traffic seems to indicate that the pages are indexed and ranking. Gains might be made via external links, but as far as modifying your link flow goes, it doesn't seem like the site needs it based on what you've described.
-
RE: Does interlinking on mobile site helps in seo & improvement in rankings
Yes, the combined quality and quantity of links pointing to a mobile (or desktop) site is a major factor in its ability to rank. See: http://moz.com/search-ranking-factors for more factors.