Monday, June 20, 2011

SQL : select between specific times but relative dates?

This is just a quick post in case any of my more technical readers ever need this solution.

An online friend of mine recently wrote a useful blog post on how to select rows between specific times but relative dates in SQL.

He uses MySQL, so if you are using SQL server, you may need to tweak the solution.


Sunday, June 19, 2011

10 Most and Least Retweeted Words

If you are trying to generate traffic using twitter, then you want to get retreated for 3 reasons;
1. Links that are re-tweeted more than twice car considered to valuable by search engines.
2. If someone with a lot of followers re-tweets your link you can get a lot of visitors from their followers.
3. Some people pipe their twitter feeds into other social networks or their blogs as feeds, this can also generate more visitors and perceived authority on search engines.

10 Most Retweeted Words

1. you
2. twitter
3. please 
4. retweet
5. post       
6. blog 
7. social
8. free 
9. media 
10. help  

10 Least Retweetable Words

1. game 
2. going 
3. haha    
4. lol 
5. but  
6. watching 
7. work  
8. home    
9. night  
10. bed   

From this we can see that it is better to talk to and about your target audience rather than to tweet about yourself. If you are talking to "me", then I am more likely to retweet you.

The word "PLEASE" is also very important. If you want to be retweeted, ask for it and be polite.

But wait there’s more...
If you enjoyed this post then you will probably enjoy the rest of the Using Twitter for SEO series