Friday, September 28, 2018

Old Dominion - Written in the Sand (Live [Audio])

Old Dominion - Written in the Sand (Live [Audio])
Listen to “Written In The Sand” from Old Dominion’s album, Happy Endings, available now: Apple Music: https://ift.tt/2JDrRBW Spotify: https://ift.tt/2sNeFUD iTunes: https://ift.tt/2sXTBdk Amazon Music: https://ift.tt/2sNeHMf Google: https://ift.tt/2sXDL2p All Retailers: https://ift.tt/2MhO9e4 Get To Know Old Dominion: Instagram: https://ift.tt/2sXJGUR Facebook: https://ift.tt/2sNIVhT Twitter: https://twitter.com/olddominion Website: https://ift.tt/1SG2ukw

Old Dominion - Written in the Sand (Live [Audio])

Old Dominion - Written in the Sand (Live [Audio])
Listen to “Written In The Sand” from Old Dominion’s album, Happy Endings, available now: Apple Music: https://ift.tt/2JDrRBW Spotify: https://ift.tt/2sNeFUD iTunes: https://ift.tt/2sXTBdk Amazon Music: https://ift.tt/2sNeHMf Google: https://ift.tt/2sXDL2p All Retailers: https://ift.tt/2MhO9e4 Get To Know Old Dominion: Instagram: https://ift.tt/2sXJGUR Facebook: https://ift.tt/2sNIVhT Twitter: https://twitter.com/olddominion Website: https://ift.tt/1SG2ukw

Surprising SEO A/B Test Results - Whiteboard Friday

Posted by willcritchlow

You can make all the tweaks and changes in the world, but how do you know they're the best choice for the site you're working on? Without data to support your hypotheses, it's hard to say. In this week's edition of Whiteboard Friday, Will Critchlow explains a bit about what A/B testing for SEO entails and describes some of the surprising results he's seen that prove you can't always trust your instinct in our industry.

Click on the whiteboard image above to open a high-resolution version in a new tab!

Video Transcription

Hi, everyone. Welcome to another British Whiteboard Friday. My name is Will Critchlow. I'm the founder and CEO at Distilled. At Distilled, one of the things that we've been working on recently is building an SEO A/B testing platform. It's called the ODN, the Optimization Delivery Network. We're now deployed on a bunch of big sites, and we've been running these SEO A/B tests for a little while. I want to tell you about some of the surprising results that we've seen.

What is SEO A/B testing?

We're going to link to some resources that will show you more about what SEO A/B testing is. But very quickly, the general principle is that you take a site section, so a bunch of pages that have a similar structure and layout and template and so forth, and you split those pages into control and variant, so a group of A pages and a group of B pages.

Then you make the change that you're hypothesizing is going to make a difference just to one of those groups of pages, and you leave the other set unchanged. Then, using your analytics data, you build a forecast of what would have happened to the variant pages if you hadn't made any changes to them, and you compare what actually happens to the forecast. Out of that you get some statistical confidence intervals, and you get to say, yes, this is an uplift, or there was no difference, or no, this hurt the performance of your site.

This is data that we've never really had in SEO before, because this is very different to running a controlled experiment in a kind of lab environment or on a test domain. This is in the wild, on real, actual, live websites. So let's get to the material. The first surprising result I want to talk about is based off some of the most basic advice that you've ever seen.

Result #1: Targeting higher-volume keywords can actually result in traffic drops

I've stood on stage and given this advice. I have recommended this stuff to clients. Probably you have too. You know that process where you do some keyword research and you find that there's one particular way of searching for whatever it is that you offer that has more search volume than the way that you're talking about it on your website right now, so higher search volume for a particular way of phrasing?

You make the recommendation, "Let's talk about this stuff on our website the way that people are searching for it. Let's put this kind of phrasing in our title and elsewhere on our pages." I've made those recommendations. You've probably made those recommendations. They don't always work. We've seen a few times now actually of testing this kind of process and seeing what are actually dramatic drops.

We saw up to 20-plus-percent drops in organic traffic after updating meta information in titles and so forth to target the more commonly-searched-for variant. Various different reasons for this. Maybe you end up with a worse click-through rate from the search results. So maybe you rank where you used to, but get a worse click-through rate. Maybe you improve your ranking for the higher volume target term and you move up a little bit, but you move down for the other one and the new one is more competitive.

So yes, you've moved up a little bit, but you're still out of the running, and so it's a net loss. Or maybe you end up ranking for fewer variations of key phrases on these pages. However it happens, you can't be certain that just putting the higher-volume keyword phrasing on your pages is going to perform better. So that's surprising result number one. Surprising result number two is possibly not that surprising, but pretty important I think.

Result #2: 30–40% of common tech audit recommendations make no difference

So this is that we see as many as 30% or 40% of the common recommendations in a classic tech audit make no difference. You do all of this work auditing the website. You follow SEO best practices. You find a thing that, in theory, makes the website better. You go and make the change. You test it.

Nothing, flatlines. You get the same performance as the forecast, as if you had made no change. This is a big deal because it's making these kinds of recommendations that damages trust with engineers and product teams. You're constantly asking them to do stuff. They feel like it's pointless. They do all this stuff, and there's no difference. That is what burns authority with engineering teams too often.

This is one of the reasons why we built the platform is that we can then take our 20 recommendations and hypotheses, test them all, find the 5 or 6 that move the needle, only go to the engineering team to build those ones, and that builds so much trust and relationship over time, and they get to work on stuff that moves the needle on the product side.

So the big deal there is really be a bit skeptical about some of this stuff. The best practices, at the limit, probably make a difference. If everything else is equal and you make that one tiny, little tweak to the alt attribute or a particular image somewhere deep on the page, if everything else had been equal, maybe that would have made the difference.

But is it going to move you up in a competitive ranking environment? That's what we need to be skeptical about.

Result #3: Many lessons don't generalize

So surprising result number three is: How many lessons do not generalize? We've seen this broadly across different sections on the same website, even different industries. Some of this is about the competitive dynamics of the industry.

Some of it is probably just the complexity of the ranking algorithm these days. But we see this in particular with things like this. Who's seen SEO text on a category page? Those kind of you've got all of your products, and then somebody says, "You know what? We need 200 or 250 words that mention our key phrase a bunch of times down at the bottom of the page." Sometimes, helpfully, your engineers will even put this in an SEO-text div for you.

So we see this pretty often, and we've tested removing it. We said, "You know what? No users are looking at this. We know that overstuffing the keyword on the page can be a negative ranking signal. I wonder if we'll do better if we just cut that div." So we remove it, and the first time we did it, plus 6% result. This was a good thing.

The pages are better without it. They're now ranking better. We're getting better performance. So we say, "You know what? We've learnt this lesson. You should remove this really low-quality text from the bottom of your category pages." But then we tested it on another site, and we see there's a drop, a small one admittedly, but it was helping on these particular pages.

So I think what that's just telling us is we need to be testing these recommendations every time. We need to be trying to build testing into our core methodologies, and I think this trend is only going to increase and continue, because the more complex the ranking algorithms get, the more machine learning is baked into it and it's not as deterministic as it used to be, and the more competitive the markets get, so the narrower the gap between you and your competitors, the less stable all this stuff is, the smaller differences there will be, and the bigger opportunity there will be for something that works in one place to be null or negative in another.

So I hope I have inspired you to check out some SEO A/B testing. We're going to link to some of the resources that describe how you do it, how you can do it yourself, and how you can build a program around this as well as some other of our case studies and lessons that we've learnt. But I hope you enjoyed this journey on surprising results from SEO A/B tests.

Resources:

Video transcription by Speechpad.com


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Wednesday, September 26, 2018

The E-Commerce Benchmark KPI Study: The Most Valuable Online Consumer Trend of 2018 Revealed

Posted by Alan_Coleman

The latest Wolfgang E-Commerce Report is now live. This study gives a comprehensive view of the state of digital marketing in retail and travel, allowing digital marketers to benchmark their 2018 performance and plan their 2019 strategy.

