What I Learned In Month One Of Blogging
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 = 32 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 = 'blogging its blog]
insert into wp_yarpp_keyword_cache (ID,body,title) values (32,'blogging its blog great prime fun client company blogs middle week ground ill skills traffic daily created days mention handbook ','blogging month learned ') on duplicate key update date = now(), body = 'blogging its blog great prime fun client company blogs middle week ground ill skills traffic daily created days mention handbook ', title = 'blogging month learned '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 32 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 = 32
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 32
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 = 'blogging its blog]
insert into wp_yarpp_keyword_cache (ID,body,title) values (32,'blogging its blog great prime fun client company blogs middle week ground ill skills traffic daily created days mention handbook ','blogging month learned ') on duplicate key update date = now(), body = 'blogging its blog great prime fun client company blogs middle week ground ill skills traffic daily created days mention handbook ', title = 'blogging month learned '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 32
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 32
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 = 'blogging its blog]
insert into wp_yarpp_keyword_cache (ID,body,title) values (32,'blogging its blog great prime fun client company blogs middle week ground ill skills traffic daily created days mention handbook ','blogging month learned ') on duplicate key update date = now(), body = 'blogging its blog great prime fun client company blogs middle week ground ill skills traffic daily created days mention handbook ', title = 'blogging month learned '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 32
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 32, 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 = 32 )
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 = 32 )
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 != '32') 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 (32,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 = 32 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I’ve been blogging for a couple of personal blogs for well over a year, but the Prime blog is very different with it’s company ties. One of the big reasons I finally jump started the Prime blog was every time I tried to encourage a client to start a blog they would ask "Are you blogging?". I was tired of replying "Ummm … no". It was time to practice what I preach.
So here are a few of the things I have learned blogging this past month, the good and the middle ground (nothing really bad to report).
The Good:
- It has fueled my creativity and writing skills.
- It has increased my reading of other blogs on web design, marketing, seo and blogging.
- The blog continues to grow in daily readers and subscribers (you should be one).
- The blog’s traffic has also grown the company website traffic by 15%.
- It’s honing my research skills by conducting "homework" on topics.
- It’s a great way to promote our great clients.
- It’s a great way to focus on our services and expertise.
- The power of RSS.
- Blogging has created some great connections with other professionals and bloggers.
The Middle:
- Time consumption. Blogging is one more thing to fit into my hectic schedule.
- Topic flow and selection. Some days it just flows and other days I have to hunt for ideas.
- An addiction to MyBlogLog and FeedBurner stats. It’s that quick fix for validation.
- Waiting for others at Prime to get addicted, so my load can be lightened.
- I feel compelled to post daily during the week as not to let anyone down that is expecting something from me.
I know that last one may have you laughing … but it’s true. One of the other great things I didn’t mention was that I created a "Prime Blog Handbook" that was a cross between a business plan, blogging tips and a "how to" guide for company blogging. It was a fun document to put together and I’m considering adding to it as it would be beneficial to other if tweaked a little.
So now when a client asks if we’re blogging … we most certainly are. The other good news is I have one client being set-up with a blog next week and another close to pulling the trigger. I’ll have fun helping them off the ground and seeing what they learn as well.
PS- Good luck Buffalo Bison! (’92 grad) in the Boys State Basketball Class 4A Championship game Saturday night. I’ll be at Target Center for the fun.)
No related posts.
Posted on March 23rd, 2007 by Jeff Wagner
Filed under: blogging
If you like what you're reading, please subscribe to this blog.
It is obvious that the positives outweigh the middles! I’m glad you decided to lead by example – I’m sure you’ll have many more clients blogging before you know it.
Thanks Char – Finding your blog is one of those “goods”.
[...] reaping the rewards of blogging. Aaron at Prime Advertising started blogging in February and I don’t think he will be looking back anytime soon. The layout and colors are beautiful, the content is helpful, and Aaron writes with a professional, [...]
[...] Link Menu: Blogs for 4.8.07 A few weeks ago I posted on what blogging had taught me in one month of typing away here at the Prime Blog. It was valuable for me to identify a few of the [...]
[...] user sessions last Wednesday, a new all time high for traffic at PrimeAdvertising.com.Blog-a-tizers:What I Learned ion Month One of BloggingUSA Today Redesign, Approach vs. AppearanceAnd the USA Today follow upMain Course:Stop Neglecting [...]
[...] their process understand more for what we’re trying to accomplish. I posted before on the positive impacts the blog has had in site traffic and also in growing our content [...]