Universal Search & Video For Small Business
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 = 135 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 = 'video search its ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (135,'video search its engine google business pat created universal blog content web videos hiring without searching pro professionally interactive mediums ','business video search universal ') on duplicate key update date = now(), body = 'video search its engine google business pat created universal blog content web videos hiring without searching pro professionally interactive mediums ', title = 'business video search universal '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 135 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 = 135
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 135
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 = 'video search its ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (135,'video search its engine google business pat created universal blog content web videos hiring without searching pro professionally interactive mediums ','business video search universal ') on duplicate key update date = now(), body = 'video search its engine google business pat created universal blog content web videos hiring without searching pro professionally interactive mediums ', title = 'business video search universal '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 135
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 135
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 = 'video search its ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (135,'video search its engine google business pat created universal blog content web videos hiring without searching pro professionally interactive mediums ','business video search universal ') on duplicate key update date = now(), body = 'video search its engine google business pat created universal blog content web videos hiring without searching pro professionally interactive mediums ', title = 'business video search universal '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 135
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 135, 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 = 135 )
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 = 135 )
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 != '135') 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 (135,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 = 135 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
Video, video, video. It’s everywhere, it’s increasing and it can even better your search engine results. With engines pushing more results from videos, blogs and other web elements … not just web pages, you’re going to increase your opportunities to win business from Google, Yahoo and the likes. Then consider the benefits of video to broadcast content versus standard text and graphics.
Pat Schaber of The Lonely Marketer highlighted a video produced by a chiropractor on a specific type of treatment. This self made video has resulted in one client already for the Doc and thousands of views on Google. The bottom line is that good information (content) that was presented through video, then found by a consumer in Google’s universal search results, landed new business. You can’t argue with that.
Maybe it’s time for you to think about how video can benefit your users and now even your search engine results.
Pat points out that the video was easily created without hiring a pro … but I do want to point out that professionally created videos can be used across many mediums (interactive cd-roms, website, expos, office displays, tv or cable ads), so you really do get your money’s worth and more.
If you need a bit more info on what Universal Search entails, try these blog posts from Search Engine Land and The Top Rank Blog. Below is an example of video in the results when searching David Letterman:
No related posts.
Posted on October 24th, 2007 by Jeff Wagner
Filed under: search, small business, video
If you like what you're reading, please subscribe to this blog.
Aaron,
Great point about the professional video production. I hadn’t thought about the multiple uses. There is alot of potential there!
-Pat
Aaron, you’re absolutely right on all counts. Video, Images, Text AND Audio are going to take up more and more of your search results.
In fact, if you use Ask.com, they provide what I believe is a great peak into the future of search results display.
I’m about to comment on Video Quality, as I think it’s often assumed that the postage-stamp size of YouTube vids will do justice. Just not so. They CAN work, but there are many reasons to create quality video with good storytelling. More on that shortly.
best,
Mark Alan Effinger
http://www.RichContent.com
Pat- Had to get my 2 cents in for the value of our services.
Mark- Thanks for the comment. I’m a minimal ASK user currently but I am enjoying their ad campaign on TV and radio. Maybe I’ll have to increase my efforts there. I’m 100% with you as well on the video quality aspect … I’ll stay tuned for you dropping a post on that.
Hi Aaron,
Yes, the Ask.com campaign is definitely more popular than their site activity… but they’re getting there.
If Google would just provide a CSS style button you could click to get ASK.com type visuals… Hmmm… sounds like a Firefox plugin (if anyone is listening…;-)
Here’s the post referencing your comments above. Let me know if you see things the same (keep in mind we could go MUCH deeper down the rabbit hole of SEO-SEM, but we also have a fast-growing business to run here…;-)
Have a great week!
Doh! The link: http://www.richcontent.com/universal_search/2007/10/spiders-vs-eyeb.html