The study analyzes over 250 million website sessions and more than €500 million in online revenue. Google Analytics, new Facebook Analytics reports, and online surveys are used to glean insights.

Revenue volume correlations

One of the unique features of the study is its conversion correlation. All website metrics featured in the study are correlated with conversion success to reveal what the most successful websites do differently.

This year we've uncovered our strongest success correlation ever at 0.67! Just to give that figure context: normally, 0.2 is worth talking about and 0.3 is noteworthy. Not only is this correlation with success very strong, the insight itself is highly actionable and can become a pillar of your digital marketing strategy.

These are the top factors that correlated with revenue volume. You can see the other correlations in the full study.

Click to see a bigger version

  • Average pages per session (.37)
  • Average session length (.49)
  • Conversion rate by users (.41)
  • Number of sessions per user (.67)
  • Percentage of sessions from paid search (.25)

Average website engagement metrics

Number of sessions per user Average pages per session Average session duration Bounce rate Average page load time Average server response time
Retail 1.58 6 3min 18sec 38.04% 6.84 1.02
Multi-channel 1.51 6 3min 17sec 35.27% 6.83 1.08
Online-only 1.52 5 3min 14sec 43.80% 6.84 0.89
Travel 1.57 3 2min 34sec 44.14% 6.76 0.94
Overall 1.58 5 3min 1sec 41.26% 6.80 0.97

Above are the average website engagement metrics. You can see the average number of sessions per user is very low at 1.5 over 12 months. Anything a digital marketer can do to get this to 2, to 3, and to 4 makes for about the best digital marketing they can do.

At Wolfgang Digital, we’ve been witnessing this phenomenon at a micro-level for some time now. Many of our most successful campaigns of late have been focused on presenting the user with an evolving message which matures with each interaction across multiple media touchpoints.

Click through to the Wolfgang E-Commerce KPI Report in full to uncover dozens more insights, including:

  • Is a social media engagement more valuable than a website visit?
  • What's the true value of a share?
  • What’s the average conversion rate for online-only vs multi-channel retailers?
  • What’s the average order value for a hotel vs. tour operator?

Video Transcript

Today I want to talk to you about the most important online consumer trend in 2018. The story starts in a client meeting about four years ago, and we were meeting with a travel client. We got into a discussion about bounce rate and its implication on conversion rate. The client was asking us, "could we optimize our search and social campaigns to reduce bounce rate?", which is a perfectly valid question.

But we were wondering: Will we lower the rate of conversions? Are all bounces bad? As a result of this meeting, we said, "You know, we need a really scientific answer to that question about any of the website engagement metrics or any of the website channels and their influence on conversion." Out of that conversation, our E-Commerce KPI Report was born. We're now four years into it. (See previous years on the Moz Blog: 2015, 2016, 2017.)

The metric with the strongest correlation to conversions: Number of sessions per user

We've just released the 2019 E-Commerce KPI Report, and we have a standout finding, probably the strongest correlation we've ever seen between a website engagement metric and a website conversion metric. This is beautiful because we're all always optimizing for conversion metrics. But if you can isolate the engagement metrics which deliver, which are the money-making metrics, then you can be much more intelligent about how you create digital marketing campaigns.

The strongest correlation we've ever seen in this study is number of sessions per user, and the metric simply tells us on average how many times did your users visit your website. What we're learning here is any digital marketing you can do which makes that number increase is going to dramatically increase your conversions, your revenue success.

Change the focus of your campaigns

It's a beautiful metric to plan campaigns with because it changes the focus. We're not looking for a campaign that's a one-click wonder campaign. We're not looking for a campaign that it's one message delivered multiple times to the same user. Much more so, we're trying to create a journey, multiple touchpoints which deliver a user from their initial interaction through the purchase funnel, right through to conversion.

Create an itinerary of touchpoints along the searcher's journey

1. Research via Google

Let me give you an example. We started this with a story about a travel company. I'm just back from a swimming holiday in the west of Ireland. So let's say I have a fictional travel company. We'll call them Wolfgang Wild Swimming. I'm going to be a person who's researching a swimming holiday. So I'm going to go to Google first, and I'm going to search for swimming holidays in Ireland.

2. E-book download via remarketing

I'm going to go to the Wolfgang Wild Swimming web page, where I'm going to read a little bit about their offering. In doing that, I'm going to enter their Facebook audience. The next time I go to Facebook, they're now remarketing to me, and they'll be encouraging me to download their e-book, which is a guide to the best swimming spots in the wild west of Ireland. I'm going to volunteer my email to them to get access to the book. Then I'm going to spend a bit more time consuming their content and reading their book.

3. Email about a local offline event

A week later, I get an email from them, and they're having an event in my area. They're going for a swim in Dublin, one of my local spots in The Forty Foot, for example. I'm saying, "Well, I was going to go for a swim this weekend anyway. I might as well go with this group." I go to the swim where I can meet the tour guides. I can meet people who have been on it before. I'm now really close to making a purchase.

4. YouTube video content consumed via remarketing

Again, a week later, they have my email address, so they're targeting me on YouTube with videos of previous holidays. Now I'm watching video content. All of a sudden, Wolfgang Wild Swimming comes up. I'm now watching a video of a previous holiday, and I'm recognizing the instructors and the participants in the previous holidays. I'm really, really close to pressing Purchase on a holiday here. I'm on the phone to my friend saying, "I found the one. Let's book this."

Each interaction moves the consumer closer to purchase

I hope what you're seeing there is with each interaction, the Google search, the Facebook ad which led to an e-book download, the offline event, back online to the YouTube video, with each interaction I'm getting closer to the purchase.

You can imagine the conversion rate and the return on ad spend on each interaction increasing as we go. This is a really powerful message for us as digital marketers. When we're planning a campaign, we think about ourselves as though we're in the travel business too, and we're actually creating an itinerary. We're simply trying to create an itinerary of touchpoints that guide a searcher through awareness, interest, right through to action and making that purchase.

I think it's not just our study that tells us this is the truth. A lot of the best-performing campaigns we've been running we've seen this anecdotally, that every extra touchpoint increases the conversion rate. Really powerful insight, really useful for digital marketers when planning campaigns. This is just one of the many insights from our E-Commerce KPI Report. If you found that interesting, I'd urge you to go read the full report today.


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

It takes an army. The Mountain High Tour has been so much damn fun. Will be a sad day when it’s...


It takes an army. The Mountain High Tour has been so much damn fun. Will be a sad day when it’s over. Love every damn person in this photo.

(RSS generated with FetchRss)

It takes an army. The Mountain High Tour has been so much damn fun. Will be a sad day when it’s...


It takes an army. The Mountain High Tour has been so much damn fun. Will be a sad day when it’s over. Love every damn person in this photo.

(RSS generated with FetchRss)

Saturday, September 22, 2018

When @lespaulforum lets you borrow his 1959 Les Paul Burst worth more than your house and you’re...


When @lespaulforum lets you borrow his 1959 Les Paul Burst worth more than your house and you’re forever ruined because you’ll never play a guitar as good that one so you try to play as many notes as possible because there’s a damn good chance you’ll never have that opportunity again. Thanks Charlie!

(RSS generated with FetchRss)

When @lespaulforum lets you borrow his 1959 Les Paul Burst worth more than your house and you’re...


When @lespaulforum lets you borrow his 1959 Les Paul Burst worth more than your house and you’re forever ruined because you’ll never play a guitar as good that one so you try to play as many notes as possible because there’s a damn good chance you’ll never have that opportunity again. Thanks Charlie!

(RSS generated with FetchRss)

Friday, September 21, 2018

Spectator to Partner: Turn Your Clients into SEO Allies - Whiteboard Friday

Posted by KameronJenkins

Are your clients your allies in SEO, or are they passive spectators? Could they even be inadvertently working against you? A better understanding of expectations, goals, and strategy by everyone involved can improve your client relations, provide extra clarity, and reduce the number of times you're asked to "just SEO a site." In today's Whiteboard Friday, Kameron Jenkins outlines tactics you should know for getting clients and bosses excited about the SEO journey, as well as the risks involved in passivity.

