Viral Marketing Hit For Office Max – The Dancing Elf Yourself
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 = 146 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 = 'office viral emai]
insert into wp_yarpp_keyword_cache (ID,body,title) values (146,'office viral email fun dancing max local national tv internet news featured sites efforts prime department away customers maxs blogs ','dancing elf yourself max office marketing hit viral ') on duplicate key update date = now(), body = 'office viral email fun dancing max local national tv internet news featured sites efforts prime department away customers maxs blogs ', title = 'dancing elf yourself max office marketing hit viral '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 146 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 = 146
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 146
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 = 'office viral emai]
insert into wp_yarpp_keyword_cache (ID,body,title) values (146,'office viral email fun dancing max local national tv internet news featured sites efforts prime department away customers maxs blogs ','dancing elf yourself max office marketing hit viral ') on duplicate key update date = now(), body = 'office viral email fun dancing max local national tv internet news featured sites efforts prime department away customers maxs blogs ', title = 'dancing elf yourself max office marketing hit viral '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 146
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 146
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 = 'office viral emai]
insert into wp_yarpp_keyword_cache (ID,body,title) values (146,'office viral email fun dancing max local national tv internet news featured sites efforts prime department away customers maxs blogs ','dancing elf yourself max office marketing hit viral ') on duplicate key update date = now(), body = 'office viral email fun dancing max local national tv internet news featured sites efforts prime department away customers maxs blogs ', title = 'dancing elf yourself max office marketing hit viral '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 146
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 146, 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 = 146 )
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 = 146 )
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 != '146') 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 (146,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 = 146 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
Office Max has made splash with their Elf Yourself viral campaign for the 2007 Holiday season (an encore performance). I think I have received 7 or 8 different emails from this site now with everything from my wife and I dancing to co-workers. Office Max created a very simple to use flash interface for uploading up to four photos, face cropping tools and the ability to email the link out to friends. You can see Allison, Stephanie and Alicia from the sales department here at Prime dancing away.
Office Max’s viral efforts here have also been featured on national and local TV, internet news sites, blogs, other mediums and of course have appeared in millions of email inboxes. Not a bad amount of bang for the buck. Lesson learned: Get creative, do more than just market with a "buy now" attitude and find a way to have some fun and give your customers some fun.
No related posts.
Posted on December 13th, 2007 by Jeff Wagner
Filed under: email marketing, internet, marketing
If you like what you're reading, please subscribe to this blog.
My family has already elfed itself. It is cute, creative, and a way for people to have some fun and laugh at themselves.
Aaron, you and your wife are tearing it up!
I sent the elf yourself greeting to a few friends out west that I don’t get a chance to talk to that much. It’s definitely a fun way to send holiday wishes…
I love the elves!!! Glad they’re back. I wish you could take your Elf video and turn them into flip books that you can then send to friends. Now THAT would be cool!
Great post!