Free Marketing Campaign Response Cost and Return Calculator Tool

  • Why not share:
  • Social sharing button for Facebook
  • Social sharing button for Linkedin
  • Social sharing button for Twitter
  • Social sharing button for Googleplus
  • Social sharing button for Pinterest
Download free sms marketing excel response tool

Click the icon to download the FREE Excel Campaign Calculator

What response rate will you get from your Marketing Campaign?

I’m often asked about the relative differences between different marketing communication channels and which one might provide the best return.

Of course, there are many factors that have an effect on the success or failure of any campaign (list, creative, offer, etc.) but there are some well-respected organisations that conduct research on these things and publish ‘industry averages’.

To help you gauge a likely cost and return and compare the differences between SMS, Email, Telemarketing, Fax Marketing and Direct Mail I have built an Excel tool which gives you you the ability to change the parameters of the campaign and see the likely cost and return implications.

A quick video demo’ of how easily it works;


First, you enter how many people you’re going to contact, what is the cost per hour of your staff/agency running the campaign and the likely revenue you’d expect to earn from each response (averaged across all responses).

Excel tool to calculate marketing campaign response


The areas in green use industry standard figures for costs and response rates across the channels but you can amend these should you have more relevant figures for your industry sector. In particular, if you had a large direct mail campaign, you might want to up the printing costs.

Average response rates to marketing campaigns


The results are then calculated in the red area (do not change these cells). You will see the estimated total costs & revenue for the campaign and then the likely net revenue received by you.

A calculation of the marketing campaign results

I hope this will provide some ‘science’ behind making decisions on what type of marketing channel has the most likely chance of success for you.


The Excel Marketing Campaign Calculator is free to download (it’s in 97-2003 format so should work for most people).

Related articles

  1. Is SMS to Landlines effective as a Marketing tool?
    This is a question worth pondering for a moment for your business. As with all marketing/communication options there is never...
  2. How can you benefit from our free SMS keyword and shortcode text response system?
    Ever seen a TV Ad’ that says, “Text BROCHURE to 69888 for more details”? Why do they do this instead...
  3. Generate free QR Codes
    QR Codes are a great way to get response from your mobile marketing adverts and even from web sites. Although...
  4. The benefits of using Text Messaging vs Postal Services – Saving Money, Boosting Response & Going Green
    Are you still using the postal service for all your communications? Then, you’re in for some very good news indeed...
  5. How to nearly Double Advertising Response Rates
    How to double advertising response rates. Continue reading →...
  6. 5 winning ways to make your company’s Christmas sales sing along like a carol
    The Text Marketer creative team have been at it again, coming up with fabulous new ways for our customers to...
  7. Extract name and email address from Text Message autoresponses using Excel
    When using a text message response mechanic it is often good to ask for a name and an email address...
  8. Mobile Coupon Text Message Campaign Delivers 28 Per Cent Redemption Rate
    Coca Cola brand Sprite has just completed a 6-week Sell Your Mother mobile couponing campaign in Denmark. Sprite used web-based...
  9. How to use the Text Marketer Text Response system Using Short Code 88802
    Introduction This article explains how to use the incoming text feature or shortcode SMS part of your Text Marketer account....
  10. How RoughTrax increased sales by over 19% for next to nothing using Bulk SMS – could you?
    Further to our article, Top 5 Tips for increasing sales using Bulk SMS, one of our customers RoughTrax (a mail...