What Are Your Website’s Resolutions for 2008?
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 157 and date > date_sub(now(),interval 600 minute)
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'website content s]
insert into wp_yarpp_keyword_cache (ID,body,title) values (157,'website content site 2008 resolution mind year keep stats offering users already goal analytics start websites maybe resolutions services yourself ','2008 resolutions website ') on duplicate key update date = now(), body = 'website content site 2008 resolution mind year keep stats offering users already goal analytics start websites maybe resolutions services yourself ', title = '2008 resolutions website '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 157 and ID != 0
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 157
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 157
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'website content s]
insert into wp_yarpp_keyword_cache (ID,body,title) values (157,'website content site 2008 resolution mind year keep stats offering users already goal analytics start websites maybe resolutions services yourself ','2008 resolutions website ') on duplicate key update date = now(), body = 'website content site 2008 resolution mind year keep stats offering users already goal analytics start websites maybe resolutions services yourself ', title = '2008 resolutions website '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 157
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 157
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'website content s]
insert into wp_yarpp_keyword_cache (ID,body,title) values (157,'website content site 2008 resolution mind year keep stats offering users already goal analytics start websites maybe resolutions services yourself ','2008 resolutions website ') on duplicate key update date = now(), body = 'website content site 2008 resolution mind year keep stats offering users already goal analytics start websites maybe resolutions services yourself ', title = '2008 resolutions website '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 157
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now()' at line 15]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 157, ID, (0+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 157 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 157 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '157') and post_date <= NOW() and post_password ='' and post_date > date_sub(now(), interval 12 month) and post_type IN ('post', 'page')
group by id
having score >= 2.5 order by score desc limit 5 on duplicate key update date = now()
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (157,0,0)
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_I]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_ID = 157 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
You might be already breaking the resolutions you set for yourself in 2008 or maybe you’re one of the few that always sees them to fruition, either way have you thought about your website’s resolutions for 2008?
Here is a list of three basic website resolutions you might have this coming year. No matter if you set just one, or make a list of 50, the most important point is to keep your website on your mind for how it can grow, evolve and succeed.
Website Resolution #1 – Web Stats / Analytics
For some their website’s stats are gold, and others have long forgotten how to even check them. There are patterns, successes, failures and opportunities logged in those stats so pay attention. If you haven’t looked in forever, make a goal to check monthly and start asking questions. If you’re already in there daily or weekly, find new ways to dig into your data, analyze, compare and try new ways to improve towards your goals. You may want to look into a better analytics program (we work with Urchin and Google Analytics). 2008 is the year to start valuing the truth behind your website.
Website Resolution #2 – New Content
Set a goal or specific dates for creating and adding new content to your website. So many small businesses forget to keep their latest happenings and offerings updated on the site and turn things stale. Create a committee to offer up quarterly ideas and implement them. Also keep in mind different types of content such as blogs, video and social websites will continue to add value. Your content should have a goal as well … what are you wanting users to do with your content? Develop content with a strategy in mind. If you can’t make changes to your website yourself, you can explore content management solutions. Maybe explore the services of a copywriter and get their valuable input. 2008 is the year to get new life into your website.
Website Resolution #3 – Usability
Make it easy. Don’t make them think. The mom test. Users of your website want to enjoy their visit. I’m not talking about offering drinks and snacks while they interact (if you do, please email me), but reducing frustration and increasing the answers they find. Make it easy by offering clear navigation and also making good use of internal links in your copy. Don’t make them guess where to find information by using clear site structure, offering a site search function, a site map and page names/headers that make sense. If you are struggling to address what might be a problem on your site, maybe take the time to survey your users and find out what they like, dislike or want to see. If that sounds too overwhelming, just ask your mom to click around your site. Chances are she’ll provide some basic feedback that will improve your sites usability.
The days of 2008 are already trickling away, so get out there and make a resolution or two for your website and follow through. If you need a little kick start, or even a big one, our web services can do the trick. Have a great 2008!
No related posts.
Posted on January 7th, 2008 by Jeff Wagner
Filed under: marketing, small business, web design
If you like what you're reading, please subscribe to this blog.
Leave a Reply