Click on the whiteboard image above to open a high-resolution version in a new tab!

Video Transcription

Hey, everyone, and welcome to this week's edition of Whiteboard Friday. I am Kameron Jenkins, and I'm the SEO Wordsmith here at Moz. Today I'm going to be talking with you about how to turn your clients from spectators, passive spectators to someone who is proactively interested and an ally in your SEO journey.

So if you've ever heard someone come to you, maybe it's a client or maybe you're in-house and this is your boss saying this, and they say, "Just SEO my site," then this is definitely for you. A lot of times it can be really hard as an SEO to work on a site if you really aren't familiar with the business, what that client is doing, what they're all about, what their goals are. So I'm going to share with you some tactics for getting your clients and your boss excited about SEO and excited about the work that you're doing and some risks that can happen when you don't do that.

Tactics

So let's dive right in. All right, first we're going to talk about tactics.

1. Share news

The first tactic is to share news. In the SEO industry, things are changing all the time, so it's actually a really great tactic to keep yourself informed, but also to share that news with the client. So here's an example. Google My Business is now experimenting with a new video format for their post feature. So one thing that you can do is say, "Hey, client, I hear that Google is experimenting with this new format. They're using videos now. Would you like to try it?"

So that's really cool because it shows them that you're on top of things. It shows them that you're the expert and you're keeping your finger on the pulse of the industry. It also tells them that they're going to be a part of this new, cutting-edge technology, and that can get them really, really excited about the SEO work you're doing. So make sure to share news. I think that can be really, really valuable.

2. Outline your work

The next tip is to outline your work. This one seems really simple, but there is so much to say for telling a client what you're going to do, doing it, and then telling them that you did it. It's amazing what can happen when you just communicate with a client more. There have been plenty of situations where maybe I did less tangible work for a client one week, but because I talk to them more, they were more inclined to be happy with me and excited about the work I was doing.

It's also cool because when you tell a client ahead of time what you're going to do, it gives them time to get excited about, "Ooh, I can't wait to see what he or she is going to do next." So that's a really good tip for getting your clients excited about SEO.

3. Report results

Another thing is to report on your results. So, as SEOs, it can be really easy to say, hey, I added this page or I fixed these things or I updated this.

But if we detach it from the actual results, it doesn't really matter how much a client likes you or how much your boss likes you, there's always a risk that they could pull the plug on SEO because they just don't see the value that's coming from it. So that's an unfortunate reality, but there are tons of ways that you can show the value of SEO. One example is, "Hey, client, remember that page that we identified that was ranking on page two. We improved it. We made all of those updates we talked about, and now it's ranking on page one. So that's really exciting. We're seeing a lot of new traffic come from it.I'm wondering, are you seeing new calls, new leads, an uptick in any of those things as a result of that?"

So that's really good because it shows them what you did, the results from that, and then it kind of connects it to, "Hey, are you seeing any revenue, are you seeing new clients, new customers," things like that. So they're more inclined to see that what you're doing is making a real, tangible impact on actual revenue and their actual business goals.

4. Acknowledge and guide their ideas

This one is really, really important. It can be hard sometimes to marry best practices and customer service. So what I mean by that is there's one end of the pendulum where you are really focused on best practices. This is right. This is wrong. I know my SEO stuff. So when a client comes to you and they say, "Hey, can we try this?" and you go, "No, that's not best practices,"it can kind of shut them down. It doesn't get them involved in the SEO process. In fact, it just kind of makes them recoil and maybe they don't want to talk to you, and that's the exact opposite of what we want here. On the other end of that spectrum though, you have clients who say, "Hey, I really want to try this.I saw this article. I'm interested in this thing. Can you do it for my website?"

Maybe it's not the greatest idea SEO-wise. You're the SEO expert, and you see that and you go, "Mm, that's actually kind of scary. I don't think I want to do that." But because you're so focused on pleasing your client, you maybe do it anyway. So that's the opposite of what we want as well. We want to have a "no, but" mentality. So an example of that could be your client emails in and says, "Hey, I want to try this new thing."

You go, "Hey, I really like where your head is at. I like that you're thinking about things this way. I'm so glad you shared this with me. I tried this related thing before, and I think that would be actually a really good idea to employ on your website." So kind of shifting the conversation, but still bringing them along with you for that journey and guiding them to the correct conclusions. So that's another way to get them invested without shying them away from the SEO process.

Risks

So now that we've talked about those tactics, we're going to move on to the risks. These are things that could happen if you don't get your clients excited and invested in the SEO journey.

1. SEO becomes a checklist

When you don't know your client well enough to know what they're doing in the real world, what they're all about, the risk becomes you have to kind of just do site health stuff, so fiddling with meta tags, maybe you're changing some paragraphs around, maybe you're changing H1s, fixing 404s, things like that, things that are just objectively, "I can make this change, and I know it's good for site health."

But it's not proactive. It's not actually doing any SEO strategies. It's just cleanup work. If you just focus on cleanup work, that's really not an SEO strategy. That's just making sure your site isn't broken. As we all know, you need so much more than that to make sure that your client's site is ranking. So that's a risk.

If you don't know your clients, if they're not talking to you, or they're not excited about SEO, then really all you're left to do is fiddle with kind of technical stuff. As good as that can be to do, our jobs are way more fun than that. So communicate with your clients. Get them on board so that you can do proactive stuff and not just fiddling with little stuff.

2. SEO conflicts with business goals

So another risk is that SEO can conflict with business goals.

So say that you're an SEO. Your client is not talking to you. They're not really excited about stuff that you're doing. But you decide to move forward with proactive strategies anyway. So say I'm an SEO, and I identify this keyword. My client has this keyword. This is a related keyword. It can bring in a lot of good traffic. I've identified this good opportunity. All of the pages that are ranking on page one, they're not even that good. I could totally do better. So I'm going to proactively go, I'm going to build this page of content and put it on my client's site. Then what happens when they see that page of content and they go, "We don't even do that. We don't offer that product. We don't offer that service."

Oops. So that's really bad. What can happen is that, yes, you're being proactive, and that's great. But if you don't actually know what your client is doing, because they're not communicating with you, they're not really excited, you risk misaligning with their business goals and misrepresenting them. So that's a definite risk.

3. You miss out on PR opportunities

Another thing, you miss out on PR opportunities. So again, if your client is not talking to you, they're not excited enough to share what they're doing in the real world with you, you miss out on news like, "Hey, we're sponsoring this event,"or, "Hey, I was the featured expert on last night's news."

Those are all really, really good things that SEOs look for. We crave that information. We can totally use that to capitalize on it for SEO value. If we're not getting that from our clients, then we miss out on all those really, really cool PR opportunities. So a definite risk. We want those PR opportunities. We want to be able to use them.

4. Client controls the conversation

Next up, client controls the conversation. That's a definite risk that can happen. So if a client is not talking to you, a reason could be they don't really trust you yet. When they don't trust you, they tend to start to dictate. So maybe our client emails in.

A good example of this is, "Hey, add these 10 backlinks to my website." Or, "Hey, I need these five pages, and I need them now." Maybe they're not even actually bad suggestions. It's just the fact that the client is asking you to do that. So this is kind of tricky, because you want to communicate with your client. It's good that they're emailing in, but they're the ones at that point that are dictating the strategy. Whereas they should be communicating their vision, so hey, as a business owner, as a website owner, "This is my vision. This is my goal, and this is what I want."

As the SEO professional, you're receiving that information and taking it and making it into an SEO strategy that can actually be really, really beneficial for the client. So there's a huge difference between just being a task monkey and kind of transforming their vision into an SEO strategy that can really, really work for them. So that's a definite risk that can happen.

Excitement + partnership = better SEO campaigns

There's a lot of different things that can happen. These are just some examples of tactics that you can use and risks. If you have any examples of things that have worked for you in the past, I would love to hear about them. It's really good to information share. Success stories where maybe you got your client or your boss really bought into SEO, more so than just, "Hey, I'm spending money on it."

