WordPress database error: [Table 'wordpressredirection_404' already exists]
CREATE TABLE `wordpressredirection_404` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`url` varchar(255) NOT NULL DEFAULT '',
`agent` varchar(255) DEFAULT NULL,
`referrer` varchar(255) DEFAULT NULL,
`ip` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `created` (`created`),
KEY `url` (`url`),
KEY `ip` (`ip`,`id`),
KEY `referrer` (`referrer`)
) DEFAULT CHARACTER SET utf8;
When a business is evaluating launching an SMS marketing campaign, they sometimes get sticker-shock when looking at the monthly cost. Lets say you as a business owner think that you will have 500 mobile subscribers in your SMS campaign. Lets also say that you want to message those customers once per week. The math is done below.
That’s 2,000 messages per month! If you look at the monthly plans available at Tatango, this means you as a business owner will be paying $149/month. Seems like a good chunk of change huh? Not so if you do the math on what each redeeming customer will cost you.
What is a redeeming customer? A redeeming customer is someone that comes into your business to redeem the promotion you sent via text message. Well how the heck do you as a business owner calculate the cost per redeeming customer? It’s actually pretty easy.
In the formula below, use the following variables to calculate your cost per redeeming customer.
Not very good at math or just don’t want to wipe out your calculator? Don’t worry, I’ve done the math for you below at a cost per text message of $0.07. For a reference point, lets use one of our restaurant clients at Tatango (New York Pizza – See the case study below).
This client is experiencing up to a 10% SMS redemption rate on their SMS campaign. That means the cost per redeeming customer for New York Pizza is a mere seventy cents. To put it another way… This SMS campaign is only costing New York Pizza $0.70 per customer that comes into the restaurant. Doesn’t that sound better than $149/month? Sticker shock no longer an issue.