home | faq | join now | member login
  
Downloads | Business Plans | Discussion Forum | Testimonials | Contact Us

Become a member & get immediate access to all of our resources.


Take a Free Tour


Who Should Join
Contributors
Download Resources
Member Benefits
Open a Restaurant
Privacy Policy
Terms of Use
Member Comments
FAQ



Discussion Forum


Business & Financial
Business Plans
Restaurant Accounting
Food & Beverage
Staffing
Bar Management
Menu
Customer Service
Marketing
Social Media/Web 2.0
Startup & Growth
Technology



Online Seminars


RS&G Archives
Online Seminars
Audio Programs
Discussion Forum
Download Library
Industry Surveys
Inner Circle Resources
Recipe Mapping®
Spanish Resources
Success Focus Videos
Videos & Webcasts
My Membership
Help



Online Staff Training
Prime Cost Wizard



Visit our Online Store.




DOWNLOAD: Restaurant Marketing Promotion Tracking Template

Restaurants that gross over $1,000,000 annually report spending from 2-4% of revenue on marketing. The most successful ones track their promotions so they "know" which ones work and which don't. Tracking the success or failure of your promotions can help you to maximize your marketing dollars and prevent throwing your hard-earned cash down the drain by identifying the rate of return on your marketing investments.

The Marketing Promotion Tracking Template gives operators a tool to track the cost and response rate of individual marketing promotions. This Microsoft Excel® workbook is ready for use by any type of restaurant or bar operation without the need for extensive customization.

FEATURES -

  • Promotion Budget - Easy to use drop down lists for marketing expenses and vendors  make budget preparation quick and simple.

  • Zip Code Response - You can define up to 6 different zip codes for tracking the areas that give you your best responses.

  • Redemption Items - User-defined redemption items such as gift certificates or coupons can be set up to track the cost for each discount.

  • Cost of Sales Tracking - The average cost of sales for each discount is applied to your other promotion costs to give you a true cost of the promotion.

  • Most Popular Redemption Day - Entering the responses for each day provides the data needed to track which day of the week promotion items are being redeemed the most.

  • Profit Tracking - As you record your ongoing expenses and responses, the profit of the promotion is automatically recalculated.

  • ROI - The P-T-D Summary includes a Return on Investment calculation that compares the cost of the promotion to the gross profit of the associated sales incurred as a result of the response to the promotion.

  • Drop-down Lists - The Drop Down List feature eliminates the need for typing repetitive data when preparing a new promotion. Use the one-time set-up worksheet to define your own unique drop-down lists for Expenses, Vendors, Redemptions and Zip Codes

  • Step-by-Step Instructions - Get started right away by using the step by step instructions for setting up and using the Marketing Promotion Tracking Template.

 

Sample Report Page-

Restaurant Marketing Promotion Tracking Template
Restaurant Marketing Promotion Tracking Template
 




Printer-Friendly Format