Marketing Communications Budget by demandmetric

VIEWS: 5,605 PAGES: 5

More Info
									                                                                                         Marketing Communications Budget Template

Instructions

Use this tool to set and track your marketing communications budget.


1. In the "Marcomm Budget" tab, record your budget categories and allocated budgets.


2. Each month, track your spending by inserting the actual amount of money spent for each category.


3. View the automatically generated Dashboard charts in the "Actual vs Budget", "Spending Summary" and "Budget Category Breakdown" tabs.
                                                                                                                                                                                    Marketing Communications Budget Template

Marcomm Budget
                                                           Year To Date       Budget
Channel                                    Total Budget                                  % Remaining      Jan         Feb         Mar         Apr         May         Jun          Jul        Aug         Sep         Oct         Nov         Dec
                                                              Spend          Remaining

Public Relations                             $20,000          $7,000           $13,000      65%          $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000

Content Marketing                           $150,000         $120,000          $30,000      20%          $50,000     $10,000       $0        $10,000       $0        $50,000       $0

Advertising (print)                         $100,000          $35,000          $65,000      65%          $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000

Advertising (online)                        $200,000          $28,000         $172,000      86%          $4,000      $4,000      $4,000      $4,000      $4,000      $4,000      $4,000

Events & Sponsorships                        $75,000          $40,000          $35,000      47%          $5,000        $0        $15,000       $0          $0        $20,000       $0

Social Media                                $100,000          $52,500          $47,500      48%          $7,500      $7,500      $7,500      $7,500      $7,500      $7,500      $7,500

Mobile                                       $50,000          $40,000          $10,000      20%          $20,000       $0          $0          $0          $0          $0        $20,000

Marketing Automation/Email                  $100,000          $42,000          $58,000      58%          $6,000      $6,000      $6,000      $6,000      $6,000      $6,000      $6,000

SEO/Website                                  $50,000          $28,000          $22,000      44%          $4,000      $4,000      $4,000      $4,000      $4,000      $4,000      $4,000

Internal Communications/Sales Enablement    $100,000          $40,000          $60,000      60%          $5,000      $5,000      $5,000      $10,000     $5,000      $5,000      $5,000

Totals                                     $945,000        $432,500          $512,500       54%         $107,500    $42,500     $47,500     $47,500     $32,500     $102,500    $52,500        $0          $0          $0          $0          $0

                                                                Cumulative Spend                        $107,500    $150,000    $197,500    $245,000    $277,500    $380,000    $432,500    $432,500    $432,500    $432,500    $432,500    $432,500

                                                          Total Budget Allocation                      ########### ########### ########### ########### ########### ########### ########### ########### ########### ########### ########### ###########
                                             Actual Spend vs Budget
                                            Year to Date Spend       Budget

$250,000



                                           $200,000
$200,000



                     $150,000
$150,000



                                $100,000                               $100,000             $100,000             $100,000
$100,000
                                                           $75,000

                                                                                  $50,000              $50,000
 $50,000

           $20,000


     $0
                             Spending by Month
                             Spending by Month                                                                  Total Cumulative Spend

                                                                                                                      Cumulative Spend          Total Budget
$120,000
                                                                                       $1,000,000

                                                                                        $900,000
$100,000
                                                                                        $800,000

 $80,000                                                                                $700,000

                                                                                        $600,000
 $60,000                                                                                $500,000

                                                                                        $400,000
 $40,000
                                                                                        $300,000

                                                                                        $200,000
 $20,000
                                                                                        $100,000

     $0                                                                                       $0
           Jan   Feb   Mar    Apr    May     Jun   Jul   Aug   Sep   Oct   Nov   Dec                Jan   Feb   Mar   Apr    May    Jun   Jul   Aug   Sep      Oct   Nov   Dec
                            Allocated Budget                                                                          Year to Date Spend


                               $20,000
                                                            Public Relations                                            $7,000                   Public Relations
                $100,000                                                                                 $40,000
                                         $150,000
                                                            Content Marketing                                                                    Content Marketing
      $50,000                                                                              $28,000

                                                            Advertising (print)                                                       $120,000   Advertising (print)

                                                            Advertising (online)                                                                 Advertising (online)
$100,000
                                                                                     $42,000
                                                    $100,000 Events & Sponsorships                                                               Events & Sponsorships

                                                            Social Media                                                                         Social Media
$50,000
                                                            Mobile                   $40,000                                                     Mobile

                                                            Marketing                                                                  $35,000   Marketing
                                                            Automation/Email                                                                     Automation/Email
  $100,000
                                                            SEO/Website                                                                          SEO/Website
                                         $200,000
                                                                                               $52,500                           $28,000
                  $75,000                                   Internal                                                                             Internal
                                                                                                                   $40,000
                                                            Communications/Sales                                                                 Communications/Sales
                                                            Enablement                                                                           Enablement

								
To top