Digital marketing budgeting and costing approaches spreadsheet

Costings spreadsheets to help you create online marketing budgets

How will these  budgeting spreadsheets help me?

These templates are designed for marketing agency team members who create estimates / costings for either existing client online marketing projects and campaigns or for new business proposals.  Depending on the size and shape of the agency they can be used by Project Managers who pull an estimate together, or an Account Manager or the Agency owner (particularly in micro or freelance consultant agencies).

They are also designed to be useful for client­-side marketers to understand agency costing models to get more value from their agencies and to prepare their own budgets for internal approval.

What does the template include?

This template is a Microsoft Excel spreadsheet with two workbook-based estimating templates:

1. Top-level project charging fees template. Use this spreadsheet to create an overall online marketing budget based on the cost of team members working on activities defined in separate tabs including website, email, display, production, retainers, media and content strategy.

2. Detailed project costing examples template. Use this spreadsheet to create a more accurate budget based on the fees for different team members at each phase of a project.

How do I use these worksheets?

You can add your own agency day or hour rates as applicable and liaise with specialists in your teams (e.g Studio Manager, Head of Creative, Technical Lead) to reach a consensus on how long each task is likely to take.

Available to
Expert members
Learn more

What our members say

Just to let you know that it was a bittersweet experience signing up to the Smart Insights platform, as I’ve been running a design/digital agency for 6 years now, and finding all of the valuable resources you have on there has highlighted how little I actually know!

Managing Director, Marketing Agency

Smart Insights has helped us take the right decision on a variety of occasions and we actively use its content to justify our marketing initiatives and spend.

Joao da Costa, Marketing Officer at Southbank International School

Smart Insights is one of the best digital ‘tools’ on the internet today. It has been a great asset as a channel of advice and insight, helping me to deliver an all-encompassing digital strategy.

Jennifer Law, E-Communications Manager, National Pharmacy Association

Get access to this advice now by joining as an Expert member

Plus access 100s of resources in our Digital Marketing Library to Plan, Manage and Optimize your marketing:

  • In-depth Ebooks
  • Online training
  • How to videos
  • Marketing templates
Feedback Form
Feedback Form