Data-driven marketing has become an increasingly popular topic in the marketing industry. But it’s as easy to be overwhelmed by data as it is to utilize it to drive your marketing.
In Episode 2 of The Marketer as Philosopher: Become a Force for the Good, Flint McGlaughlin teaches how you can transform your data into wisdom. The CEO and Managing Director of MECLABS Institute (parent organization of MarketingExperiments) teaches viewers how to
- Use a simple but powerful spreadsheet tool that will help you tame your metrics (click here to download your free Data Pattern Analysis Tool)
- Simplify your marketing goals with just three ratios that any marketer can understand
- Treat these ratios as dials you can turn in the right combination and order to unlock transformational results
McGlaughlin uses real-world data from TenbyThree© — a unique nonprofit that sells products — to illustrate these points with a specific example. Since the organization is a nonprofit, it has allowed transparent sharing of its journey to increase sales. While engaging with the show, any insights you add that help to increase sales for TenbyThree will also do good by helping to reduce poverty for artisans throughout the world.
Here are some key points in the video:
- 3:47 An explanation of the math equation that powers the DPA tool
- 8:34 Four ways to tame your data
- 15:23 Maximize your ROI with this heuristic. Notice the importance of the ORDER of activities.
- 16:47 How to extract the predictive power of your data
- 20:04 Real-world Example: MECLABS analysts determined where revenue is being lost in TenbyThree’s nonprofit business using the DPA tool. Hint: We detected a problem in the psychology of the messaging on the product tags.
- 20:59 Now that the location of a major funnel leak has been identified, in the next episode we invite you to participate with us in optimizing the product tag to help plug the leak.
- 23:55 Three ways you can help…
Live Coaching Session with Flint McGlaughlin: The Data Pattern Analysis, 3 ways to turn info into insight – Thursday, August 20th, 2020 from 1 p.m. to 2 p.m. EDT
Data Pattern Analysis Tool — Free spreadsheet tool to help you tame your metrics
Infographic – Visual summary of the teachings from this
video will be available soon
How to Model Your Customer’s Mind: 60 pages of essential
tools and charts
– Download this free tool to see how you can leverage data to better understand
and serve your customer so you can achieve better results.
Conversion Sequence Heuristic – Review the conversion heuristic to prepare
for Episode 3
Sign up for the free MarketingExperiments newsletter to get notified when each episode goes live.
This transcript provided by GoTranscript:
Flint McGlaughlin: How would you translate this data into a step-by-step plan to grow the
business? Do you see any clues in this column? Where is the most significant
conversion opportunity? Can you detect any intriguing patterns? What about this
product tag? If the goal is to get you to visit the website how would you
improve its performance? How do these three numbers connect?
number is absurdly low.
Dani: You and I both.
answer to how is why.
Flint: We would achieve a triple win; high traffic, higher conversion, higher average customer spend. Marketer how can you transform your data into wisdom? How do we keep from being overwhelmed by the deluge of information flowing into our analytics program? Could there be powerful practical insights hiding in the undetected patterns of our silos reports. My name is Flint. This is episode two of our new series The Marketer as Philosopher, Become a force for the good.
In episode two we’re going to learn how to discover hidden opportunity
within our data. First, we’re going to give you, at no cost, a simple but
powerful spreadsheet tool that will help you tame your metrics. Next, you’re
going to learn to simplify your marketing with just three ratios. We call them
the three data dials. By the way, you don’t have to be a mathematician to
understand or use it. Three, you’re going to learn how to turn these dials in
the right combination and in the right order to unlock transformation results.
This requires us to reflect on three powerful insights. Let’s begin
with insight one. In data analysis, the way forward is back. It is 4:00 PM on a
Monday afternoon. The world is in crisis and so like many others, our meetings
are being conducted via video conference. It’s important to get to that
simplicity on the other side of complexity.
Dani: You and I both. [laughs] …
Theresa: All of the orders backed up. All of these just came in …
Flint: You’re muted Dani. You’re muted. Analysts from the MECLABS team are meeting with Theresa Carrington, the founder of Ten by Three. We are discussing the first in a series of tools that will be applied to Theresa’s challenge. This is the data pattern analysis, the DPA. It consists of at least a dozen tabs derived from data within Theresa’s metrics platform. All of this data was automatically imported from Google Analytics. There are a number of tabs but the two most important are the Funnel Analysis and the Three Data Dials. Marketer to help Theresa you’re going to learn how to think about your craft like a philosopher beneath your assumptions in reverse order from your revenue target back through your customer data then even further back into the heart of your message.
Speaker 3: We
engage past purchasers and get people to return to the site.
Dani: These are initially some of the pages that we’ll look at for initial testing.
Flint: If we
can turn these dials we can turn up your sales. We must capture the clarity of
the three data dials. Before we show you the dials in action we need to show
you a very simple math equation that powers their insights. You’ll notice RV=SU
x CR x AOV. RV is revenue. SU is select users, that’s the number of people who
encounter the opportunity. That definition is important when we test. CR is the
conversion rate, that’s the number of people who say yes. Average order value
that is the average customer spend.
The best way to learn the raw power of this simple equation is to push
it to extremes. Here’s a very simple example. If our revenue target is $50,000
then one person visits our site and they purchase a product for $50,000. You
can see that our conversion rate’s 100%. Our SU is 1 and our AOV is $50,000.
Now we all know that this scenario is unlikely so let’s take it further. By the
way, if you’re a mathematician and you say, “I’m bored with this. I know
about this,” stay with me. Before this episode is over we’re going to be
delving the data deeply for patterns.
Here is another example. If you had two people visit and your average
order value remained at $50,000. What would you need for a conversion rate? If
both people who visit and said yes you would have $100,000. That’s two times
your goal. It would only take one of those two people to buy. Only one of those
two people to say yes. The answer is 50%.
Here’s one more scenario. What if you had an average order value of $50
and a conversion rate of 10%. How many visits would you need? We’re solving for
SU. To get to $50,000 total with an average order value of 50 you would need
1,000 yeses. That’s 1,000 times 50. If 1 out of 10 people who encounter the
opportunity say yes, that’s 10% then you would need 10,000 users.
By the way, the three data dial does all of this calculation for you
and it helps you chart a critical path. Keep in mind that while we’ve used this
tool in very simple situations with startups we’ve used it with Fortune 10
companies. I’ve used it with one organization whose revenue was $138 billion.
We prioritized and exceeded our budget goals by carefully following the logic
that’s implied, that’s built-in to the simplicity of this tool. Stay with me.
Here is how it works. There are three dials. You should already be
familiar with the SU, the CR, and the AOV. Select users, conversion rate, and
average order. However, any change here is reflected in the incremental revenue
gains that you see at the top both annually and monthly. This is powerful
because it allows you to move those three ratios in combination to achieve the
most likely and most profitable way forward.
There is a basic calculation here for overall conversion and then for
more advanced work, there’s a calculation for step by step conversion. That is
improvements in each stage of the funnel. We’ve seen how the DPA works but how
can we use it to solve the financial challenges of Ten by Three? What does it
look like in practical application? How can we use it to prioritize our work
over the next several episodes?
These questions bring us to the next insight. Insight two: opportunity
is discovered through limitations. What am I saying? This statement seems
counterintuitive. What does it mean? The answer will become clear in the next
five minutes. Let’s look at this DPA with the actual Ten by Three numbers. We
know our goal is $100,000 but we’ve left that blank. We’re going to exceed that
by spinning the dials. We know that the current monthly traffic is 1,351,
that’s SU. We know that conversion rate is 1.27%. We know the average order
value is $112. Now, we understand these basic numbers, our task is to find the
optimal path forward. This task demands relentless prioritization. This
prioritization requires perspicuous clarity. This clarity requires a four-step
Throughout this series, we’re going to be helping Theresa and then teaching you transferable principles. Here are four that you should be applying right now to your own data. First of all, define the practical range of your dials, that is, separate the improbable from the possible. Number three, adjust your goals to the optimal settings. You’re going to see that power very soon. It’s remarkable. Number four, sequence your improvements for the highest impact. Now let’s apply principles one and two. What is the practical range of the three dials? How can we separate the improbable from the possible?
Average order value is $112. We have tested more than 20,000
treatments. From that experience, I’m going to suggest that it’s not likely
that this number could increase by more than 50% without changing the business
model. Achieving that gain would be difficult but what is the impact if we did?
This is where the DPA becomes so valuable. We plug in an increase. The range is
from $112 to $168 but we can see the maximum impact is only $11,000. We need
Let’s look at conversion. Conversion is 1.27%. Once again, experience
suggests that for an e-commerce site one would rarely see this number increase
by more than 100% and that would be a remarkable success. What is the impact if
we did? Again, in the DPA, we can see our range is from 1.27% to 2.54% but the
total impact, that’s if we maximize the dial is only $23,216. It’s not enough.
SU is 1,351. That’s 1,351 visits per month. Very low. This number could grow
exponentially. It could grow a hundredfold. It could grow more. It would be
hard but it would be possible.
Let’s follow the impact with the tool. We turn that dial. Our range is
1,351 to 14,858. What is the impact? $232,000 plus. Marketer, something should
start to emerge in your mind. What can we learn from this? Which of the three
ratios is holding us back? Which dial do we turn the most? If you answered
select users, traffic, then you are correct. You have separated the improbable
from the possible. With a big enough budget, you could buy a tenfold traffic
increase, and we don’t have that budget. Yet all the money in the world might
not be able to buy a tenfold conversion increase. Does this mean conversion is
important? It is incredibly important. We’re going to see. It does suggest that
we need to be realistic about how we turn the dials, how we set them for the
right combination. We need to be realistic so that we can chart the best path
forward. I’m going to share with you that optimal setting but before I do, I
want to take a break from the math.
It’s important to me that every marketer, whether you specialize in the
creative or you specialize in the analysis, that every marketer who wants to
make a difference can follow along and see how their talent can be applied.
Right now, I can tell you that before this episode is over, we’re going to
discover why the question I’m asking next could make all the difference for
thousands of families. There is.
I’m holding up a basket in my hand. Attached to is a product tag, a
label. Let’s assume the goal of this tag is to get people to visit the website
and connect with the artists. Marketer, what would you do to improve the
performance of this tag? Would you change the photograph? Would you change the
color? Would you change something about the call to action? Let’s go back to
three dials. How should we adjust our goals in view of the optimal settings?
Now, this is where we establish a framework to guide all of your marketing
activities. I’m going to take a very conserved approach. I’m going to suggest
that we only improve Average Order Value by 20% and Conversion by 25%. I
believe that number can be higher. Traffic is set for 500%. If that seems high,
remember the traffic is very low, so it doesn’t take very much to create a
In the right combination, we can see the impact on the financial
picture. Look at it. This puts us on track to exceed our goal of $100,000 by
$85,000. That is a healthy margin of error and more, if we fall short we can
spin one of the other dials to make up for it. For example, if we couldn’t
increase Average Order Value but we could increase Conversion, you might see
this. We hit the same number by simply adjusting the mix of the dials. As
simple as this might be for those of you that are experienced marketers in big
organizations, its clarity can guide every aspect of your resource planning.
We have to do it now so that we can guide our resources and plan the
next several weeks together so that we can help Theresa rescue these 3,500
small businesses. Watch us do it and help us do it. Not only will you learn,
but you’ll be making a major difference all over the world. In this way, you
adjust your ratios to dialing your marketing performance despite the inevitable
surprises that are sell any plan. It brings us to the fourth principle.
This fourth principle I can only touch lightly but it’s very important.
We learned it after doing an 18-month study. Sequence your improvements for the
highest impact. Now there’s a difference between the urgent and the important.
We have identified what’s important using steps one through three but step four
is about urgency, doing what must be done now. To do that, we can discipline
our activity to produce the highest return if we keep in mind the following
heuristic. Optimize the product in the presentation and in the channel.
Ultimately, you will make more money if you begin by optimizing the
value proposition of the offer, then optimizing the message in your marketing
collateral, and finally, optimizing the spend in your channels. If you do it in
a different order, you’re going to leave a great deal of money on the table.
We’re going to teach you much more about this in upcoming episodes. For now,
let’s admit that while approaching your data with these dials can produce a
central clarity, it does not produce actual sales. How can we translate this
clarity into rewarding results? Are there any hidden patterns in the Ten by
Three data that we could leverage immediately to sell more baskets?
These questions bring us to our final insight in today’s episode. Insight
three, the value of data is limited to its predictive power. It’s now time to
think about how to use other tabs within the DPA to produce impact. While there
are many ways we can achieve an increase in visits and some ways to achieve an
increase in Conversion, there may be a powerful solution for both just hiding
in the data. Challenge yourself with a riddle. Take a look at this table. Where
is the greatest opportunity and why?
Let me give you three principles that will help you extract the
predictive power of the data. Number one, do not seek to optimize webpages;
seek to optimize the sequence of thought. Number two, do not think of data as
digital bits; think of data as behavioral traces, as mind tracks. Number three,
do not look for numbers; look for dissonance in patterns. Please, marketer,
don’t let your attention fade just yet. We’re on the edge of a discovery that
could help rescue 3,500 small businesses. The families that depend upon them
are depending upon us. This is the moment where your powers, your craft can
truly make a difference. We’re about to be surprised. Carefully study the next
clip from Ten by Three. Think about the table we just reviewed and try to find
the connection to elements in this short video.
you watch the exchanges, they’re quite powerful. To see that human-to-human
connection, it’s getting to know one another on a human level. It’s how the
world change us.
African Woman 1: I was filled with so much love and beauty. [foreign language] I had to
you have a beautiful smile.
African Woman 2: [chuckles]
the women get their picture taken, it is also a very remarkable and very moving
moment because, in many cases, it is the first time their picture has ever been
taken. It’s the first time that they’ve ever seen a digital image of
consider these numbers from the DPA. Remember, we’re looking for dissonance.
For the 15-month period analyzed in the DPA, total website traffic is 20,261.
Total number of units sold through all channels is 59,817. Hold on a moment.
Something should already be puzzling you. Pay close attention, we’re close to
breakthrough insights. Total number of units sold on the website is just 1,280.
It is when you look on the top pages tab of the DPA that we can start to detect
dissonance in the patterns. In just two minutes of math, we’re going to find
something that could transform this entire operation. Stay close now. Pay close
The total number of visits to the artisan-lookup is 1,059. Can you
detect the dissonance? The answer to how is why? How can we drive more traffic?
How can we improve Conversion? How can we improve Average Customer Spend? Let’s
start with the why. Why is that number so low? Why are people behaving in that
way? Think about it. Here’s a simple subtraction problem to help clarify.
59,817, that’s total baskets sold, minus 1,280, that’s total basket sold on the
website. The answer is 58,537. Wait a second. Ten by Three sold 58,537 units
through their network of stores. That is 58,537 product tags that could be used
to get people to visit the website to look up the artists and who created the
product and interact and connect. Yet, wait for it, here’s the hidden
opportunity. Only 1,059 people visited the artisan-lookup page. That number is
absurdly low. Why is this so important? Because it’s also an absurdly rich
opportunity for you and I to make a difference.
If we start with this pattern dissonance and follow the mind tracks
back to the customer, we can detect the problem in the psychology of the
message. That can be fixed. Our lab has developed specific heuristics for
discerning the underlying psychology of a message. We’re going to teach those
to you in the next episode. We’re going to help you analyze this message, but
if we could optimize these labels to achieve a higher conversion rate we could
find a major source of free traffic and we could increase average customer
value because some of these people would place additional orders. Moreover, Ten
by Three would win a direct relationship with the customer something they don’t
have when the product’s purchased in a store. We would achieve a triple win.
High traffic, higher conversion, higher average customer spend.
This single insight could help us achieve our goal for Ten by Three. In
fact, you can see the power in these last two or three numbers we need to
review. If we could optimize the product tags so that 20% of the in-store
buyers came to the website and ordered again, we would drive $1,311,329 in new
sales. That’s a lot more than our goal of $100,000. But you say, “I don’t
know if 20% is practical. Let’s cut the number in half.” If we could
optimize the product tag so that 10% of the in-store buyers came to the website
and ordered again, we would drive $656,000 in new sales. You say, “That
seems pretty high,” it doesn’t to me. I’ve done this before, and I’ve
achieved much higher numbers. Let’s go to 5%. If we could optimize the product
tags so that 5% came back and purchased, we would still drive an additional
$327,000 in new sales. In one powerful move, we could solve the Ten by Three
financial challenge. We would achieve a triple lift; conversion, traffic,
average customer spend, and all without investing $1 more in marketing or
This is powerful. Marketer, this is where you can truly help. If we
stand together, we can win this revenue for Ten by Three. This is a way for you
to do something meaningful with your special skills. You have more power than
you realize. As we learn together through this series, your power to help
others only grows. As I have said from the beginning, you can learn and you can
help. Here’s what you can do now. We need to optimize this product tag. The
best way to do that is with the MECLABS Conversion Heuristic.
In the next episode, we will teach you step-by-step how to use this
tool, then we’re going to host a live YouTube session where you can share with
us your best thinking. In the meantime, three ways to help. One, we need to
reach critical mass with this program. With that, we’ll have enough people to
solve larger and larger problems, not just for Ten by Three but for other
groups. Please invite at least 10 like-minded marketers to watch the first two
episodes and join this new community. Two, visit this link to learn how to
apply the MECLABS Conversion Heuristic. This will help prepare you to make a
significant contribution during the next episode. It is, of course, free.
Three, visit Ten by Three. Purchase an authentic handcrafted product. Some of
you are already doing so. Theresa called me and said she noticed a small spike
in sales. Let’s give her a big spike in sales. The money will help us meet our
goal and the experience will help you make useful recommendations for improving
the checkout proceeds.
Remember, we are open to any of your ideas on how to drive traffic for
improved performance. Feel free to contact me at my personal email, I read
every one. email@example.com. Here’s what you can learn from this
episode. Download the simplified MECLABS data pattern analysis so that you can
use it to grow your own organization. It is free. It’s distributed under a
Creative Commons Licence. In addition, we have built a large infographic poster
that summarises everything I taught today. You can download it and use it to
keep these principles at the forefront of your thinking.
My name is Flint. Thank you for your trust. We’ll be back with more.
The post The Marketer as Philosopher Episode 2
The Data Pattern Analysis: 3 ways to turn info into insight appeared first on MarketingExperiments.