But, "Hey, I'm your partner in this. I'm your ally, and I'm going to give you all the information because I know that it's going to be mutually beneficial for us." So at the end here, excitement, partner, better SEO campaigns. This is going to be I believe a recipe for success to get your clients and your boss on board. Thanks again so much for watching this edition of Whiteboard Friday, and come back next week for another one.

Video transcription by Speechpad.com


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Wednesday, September 19, 2018

How to Improve Your Link Building Outreach Pipeline

Posted by John.Michael123

Link building is probably one of the most challenging pieces of your SEO efforts. Add multiple clients to the mix, and managing the link outreach process gets even tricker. When you’re in the thick of several outreach campaigns, it’s hard to know where to focus your efforts and which tactics will bring you the most return on your time and resources.

Three common questions are critical to understand at any point in your link campaign:

  • Do you need more link prospects?
  • Do you need to revise your email templates?
  • Do you need to follow up with prospects?

Without a proven way to analyze these questions, your link building efforts won’t be as efficient as they could be.

We put together a Google Sheets template to help you better manage your link building campaigns. The beauty of this template is that it allows for customization to better fit your workflow. You'll want to make a copy to get started with your own version.

Our link building workflow

We've been able to improve our efficiency via this template by following a simple workflow around acquiring new guest posts on industry-relevant websites. The first step is to actually go out and find prospects that could be potentially interested in a guest blog post. We will then record those opportunities into our template so that we can track our efforts and identify any area that isn’t performing well.

The next step is to make sure to update the status of the prospect when anything changes like sending an outreach email to the prospect or getting a reply from them. It’s critical to keep the spreadsheet as up to date as possible so that we have an accurate picture of our performance.

Once you've used this template for enough time and you've gathered enough data, you'll be able to predict how many link prospects you'll need to find in order to acquire each link based on your own response and conversion rates. This can be useful if you have specific goals around acquiring a certain number of links per month, as you'll get a better feel for how much prospecting you need to do to meet that link target number.

Using the link outreach template

The main purpose of this template is to give you a systematic way to analyze your outreach process so you can drill down into the biggest opportunities for improvement. There are several key features, starting with the Prospects tab.

The Prospects tab is the only one you will need to manually edit, and it houses all the potential link prospects uncovered in your researched. You'll want to fill in the cells for your prospect’s website URL;, and you can also add the Domain Authority of the website for outreach prioritization. For the website URL, I typically put in an example of a guest post that was done on that site or just the homepage if I can’t find a better page.

There’s also a corresponding status column, with the following five stages so you can keep track of where each prospect is in the outreach process.

Status 1: Need to Reach Out. Use this for when you initially find a prospect but have not taken any action yet.

Status 2: Email Sent. This is used as soon as you send your first outreach email.

Status 3: Received Response

Status 4: Topic Approved. Select this status after you get a response and your guest post topic has been approved (this may take a few emails). Whenever I see this status, I know to reach out to my content team so they can start writing.

Status 5: Link Acquired. Selecting this status will automatically add the website to your Won Link Opportunities Report.

The final thing to do here is record the date that a particular link was acquired and add the URL where the link resides. Filling in these columns automatically populates the “Won Link Opportunities” report so you can track all of the links you acquire throughout the lifetime of your campaign.

Link building progress reports

This template automatically creates two reports that I share with my clients on a monthly basis. These reports help us dial in our efforts and maximize the performance of our overall link building campaign.

Link Pipeline report

The Link Pipeline report is a snapshot of our overall link outreach campaign. It shows us how many prospects we have in our pipeline and what the conversion/response rates are of each stage of our outreach funnel.

How to analyze the Link Pipeline report

This report allows us to understand where we need to focus our efforts to maximize our campaign’s performance. If there aren't enough prospects at the top of the funnel, we know that we need to start looking for new link opportunities. If our contact vs. response rate is low, we know we need to test new email copy or email subject lines.

Won Link Opportunities

The Won Link Opportunities report lists out all the websites where a link has been officially landed. This is a great way to keep track of overall progress over time and to gauge performance against your link building goals.

Getting the most out of your link building campaigns

Organization is critical for maximizing your link building efforts and the return on the time you're spending. By knowing exactly which stage of your link building process is your lowest performing, you can dramatically increase your overall efficiency by targeting those areas that need the most improvement.

Make a copy of the template


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Friday, September 14, 2018

This kid for president (📷: @trudier)


This kid for president (📷: @trudier)

(RSS generated with FetchRss)

This kid for president (📷: @trudier)


This kid for president (📷: @trudier)

(RSS generated with FetchRss)

SEO Maturity: Evaluating Client Capabilities - Whiteboard Friday

Posted by HeatherPhysioc

Clients aren't always knowledgeable about SEO. That lack of understanding can result in roadblocks and delay the work you're trying to accomplish, but knowing your client's level of SEO maturity can help. In today's Whiteboard Friday, we welcome the brilliant Heather Physioc to expound upon the maturity models she's developed to help you diagnose your client's search maturity and remove blockers to your success.

Click on the whiteboard image above to open a high-resolution version in a new tab!

Video Transcription

What up, Moz fans? My name is Heather Physioc. I'm Director of the Discoverability Group at VML. We are in Kansas City. Global ad agency headquartered right in the middle of the map.

Today we're going to talk about how to diagnose the maturity of your SEO client. I don't mean emotional maturity. I mean maturity as it pertains to SEO capabilities, their ability to do the work, as well as their organizational search program maturity. Now a lot of times when a client signs a contract with us, we make the assumption that they're knowledgeable, they're motivated, they're bought in to do the search work.

So we go dumping all these recommendations in their lap, and we're trucking full speed ahead. But then we're surprised when we start hitting blockers and the work doesn't go live. I actually surveyed over 140 of our colleagues in the search industry, and they reported running into blockers, like low prioritization and buy-in for the work, limited technical resources for developers or budgeting for copywriters, low advocacy, high turnover, and any number of different things that stand in the way.

I didn't just ask about the problems. I asked about the solutions, and one of the tools that came out of that was the ability to diagnose the client's maturity. So a maturity model is intended to evaluate an organization's capability to continuously evolve in a practice. The point, the purpose of this is to understand where they stand today, where they want to go, and the steps it's going to take to get there.


The SEO Capabilities matrix

Let's talk about the SEO capabilities first, the technical ability to do the job.

Harmful

On the low end of the scale, a client may be engaging in spammy, outdated, or harmful SEO practices that are doing more harm than good.

Tactical

From there, they may be tactical. They're doing some super basic SEO, think title tags and meta description tags, but nothing earth-shattering is happening here, and it's not very strategic or aligned to brand goals.

Strategic

From there, the brand moves into the strategic phase. They're starting to align the work to goals. They're starting to become a little more search savvy. They're getting beyond the titles and metas, and they're more thorough with the work. While good stuff is happening here, it's not too advanced, and it still tends to be pretty siloed from the other disciplines.

Practice

From there, the organization might move into a practice. Search is starting to become a way of life here. They're getting significantly more advanced in their work. They're starting to connect the dots between those different channels. They're using data in smarter ways to drive their search strategy.

Culture

Then from there, maybe they're at a level of culture for their SEO capabilities. So search here is starting to become a part of their marketing DNA. They're integrating across practices. They're doing cutting edge. They're testing and innovating and improving their SEO implementation, and they're looking for the next big thing. But these groups know that they have to continually evolve as the industry evolves. So we don't just look at their whole SEO program and figure out where the client goes on the map.

✓ Data-driven

We actually break it down into a few pieces. First, data-driven. Is the organization using information and analytics and combining it with other sources even to make really smart marketing decisions?

✓ SEO for content

Next is content. Are they doing any SEO for content at all? Are they implementing some SEO basics, but only during and after publication? Or are they using search data to actually drive their editorial calendar alongside other data inputs, like social listening or web analytics?

✓ Mobility

