Monday, September 29, 2014

Same domain, completely different sites - how come?

KFMA - is a radio station here in Austin. As I just listened to some music, and wanted to learn what it was, I tried to access their site.

1. kfma.org in chrome - result is a redirect to this, same result for www.kfma.org:



So far, so good - or not, because that does not look like the radio station.










Thinking my memory might have tricked me, I google and see this, with big surprise, because that's what I typed and got the Korean site. How come?














I click through, and get this result - the site I wanted to see.

Funny, though, that's the url that I used earlier, which forwarded me to the other site, but this time, coming from Google it works.

How is that possible? Wrong entry in some DNS? And why is Google sending me to the 'right' site, and not to the Korean? Do they actually use IP addresses rather than domains?




Friday, September 5, 2014

Backlink Analysis - Tools Insights: Compare backlink domains from Google, Majestic Seo and Bing


Do 3rd party link tools show the same backlinks like Google does?

As described in the last post - there is some small overlap between domains linking to support.dell.com from either Open Site Explorer and Google Webmaster tools.


How many domains are the same from each tool?

Bing webmaster tools is showing  31 domains that link to support.dell.com that Google Webmaster tools show, and Majesticseo is showing 0 ( and remember - Moz / open site explorer showed 43 domains).

Two annotations:

  1. Last year it was the opposite, Moz zero, Majestic some, Bing most overlap (nearly 5%). 
  2. Although Majestic seems not on spot, we used Majestic data + GWT (Google Webmaster tools) data to remove spam links and penalty - successfully. While I would expect the tools to show all links they possibly see (or even estimate like Majestic) - Google hides most backlink data. That might lead to a much larger overlap between the tools and GWT - we just don't see it.


The scripts are here - and because of the setup, the only line that needs to change to compare other tables is highlighted below:
create temporary table if not exists url_T  (select mid(Source_URL, (locate("//", Source_URL)+2)) as fullurl from support_moz_t );
create temporary table if not exists url_T  (select mid(Source_URL, (locate("//", Source_URL)+2)) as fullurl from supportdellcom_backlinks_t );
create temporary table if not exists url_T  (select mid(Source_URL, (locate("//", Source_URL)+2)) as fullurl from supportdellcom_bing_links_urls_t );
Yeah, I had to drop the tables, but prefer to do that rather than to overwrite - I find it easier to remember.

(Ping me and I'll share the scripts. )
Bookmark and Share