“How can I prove that marketing is impacting our bottom line?”
This is probably the most important question for the average marketer to answer. It’s literally the difference between keeping our jobs and being asked to either improve or leave. Today, we’ll review the process of valuing our business goals, then spreading that value across different marketing metrics. We’ll also look at applying those goals to Google Analytics™.
Watch this 10 minute video to see the step by step in a spreadsheet and Google Analytics:
Can’t see anything? Watch this video on YouTube.
Listen to the audio here:
Got a question for You Ask, I’ll Answer? Submit it here: http://www.christopherspenn.com/newsletter/you-ask-ill-answer/
Subscribe to my weekly newsletter: http://www.christopherspenn.com/newsletter
Please subscribe to my YouTube channel for more marketing and analytics videos! https://www.youtube.com/user/christopherspenn
The following transcript was generated by an AI. It may contain significant errors and is not a substitute for watching the video itself.
Today’s you asked my answer. Sandy asks, How can I prove that marketing is impacting our bottom line. I’m going to do a little screen cast you because this is going to require a little bit of math, all you need to spreadsheet nothing super fancy to prove that marketing is impacting the bottom line, you have to have visibility into the marketing mark at the bottom line. So let’s take a look at a sample set up. Now this is a sample marketing and sales funnel, you’ll want to substitute all this stuff for everything that you know you you have in your company. So if you are a b2c company if you’re a restaurant. If you are a tax firm, whatever the case may be. You want to set this up to be the different stages that you measure if you don’t measure these stages. That’s a prerequisite. So let’s look at an example. Let’s say we sell software software services subscription. Whatever, let’s say we closed 100 deals. We want 100 new customers and the value of a customer on an.
You will basis. Let’s say if it’s a 20, a month service times 12 months that’s240
per that’s the tuna 40 per deal okay now the total value then would be 100 customers times240 the annual fee. That’s 24,000.
So far so good, let’s uh let’s do a little format here make sure this is in currency so that it’s easy to read.
Okay. Now, in order for us to get 200 close deals our website or our software or our sales force or whatever has to have opportunity to call them at bats, whatever you want to call them. Let’s say we had 1000 at bats. Thus, the closing rate the closing rate between
one deals at at bats is going to be 100 divided by 1000 equals 100 to 1000. So that’s our, our ability to close.
How well can we close a deal. Let’s go ahead and make this a percentage.
So that, again, we’re on the same page
I actually let’s move that up one cell because I wanted to
put this year. So now, if the value per deal is
240 have closed deals to in 40, we’re going to multiply this
times this so every opportunity is worth24
right because 900 out of 1000 don’t close. They don’t turn into business we have
we have that there. And then, of course, we’re going to multiply this times this
so we have 1000 opportunity action side, it should be this times this
the value should still be 24,000
right because logically
you have 1000 pictures, a 24 per.
So let’s go ahead and just delete that math check ourselves now for
all those opportunities media marketing qualified leads to fuel them. That means people who have filled out a contact form raising hand requested a demo.
They have walked in our restaurant. They have done all these whatever it is that that gets somebody eventually to to do something. Let’s put it in 10,000 people have raised their hand of the last year. Yeah, we’re going to copy this math formula here, this is 10% from here to here because 9000 people chose not to do business with us. And then we’re going to copy this here
and now we see every marketing qualified lead is worth202
and 40 cents. Let’s go ahead and make sure this is a currency as well. Okay, now prospects I people who sign up for our mailing list to sign up for email, subscribe to our blog. We have contact information on them but they have not raised a hand. They have not said yes, I want to potentially buy something from it. So let’s make that 100,000.
And again, copy and paste.
So 24 sets. So if we were using say Google Analytics.
I’m going to go to switch over to my Google Analytics account. If someone fills out a
just subscribe to my newsletter subscription. For example,
I would say, you know, they are worth 24 cents, because that’s that’s what their value is worth. Now we can take this up another level. What if we took said okay, we now have
that many website visitors right
can copy and paste. So every website visitors worth about two cents. Again, if we were to do the math and multiply across we would still get that same 24,000
in value, we know that would be you know that to be the case, but each stage gets progressively smaller and smaller and value. So if, for example, we worked at the company where we did not have direct line of sight into sales. For example, if.
You are say Energizer if you are you as a company, never sell direct to the consumer you sell through distributors resellers and retail outlets. Right. You cannot buy something from energize you have to go to Walmart or Target or wherever to buy Energizer batteries so you may not necessarily have some of these phases, but you do have the ability to compute visitors to your website and you could do a similar calculation like this to figure out what’s the value of that visitor. Now if you want to go up in even one more level to say let’s let’s do a lot of social media right let’s do social media and we have an audience of a million people or 10 million people in social media right and we only get 10% as people to the website, the value of those people is very, very small,
it would be you know point 000 to four again if you’re if I was still to multiply squats would still be24,000.
this means that I can compute and count.
The value of any stage based on the final stage and the and the conversions that happened between them. That’s supposed. For example, this would number was 2000 right.
This would mean that this stage here prospects was the most broken stagers I had a lot of prospects, but it couldn’t get them to raise their hands as a marketer, obviously I can now figure out while this is going to be a tough challenge to fix.
But it also means that the value here has changed so now this you know leads are worth more opportunities with more but then prospects are worth a little bit less so we can you would use that in Google Analytics update that data. This is also tells me it is this phase of the process that I need to focus my marketing or my sales efforts are my business emphasis on to restore this back to normalcy. Right. So if that was the case and then this was the case and then
now look at how quickly the values change these were 10%.
words but this is 2%. Whoo, and visitors really worth very, very little half a penny and we can see of course with fewer deals. We have less revenue. So I would encourage you to build this spreadsheet for yourself. This is how you determine the impact of marketing on the bottom line because you do this calculation. Maybe you update your Google Analytics goals once a quarter or once a month but by doing it this way, you could say I can now forecast based on everything that’s happening and sales all the way down to revenue what the impact of marketing is it I know if I if my prospects are worth five cents each. And I drove 10,000
fewer prospects this month I know I contributed 50 or 500 less to the company’s bottom line and obviously that’s a bad thing. Right.
Likewise, if you try something new and you get a flood of new prospects, but they don’t convert very well like here then, you know, man.
Even that we drove a lot of prospects. They were less valuable say we couldn’t convert them. And so the impact the bottom line was still not great. So that’s how you do this. That’s how you build these very simple spreadsheet again nothing complex no super crazy math here but then putting it into Google Analytics gives you the ability to then see the impact across the board. So I’m just going to pop in real quick here and to acquisition. We’re going to go to all traffic. I’m going to go to source medium. Now I have ecommerce setup so Google automatically tracks the value of
of sales in addition to everything else. It’s good to January one by having e commerce plus lead generation value said, and I can now see per channel hey this channel is helping me drive700
revenue this child’s driving $69. We have no let’s go ahead and sort by here and then get to further on channels for the down Hey Twitter combine these two are both Twitter is driving more.
Revenue actually then my email. Wow. Okay, I know I need to up my game with Twitter, Facebook,
right, not so much there because LinkedIn. If you add up LinkedIn his his double almost Facebook, the value Facebook. So
by having these goal value set based on is very simple spreadsheet and whatever however far down you can measure the further down you can measure inside Google Analytics, the better. So if you can measure marketing qualified leads through form fills or you can measure sales through enhanced e commerce, you’re going to get better and better, more precise numbers. That’s how you prove the value of marketing how you prove that marketing is impacting the bottom line. Great question. Sandy hope this tutorial is helpful to you and I look forward to talking to you soon. Please subscribe to the blog, subscribe to the newsletter and subscribe to the YouTube channel for more videos like. Thanks.
You might also enjoy:
- How to Start Your Public Speaking Career
- Google Analytics 4 or Bust: Lessons from Google Marketing Live 2021
- The Year of the Yin Metal Ox
- Four Requirements of Great Marketing Data Visualization
- How To Break Down Marketing KPIs
Want to read more like this from Christopher Penn? Get updates here:
Get your copy of AI For Marketers