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.
Monday, June 20, 2011
Sunday, June 19, 2011
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
10 Least Retweetable Words
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