From there, mobility. Do they have no mobile experience at all, or do they have a fully responsive and technically mobile friendly site, but they're not investing any more in that mobile optimization? Or are they a completely mobile-first mindset? Are they continuously iterating and improving in usability, speed, and content for their mobile users?

✓ Technical ability

Beyond that, we could look at how technically savvy they are. Do they have a lot of broken stuff, or are they on top of monitoring and maintaining their technical health and accessibility?

✓ On-page/off-page SEO

Then some standard SEO best practices here. Are they limited or advanced in on-page SEO, off-page SEO?

✓ Integrating across channels

Are they integrating across channels and not having search live in a silo?

✓ Adopting new technology

Are they adopting new technology as it pertains to search? Some clients have a very high appetite for this, but they chase after the shiny object.

Others have a high appetite and a high tolerance for risk, and they're making hard choices about which new technology to invest in as it pertains to their search program. You may also want to customize this maturity model and include things like local search or international search or e-commerce. But this is a great place to start. So this does a very good job of choosing which projects to begin with for a client, but it doesn't really get to the heart of why our work isn't getting implemented.


The Organizational Search Maturity matrix

I developed a second maturity model, and this one is more traditional and you see it across other industries as well. But this one focuses on the search program inside the organization. This is the squishy organizational stuff.

✓ People

This is people. Do they have the necessary talent within the organization or within their scope? That might not just mean SEOs. That means are they scoping appropriately for content and development needs?

✓ Process

What about process? Are they actually using a defined and continuously improving process for the inclusion of search? Now I don't mean step-by-step best practices for implementing a title tag. This isn't instructions or a tutorial. This is a process for including organic search experts at the right moments in the right projects.

✓ Planning

What about planning? A lot of times we find that clients are doing search very reactively and after the fact. We want to reach a point with an organization where it's preplanned, it's proactively included, and it's always aligned to brand, business, or campaign goals.

✓ Knowledge

Next is knowledge. We know that this industry is complicated. There are a lot of moving pieces. We want to know how knowledgeable is the organization about search. That doesn't necessarily mean how to do SEO, but perhaps the importance or the impact or the outcomes of it. How committed are they to learning more through reading or trainings or conferences? At the very least, the organization they're hiring to do search needs to be extraordinarily knowledgeable about it.

✓ Capacity

Then capacity. Do they have the prioritization within the organization? Are they budgeting appropriately? Do they have the resources and the means and the capacity to get the work done?

Initial

When we've evaluated a client against these criteria, we could find them in an initial phase where the program is very new, they're not doing any search at all...

Repeatable

...to repeatable, meaning they're starting to include it, but it's not super cohesive yet. They're not enforcing the process. They don't have super dedicated resources just yet.

Defined

Up into defined, where they actually are documenting their process. It's continuing to iterate and improve. They're becoming more knowledgeable. They're dedicating more resources. They're prioritizing it better.

Managed

We can move up into managed, where that's continuing to improve even further...

Optimized

...and into optimized. So again, this is where search programs are part of the organization's DNA. It's always included. They are always improving their process. They are maintaining or even increasing the talent that they have dedicated to the work. They're planning it smarter and better than ever before, and they have adequate capacity to keep iterating and growing in their search program.


With that, the steps to complete this process and figure out where your client falls on either of these maturity models, I want to be clear is not a one-sided exercise. This is not a situation where you're just punching numbers into a spreadsheet and the agency is grading the client and our job is done. This needs to be a conversation.

We need to invite stakeholders at multiple levels, both on the client side and on the agency side, or if you're in-house, just multiple levels within the organization, and we should ask for opinions from multiple perspectives to paint a more accurate picture of where the client stands today and agree on the steps that we need to take to move forward. When you do these maturity assessments, this isn't enough.

This is step one. This isn't a finish line. We need to be using this as a springboard for a dialogue to uncover their pain points or the obstacles that they run into, inside their organization, that are going to keep you from getting that work done. We need to have honest and frank conversations about the things we need to clear out of the way to do our best work. With that, I hope that you can try this out.

We've got a great article that we published on the Moz blog to get into more detail about how to implement this. But try it out in your organization or with your client and let us know. Peer review this and help us make it better, because this is intended to be a living process that evolves as our industry does.

Video transcription by Speechpad.com


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Tuesday, September 11, 2018

Visualizing Time: A Project Management How-To Using Google Sheets

Posted by R0bin_L0rd

The short version of this post: Project management is a vital part of our job as marketers, but planning and visualizing projects over time is hard, so I’ve created a set of Google Sheets to make that work easier for you.

I’ve found this system helpful in a number of ways, so I’m sharing my templates here in case it’ll make your day a bit shorter. I’ll start off with a brief overview of what the sheets do, but in the latter section of this post I’ll also go into greater depth about how they work so you can change them to suit your own needs.

If you’d like to skip this post and get straight to the templates, you can access them here (but I’d recommend reading a bit about how they work first):

It’s worth mentioning: I don’t consider these sheets to be the only solution. They are a free solution that I’ve found pretty useful, but I have colleagues who swear by the likes of Smartsheet and Teamwork.

It’s also worth noting that different tools work better or worse with different styles. My aim with these sheets is to have a fairly concrete plan for the next three or four months, then a looser set of ideas for further down the line. When I’m filling out these sheets, I also focus on outcomes rather than processes - that helps cut down the time I spend updating sheets, and makes everything clearer for people to read.

The long version of this post is a lot like the short version above, but I talk more about some principles I try to stick to and how this setup fulfills them (shocker, eh?). As promised, the final section will describe how the sheets work, for anyone who runs into problems or wants to make something of their own.

Contents (for if you just want to jump to a specific section):

The 3 principles (which are about people as much as using the sheets)
An early conclusion
Appendices & instructions
How to add tasks to the list
Splitting tasks across multiple time periods
Working with the Month View tab (Planner and Stakeholder Versions)
How to make the Gantt charts work (and add categories)
How to make the Category-Filterable Forward-Facing Gantt Charts work
How to create the Stakeholder View
How to update the God's-I Version


The principles (which are about people as much as using the sheets)

Principle 1: We shouldn’t need to store all our information in our heads.

This is a simple one — if we have to regularly understand something complex, particularly if it changes over time, that information has to be on the page. For example, if I’m trying to plan a marketing strategy and I have to constantly look at the information on the screen and then shuffle it around in my head to work out what we have time for month to month, I’m going to lose the thread and, eventually, my mind.

The Planner Version sheet aims to solve this in a few ways. First, you write all the tasks down in the Task View tab, the time period you’re completing them in is on the far left (in my example, it’s the month the task is planned for), and there are other columns like status and category — but initially, it can just be a brain dump of what needs to happen. The idea here is that when you’re first writing everything out, you don’t have to think too much about it — you can easily change the dates and add other information later.

The Month View tab takes the information in the Task List tab and reorders it by the months listed in column A of the Task View (it could be other time periods, as long as it’s consistent).

This way you can look at a time period, see how much resource is left, and read everything you currently have planned (the remaining resource calculation will also take into account recurring tasks you don’t always want to write out, like meetings).

While the Month View tab can help you focus on specific time periods, it doesn’t give you a long-term view of the plan or task dependencies, so we have the two Gantt views. The Gantt View tab contains everything from sixty days ago and into the future, as long as you haven’t just marked the task as "Later." The Category-Filterable Gantt only focuses on things that are planned for the next six months.

As the name suggests, you can filter this second Gantt to only show specific categories (you label tasks with categories in the Task View tab). This filter is to help with broader trends that are harder to notice — for instance, if the most important part of the project is a social campaign or a site change and you don’t get to it for six months, you may need to make sure everyone is aware of that and agrees. Likewise, if you need to be showing impact but spend most of your time reporting, you may want to change your plan or make sure everyone understands why things are planned that way.

