Social Media Marketing Budget Template by demandmetric

VIEWS: 170 PAGES: 5

More Info
									                                                                                                Social Media Marketing Budget Template

Instructions

Use this tool to set and track your social media budget.


1. In the "Social Media 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.
                                                                                                                                                                                                         Social Media Marketing Budget Template

Social Media Marketing Budget
                                                                         Year To Date       Budget
Expenses                                                 Total Budget                                  % Remaining      Jan         Feb         Mar         Apr         May         Jun          Jul        Aug         Sep         Oct         Nov         Dec
                                                                            Spend          Remaining

Video Production                                           $60,000          $45,000          $15,000      25%          $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000

Content Creation                                           $60,000          $45,000          $15,000      25%          $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000      $5,000

Graphic Design                                             $10,000          $2,500            $7,500      75%          $2,500        $0          $0          $0          $0          $0          $0          $0          $0

Technology - Social Media Listening (software license)     $6,000           $2,250            $3,750      63%           $250        $250        $250        $250        $250        $250        $250        $250        $250

Technology - Social CRM Connector (software license)       $10,000          $6,750            $3,250      33%           $750        $750        $750        $750        $750        $750        $750        $750        $750

Staff Costs                                                $60,000          $52,500           $7,500      13%          $7,500      $7,500      $7,500      $7,500      $7,500      $7,500      $7,500        $0          $0

Advertising                                                $15,000          $9,000            $6,000      40%          $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000

Promotions                                                 $10,000          $9,000            $1,000      10%          $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000      $1,000

Agency/Consulting Fees                                     $50,000          $28,000          $22,000      44%          $4,000      $4,000      $4,000      $4,000      $4,000      $4,000      $4,000        $0          $0

Microsite                                                  $10,000          $10,000               $0       0%            $0        $5,000      $5,000        $0          $0          $0          $0          $0          $0

Totals                                                   $291,000        $210,000           $81,000       28%         $27,000     $29,500     $29,500     $24,500     $24,500     $24,500     $24,500     $13,000     $13,000        $0          $0          $0

                                                                              Cumulative Spend                        $27,000     $56,500     $86,000     $110,500    $135,000    $159,500    $184,000    $197,000    $210,000    $210,000    $210,000    $210,000

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

$70,000

          $60,000   $60,000                                         $60,000
$60,000

                                                                                       
								
To top