Posted April 7, 2007 at 08:04pm in
General
This post is pretty much worthless
Someone told me they would almost bet me 3 Xeon processors if I could get one of my pages or posts in the first page of Google under the search “bed and breakfast lexington virginia” with or without quotes I am guessing. Some of my pages do really well, like my post on the 2007 standard mileage deduction comes up #7 in Google. So this is my attempt to get a Bed and Breakfast post about Lexington Virginia in the first page of Google. The rest of this post is garbage to help get more words in.
Lexington, Virginia is located in South West, Virginia and is the home of many historical landmarks. The majority of Bed and Breakfasts in the area are in historic homes dated back before the Civil War. Staunton, Virginia which is North of Lexington also has a nice selection of historic homes that have taken on the role of a B&B. Many homes offer scenic views of the mountain ranges that surround Lexington.
Update: The post is coming in at #19 on google. That was on digital39.com not www.digital39.com, www has a higher page rank so I have made changes to try to get that in there instead. I would appreciate it if some of you could link to try and help me out. Thanks
Posted April 7, 2007 at 06:04am in
General
The other day I wrote a post complaining about the lovely issues I have been having with Dell and some of you may remember my post way back about my great experience with the Dell’s Customer Advocate Department. I received an email from Debby, who like John is a member of this department. She was very eager to help me resolve this issue, and we have shared a few emails back and forth. It sounds like my opinion is being taken seriously and she mentioned that this will be used for training and passed along to management. It looks like I will also be speaking with someone from DFS to resolve any issues that exist.
Despite my problems with Dell I have to give them a real thumbs up for their efforts in resolving these issues that have made some customers very unhappy. I think it was under 48 hours from the time I posted it till the time she contacted me, that is better return time than I get from companies I email directly. I sometimes wonder how many people with the 1800FP they have helped because that is one of my most popular keyword searches both from Google and on my site.
I hope some of you with Dell issues have had the opportunity to chat with someone from the Customer Advocate Department, I would have to say out of every company I have ever dealt with regardless of industry this department is hands down the best. That says a lot.
Posted April 7, 2007 at 02:04am in
Programming
UPDATE: Fixed error
If you are running WP-Shortstats it really doesn’t tell you what your monthly breakdown of unique visitors is or the yearly breakdown. In writing this I probably should have written the WP-Shortstats function to show this data, but I will do that sometime this weekend. For now here is the SQL that will break down your unique visitors by month and year. Enjoy
SELECT
COUNT(DISTINCT remote_ip) as rip,
MONTH(FROM_UNIXTIME(dt)) as umonth,
YEAR(FROM_UNIXTIME(dt)) as uyear
FROM
wp_ss_stats
GROUP BY
uyear,umonth;
-
SELECT
-
COUNT(DISTINCT remote_ip) AS rip,
-
MONTH(FROM_UNIXTIME(dt)) AS umonth,
-
YEAR(FROM_UNIXTIME(dt)) AS uyear
-
FROM
-
wp_ss_stats
-
GROUP BY
-
uyear,umonth;
+------+--------+-------+
| rip | umonth | uyear |
+------+--------+-------+
| 419 | 7 | 2006 |
| 365 | 8 | 2006 |
| 286 | 9 | 2006 |
| 623 | 10 | 2006 |
| 821 | 11 | 2006 |
| 773 | 12 | 2006 |
| 748 | 1 | 2007 |
| 2022 | 2 | 2007 |
| 4819 | 3 | 2007 |
| 1320 | 4 | 2007 |
+------+--------+-------+
10 rows in set (0.72 sec)