Principle 2: No one knows everything (and they shouldn't).

If you're working on a project where you have all the information, then one of two things is likely happening:

  1. You've really doubled down on that neuroticism we share
  2. You’re carrying this thing — you should just quit and start your own company selling beads* or something.

We can trust that our clients/bosses have more context than we do about wider plans and pressures. They may know more about wider strategies, that their boss tenses up every time a certain project is mentioned, or that a colleague hasn't yet announced their resignation. While a Google Sheet is never an acceptable substitute for actual communication, our clients or bosses may also have an idea of where they want the project to go which they haven’t communicated, or which we haven’t understood.

We can also trust that people working on individual tasks have a good idea of whether things are going to be a problem — for instance, if we’re allowing far too little time for a task. We can try to be as informed as possible, but they’re still likely to know something we don’t.

Even if we disagree that certain things should be priorities or issues, having a transparent, shared plan helps us kick off difficult conversations with a shared understanding of what the plan currently is. The less everyone has to reprocess information to understand it (see Principle 1), the more likely we are to weed out problems early.

This is all well and good, but expecting someone to absorb everything about a project is likely to have the opposite effect. We need a source of data that everyone can refer to, without crowding their thoughts or our conversations with things that only we as project managers have to worry about.

That’s why we have the Stakeholder Version of our sheets. When we write everything in the Planner Version, the Planned tab is populated with just the things that are relevant for people who aren’t us (i.e, all the tasks where the status isn’t “unpitched,” “cancelled,” “forgotten,” or blank) with none of the resource or project identifier information.

We never have to fill out the Stakeholder Version sheet — it just grabs that information from the Planned tab using importrange() and creates all the same Gantt charts and monthly views — so we don’t have to worry about different plans showing different information.

*Bees?

Principle 3: I’m going to miss stuff (less is more).

I’ll be honest: I’ve spent a bunch of time in the past putting together tracking systems that I don’t check enough. I keep filling them out but I don’t spend enough time figuring out what’s needed where. If we have a Stakeholder Version which takes out the stuff that is irrelevant to other people, we need the same for us. After all, this isn’t the only thing we’re thinking about, either.

The What-in-God's-name-have-I-missed Version (God's-I from now on) pulls in data from all of your individual project management sheets and gives you one place to go to be reminded about all the things you’ve forgotten and messed up. It’s like dinner with your parents in a Google Sheet. You’re welcome.

The three places to check in this version are:

  1. Alerts Dashboard tab, which shows you the numbers of deadlines upcoming or missed, the work you need to budget for or brief, and how much unplanned budget you have per project, per month (where budget could just be internal people-hours, as that is still finite).
  2. Task Issues tab, which gives a filterable view of everything over the next three months (so you can dig in to the alerts you see in step one).
  3. Deadlines This Week tab so you have a quick reminder of what you need to complete soon.


An early conclusion:

Often, when I'm making a point, people tell me they hope I’ll wrap up early. This section is mainly proof of personal growth.

It’s also because everything after this is specific to using, changing, or understanding the project management sheets I’ve shared, so you need only read what follows if you're interested in how to use the sheets or how I made them (I really do recommend dabbling with some uses of filter() and query(), particularly in conjunction with RegEx formulas).

Aside from that, I hope you find these resources useful. I’ve been getting a lot of value from them as a way to plan with people collaboratively and separate the concept of “project manager” from “person who needs to know all the things,” but I would be really interested in any thoughts you have about how to improve them or anything you think I’ve missed. Feel free to comment below!

Access the template sheets here:


Appendices & instructions

Some general notes

Quick notes on avoiding problems:

  1. Make sure that when you copy the sheets, the sharing permissions for the Planner View is email- or at least organization-based (anyone with access to the Stakeholder View will see the Planner View URL). It’s a good idea to keep the God's-I Version permissions email-based, too.
  2. Try to follow the existing format of words and numbers as closely as possible when creating new information.
  3. If you want a new row, I’d insert a row, select the one above, copy it down into the new row, then change the information — that way, the formulas in the hidden columns should still work for you.
  4. If you want a new column, it might break one of the query() functions; once you’ve added it, have a quick look for formulas using =query() and consider changing the columns they reference that will have been affected by your change.

Quick notes on fixing problems:

Here's a list of things to check for if you’ve changed something and it isn’t being reflected in the sheet:

  1. Go through all the tabs in the stakeholder view and unhide any hidden columns
    1. They usually just contain a formula that reformats text so our lookups work. See if any of those are missing or broken.
  2. Try copying the formulas from the row above or next to the cell that isn’t working.
  3. Try removing the =iferror portion of formulas.
    1. A lot of the cells are set up to be blank if they break. It makes it easier to read the sheet, but can make it harder to know whether something is actually empty or just looks empty.
  4. If one sheet isn’t properly pulling through data from another, look for the =importrange() formulas and make sure there is one that matches the URL of the sheet you’re trying to reference and that you've given permission for the formula to work — you’ll need to click a button.
    1. Check the Task View tab in the Stakeholder Version and Project URLs tab in the God's-I Version
  5. Have you just called a task “Part 4” or similar? There is a RegEx formula which will strip that out.
  6. Have you forgotten to give a task a type? If so, the Gantt view will warn you in the Status column.

The query function

The =query() function in Google Sheets is awesome — it makes tons of things tons easier, particularly in terms of automating data manipulation. Most of what these sheets do could be achieved with =query, but I’ve often used =filter (which is also very powerful) because =filter is apparently quicker in Google Sheets and at times these sheets have a lot to process.

RegEx

You shouldn’t need to know any RegEx for this sheet, but it is useful in general. Here the RegEx is mainly used to remove the “Part #” in multi-part tasks (see below) and look for anything that matches multiple options — for instance, when selecting multiple categories in the Category-specific forward-facing Gantt tab (see below). RegEx is only used here in RegExmatch(), RegExextract(), RegExreplace(), or as part of the query function where we say “matches.”

Query/filter and isblank

