Email Marketing Offers: Happy Birthday!
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 = 62 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 = 'birthday offer gi]
insert into wp_yarpp_keyword_cache (ID,body,title) values (62,'birthday offer give email free burrito getting offers grill lookout ruby tuesdays goal party co people consumer isnt plans options ','birthday happy offers marketing email ') on duplicate key update date = now(), body = 'birthday offer give email free burrito getting offers grill lookout ruby tuesdays goal party co people consumer isnt plans options ', title = 'birthday happy offers marketing email '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 62 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 = 62
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 62
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 = 'birthday offer gi]
insert into wp_yarpp_keyword_cache (ID,body,title) values (62,'birthday offer give email free burrito getting offers grill lookout ruby tuesdays goal party co people consumer isnt plans options ','birthday happy offers marketing email ') on duplicate key update date = now(), body = 'birthday offer give email free burrito getting offers grill lookout ruby tuesdays goal party co people consumer isnt plans options ', title = 'birthday happy offers marketing email '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 62
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 62
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 = 'birthday offer gi]
insert into wp_yarpp_keyword_cache (ID,body,title) values (62,'birthday offer give email free burrito getting offers grill lookout ruby tuesdays goal party co people consumer isnt plans options ','birthday happy offers marketing email ') on duplicate key update date = now(), body = 'birthday offer give email free burrito getting offers grill lookout ruby tuesdays goal party co people consumer isnt plans options ', title = 'birthday happy offers marketing email '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 62
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 62, 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 = 62 )
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 = 62 )
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 != '62') 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 (62,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 = 62 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I had the privilege of getting older this past weekend, turning 33 on Cinco De Mayo. Part of anyone’s birthday, no matter how old you are, is getting presents … and some come by email marketing. My email inbox starting seeing "Happy Birthday!" offers at the end of April right up until the day of my birthday. I have probably joined about 10 different restaurant’s e-clubs over the years and I thought I would share with you some of the offers I received and give some tips to those that failed to get me and praise those that will.
- Ruby Tuesdays – Enjoy a free chocolate tallcake, expires 5/12
- Qdoba Mexican Grill – Free Burrito, expires 5/12
- The Lookout Bar & Grill – free $10 meal, only valid on b-day
- Domino’s – $10 large Brooklyn style or Philly Pizza – No expiration
Out of these four offers, only one is getting used. I will be going to Qdoba today and enjoying a chicken burrito on them. What could the other three have done to win me over … and more importantly make their birthday offer more attractive to me?
1. Give some options – I’m a not a dessert guy so Ruby Tuesday’s is out. Make sure you give your consumer some flexiblity. Isn’t the best gift something they want? Don’t force your latest product or marketing pitch down my throat … but let me choose what I want to eat within a range. If Qdoba only offered a steak burrito, I would not be using there coupon either.
2. Flexible dates – Giving me only my birthday to come in just won’t work. Many people have birthday plans in advance and an email offer isn’t going to change them. If it had a two week window, I would definately have gone into the Lookout for lunch or dinner … and brought a co-worker or two.
3. Embrace the celebration – Most people have group plans on their birthday, with family, friends or co-workers. Why not entice the group? You can make the offer with options, one for the birthday person or an offer structured for a party of 4 or more. Everyone wins when a party of 8 walks in for lunch or dinner … all from one little email offer.
Overall: The goal should be to get me in the door, right? Too many limitations on time frame or items only reduces the chance of accomplishing the goal. While you can’t give away the farm, there is much to be gained from putting forth an offer that actually produces action. Maybe these marketers should simply ask themselves "What would get me from my inbox into this restaurant?" and then put that in their offer. Think like a consumer, then you’ll see a few more of them.
No related posts.
Posted on May 8th, 2007 by Jeff Wagner
Filed under: email marketing, marketing
If you like what you're reading, please subscribe to this blog.
Aaron- Good insight how companies should be really thinking their offers through. It is not just about giving customers something “free” but giving them something free that will entice them. Good blog!
Great post Aaron…and you’re exactly right. It’s funny because I get the same birthday offers from many different places as well.
I remember last year I received a free round of golf from an e-newsletter membership. The catch was that I had to use the round of golf on my birthday only. Well my birthday last year fell on a Tuesday so like most of us who have full-time jobs using a free round of golf on a weekday was pretty much impossible.
I sure would have loved to use that round on the weekend or give me a two week period to use the free round.
Just some simple things marketing departments over look when sending out their “FREE” offers.
I agree – nice insight! Qdoba would get my vote too. I have a birthday coming up – I had better get on their list quick.
Hi Aaron:
Just wanted to wish you a “Happy Birthday!” Enjoy your evening out. Thanks for the info. and help with Blog Site, etc.!
Barb Rodgers
Paramount Granite Company