Carter Cole LinkedInCarters Twitter PageCarter Cole on Facebook Carter Coles RSS

Friday, February 25, 2011

Anti-Abortion sites create a Google Bomb for murder

"Google Bombs" are when a number of sites all link to a certain site with exact anchor text (like carter) to cause the search giant to move a page onto a SERP where it would usually never show. Some of the bigger ones was choosing "im feeling lucky" for "French military victories" would show "did you mean French military defeats" but now anti-abortion e-protesters have caused abortion to show under murder SERP using SEO to make a statement about their political views. It will be interesting to see if Google takes any action to move it out of that position. When George Bush was Google bombed for "miserable failure" they removed the bomb so it may make a political statement based on what they do (or dont do)

Google Murder

Do you know of any other bombs that still exist?
Id love your help to get me to rank on the first page for "carter" that president is killing me with his domain authority. to help me drop a link for me on something you control
Isnt SEO funny? Ill let yall know when im ranking for "carter"

Thursday, February 24, 2011

Calculating business days between dates in SQL (a datediff function without weekends)

Im having to kinda roll my own simplest cms in the world for a customers contact script and they want to know how many business days are between the customer contact and when they responded. After some digging and optimization this is the DATEDIFF sql function I came up with that excludes weekends...


 @startdate as DATETIME,
 @enddate as DATETIME
 DECLARE @res int
SET @res = (DATEDIFF(dd, @startdate, @enddate) + 1)
  -(DATEDIFF(wk, @startdate, @enddate) * 2)
  -(CASE WHEN DATEPART(dw, @startdate) = 1 THEN 1 ELSE 0 END)
  -(CASE WHEN DATEPART(dw, @enddate) = 7 THEN 1 ELSE 0 END)
 RETURN @res


Ill add holiday support if i have time but it shouldn't be tough at all just select count of holidays that fall between the dates and subtract it from the total. Hope someone finds this usefull :)

Tuesday, February 22, 2011

Easy pdf download event tracking with jQuery and Google Analytics

Quick tip:
One of the things we wanted to add was a generic script to track pdf downloads as events in GA so i wrote this real quick... ill probably add in some other flavors based on prototype or another library later but for now this is a quick and easy post to try and get me in the habit of publishing again

you can easily modify this to also look for powerpoint or txt file whatever... just change the extension in the jQuery selector

Do you have any cool Google Analytics scripts you use around your sites? Id love to hear about some other ideas for what to track