Got a Facebook budget but not sure how much traffic it’s going to get you? Or perhaps you know how much traffic you want to send to your website, but you don’t know how much it will cost? This spreadsheet calculates how much you may need to spend to reach your goals. It uses industry-based benchmarks as a starting point, but you can edit it with your real-world data to get a more accurate idea of the costs. Amazing!
This Excel spreadsheet is a template to help you project your social media advertising spend.
With easy colour-coded fields, you can update your own figures including your budget, expected CPC or CPM and site conversion rate.
The spreadsheet will tell you what budget you may expect to spend based on the figures and dynamically update when you enter new data. If you’re new to online advertising, industry standard benchmarks are pre-filled to give you some ideas to work with.
With six alternative calculators built into the spreadsheet, this calculates for you either:
a) Awareness ads – how many people will see your ad with the budget you have, based on CPM.
b) Awareness ads – how much your advertising budget should be for the amount of people you want to reach, based on CPM.
c) Traffic ads – how many people will visit your site with the ad budget you have, based on CPC.
d) Sales ads – how much your advertising budget should be for the amount of sales your would like on your site, based on CPC and your site conversion rates.
e) Sales ads – how many people are likely to purchase products on your site with the ad budget you have, based on CPC and your site conversion rates.
f) Traffic ads – how much your advertising budget should be for the amount of people you want to visit your site, based on CPC.
This is a simple tool to help you more accurately project your social media marketing budget and spend less time with maths, and more time running your business.
This is a tool you can create for yourself in Excel, but to save you time, this neato calculator is ready to go!
1 x Excel Spreadsheet download.
After you place your order you will be sent an email, with a link to download the document. It may go to your junk mail so please check carefully!
Last updated July 2017.
About Rachel Beaney
Rachel Beaney is an Australian freelance social media specialist with over a decade in digital media. She’s worked with global names like Microsoft, Samsung, News Corp and General Assembly, in addition to not-for-profits and government bodies. She loves helping clients solve their business needs with creative and data-driven solutions. Get in touch today to jump on a free consultation call to find out how Rachel can help you.