Join our free Digital Trends Summit 2022 - Jan 26th

Guides and Templates

Digital marketing budgeting and costing approaches spreadsheet

Costings spreadsheets to help you create online marketing budgets

How will these budgeting spreadsheets help me and my business?

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 and who are they for?

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.

Latest updates

This content is evergreen and has been updated to our newest branded document style to ease readability.

Resource Details

About the author

Mark Kelly

Mark KellyMark Kelly is a freelance digital marketing consultant working with agencies and direct clients of Mark Kelly digital consultancy. You can follow him on Twitter or connect on LinkedIn.



Business memebrship badge icon Professional Membership is required

Access this resource now

Professional members get full access to this and 16 other guides in the Agency growth and management Toolkit.

Learn more about Professional membership Already a Professional member? Login here Guide cover

The Digital marketing budgeting and costing approaches spreadsheet is included in the

Agency growth and management Toolkit

Business members can access this and 16 other guides and templates in this toolkit

Learn more about business membership Already a Business Member? Login here

...or take a look at the other Guides and Templates in this Toolkit

Look inside content

Trusted by marketers all over the world

Since 2009 our toolkits have helped thousands of marketers in over 170 countries to hit - and exceed - their targets.
Will you be next?

Globe illustration
Smart Insight partner logos over 165,000 consultants, agencies, entrepreneurs and SMB's in over 170 countries.

Get better results

Make your job easier

Tenfold improvement

Learn more about business membership
Smart insights logo