A lot of the formulas in these sheets are either filter() or query() or are wrapped in =if(isblank() — that’s basically because filter and query functions can fill more cells than just the one you put the formula in. For example, they can fill a whole row, column, or sheet. That means that other cells are calculating or looking up against cells which may or may not be empty, so I’ve added the isblank() check so that the cells don’t break when there isn’t information somewhere, but as you add information you don’t have to do as much copying and pasting of formulas.

Tick boxes

The tick boxes are relatively new in Google Sheets. If you need another one, just copy it from an existing cell or select from the “Insert” menu. Where I’ve used tick boxes, I often have another formula in the sheet which filters rows based on what boxes are ticked, then creates a RegEx based on the values that have a tick next to them.

You don’t need to understand this to use the sheets, but you can see it in the rows I’ve unhidden in the Category-specific forward-facing Gantt tab of the Stakeholder Version sheet.

Quick tip — if you want to change all the boxes to ticked/unticked and don’t want to have to do so one by one, you can copy a ticked or unticked checkbox across all the other cells.

How to add tasks to the list

In the task view, the most important things to include are the task name, time period it’s planned for, cost, and type.

For ease, when creating a new task I recommend inserting a row, copying the row above into it, and then changing the information, that way you know you’re not missing any hidden formulas.

Again, don’t bother changing the Stakeholder Version. Once you’ve added the URL of the Planner Version to the =importrange() function, it will pull automatically from the Planner Version.

Splitting tasks across multiple time periods

You can put more than one thing in the time period for a task, just by separating it with “, “ (comma space). That’s because when we get the full list of months, we join all the individual cells together with “, “ then split them apart by “, “ and then dedupe the list — so multiple months in one cell are treated the same as all the other months.

=unique(transpose(split(JOIN(", ",'Task view'!A:A),", ",0)))

The cost-per-month formula in the Task List tab counts how many commas are present in the month column for that row, then divides the planned cost by that number — meaning the cost is split equally across all of the months listed.

=H2/(len(REGEXREPLACE(A2,"[^\,]*",""))+1)

If you don’t want the task to be completely equally split between different time periods, you can write “Part 1” or “Part 2” next to a task. As long as you write just “Part” and then numbers at the end of the name, that’ll be stripped out in column O of the task list tab so the different parts of a task will be combined into one record in things like the Gantt chart.

=REGEXREPLACE(B2,"Part \d+$","")

Working with the Month View tab (Planner and Stakeholder version)

A few key things are going on in the Month View tab. First, we’re getting all of the time periods we have listed in the Task View.

Because the months don’t always show up in the right format (meaning later filters don’t work), we then use a =text() formula in the hidden column B to make sure the months stay in the format we need.

Then, in the “deliverables” section of this tab, we use the below formula:

=if(not(isblank(A12)), iferror(TRANSPOSE(FILTER('Task view'!B:B,RegExmatch('Task view'!A:A,B12))),""),"")

What we’re doing above is checking if the “month” cell of this row is has anything in it. If there is a month there, we filter the tasks in the Task View to only those that contain that month in the text month column. Then we use the transpose() function to change our filtered tasks from a vertical list to the horizontal list we see in the sheet.

Finally, we use the below formula to filter the costs we’ve listed in the Task View tab, the same way we filtered the task names above. Then we add together all the costs for the month (plus the standing monthly costs) and subtract them from the total amount of time/hours we have to spend. That way we calculate how much we have left to play with, or if we’re running over.

=if(isblank(A12),"",((D12-SUM(FILTER('Task view'!I:I,RegExmatch('Task view'!A:A,B12))))-sum($D$6:$F$8)))

We also pull this value through to our God's-I Version to see at a glance if we’ve over/under-planned.

How to make the Gantt charts work (and add categories)

Column C in the Task View tab is the category; you also need to fill this out for the Gantt charts to work. I haven't forced the kind of categories you have to use because each project is different, but it's worth using consistent categories (down to the capital letter) because we deduplicate the task categories, and that relies on all of the names being consistent.

What's happening in the Gantt chart is each cell is a combination of a filter and vlookup (the below looks more complicated than it is).

=iferror(if(not(or(isblank($D6),ISBLANK(F$1))),vlookup(filter('Task view'!$C:$C,'Task view'!$O:$O=$D5,REGEXMATCH('Task view'!$A:$A,F$2)),'Status and colour code'!$C:$E,3,0),""),"")

The formula first checks if the task or month cells are blank. If not, it looks in the month cell in its column and cross-references with the task cell in its row. Where the intersection of a month and task matches a task in our Task View (as in the task in that row is taking place during the month in that column), the filter formula will return the category. For those interested, this might also have been achieved with index-match, but filter lets us match with RegEx so we can give multiple matching options and they don’t have to match exactly. Because we split tasks across multiple months, we need to be flexible in our matching.

The reason we check whether the task or month cells are empty, as mentioned above is so we can paste the above formula in all the cells of the Gantt chart and have them fill out as we add more months and tasks, rather than having to copy and paste the formula each time.

When our filter formula returns the specific category of our task, we take that value and run a vlookup in the Status and color code tab. (That’s only necessary so I could set up the conditional formatting for you so it won’t break when you change the specific category names.)

At the moment, the Gantt charts are set up to color-code the first 7 categories, plus a Deadline category if needed. If you want to add more, they'll show up initially in the Gantt chart as a black block and you'll need to set up conditional formatting to color-code them.

To add automatic color formatting for more categories, repeat the below process for each of the Gantt chart views in the Planner and Stakeholder sheets:

  1. Select all the cells in the tab
  2. Select “Conditional Formatting” from the Format menu
  3. Find the rule with the black box next to it and make a note of what number it's currently targeting from
  4. Create a new rule for anything which equals the number in step 3, then set the same color for both the background and text of that rule
  5. Change the rule that's got a black block next to it to target one number higher

How to make the Category-Filterable Gantt Charts work

This tab uses our old friends, the =filter() and =query() functions. First we use filter to grab the full list of categories from the Status and color code tab we mentioned before:

=FILTER('Gantt view'!A6:B,RegExmatch('Gantt view'!A6:A,".*[a-zA-Z].*"))

Then we put Google Sheets’ shiny new checkboxes next to them (that’ll help us filter our data easily).

Normally we’ll hide row one, but it’s visible to show you a formula that looks at all of the categories and filters them to just those where the tick-box next to them is ticked. If there are none, it returns “(\d|Deadline)” meaning “either a number, or the word Deadline” in RegEx-speak (so anything in our list), because the vertical pipe “|” means “or” and “\d” means “number.”

If there is a tick next to one or more of the categories, the formula will return those things, separated with the “|” that, again, means “or” in RegEx.

=if(countif(C3:C,True)>0,CONCATENATE("(",JOIN("|",FILTER(B3:B,C3:C=True,not(isblank(B3:B)))),")"),"(\d|Deadline)")

Then in cell E3 we have a query formula. The reason we’re using =query and not =filter here is that we need to look for things in more than one column; filter can only really handle one column at a time.

The query function then checks the first six columns of our original Gantt chart, each time looking for any of the category numbers we’ve ticked (what the conditional formatting hides is that the category numbers are in that original Gantt, they’re just the same color as the cell shading). When no tick-boxes are checked, it returns anything that has falls in to any category over the next six planned months. Once we start ticking checkboxes, this will return only the things over the next six planned months that are in one of the categories we’ve selected.

=query('Gantt view'!D1:1056,"Select D, E, F, G, H, I, J where D <> '' and (E matches '"&B1&"' or F matches '"&B1&"' or G matches '"&B1&"' or H matches '"&B1&"' or I matches '"&B1&"' or J matches '"&B1&"')",1)

How to create the Stakeholder View

The Planner Version sheet has a tab called Planned. You don’t need to fill out this tab — it has a query which extracts information from the Task View tab using a =query() function:

=QUERY({'Task view'!A1:F,'Task view'!O1:P},"Select * where not (Col6 contains 'pitched' or Col6 contains 'cancelled' or Col6 = '' or Col6 = 'Forgotten')")

All the formula above is doing is taking the Month, Task, Description, Blocker, Status, Category, and Full task columns, then showing every record where the status isn’t “unpitched,” “cancelled,” “forgotten,” or empty. That gives us a tab with the information we’re ready to share. We could also achieve this with =filter() if we reordered the data in the Task View tab, but this ordering of data is easier to work with, so we just use =query() and select only the columns we want here, combining the ranges horizontally by listing them between {} at the start of this formula.

Then, the Task View tab in our Stakeholder Version sheet file uses =importrange() to target that cleaned list we’ve created. To make sure the Stakeholder Version keeps functioning when you create copies of both of these files, all you need to do is go to the new Planner Version sheet and copy the URL of the page, then go to the Stakeholder Version, find the Task View tab, and update the importrange() formula in cell A1 to have the new URL of your Planner Version sheet. The cell will recalculate, you’ll need to grant permission, then it should work as normal.

How to update the God's-I Version

This view gives you the following:

A quick look at the total number of tasks in any project which:

  1. Have a deadline within 10 days of now
  2. Have passed a deadline (with the task not completed)
  3. Don’t have a deadline set
  4. Aren’t briefed or aren't budgeted for the next three months

It’ll also give you a quick look at the amount of unplanned budget per project, per month, to make sure you haven’t forgotten to plan a month and haven’t overplanned a month.

The God's-I Version works in a similar way to the Stakeholder Version in that it pulls in information using =importrange(), but a key difference is that we want to pull from multiple sheets. Rewriting the formula could get to be a pain, so instead we can generate the formula we need in the Project URLs tab.

The only things you need to do are:

  1. Add the URL of the new Planner View sheet you want to include in the Project URLs tab of the God's-I Version
  2. Grant permission for this sheet to access that sheet (you can click on the alert that appears in column A)
  3. Copy the value in Cell B1, go to the All Imported Task Views tab and select cell A2, then paste the value into the top bar. It’s important that we don’t paste straight into the cell or the sheet will run the concatenate formula rather than the query formula we’re making.

It’s worth noting that this sheet will have all the information about every project you’re managing. Once it’s set up, you shouldn’t share access to anyone unless you’re happy with them seeing all the budgeting details for each of the sheets.


A late conclusion:

Why are you looking for a conclusion down here? It’s in the middle of the post under the title of An early conclusion,” of course. Have a nice day!


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Friday, September 7, 2018

SEO "Dinosaur" Tactics That You Should Retire - Whiteboard Friday

Posted by randfish

It's tough to admit it, but many of us still practice outdated SEO tactics in the belief that they still have a great deal of positive influence. In this week's Whiteboard Friday, Rand gently sets us straight and offers up a series of replacement activities that will go much farther toward moving the needle. Share your own tips and favorites in the comments!

Click on the whiteboard image above to open a high-resolution version in a new tab!

Video Transcription

Howdy, Moz fans, and welcome to another edition of Whiteboard Friday. This week we're going to go back in time to the prehistoric era and talk about a bunch of "dinosaur" tactics, things that SEOs still do, many of us still do, and we probably shouldn't.

We need to replace and retire a lot of these tactics. So I've got five tactics, but there's a lot more, and in fact I'd loved to hear from some of you on some of yours.

Dino Tactic #1: AdWords/Keyword Planner-based keyword research

But the first one we'll start with is something we've talked about a few times here — AdWords and Keyword Planner-based keyword research. So you know there's a bunch of problems with the metrics in there, but I still see a lot of folks starting their keyword research there and then expanding into other tools.

Replace it with clickstream data-driven tools with Difficulty and CTR %

My suggestion would be start with a broader set if you possibly can. If you have the budget, replace this with something that is driven by clickstream data, like Ahrefs or SEMrush or Keyword Explorer. Even Google Search Suggest and related searches plus Google Trends tend to be better at capturing more of this.

Why it doesn't work

I think is just because AdWords hides so many keywords that they don't think are commercially relevant. It's too inaccurate, especially the volume data. If you're actually creating an AdWords campaign, the volume data gets slightly better in terms of its granularity, but we found it is still highly inaccurate as compared as to when you actually run that campaign.

It's too imprecise, and it lacks a bunch of critical metrics, including difficulty and click-through rate percentage, which you've got to know in order to prioritize keywords effectively.

Dino Tactic #2: Subdomains and separate domains for SERP domination

Next up, subdomains and separate domains for SERP domination. So classically, if you wanted to own the first page of Google search results for a branded query or an unbranded query, maybe you just want to try and totally dominate, it used to be the case that one of the ways to do this was to add in a bunch of subdomains to your website or register some separate domains so that you'd be able to control that top 10.

Why it doesn't work

What has happened recently, though, is that Google has started giving priority to multiple subpages in a single SERP from a single domain. You can see this for example with Yelp on virtually any restaurant-related searches, or with LinkedIn on a lot of business topic and job-related searches.

You can see it with Quora on a bunch of question style searches, where they'll come up for all of them, or Stack Overflow, where they come up for a lot of engineering and development-related questions.

Replace it with barnacle SEO and subfolder hosted content

So one of the better ways to do this nowadays is with barnacle SEO and subfolder hosted content, meaning you don't have to put your content on a separate subdomain in order to rank multiple times in the same SERP.

Barnacle SEO also super handy because Google is giving a lot of benefit to some of these websites that host content you can create or generate and profiles you can create and generate. That's a really good way to go. This is mostly just because of this shift from the subdomains being the way to get into SERPs multiple times to individual pages being that path.

Dino Tactic #3: Prioritizing number one rankings over other traffic-driving SEO techniques

Third, prioritizing number one rankings over other traffic-driving SEO techniques. This is probably one of the most common "dinosaur" tactics I see, where a lot of folks who are familiar with the SEO world from maybe having used consultants or agencies or brought it in-house 10, 15, 20 years ago are still obsessed with that number one organic ranking over everything else.

Replace it with SERP feature SEO (especially featured snippets) and long-tail targeting

In fact, that's often a pretty poor ROI investment compared to things like SERP features, especially the featured snippet, which is getting more and more popular. It's used in voice search. It oftentimes doesn't need to come from the number one ranking result in the SERP. It can come number three, number four, or number seven.

It can even be the result that brings back the featured snippet at the very top. Its click-through rate is often higher than number one, meaning SERP features a big way to go. This is not the only one, too. Image SEO, doing local SEO when the local pack appears, doing news SEO, potentially having a Twitter profile that can rank in those results when Google shows tweets.

And, of course, long-tail targeting, meaning going after other keywords that are not as competitive, where you don't need to compete against as many folks in order to get that number one ranking spot, and often, in aggregate, long tail can be more than ranking number one for that "money" keyword, that primary keyword that you're going after.

Why it doesn't work

Why is this happening? Well, it's because SERP features are biasing the click-through rate such that number one just isn't worth what it used to be, and the long tail is often just higher ROI per hour spent.

Dino Tactic #4: Moving up rankings with link building alone

Fourth, moving up the rankings on link building alone. Again, I see a lot of people do this, where they're ranking number 5, number 10, number 20, and they think, "Okay, I'm ranking in the first couple of pages of Google. My next step is link build my way to the top."

Why it no longer works on its own

Granted, historically, back in the dinosaur era, dinosaur era of being 2011, this totally worked. This was "the" path to get higher rankings. Once you were sort of in the consideration set, links would get you most of the way up to the top. But today, not the case.

Replace it with searcher task accomplishment, UX optimization, content upgrades, and brand growth

Instead I'm going to suggest you retire that and replace it with searcher task accomplishment, which we've seen a bunch of people invest in optimization there and springboard their site, even with worse links, not as high DA, all of that kind of stuff. UX optimization, getting the user experience down and nailing the format of the content so that it better serves searchers.

Content upgrades, improving the actual content on the page, and brand growth, associating your brand more with the topic or the keyword. Why is this happening? Well, because links alone it feels like today are just not enough. They're still a powerful ranking factor. We can't ignore them entirely certainly.

But if you want to unseat higher ranked pages, these types of investments are often much easier to make and more fruitful.

Dino Tactic #5: Obsessing about keyword placement in certain tags/areas

All right, number five. Last but not least, obsessing about keyword placement in certain tags and certain areas. For example, spending inordinate amounts of time and energy making sure that the H1 and H2, the headline tags, can contain keywords, making sure that the URL contains the keywords in exactly the format that you want with the hyphens, repeating text a certain number of times in the content, making sure that headlines and titles are structured in certain ways.

Why it (kind of) doesn't work

It's not that this doesn't work. Certainly there's a bare minimum. We've got to have our keyword used in the title. We definitely want it in the headline. If that's not in an H1 tag, I think we can live with that. I think that's absolutely fine. Instead I would urge you to move some of that same obsession that you had with perfecting those tags, getting the last 0.01% of value out of those into related keywords and related topics, making sure that the body content uses and explains the subjects, the topics, the words and phrases that Google knows searchers associate with a given topic.

My favorite example of this is if you're trying to rank for "New York neighborhoods" and you have a page that doesn't include the word Brooklyn or Manhattan or Bronx or Queens or Staten Island, your chances of ranking are much, much worse, and you can get all the links and the perfect keyword targeting in your H1, all of that stuff, but if you are not using those neighborhood terms that Google clearly can associate with the topic, with the searcher's query, you're probably not going to rank.

Replace it with obsessing over related keywords and topics

This is true no matter what you're trying to rank for. I don't care if it's blue shoes or men's watches or B2B SaaS products. Google cares a lot more about whether the content solves the searcher's query. Related topics, related keywords are often correlated with big rankings improvements when we see folks undertake them.

I was talking to an SEO a few weeks ago who did this. They just audited across their site, found the 5 to 10 terms that they felt they were missing from the content, added those into the content intelligently, adding them to the content in such a way that they were actually descriptive and useful, and then they saw rankings shoot up with nothing else, no other work. Really, really impressive stuff.

So take some of these dino tactics, try retiring them and replacing them with some of these modern ones, and see if your results don't come out better too. Look forward to your thoughts on other dino tactics in the comments. We'll see you again next week for another edition of Whiteboard Friday. Take care.

Video transcription by Speechpad.com


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!