Enter the budgets you know before the campaign (Pre ROI)   Investment in Advertising   Cost of Responses   Cost of Conversion   
 Developement & Production   Media investement   Range / Views / Print run   By Phone   Webform   mailpack   mailpack, premium and administration   
 
 
 Total             
                 
 Enter the budgets you know after the campaign (Post ROI)   Investment in Advertising   Cost of Responses   Cost of Conversion   
 Developement & Production   Media investement   Range / Views / Print run   By Phone   Webform   mailpack   mailpack, premium and administration   
 
 
 Total   
 
 Hurdle rate for ROI  20% enter the required minimum internal return rate for investments  
               
Enter your e-mail address  
You will receive a copy with the data entered here, by unsecured e-mail    
 
In every 'Tab' you can only enter data in de light green cells  
Enter Pre ROI estimates  Response %     Response #     conversion %     Conversion #     Total Media costs   Total response costs   Total conversion costs 
 By Phone   website   By Phone   website   By Phone   website   By Phone   website       
    Total   Total
Extra sales per order (assumed)   Total   Total
Extra profit per order (assumed)        Total ROMI 
       Total ROI 
Enter Post ROI actuals  Response %     Response #     conversion %     Conversion #     Total Media costs   Total response costs   Total conversion costs 
 By Phone   website   By Phone   website   By Phone   website   By Phone   website       
    Total   Total
Extra sales per order (reality)   Total   Total
Extra profit per order (reality)        Total ROMI 
       Total ROI 
       
Note: in the ideal situation the numbers in the post ROI (light green cells) match the numbers in the Pre ROI. However this will most of the time not happen. So you can overwrite the numbers which are automatically copied here for your convenience.    
   
 Pre ROI forecasts 
 CPO forecast   Sales ROMI forecast   Profit ROI forecast 
Average
       
   Post ROMI actuals 
 CPO actual   Sales ROMI actual   Profit ROI actual 
Average
       
   Differences 
CPO Sales ROMI Profit ROI
Average
 
  Best score  
The required information explained  
input fields in every tab
Investment in Advertising
  Developement & Production How much do you have to invest to get the campaign developed and materials produced
  Media investement How much are you going to invest in media (print, RTV, Internet, out door, etc.)
  Range / Views / Print run How many will see your add
Cost of Responses
  By Phone How much does a response per phone cost you
  Webform How much does a response via the website cost you
Cost of Conversion
  mailpack How much does sending the mailpack cost that you send responders
  mailpack, premium and administration How much does the response package cost you to send out
Response %
   By Phone  What % will respond by phone: enter estimated in Pre vs calculated in Post
   website  What % will respond by web: enter estimated in Pre vs calculated in Post
Response #
   By Phone  What number will respond by Phone (Pre calculated and Post actual)
   website  What number will respond by Web (Pre calculated and Post actual)
conversion %
   By Phone  What % will buy over the phone: enter estimated in Pre vs calculated in Post
   website  What % will buy online: enter estimated in Pre vs calculated in Post
Conversion #
   By Phone  What number will buy over the Phone: Pre calculated and Post actual
   website  What number will buy online: Pre calculated and Post actual
 Total Media costs   Autosum 
 Total response costs   Autosum 
 Total conversion costs   Autosum 
         
 Note: The main differences in data for Pre and Post campaign information is: 
 Pre campaign information consists of estimates, budget from agency's proposals and % made up, best guess or based on experiences. 
 Post campaing information constist of actuals, invoices from agencies and numbers as measured