How to Measure Marketing ROI With Google Analytics and a Formula

How to Effectively Measure Marketing ROI With Google Analytics and a Simple Formula

Headline Analyzer

The blog post headline analyzer will score your overall headline quality and rate its ability to result in social shares, increased traffic, and SEO value.

Test every headline before you publish. Try the Headline Analyzer »

How to Effectively Measure Marketing ROI With Good Analytics and a Simple Formula

Your team works incredibly hard producing content that should produce positive results for your company, one of them being growth for your bottom line.

What good is all that work when you can’t prove that what you’re doing is actually having an effect on your ROI?

According to CMOSurvey.org, 37% of chief marketing officers feel confident they can prove their short-term ROI. That number drops to 31% when they’re asked if they could prove-long term ROI.

What’s the solution?

A marketing ROI formula that helps your team track costs and revenue generated from your projects and find a final ROI total.

When you read this chapter, you’ll learn how to:

  • Find the costs for your team to create a piece of content or campaign.
  • Use Google Analytics to calculate the amount of profit that your content or campaign makes.
  • Track and calculate your marketing costs versus profits with an Excel spreadsheet template to find your marketing ROI (MROI).

Download Graphic

Get Your Marketing ROI Template

Plus, join our email list to stay up to date.

 
 
 
 

By signing up, you agree to CoSchedule’s terms of service, end user agreement, and privacy policy; you are 16 years or older; and you will receive information from CoSchedule from which you can opt out at any time.

Success! Your download should start shortly. Or you can download it manually here.

It’s time to get started.

What is Marketing ROI?

The measurable revenue generated as a result of marketing activity.

Definition of marketing ROI

A Few Quick Assumptions Before You Start

Marketing ROI can be difficult to discuss in generalities because each marketing strategy is different and, therefore, requires an adjustment in recording strategy.

For the sake of this blog post, here are the assumptions you need to know:

  • Every customer conversion produces the same amount of revenue.
  • You’re publishing digital content, and you’ll measure your conversions through this content with Google Analytics Goals and Custom Reports.
  • If you’re publishing printed content, it drives back to an online medium from which you can measure your success.
  • This is the marketing ROI formula you’ll learn throughout this blog post: MROI = Revenue Generated From Content – Cost to Produce Content

If your team is operating outside these assumptions, you may need to adjust the formula in this post to fit your strategy specifically.

Find How Much Revenue a Page or Project Has Generated

The next step in finding your marketing ROI involves finding the amount of revenue your content generates.

This is a three-step process that helps your team track the content that is generating revenue. To find this out, open your Google Analytics account.

To start tracking your generated revenue, you first need to set up a goal in your Google Analytics account, as well as a custom report. Check out the following video for ways to get started.

In the video, you’ll notice the goal that was set up was a destination goal — meaning that when that web page is visited, Google counts it as a conversion.

Since it is assigned a value of $50, every time that URL surfaces, Google will add another $50 to your total revenue earned from the piece viewed immediately before the conversion.

In order to see that final total, you need to set up a Custom Report. This video shows you how to set one up.

The total that appears in the report is the total number of conversions and money that your content created. Depending on how long you want to track your conversions, you’ll need to adjust the date at the top of the report.

It’s important to note that you need to give each piece of content a fair chance to contribute to your team’s total MROI. That means that there needs to be a trial period where your team tracks the total amount of revenue that a piece of content generates in one time frame.

This could be anything from a week to 30 days to 6 months. Once your team selects a trial period, it needs to apply to every piece of content.

In your marketing ROI template, enter in the total made and how long you tracked the number of conversions your content made.

Determine How Much Each Project Will Cost Your Company to Create

The first step in your MROI process is finding how much your intended project is going to cost your company.

Why is this important?

In order to track your MROI accurately, you need to know the upfront costs first.

How can you determine those costs?

First, pick your project and decide what your team needs to do in order to complete it. For example, let’s say your team is publishing an e-book. Begin by making a list of everything that needs to be completed by the team in order to publish it. That list would look like:

Project steps for creating an ebook

  • E-book
  • Write
  • Edit
  • Design
  • Landing page
  • Write
  • Edit
  • Wireframe
  • Design
  • Code
  • Social campaign
  • Write
  • Edit
  • Design
  • Schedule
  • Advertising
  • Write
  • Edit
  • Design
  • Stage
  • Google Analytics set-up

Each of these steps involves a member of your team whose time is worth a certain amount of money. First, you need to determine who on your team is filling each role. For this example, you will need:

  • Writer
  • Editor
  • Designer
  • Design editor
  • Developer
  • Social media specialist
  • Ad specialist

Then, divide their yearly salary by 52. Divide that result by 40.

Price per hour = (Yearly salary/52 weeks)/40 hours per week.

Now you have the price per hour for each of your team members. The next thing you need to do is ask your team to estimate how long it will take them to complete their assigned tasks and record those hours.

For the example, let’s say your team gave the following answers:

  • Writer: four hours
  • Editor: two hours
  • Designer: four hours
  • Design editor: two hours
  • Developer: three hours
  • Social specialist: two hours
  • Ad specialist: two hours

Each hourly salary can then be added on to get your final cost total:

  • Writer: four hours at $15 per hour
  • Editor: two hours at $16 per hour
  • Designer: four hours at $16 dollars per hour
  • Design editor: two hours at $17 per hour
  • Development: three hours at $16 per hour
  • Social Specialist: two hours at $15 per hour
  • Ad Specialist: two hours at $15 per hour
  • Grand Total: $250

In the template you downloaded earlier, enter in each position that will contribute to your overall project, how many hours they spent working, and how much it costs per hour.

Calculating project cost

Calculate Your Marketing ROI

The final step of calculating your MROI is to use the following formula:

Total Revenue Generated From Content – Total Cost To Produce Content = MROI

For the example, your formula would look like:

$1,000 (Total Profit) – $250 (Total Cost) = MROI of $750

Your final MROI total can be entered into the last column of your MROI template.

Seems simple enough right? Some things that your team will need to think about or subtract from your final total:

  • Marketing tool cost
  • Overhead costs
    • Cost for customer service representatives
    • Costs to produce each product sold

It would make sense to think that if you avoid things, like tools, you wouldn’t have to take as much away from your total ROI, right?

However, if your tools end up saving your team more time and allow them to get their work done faster, your initial team cost lowers dramatically.

About the Author

Demand generation enthusiast, content marketing advocate, and team player. I love new ideas, strategy, and efficiency.

Download Graphic

Get Your Marketing ROI Template

CoSchedule Calendar CoSchedule Calendar

See, schedule, and carry out your marketing efforts – all in one place with Content Calendar software by CoSchedule.

The best way to organize your content.

Take 30 seconds to sign up for your Content Calendar. Start organizing all of your marketing in one place today.

Before you go...

Take a few seconds to sign up for your Content Calendar and start organizing and optimizing your marketing today.

Marketing Suite by CoSchedule Marketing Suite by CoSchedule

Complete more work, deliver high-quality projects on schedule, and prove your value with Marketing Suite by CoSchedule.

Deliver projects on time. Show your progress. Transform the way you work.

With Marketing Suite by CoSchedule, you’ll get more done in less time, be able to coordinate and communicate with your team, and consolidate your projects, and processes.

Before you go...

Do you want to see how you can optimize your organization with Marketing Suite by CoSchedule? Scheduling a demo with us is easy, fast, and completely free.