“What are the most important factors to consider in a digital marketing audit of performance?”
Pradeep’s question requires a deep dive into statistics and analytics to provide an answer. The reality is we have a massive buffet of questions we could ask of our data. We have more variables to consider than ever before, more data sources. To even understand what’s important, we need to dive into exploratory data analysis to narrow down what to look at.
In this video, watch as we explore just basic Twitter analytics. Today’s video is highly technical; the last 3 minutes, however, review the strategic implications of NOT doing exploratory data analysis.
Can’t see anything? Watch it on YouTube here.
Listen to the audio here:
- Got a question for You Ask, I’ll Answer? Submit it here!
- Subscribe to my weekly newsletter for more useful marketing tips.
- Find older episodes of You Ask, I Answer on my YouTube channel.
The software packages used in this video are:
What follows is an AI-generated transcript. The transcript may contain errors and is not a substitute for watching the video.
In today’s you asked I answer Friday asks, What are the most important factors to consider when auditing digital marketing performance. Well, this is a really good question. It’s a complicated question because we need to be able to understand our data and understand what we’re measuring first whether we’re measuring the right or wrong things. And then we can figure out what’s working, what’s not. We’re going to use the software. Our. This is a free open source software from
a number of different foundations. You can download it for free. I also recommend the our studio interface which is also free that makes it a little bit easier to use because it is very much a programming language. So let’s do this. We’re going to start by taking I’m gonna take some fun Twitter data right these are just my tweets. Let’s take a quick look at these tweets over the last 90 days and I know for be good. Well I care about reaching so that’s a metric that’s important to me. So we’re going to focus on that in in the here if you wanted to know what measures were really important.
I would strongly suggest doing this with Google Analytics data instead it because that’s certainly has greater connections to out to business results retweets not true. The first I’m going to do is look, see
I want to know
what data is missing, if any, so I use a function called plot missing and I don’t see anything here. This is all zero percent. So we’re looking pretty good there. Now there are a bunch of variables. If we open the variable selector factors we charge numeric non numeric things the text the handles and stuff like that,
for the purposes of understanding data and its impact we want to remove those for right now, unless they are
So if I had gone through and categorize tweets by their topics say social media or CEO, I could certainly use that to understand my data set, but in this case I have not done that and we’re not going to do that in this particular exercise. So let’s
go ahead and remove all of the non
variables close this up here we see we’ve gone from 40 to 19 down to 19 variables, there’s still some in here that are not helpful. So for example, tweet ID not really helpful. So I’m going to go ahead and get rid of that
and now we have a we have numeric data,
the first place I typically typically to start is in correlations, what are the correlations between these different variables. So we’ll do that and it says warning. There are standard deviations, and it is zero.
This means there’s some variables in here that are zeros, all the way down or close to zeros
and so we’re going to need a few libraries to do some exploration on this. Let’s go ahead and actually get
a whole bunch of these libraries and this just loads them up in the software.
Okay, so let’s look at our data set and see what variables are near zero or zeros. This one app opens app installs. I have no tweets involving either those no tweets that have an email and no tweets that have encouraged people to dial phone number. So those variables are, in fact,
causing problems into predictive model because
well, frankly, there’s zeros that they don’t if they don’t really inform anything. So I’m going to knock
those out. Now you can take a look at the
I’ll make this bigger what we’re looking for. Here’s retweets. What’s the biggest number where the biggest numbers that indicate this is definitely something that impacts retweets. So we see here point five eight for hashtags point 434 replies point seven for for likes that’s seems like it’s some important points six for user profile clicks point for for media views so interesting stuff there. If you go down this way here. Meet engagements point six what impressions, point, six, eight gauges point seven one engage right point 09 detail expands point
for to your all clicks point for now. Do you see the problem here engagement and engagement rate or actually sums of all these other activities. That’s a problem because that’s kind of throwing a wrench into our ability to understand what’s going on, those are those roll up numbers and not something that would help
us say let’s let’s just go get more engagement. Okay, well, what kind of engagements. Do we want link clicks to a permanent clicks what profile clicks what’s going on. So we’re going to take those two out because that’s really actually fairly unhelpful
what’s go rerun this our plot
animals zoom in here and now for retweets, we see impressions is his health is important, their meeting gauges somewhat important likes is important. Hashtag clicks is important
but when you look at these numbers, they’re all a good number of them are relatively close to have a really good answer. We’re here the answer. There’s not a just a handful of things. It’s basically says so far, do everything. Well, I don’t want so you do everything. So the next step we could take there’s a couple different ways we could do this, we could run a subsets to see what combination things randomly sub setting through and taking two or three or four or five variables of time testing them and against each other. However, there’s a machine learning technique called random forests, which does this very, very efficiently and so we’re going to use that I say I care about retweets and let’s use everything else is left in this in our data to focus on retweets. So let’s go ahead and run this
is going to run 5000 variations of every possible variable put together
and we see our error rate. They’re slowly declining looking good saying well to the consistent
and now let’s ask the vendor for us what’s things mattered
here. These two variables are the furthest right in this scoring system here impressions and likes followed by all the others. The others are important but these two really are the are the most important thing. So if I can get impressions and likes in my tweets that is likely to result in retweets. Now what do I do with this information. I now have
a hypothesis. Right. This is the beginning of the scientific method
and I’m going to go out and try and get more impressions and more likes on my tweets and see if that in fact results in more retweets so scientific method, we’ve formed a hypothesis. Now we go tested gather data, analyze it and then refine our hypothesis. See if in fact impressions that likes are a causal variables. So if we zoom back up to the 50,000, foot view pretty question, but how do we know what factors to consider when auditing or digital marketing. The answer is we don’t know
we have to first do analysis and this whole session here what we did with just retweets has what we call exploratory data analysis what’s in the data what’s in the box what data is good what data is not good, and then build a model
that has some predictive value to it impressions and likes and now we got we test that this model is not the answer. We cannot conclusively say without a
shadow of doubt that yep it’s all retweets. No, this is the start of the scientific method. We’ve now got a hypothesis we can go test, we have to test it. We have to verify it.
It may turn out that this is false, there may be something wrong with the data they may be something wrong. Conceptually, there may be some factors we are not considering but if you were to then pull in say your CRM data and your marketing automation data and your Google Analytics data and your social media and do this across all these and have a target
instead of retweets have a target of sales or leads or form films or whatever. Once you do that, then you’ll be able to understand it to have a bigger picture understanding of what actually matters to business audit your strategy that way. Do this and then test those competitions variables.
When you do this for
your digital marketing, there’s a good chance you’re going to have 50 6070 8090
you so you won’t necessarily do this every single day or even even once a month you’ll probably do this quarterly or maybe even semi annually,
doing this set of techniques
will help you get a better understanding of what you should be testing next to drive the results you want. And that’s how
you do in a digital marketing oddities you have to do you have to take in all your data clean
understand it, analyze it and then form your hypothesis and begin your testing. So a great question for a deeper very complicated question that requires real analysis real analytics. If you don’t, if you’re just guess you’re just looking at at the prepackaged chart. It’s the common a lot of software packages and if you haven’t connected your marketing systems data together.
You’re not going to come up with even close to the right answer, you know, you’ve got to come up with a good question to ask when you’re doing you’re trying to figure out what’s wrong with the strategy. So
use are you can use Python two, you can use SMS or SPSS or whatever statistical language you prefer if you don’t have the capabilities. To do this, go and find someone who does go and hire a firm of some kind and agency, a person to do this for you so that you can then develop sound hypotheses, because otherwise you’re just guessing and that’s going to lead to bad outcomes. As always, my company bring interesting insights. Does this stuff. So please feel free to get in touch if this is of interest to you if not enjoy the video please subscribe to the YouTube channel and the newsletter and I’ll talk to you soon. Take care.
You might also enjoy:
- Unsolicited "Embargoed" Press Releases Are Absurd
- You Ask, I Answer: Best Language for Marketing Data Science, R or Python?
- Six Types of Marketing Demand Generation
- Marketers, Stop Panicking About Apple Mail Privacy Protection
- The Power of Analogy in Marketing Communications
Want to read more like this from Christopher Penn? Get updates here:
Get your copy of AI For Marketers