Marketing Calculator by kellena97

VIEWS: 0 PAGES: 4

									                                                                               Marketing ROI Calculator


               Marketing campaign costs

Direct mail                                                               Reach                                  Radio spots                                 Reach
          Q1                                  $0.00                               0                                                  Q1       $0.00
          Q2                              $5,000.00                            5000                                                  Q2       $0.00
          Q3                                  $0.00                                                                                  Q3       $0.00
          Q4                              $5,000.00                            5000                                                  Q4       $0.00
Sub Total                                $10,000.00                                                              Sub Total                    $0.00



Television Spots                                                          Reach                                  Print Advertising                           Reach
          Q1                                   $0.00                                                                                 Q1        $0.00
          Q2                                   $0.00                                                                                 Q2    $2,250.00            20000
          Q3                                   $0.00                                                                                 Q3    $1,500.00            20000
          Q4                                   $0.00                                                                                 Q4    $2,250.00            20000
Sub Total                                      $0.00                                                             Sub Total                 $6,000.00



Networking/Trade Shows                                                    Reach                                  Search Engine Marketing                     Reach
          Q1                                $400.00                               500                                              Q1          $0.00                0
          Q2                                $400.00                               500                                              Q2      $2,000.00           100000
          Q3                                $100.00                               100                                              Q3      $2,000.00           100000
          Q4                                $400.00                               500                                              Q4      $2,000.00           100000
Sub Total                                 $1,300.00                                                              Sub Total                 $6,000.00



Total Annual Reach                                              371,600
     Q1      500
     Q2      125500
     Q3      120100
     Q4      125500

Total Marketing Costs                                        $23,300.00




               Anticipated response rate (%)

               Yearly rates                                                             Total Annual Reach              # of Prospects
               Direct Mail                                     0.1000%    x                             10,000                      10
               Radio                                           0.0000%    x                                -                         0
               Television                                      0.0000%    x                                -                         0
               Print                                           0.0500%    x                             60,000                      30
               Networking/Trade Shows                          1.0000%    x                              1,600                      16
               Search Engine Marketing                         0.0100%    x                            300,000                      30
               Sub Total                                         1.16%

                                                       Total Response Rate Across All Media                                       1.16%

               Total generated leads


               Antcipated response rates multiplied by total prospects                                                               86
               Cost per lead


                                                                                        Cost per lead                        $270.93
               Anticipated conversion rate (%)

               Percentage of prospects that will purchase
                                                                          Anticipated Conversion rate                            70.00%

               Actual Purchasers


                                                                          Total Purchasers                                           60
               Average purchase transaction ($)

               Average value per transaction
                                                                                        Average Value                          $2,500.00


               Total revenue from campaign ($)                                                                       $150,500.00

                                                                                        ROI                                  545.92%




                                                       Strategies for Success           Ste. 121 9a Street NE        Calgary, Alberta Canda (403) 212-0099
                                             Prospect Trends

                      140000
                                                      125,500.00                      125,500.00
                      120000
Number of Prospects




                                                                        120,100.00

                      100000
                      80000
                      60000
                      40000
                      20000
                           0        500.00
                               Q1                Q2                Q3                Q4
                                                   Quarters
       Yearly Response Rates



Search Engine       Direct Mail
  Marketing            12%
    35%



                       Print
                       35%

  Networking/Trad
     e Shows
                                  Radio   Television
       18%
                                   0%        0%

								
To top