Social Media Marketing Budget Template

Document Sample
Social Media Marketing Budget Template Powered By Docstoc
					                                                                                                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

                                                                                       
				
DOCUMENT INFO
Shared By:
Stats:
views:170
posted:6/8/2012
language:English
pages:5
Description: Your Problem You are trying to set and track your social media marketing budget. Our Solution Use this Microsoft Excel template to set and track your social media budget and then view 3 charts (actual vs budget, spend summary, category breakdown). Download our free Social Media Marketing Plan Methodology, which uses this tool to help you implement a Social Media Marketing Program that gets results. Key Benefits easy to use Excel format save 3 hours on formatting generates 3 charts automatically tracks social media budget month by month calculates year to date & cumulative spend Microsoft Excel Spreadsheet Estimated Time Required: 2 Hours Skills Required: Excel (Basic)
BUY THIS DOCUMENT NOW PRICE: $49.99 100% MONEY BACK GUARANTEED
PARTNER demandmetric.com
Demand Metric is a web-based consulting firm that researches business best practices, publishes concise information, and builds practical Microsoft Office tools & templates. Our members have access to over 250 Templates & Tools and 100 How To Guides that have been developed based on requests from over 1500 clients.