New month, come on, everyone! Now is the time for a new start. New email campaigns, blog posts and social media strategies are about to emerge.
But, have we forgotten something? After completing the activities of the previous month, we need to pause for one second to check which ones are valid and which ones are invalid. You can’t just say that last month’s event was “great”—because “great” doesn’t pay the bill.
If you can prove that your marketing activities really have an impact on your business, then you will have more opportunities. More budgets, potential employees to join, and more ideas into action. Sounds like every marketer’s dream, right?
So, how do you first find the right metrics to use, and secondly prove your marketing return on investment to your boss? Why, of course, there are monthly marketing report templates. Click here to download our comprehensively improved PowerPoint and Excel templates, Read on to learn how to calculate marketing ROI through Excel and use them in real life.
How to calculate the return on marketing investment
To calculate marketing ROI, use the following formula: (Sales Growth-Marketing Cost)/Marketing Cost = ROI. If you cannot directly attribute sales growth to marketing activities, you must calculate existing sales trends. Then the formula becomes: (Sales Growth-Average Organic Sales Growth-Marketing Cost) / Marketing Cost = ROI.
For example, if you have been running a $800 marketing campaign for three months, and you see an average monthly sales increase of 5%, while last month’s sales have increased by $10,000, then your ROI calculation can evaluate the trend: (10000-(.05*10000)-800)/800
In addition, if you are a HubSpot customer, you can Visit the ROI calculator Use the same formula programming in our program Customer relationship managementHowever, let us continue to analyze how it can be done for you in Excel with and without existing sales trends.
How to calculate return on investment in Excel
Entering formulas into Excel is a quick and easy way to solve any equation, and the return on investment can be calculated in a few seconds.For equations without pre-existing sales trends, you can easily insert a simple ROI equation in Excel, as shown below: (Sales Growth-Marketing Cost)/Marketing Cost
After you have collected the sales growth and market costs, insert the variables into their own rows or columns. When you are done, select a free cell to type the formula with your data.
After completing these steps, press “ENTER” and you will calculate your return on investment. If the formula does not automatically calculate it as a percentage, make sure to record the result by selecting the Home tab> Number> Percentage.
How to calculate the return on marketing investment
Using more factors-or more realistic results-to calculate your return on investment is not necessarily a tricky feat.
For example, during a 12-month event, your team may discover an existing sales trend that is growing organically and can use it to determine a more precise return on investment.Insert this variable along with the original factors and enter them using the following ROI equation: (Sales Growth-Average Organic Sales Growth-Marketing Cost)/Marketing Cost
To calculate the percentage, press “ENTER” and you will get a more accurate return on investment as the basis for future marketing decisions.
Now that we have reviewed a few examples, let’s take a look at how to use your data and how HubSpot resources can make your marketing reports a breeze.
What metrics should you track?
First of all, which indicators should you focus on first? Not all indicators are equal, if you want to attract the attention of your boss through this PowerPoint presentation, you will need to tell your story effectively through data.Click on our Marketing indicator template And get tips on how to combine marketing reports.
How to create your own marketing metrics report
So now you know what indicators you need, but how do you customize PowerPoint slides to suit your business? Following these four steps, you will have an engaging, accurate and concise slideshow to show to your boss.
2. Open Excel and fill in the indicators you want to track.
The equations and graphs will be automatically populated based on the indicators you add.
3. Copy the graphic and paste it into PowerPoint.
4. Customize your graphs and charts to suit your company’s theme.
After processing a bunch of numbers, you may need a creative break anyway. Click individual elements in the chart to customize them. If you really want to be interested in your speech, Check out these five simple PowerPoint tips.
5. Add relevant examples to back up your diagrams.
If you really want to explain the success that your marketing team has achieved in the past month, don’t forget to include a slide involving specific examples here or here. For example, if you have a blog post that attracts a large number of potential customers in a month, you can include this sample slide and some key points after the “Marketing Leads” slide. These specific examples add color to your presentation and justify the time spent on future projects.
ROI Excel template
Excel is one of the best tools to track and calculate the return on investment on a regular basis.
In the above collection of marketing report templates, you will be able to fill in the following (and more) to suit your company:
In this template, you can calculate your marketing scope. For example, you can calculate the reach of blogs, emails, or social media.
Then, the chart below will help you convert the data into a visual chart.
Using this template, you can calculate your traffic. This will include visits through multiple sources and channels, including paid traffic, direct traffic, and social media recommendations.
Then, the following figure will create a visualization of the data.
In this template, you can enter the number of potential customers generated by a marketing campaign.
In the image below, you can visualize your potential customers based on their source.
In this template, you can count your customers by traffic source. In the image below, you can visualize your customers.
5. Conversion rate
In this template, you can calculate the conversion rate by entering your information.
Track your marketing better in Excel
Excel is a tool designed to help you start your business. It is an organized way to track the success of your team. Make sure to make the most of it, who knows, in a few months, you may have a bigger budget or brand new marketers.
Editor’s note: This article was originally published in September 2013 and has been updated to be comprehensive.