Tuesday, October 6, 2020

3 Digital PR Tenets for Excellent Outreach

Posted by amandamilligan

Content creation and promotion is our bread and butter at Fractl, but most of the questions we get are tied to the promotions side of the process.

People ask us: How are you able to secure media coverage on sites like CNBC, USA Today, and more?

It’s not easy, I’ll tell you that. It takes a lot of time and resources, and over the years we’ve established a set of tenets that guide our digital PR process.

I hope sharing them with you will help you refine your own strategy.

1. Research and relevancy are non-negotiable

When we surveyed 500 writers in 2019, we asked them about their biggest pitching pet peeves.

PR pros and journalists have a mutually beneficial relationship. We provide them a source for their posts, and they share what we produce widely with their audience.

Why is it important to avoid peeving off journalists?

The thing is, journalists receive dozens of pitch emails a day.

That’s why it’s so imperative that you craft the best possible email to them every time. You're competing with tons of other content providers for the same spot on their editorial calendar.

As it turns out, they’re most annoyed when pitches aren’t relevant to them.

While this is great insight into how to surpass many of the other pitches that land in these writers’ inboxes, it’s still tough to know how to tangibly put this into action.

Based on our experience, here are our tips for making sure your pitches are relevant to the person you’re pitching:

  • What is the person’s beat? It’s often more specific than it may seem. For example, instead of digital marketing, they might only write about social media. Or instead of general health, they may write about health but only in conjunction with psychology. Make sure you’ve studied exactly what they cover so you’re not pitching something useless to them.
  • Do they ever cover external studies or the type of content you’re pitching? If they stick to opinion or investigative journalism, whatever you’re sending them might not be up their alley.
  • Can their website or platform support your content type? Not every site can embed interactives or videos. Or maybe the publisher is just sick of posting a certain content type like infographics. See what’s been published in the past and if your content fits in with what they’re regularly writing about.

While you’re doing this research, it doesn’t hurt to see how often that particular writer publishes. If it’s once a day, you have a much higher chance of getting coverage than if they’re a contributing writer who only writes for that publication once a month.

2. Personalization matters

People appreciate being seen, and recognizing that you’ve done your homework to make sure they’re actually a good fit to write about your content (as discussed in the previous section).

Adding a touch of personalization can go a long way in making it very clear you’re taking the pitch seriously, and also that you’re just two people having a conversation. (Wouldn’t you rather reply to someone you get a good first impression from?)

In a recent study, we sent 100 pitch emails, half with personalizations and half without them, asking for quotes to include in an article. We found that personalized emails received a higher rate of positive-sentiment responses.

Replies to personalized emails were 83.3% positive compared to replies to non-personalized emails, which were 60% positive.

We had a feeling this was the case because we get responses like this one from writers at Bustle and HubSpot, respectively:

“I have to commend you for great PR tactics here. I open so few of these, much less respond, so mentioning my cat AND sending a pic of yours AND including info that’s relevant to my beat gives you an A++. “

“Thanks for reaching out and showing OutKast some love. This is actually the only time I've ever responded to a pitch email.”

The media relations specialists knew that the former writer loved cats and the latter writer loved Outkast because they followed them on Twitter.

If you have a list of target publications or writers you’d like to reach out to, make sure you’re:

  • Following them on social channels to start building connections and getting a sense of who they are as people
  • Keeping tabs on their recent writings, not only for research purposes but to see if anything personally resonates with you that you can remark on

There’s no need to dig up stuff they’ve posted in the past — that’s when things start to get weird. Do your due diligence, but don’t make it an investigative mission. Remember: The goal here is to simply connect with another human being, and to show them you put in the work to pitch something they’d actually appreciate.

3. Emails should be short and straightforward

Some PR specialists worry that personalizing will make their emails too long and detract from their succinctness.

But personalization only needs to be a sentence or two, so it doesn’t put a huge dent in your overall word count, which, according to that same survey of publishers, should be about 100-300 words.

After leading with a personalized intro, it’s important to get right to the meat of what you’re pitching and why.

Make sure to include:

  • A link to the full content project (don’t ask if they want to see it — just provide everything they need)
  • Why you think the project is a good fit for their readers
  • Bullet points explaining the key relevant takeaways that would appeal to their audience

Take the guesswork out of it. A writer should already be intrigued by the time they click to read your full project, which ideally will sell them on including your information in their stories.

Conclusion

Perhaps the most important point of all doesn’t even relate to the pitching itself but to what you’re pitching. The truth is, no amount of excellent pitching can salvage a subpar piece of content. It’s why we don’t often offer our digital PR expertise as its own standalone service, unless we’re confident the content being provided to us is up to par.

You need high-quality content, well targeted outreach, concisely crafted emails, and a personalized approach, but with this winning combination, you can be earning top media coverage and backlinks for your brand.


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!

Saturday, October 3, 2020

mirage mini split

 Thank you for choosing our network of HVAC Pros to propose a solution to your home comfort and air quality needs. This proposal confirms the scope of work needed to complete the installation of a HVAC system. Our Team of Pros will provide all supervised labor, equipment, materials and tools required to install your new AC/Heat Unit. mirage mini split

Friday, October 2, 2020

Overcoming Blockers: How to Build Your Red Tape Toolkit — Best of Whiteboard Friday

Posted by HeatherPhysioc

Have you ever made SEO recommendations that just don't go anywhere? Maybe you run into a lack of budget, or you can't get buy-in from your boss or colleagues. Maybe your work just keeps getting de-prioritized in favor of other initiatives. Whatever the case, it's important to set yourself up for success when it comes to the tangled web of red tape that's part and parcel of most organizations.

In this helpful — and still relevant — Whiteboard Friday episode from autumn 2018, MozCon speaker Heather Physioc shares her tried-and-true methods for building yourself a toolkit that'll help you tear through roadblocks to get your work implemented.

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

Video Transcription

What up, Moz fans? This is Heather Physioc. I'm the Director of the Discoverability Group at VML, headquartered in Kansas City. So today we're going to talk about how to build your red tape toolkit to overcome obstacles to getting your search work implemented. So do you ever feel like your recommendations are overlooked, ignored, forgotten, deprioritized, or otherwise just not getting implemented?

Common roadblocks to implementing SEO recommendations

#SEOprobs

If so, you're not alone. So I asked 140-plus of our industry colleagues the blockers that they run into and how they overcome them.

  • Low knowledge. So if you're anything like every other SEO ever, you might be running into low knowledge and understanding of search, either on the client side or within your own agency.
  • Low buy-in. You may be running into low buy-in. People don't care about SEO as much as you do.
  • Poor prioritization. So other things frequently come to the top of the list while SEO keeps falling further behind.
  • High bureaucracy. So a lot of red tape or slow approvals or no advocacy within the organization.
  • Not enough budget. A lot of times it's not enough budget, not enough resources to get the work done.
  • Unclear and overcomplicated process. So people don't know where they fit or even how to get started implementing your SEO work.
  • Bottlenecks. And finally bottlenecks where you're just hitting blockers at every step along the way.

So if you're in-house, you probably said that not enough budget and resources was your biggest problem. But on the agency side or individual practitioners, they said low understanding or knowledge of search on the client side was their biggest blocker.

So a lot of the time when we run into these blockers and it seems like nothing is getting done, we start to play the blame game. We start to complain that it's the client who hung up the project or if the client had only listened or it's something wrong with the client's business.

Build out your red tape toolkit

But I don't buy it. So we're going to not do that. We're going to build out our red tape toolkit. So here are some of the suggestions that came out of that survey.

1. Assess client maturity

First is to assess your client's maturity. This could include their knowledge and capabilities for doing SEO, but also their organizational search program, the people, process, ability to plan, knowledge, capacity.

These are the problems that tend to stand in the way of getting our best work done. So I'm not going to go in-depth here because we've actually put out a full-length article on the Moz blog and another Whiteboard Friday. So if you need to pause, watch that and come back, no problem.

2. Speak your client's language

So the next thing to put in your toolkit is to speak your client's language. I think a lot of times we're guilty of talking to fellow SEOs instead of the CMOs and CEOs who buy into our work. So unless your client is a super technical mind or they have a strong search background, it's in our best interests to lift up and stay at 30,000 feet. Let's talk about things that they care about, and I promise you that is not canonicalization or SSL encryption and HTTPS.

They're thinking about ROI and their customers and operational costs. Let's translate and speak their language. Now this could also mean using analogies that they can relate to or visual examples and data visualizations that tell the story of search better than words ever could. Help them understand. Meet them in the middle.

3. Seek greater perspective

Now let's seek greater perspective. So what this means is SEO does not or should not operate in a silo. We're one small piece of your client's much larger marketing mix. They have to think about the big picture. A lot of times our clients aren't just dedicated to SEO. They're not even dedicated to just digital sometimes. A lot of times they have to think about how all the pieces fit together. So we need to have the humility to understand where search fits into that and ladder our SEO goals up to the brand goals, campaign goals, business and revenue goals. We also need to understand that every SEO project we recommend comes with a time and a cost associated with it.

Everything we recommend to a CMO is an opportunity cost as well for something else that they could be working on. So we need to show them where search fits into that and how to make those hard choices. Sometimes SEO doesn't need to be the leader. Sometimes we're the follower, and that's okay.

4. Get buy-in

The next tool in your toolkit is to get buy-in. So there are two kinds of buy-in you can get.

Horizontal buy-in

One is horizontal buy-in. So a lot of times search is dependent on other disciplines to get our work implemented. We need copywriters. We need developers. So the number-one complaint SEOs have is not being brought in early. That's the same complaint all your teammates on development and copywriting and everywhere else have.

Respect the expertise and the value that they bring to this project and bring them to the table early. Let them weigh in on how this project can get done. Build mockups together. Put together a plan together. Estimate the level of effort together.

Vertical buy-in

Which leads us to vertical buy-in. Vertical is up and down. When you do this horizontal buy-in first, you're able to go to the client with a much smarter, better vetted recommendation. So a lot of times your day-to-day client isn't the final decision maker. They have to sell this opportunity internally. So give them the tools and the voice that they need to do that by the really strong recommendation you put together with your peers and make it easy for them to take it up to their boss and their CMO and their CEO. Then you really increase the likelihood that you're going to get that work done.

5. Build a bulletproof plan

Next, build a bulletproof plan.

Case studies

So the number-one recommendation that came out of this survey was case studies. Case studies are great. They talk about the challenge that you tried to overcome, the solution, how you actually tackled it, and the results you got out of that.

Clients love case studies. They show that you have the chops to do the work. They better explain the outcomes and the benefits of doing this kind of work, and you took the risk on that kind of project with someone else's money first. So that's going to reduce the perceived risk in the client's mind and increase the likelihood that they're going to do the work.

Make your plan simple and clear, with timelines

Another thing that helps here is building a really simple, clear plan so it's stupid-easy for everybody who needs to be a part of it to know where they fit in and what they're responsible for. So do the due diligence to put together a step-by-step plan and assign ownership to each step and put timelines to it so they know what pace they should be following.

Forecast ROI

Finally, forecast ROI. This is not optional. So a lot of times I think SEOs are hesitant to forecast the potential outcomes or ROI of a project because of the sheer volume of unknowns.

We live in a world of theory, and it's very hard to commit to something that we can't be certain about. But we have to give the client some sense of return. We have to know why we are recommending this project over others. There's a wealth of resources out there to do that for even heavily caveated and conservative estimate, including case studies that others have published online.

Show the cost of inaction

Now sometimes forecasting the opportunity of ROI isn't enough to light a fire for clients. Sometimes we need to show them the cost of inaction. I find that with clients the risk is not so much that they're going to make the wrong move. It's that they'll make no move at all. So a lot of times we will visualize what that might look like. So we'll show them this is the kind of growth we think that you can get if you invest and you follow this plan we put together.

Here's what it will look like if you invest just a little to monitor and maintain, but you're not aggressively investing in search. Oh, and here, dropping down and to the right, is what happens when you don't invest at all. You stagnate and you get surpassed by your competitors. That can be really helpful for clients to contrast those different levels of investment and convince them to do the work that you're recommending.

6. Use headlines & soundbites

Next use headlines, taglines, and sound bites. What we recommend is really complicated to some clients. So let's help translate that into simple, usable language that's memorable so they can go repeat those lines to their colleagues and their bosses and get that work sold internally. We also need to help them prioritize.

So if you're anything like me, you love it when the list of SEO action items is about a mile long. But when we dump that in their laps, it's too much. They get overwhelmed and bombarded, and they tune out. So instead, you are the expert consultant. Use what you know about search and know about your client to help them prioritize the single most important thing that they should be focusing on.

7. Patience, persistence, and parallel paths

Last in your toolkit, patience, persistence, and parallel paths. So getting this work done is a combination of communication, follow-up, patience, and persistence. While you've got your client working on this one big thing that you recommended, you can be building parallel paths, things that have fewer obstacles that you can own and run with.

They may not be as high impact as the one big thing, but you can start to get small wins that get your client excited and build momentum for more of the big stuff. But the number one thing out of all of the responses in the survey that our colleagues recommended to you is to stay strong. Have empathy and understanding for the hard decisions that your client has to make. But come with a strong, confident point of view on where to go next.

All right, gang, these are a lot of great tips to start your red tape toolkit and overcome obstacles to get your best search work done. Try these out. Let us know what you think. If you have other great ideas on how you overcome obstacles to get your best work done with clients, let us know down in the comments. Thank you so much for watching, and we'll see you next week for another edition of Whiteboard Friday.

Video transcription by Speechpad.com


Ready for more?

You'll uncover even more SEO goodness in the MozCon 2020 video bundle. At this year's special low price of $129, this is invaluable content you can access again and again throughout the year to inspire and ignite your SEO strategy:

  • 21 full-length videos from some of the brightest minds in digital marketing
  • Instant downloads and streaming to your computer, tablet, or mobile device
  • Downloadable slide decks for presentations

Get my MozCon 2020 video bundle


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 29, 2020

Page Authority 2.0: An Update on Testing and Timing

Posted by rjonesx.

One of the most difficult decisions to make in any field is to consciously choose to miss a deadline. Over the last several months, a team of some of the brightest engineers, data scientists, project managers, editors, and marketers have worked towards a release date of the new Page Authority (PA) on September 30, 2020. The new model is exceptional in nearly every way to the current PA, but our last quality control measure revealed an anomaly that we could not ignore.

As a result, we’ve made the tough decision to delay the launch of Page Authority 2.0. So, let me take a moment to retrace our steps as to how we got here, where that leaves us, and how we intend to proceed.

Seeing an old problem with fresh eyes

Historically, Moz has used the same method over and over again to build a Page Authority model (as well as Domain Authority). This model's advantage was its simplicity, but it left much to be desired.

Previous Page Authority models trained against SERPs, trying to predict whether one URL would rank over another, based on a set of link metrics calculated from the Link Explorer backlink index. A key issue with this type of model was that it couldn’t meaningfully address the maximum strength of a particular set of link metrics.

For example, imagine the most powerful URLs on the Internet in terms of links: the homepages of Google, Youtube, Facebook, or the share URLs of followed social network buttons. There are no SERPs that pit these URLs against one another. Instead, these extremely powerful URLs often rank #1 followed by pages with dramatically lower metrics. Imagine if Michael Jordan, Kobe Bryant, and Lebron James each scrimaged one-on-one against high school players. Each would win every time. But we would have great difficulty extrapolating from those results whether Michael Jordan, Kobe Bryant, or Lebron James would win in one-on-one contests against each other.

When tasked with revisiting Domain Authority, we ultimately chose a model with which we had a great deal of experience: the original SERPs training method (although with a number of tweaks). With Page Authority, we decided to go with a different training method altogether by predicting which page would have more total organic traffic. This model presented several promising qualities like being able to compare URLs that don’t occur on the same SERP, but also presented other difficulties, like a page having high link equity but simply being in an infrequently-searched topic area. We addressed many of these concerns, such as enhancing the training set, to account for competitiveness using a non-link metric.

Measuring the quality of the new Page Authority

The results were — and are — very promising.

First, the new model obviously predicted the likelihood that one page would have more valuable organic traffic than another. This was expected, because the new model was directed at this particular goal, while the current Page Authority merely attempted to predict whether one page would rank over another.

Second, we found that the new model predicted whether one page would rank over another better than the previous Page Authority. This was especially pleasing, as it laid to rest many of our concerns that the new model would underperform on old quality controls due to the new training model.

How much better is the new model at predicting SERPs than the current PA? At every interval — all the way down to position 4 vs 5 — the new model tied or out-performs the current model. It never lost.

Everything was looking great. We then started analyzing outliers. I like to call this the “does anything look stupid?” test. Machine learning makes mistakes, just as humans can, but humans tend to make mistakes in a very particular manner. When a human makes a mistake, we often understand exactly why the mistake was made. This isn’t the case for ML, especially Neural Nets; we pulled URLs with high Page Authorities under the new model that happened to have zero organic traffic, and included them in the training set to learn for those errors. We quickly saw bizarre 90+ PAs drop down to much more reasonable 60s and 70s… another win.

We were down to one last test.

The problem with branded search

Some of the most popular keywords on the web are navigational. People search Google for Facebook, Youtube, and even Google itself. These keywords are searched an astronomical number of times relative to other keywords. Subsequently, a handful of highly powerful brands can have an enormous impact on a model that looks at total search volume as part of its core training target.

The last test involves comparing the current Page Authority to the new Page Authority, in order to determine if there are any bizarre outliers (where PA shifted dramatically and without obvious reason). First, let’s look at a simple comparison of the LOG of Linking Root Domains compared to the Page Authority.

Not too shabby. We see a generally positive correlation between Linking Root Domains and Page Authority. But can you spot the oddities? Go ahead and take a minute…

There are two anomalies that stand out in this chart:

  1. There is a curious gap separating the main distribution of URLs and the outliers above and below.
  2. The largest variance for a single score is at PA 99. There are an awful lot of PA 99s with a wide range of Linking Root Domains.

Here is a visualization that will help draw out these anomalies:



The gray spaces between the green and red represent this odd gap between the bulk of the distribution and the outliers. The outliers (in red) tend to clump together, especially above the main distribution. And, of course, we can see the poor distribution at the top of PA 99s.

Bear in mind that these issues are not sufficient to make the new Page Authority model less accurate than the current model. However, upon further examination, we found that the errors the model did produce were significant enough that they could adversely influence the decisions of our customers. It’s better to have a model that is off by a little everywhere (because the adjustments SEOs make are not incredibly fine-tuned) than it is to have a model that is right mostly everywhere but bizarrely wrong in a limited number of cases.

Luckily, we’re fairly confident as to what the problem is. It seems that homepage PAs are disproportionately inflated, and that the likely culprit is the training set. We can’t be certain this is the cause until we complete retraining, but it is a strong lead.

The good news and the bad news

We are in good shape insofar as we have multiple candidate models that outperform the existing Page Authority. We’re at the point of bug squashing, not model building. However, we are not going to ship a new score until we are confident that it will steer our customers in the right direction. We are highly conscientious of the decisions our customers make based on our metrics, not just whether the metrics meet some statistical criteria.

Given all of this, we have decided to delay the launch of Page Authority 2.0. This will give us the necessary time to address these primary concerns and produce a stellar metric. Frustrating? Yes, but also necessary.

As always, we thank you for your patience, and we look forward to producing the best Page Authority metric we have ever released.

Visit the PA Resource Center

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!

My 8 Best Local SEO Tips for the 2020 Holidays

Posted by MiriamEllis



Image credit: DoSchu

“No place like home for the holidays.” This will be the refrain for the majority of your customers as we reach 2020’s peak shopping season. I can’t think of another year in which it’s been more important for local businesses to plan and implement a seasonal marketing strategy extra early, to connect up with customers who will be traveling less and seeking ways to celebrate at home.

Recently, it’s become trendy in multiple countries to try to capture the old Danish spirit of hygge, which the OED defines as: A quality of coziness and comfortable conviviality that engenders a feeling of contentment or well-being.

While this sometimes-elusive state of being isn’t something you can buy direct from a store, and while some shoppers are still unfamiliar with hygge by name, many will be trying to create it at home this year. Denmark buys more candles than any other nation, and across Scandinavia, fondness for flowers, warming foods, cozy drinks, and time with loved ones characterizes the work of weaving a gentle web of happiness into even the darkest of winters.

Whatever your business can offer to support local shoppers’ aspirations for a safe, comfortable, happy holiday season at home is commendable at the end of a very challenging 2020. I hope these eight local search marketing tips will help you make good connections that serve your customers — and your business — well into the new year.

1) Survey customers now and provide what they want

Reasonably-priced survey software is worth every penny in 2020. For as little as $20/month, your local business can understand exactly how much your customers’ needs have changed this past year by surveying:

  • Which products locals are having trouble locating
  • Which products/services they most want for the holidays
  • Which method of shopping/delivery would be most convenient for them
  • Which hours of operation would be most helpful
  • Which safety measures are must-haves for them to transact with a business
  • Which payment methods are current top choices

Doubtless, you can think of many questions like these to help you glean the most possible insight into local needs. Poll your customer email/text database and keep your surveys on the short side to avoid abandonment.

Don’t have the necessary tools to poll people at-the-ready? Check out Zapier’s roundup of the 10 Best Online Survey Apps in 2020 and craft a concise survey geared to deliver insights into customers’ wishes.

2) Put your company’s whole heart into affinity

If I could gift every local business owner with a mantra to carry them through not just the 2020 holiday shopping season, but into 2021, it would be this:

It’s not enough to have customers discover my brand — I need them to like my brand.

Chances are, you can call to mind some brands of which you’re highly aware but would never shop with because they don’t meet your personal or business standards in some way. You’ve discovered these brands, but you don’t like them. In 2020, you may even have silently or overtly boycotted them.

On the opposite side of this scenario are the local brands you love. I can wax poetic about my local independent grocery store, stocking its shelves with sustainable products from local farmers, flying its Black Lives Matter and LGBTQ+ flags with pride from its storefront, and treating every customer like a cherished neighbor.

For many years, our SEO industry has put great effort into and emphasis on the discovery phase of the consumer journey, but my little country-town grocer has gone leaps and bounds beyond this by demonstrating affinity with the things my household cares about. The owners can consider us lifetime loyal customers for the ways they are going above-and-beyond in terms of empathy, diversity, and care for our community.

I vigorously encourage your business to put customer-brand affinity at the heart of its holiday strategy. Brainstorm how you can make meaningful changes that declare your company’s commitment to being part of the work of positive social change.

3) Be as accessible and communicative as possible

Once you’ve accomplished the above two goals, open the lines of communication about what your brand offers and the people-friendly aspects of how you operate across as many of the following as possible:

  • Website
  • Local business listings
  • Email
  • Social channels
  • Forms
  • Texts/Messaging
  • Phone on-hold marketing
  • Storefront and in-store signage
  • Local news, radio, and TV media

In my 17 years as a local SEO, I can confidently say that local business listings have never been a greater potential asset than they will be this holiday season. Google My Business listings, in particular, are an interface that can answer almost any customer who-what-where-when-why — if your business is managing these properly, whether manually or via software like Moz Local.

Anywhere a customer might be looking for what you offer, be there with accurate and abundant information about identity, location, hours of operation, policies, culture, and offerings. From setting special hours for each of your locations, to embracing Google Posts to microblog holiday content, to ensuring your website and social profiles are publicizing your USP, make your biggest communications effort ever this year.

At the same time, be sure you’re meeting Google’s mobile-friendly standards, and that your website is ADA-compliant so that no customer is left out. Provide a fast, intuitive, and inclusive experience to keep customers engaged.

With the pandemic necessitating social distancing, make the Internet your workhorse for connecting up with and provisioning your community as much as you can.

4) Embrace local e-commerce and product listings

Digital Commerce 360 has done a good job charting the 30%+ rise in online sales in the first half or 2020, largely resulting from the pandemic. The same publication summarizes the collective 19% leap in traffic to North America’s largest retailers. At the local business level, implementing even basic e-commerce function in advance of the holiday season could make a major difference, if you can find the most-desired methods of delivery. These could include:

  • Buy-online, pick up in-store (BOPIS)
  • Buy-online, pick up curbside
  • Buy online for postal delivery
  • Buy online for direct home delivery by in-house or third-party drivers

Here’s an extensive comparison of popular e-commerce solutions, including which ones have free trials, and the e-commerce column of the Moz blog is a free library of expert advice on optimizing digital sales.

Put your products everywhere you can. Don’t forget that this past April, Google surprised everybody by offering free product listings, and that they also recently acquired the Pointy device, which lets you transform scanned barcodes into online inventory pages.

Additionally, in mid-September, Google took their next big product-related step by adding a “nearby” filter to Google Shopping, taking us closer and closer to the search engine becoming a source for real-time local inventory, as I’ve been predicting here in my column for several years.

Implement the public safety protocols that review research from GatherUp shows consumers are demanding, get your inventory onto the web, identify the most convenient ways to get purchases from your storefront into the customer’s hands, and your efforts could pave the way for increased Q4 profits.

5) Reinvent window shopping with QR codes

“How can I do what I want to do?” asked Jennifer Bolin, owner of Clover Toys in Seattle.

What she wanted to do was use her storefront window to sell merchandise to patrons who were no longer able to walk into her store. When a staff member mentioned that you could use a QR code generator like this one to load inventory onto pedestrians’ cell phones, she decided to give it a try.

Just a generation or two ago, many Americans cherished the tradition of going to town or heading downtown to enjoy the lavish holiday window displays crafted by local retailers. The mercantile goal of this form of entertainment was to entice passersby indoors for a shopping spree. It’s time to bring this back in 2020, with the twist of labeling products with QR codes and pairing them with desirable methods of delivery, whether through a drive-up window, curbside, or delivery.

“We’ve even gotten late night sales,” Bolin told me when I spoke with her after my colleague Rob Ousbey pointed out this charming and smart independent retail shop to me.

If your business locations are in good areas for foot traffic, think of how a 24/7 asset like an actionable, goodie-packed window display could boost your sales.

6) Tie in with DIY, and consider kits

With so many customers housebound, anything your business can do to support activities and deliver supplies for domestic merrymaking is worth considering. Can your business tie in with decorating, baking, cooking, crafting, handmade gift-giving, home entertainment, or related themes? If so, create video tutorials, blog posts, GMB posts, social media tips, or other content to engage a local audience.

One complaint I am encountering frequently is that shoppers are feeling tired trying to piecemeal together components from the internet for something they want to make or do. Unsurprisingly, many people are longing for the days when they could leisurely browse local businesses in-person, taking inspiration from their hands-on interaction with merchandise. I think kits could offer a stopgap solution in some cases. If relevant to your business, consider bundling items that could provide everything a household needs to:

  • Prepare a special holiday meal
  • Bake treats
  • Outfit a yard for winter play
  • Trim a tree or decorate a home
  • Build a fire
  • Create a night of fun for children of various age groups
  • Dress appropriately for warmth and safety, based on region
  • Create a handmade gift, craft, or garment
  • Winter prep a home or vehicle
  • Create a complete home spa/health/beauty experience
  • Plant a spring garden

Kits could be a welcome all-in-one resource for many shoppers. Determine whether your brand has the components to offer one.

7) Manage reviews meticulously

Free, near-real-time quality control data from your holiday efforts can most easily be found in your review profiles. Use software like Moz Local to keep a running tally of your incoming new reviews, or assign a staff member at each location of your business to monitor your local business profiles daily for any complaints or questions.

If you can quickly solve problems people cite in their reviews, your chances are good of retaining the customer and demonstrating responsiveness to all your profiles’ visitors. You may even find that reviews turn up additional, unmet local needs your formal survey missed. Acting quickly to fulfill these requests could win you additional business in Q4 and beyond.

8) Highly publicize one extra reason to shop local this year

“72% of respondents...are likely or very likely to continue to shop at independent stores, either locally or online, above larger retailers such as Amazon.” — Bazaarvoice

I highly recommend reading the entire survey of 12,000 global respondents by Bazaarvoice, quantifying how substantially shopping behaviors have changed in 2020. It’s very good news for local business owners that so many customers want to keep transacting with nearby independents, but the Amazon dilemma remains.

Above, we discussed the fatigue that can result from trying to cobble together a bunch of different resources to check everything off a shopping list. This can drive people to online “everything stores”, in the same way that department stores, supermarkets, and malls have historically drawn in shoppers with the promise of convenience.

A question every local brand should do their best to ask and answer in the runup to the holidays is: What’s to prevent my community from simply taking their whole holiday shopping list to Amazon, or Walmart, or Target this year?

Whatever your business can offer to support local shoppers’ aspirations for a safe, comfortable, happy holiday season at home is commendable at the end of a very challenging 2020. I hope these eight local search marketing tips will help you make good connections that serve your customers — and your business — well into the new year.

My completely personal answer to this question is that I want my town’s local business district, with its local flavor and diversity of shops, to still be there after a vaccine is hopefully developed for COVID-19. But that’s just me. Inspiring your customers’ allegiance to keeping your business going might be best supported by publicizing some of the following:

  • The economic, societal, and mental health benefits proven to stem from the presence of small, local businesses in a community.
  • Your philanthropic tie-ins, such as generating a percentage of sales to worthy local causes — there are so many ways to contribute this year.
  • The historic role your business has played in making your community a good place to live, particularly if your brand is an older, well-established one. I hear nostalgia is a strong influencer in 2020, and old images of your community and company through the years could be engaging content.
  • Any recent improvements you’ve made to ensure fast home delivery, whether by postal mail or via local drivers who can get gifts right to people’s doors.
  • Uplifting content that simply makes the day a bit brighter for a shopper. We’re all looking for a little extra support these days to keep our spirits bright.

Be intentional about maximizing local publicity of your “extra reason” to shop with you. Your local newspaper is doubtless running a stream of commentary about the economic picture in your city, and if your special efforts are newsworthy, a few mentions could do you a lot of good.

Don’t underestimate just how reliant people have become on the recommendations of friends, family, and online platforms for sourcing even the basics of life these days. In my own circle, everyone is now regularly telling everyone else where to find items from hand sanitizer to decent potatoes. Networking will be happening around gifts, too, so anything you get noticed for could support extensive word-of-mouth information sharing.

I want to close by thanking you for being in or marketing businesses that will help us all celebrate the many upcoming holidays in our own ways. Your efforts are appreciated, and I’m wishing you a peaceful, profitable, and hyggelig finish to 2020.


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!

Monday, September 28, 2020

How to Detect and Improve Underperforming Content: A Guide to Optimization

Posted by SamuelMangialavori


Content, content, and more content! That’s what SEO is all about nowadays, right? Compared to when I started working in SEO (2014), today, content is consistently one of the most popular topics covered at digital marketing conferences, there are way more tools that focus on content analysis and optimization, and overall it seems to dominate most of SEO news.

Don’t believe me? Here’s a nice Google Trends graph that may change your mind:

Google Trends screenshot for “content marketing” as a topic, set for worldwide interest.

But why is it that content is now dominating the SEO scene? How vital is content for your SEO strategy, actually? And most importantly: how can you be content with your site’s content? Puns aside, this post aims to help you figure out potential causes of your underperforming content and how to improve it.

Why content is key in SEO in 2020

Content is one of the most important factors in SEO. Just by paying close attention to what Google has been communicating to webmasters in the last few years, it’s clear that they’ve put a strong emphasis on “content” as a decisive ranking factor.

For instance, let’s have a look at this post, from August 2019, which talks about Google’s regular updates and what webmasters should focus on:

“Focus on content: pages that drop after a core update don’t have anything wrong to fix. We suggest focusing on ensuring you’re offering the best content you can. That’s what our algorithms seek to reward.”

The article goes on, listing a series of questions that may help webmasters when self-assessing their own content (I strongly recommend reading the entire post).

That said, content alone cannot and should not be enough for a website to rank well, but it is a pretty great starting point!

Underperforming content: theory first

What is underperforming content?

When I say “underperforming content”, I’m referring to content, either on transactional/commercial pages or editorial ones, that does not perform up to its potential. This could be content that either used to attract a good level of organic traffic and now doesn’t, or content that never did generate any organic traffic despite the efforts you might have put in.

Over 90% of content gets no traffic from Google. Ninety bloody percent! This means that nine pages out of 10 are likely not to receive any organic traffic at all — food for thought.

What are the causes of underperforming content?

There could be many reasons why your content is not doing well, but the brutal truth is often simple: in most cases, your content is simply not good enough and does not deserve to rank in the top organic positions.

Having said that, here are the most common reasons why your content may be underperforming: they are in no particular order and I will highlight the most important, in my opinion.

Your content does not match the user intent

Based on my experience, this is a very important thing that even experienced marketers still get wrong. It may be the case that your content is good and relevant to your users, but does not match the intent that Google is showcasing in the SERP for the keywords of focus.

As SEOs, our aim should be to match user intent, which means we first need to understand the what and the who before defining the how. Whose intent we are targeting and what is represented in the SERP will define the strategy we use to get there.

Example: webmasters who hope to rank for a “navigational or informational” keyword with a transactional, page or vice versa.

Your content isn’t in the ideal format Google is prioritizing

Google may be favoring a certain type of format which your content doesn’t conform to, hence it isn’t receiving the expected visibility.

Example: you hope to rank with a text-heavy blog post for a “how to” keyword where Google is prioritizing video content.

Your content is way too “thin” compared to what is ranking

It doesn’t necessarily have to be a matter of content length (there is no proven content length formula out there, trust me) but more relevance and comprehensiveness. It may be the case that your content is simply not as compelling as other sites out there, hence Google prioritizing those over you.

Example: you hope to rank for heavily competitive informational keywords with a 200-words blog post.

Your content isn’t as up-to-date

If your content is very topical, and such a topic heavily depends on information which may change with time, then Google will reward sites that put effort into keeping the content fresh and up-to-date. Apart from search engines themselves, users really care about fresh content — no one wants to read an “SEO guide to improve underperforming content” that was created in 2015!

Example: certain subjects/verticals tend to be more prone to this issue, but generally anything related to regulations/laws/guidelines which tend to change often.

Your content is heavily seasonal or tied to a past event/experience

Self-explanatory: if your content is about something that occurred in the past, generally the interest for that particular subject will gradually decrease over time. There are exceptions, of course (god save the 90s and my fav Netflix show “The Last Dance”), but you get the gist.

Example: topics such as dated events or experiences (Olympics 2016, past editions of Black Friday, and so on) or newsworthy content (2016 US election, Kanye running for president — no wait that is still happening...).

Your tech directives have changed the page’s indexation status

If something happens to your page that makes it fall out of Google’s index. The most common issues could be: unexpected no-index tag, canonical tag, incorrect hreflang tags, page status changes, page removed with Google Search Console’s remove tool, and so on.

Example: after some SEO recommendations, your devs mistakenly put a no-index tag on your page without you realizing.

Your page is victim of duplication or cannibalization

If you happen to cover the same or similar keyword topic with multiple pages, this may trigger duplication and/or cannibalization, which ultimately will result in a loss of organic visibility.

Example: you launch a new service page alongside your current offerings, but the on-page focus (metadata, content, linking structure) isn’t different or unique enough and it ends up cannibalizing your existing visibility.

Your page has been subject to JavaScript changes that make the content hard to index for Google

Let’s not go into a JavaScript (JS) rabbit hole and keep it simple: if some JS stuff is happening on your page and it’s dynamically changing some on-page SEO elements, this may impact how Google indexes your content.

Example: fictitious case where your site goes through a redesign, heavy JS is now happening on your browser and changing a key part of your content that now Google cannot render easily — that is a problem!

Your page has lost visibility following drastic SERP changes

The SERP has changed extensively in the last few years, which means many more new features that are now present weren’t there before. This may cause disruption to previous rankings (hence to your previous CTR), or make your pages fall out of Google’s precious page one.

Also, don’t forget to consider that the competition might have gotten stronger with time, so that could be another reason why you lose significant visibility.

Example: some verticals have been impacted more than others (jobs, flights, and hotels, for instance) where Google’s own snippets and tools are now getting the top of the SERP. If you are as obsessed with SERP chances, and in particular PAA, as I am and want more details, have a read here.

Your content doesn’t have any backlinks

Without going into too much detail on this point — it could be a separate blog post — for very competitive commercial terms, not having any/too few backlinks (and what backlinks represent for your site in Google’s eyes) can hold you back, even if your page content is compelling on its own. This is particularly true for new websites operating in a competitive environment.

Example: for a challenging vertical like fashion, for instance, it is extremely difficult to rank for key head terms without a good amount of quality (and naturally gained) backlinks to support your transactional pages.

How to find the issues affecting your content

We’ve covered the why above, let’s now address the how: how to determine what issue affects your page/content. This part is especially dedicated to a not-too savvy SEO audience (skip this part and go straight to next if you are after the how-to recommendations).

I’ll go through a list of checks that can help you detect the issues listed above.

Technical checks

Google Search Console

Use the URL inspection tool to analyze the status of the page: it can help you answer questions such as:

  • Has my page been crawled? Are we even allowing Google to crawl the page?
  • Has my page been indexed? Are we even allowing Google to index the page?

By assessing the Coverage feature, Google will share information about the crawlability and indexability of the page.


Pay particular attention to the Indexing section, where they mention user-declared canonical vs google-selected canonical. If the two differ, it’s definitely worth investigating the reason, as this means Google isn’t respecting the canonical directives placed on the page — check official resources to learn more about this.

Chrome extensions

I love Chrome extensions and I objectively have way too many on my browser…

Some Chrome extensions can give you lots of info on the indexability status of the page with a simple click, checking things like canonical tags and meta robots tags.

My favorite extensions for this matter are:

JavaScript check

I’ll keep it simple: JavaScript is key in today’s environment as it adds interactivity to a page. By doing so, it may alter some key HTML elements that are very important for SEO. You can easily check how a page would look without JS by using this convenient tool by Onley: WWJD.

Realistically speaking, you need only one of the following tools in order to check whether JavaScript might be a problem for your on-page SEO:

All the above tools are very useful for any type of troubleshooting as they are showcasing the rendered-DOM resources in real-time (different from what the “view-source” of a page looks like).

Once you’ve run the test, click to see the rendered HTML and try and do the following checks:

  • Is the core part of my content visible?
    • Quick way to do so: find a sentence in your content, use the search function or click CTRL + F with that sentence to see if it’s present in the rendered version of the page.
  • Are internal links visible to Google?
    • Quick way to do so: find an internal link on the page, use the search function or click CTRL + F with that sentence to see if it’s present in the rendered version of the page.
  • Can Google access other key elements of the page?
    • Check for things such as headers (example below with a Brainlabs article), products, pagination, reviews, comments, etc.

Intent and SERP analysis

By analyzing the SERP for key terms of focus, you’ll be able to identify a series of questions that relate to your content in relation to intent, competition, and relevance. All major SEO tools nowadays provide you with tons of great information about what the SERP looks like for whatever keyword you’re analyzing.

For the sake of our example, let’s use Ahrefs and the sample keyword below is “evergreen content”:

Based on this example, these are a few things I can notice:

  • This keyword triggers a lot of interesting SERP features (Featured Snippet, Top Stories, People also ask)
  • The top organic spots are owned by very established and authoritative sources (Ahrefs blog, Hubspot, Wordstream etc), which makes this keyword quite difficult to compete for

Here are quick suggestions on what types of checks I recommend:

  • Understand and classify the keyword of analysis, based on the type of results Google is showing in the SERP: any ads showing, or organic snippets? Are the competing pages mainly transactional or informational?
  • Check the quality of the sites that are ranking in page one: indicative metrics that can help you gather insights on the quality of each domain (DA/DR) are helpful, the number of keywords those pages are visible for, the estimated traffic per page, and so on.
  • Do a quick crawl of these pages to bulk check the comprehensiveness of their content and metadata, or manually check some if you prefer that way.

By doing most of these checks, you’ll be able to see if your content is underperforming for any of the reasons previously mentioned:

  • Content not compelling enough compared to what is ranking on page one
  • Content in the wrong format compared to what Google is prioritizing
  • Content is timely or seasonal
  • Content is being overshadowed by SERP features

Duplication and cannibalization issues

Check out my 2019 post on this subject, which goes into a lot more detail. The quick version of the post is below.

Use compelling SEO tools to understand the following:

  • whether, for tracked keywords of interest, two or more ranking URLs have been flip-flopping. That is a clear sign that search engines are confused and cannot “easily decide” on what URL to rank for a certain keyword.
  • whether, for tracked keywords of interest, two or more ranking URLs are appearing at the same time (not necessarily on page one of the SERP). That is a clear signal of duplication/cannibalization.
  • check your SEO visibility by landing page: if different URLs that rank for very similar keyword permutations, chances are there is a risk there.
  • last but not least: do a simple site search for keywords of interest in order to get an initial idea of how many pages (that cover a certain topic) have been indexed by Google. This is an insightful preliminary exercise and also useful to validate your worries.

How to fix underperforming content

We’ve covered the most common cases of underperforming content and how to detect such issues — now let’s talk about ways to fix them.

Below is a list of suggested actions to take when improving your underperforming content, with some very valuable links to other resources (mostly from Moz or Google) that can help you expand on individual concepts.

Make sure your page can be crawled and indexed “properly”

  • Ensure that your page does not fall under any path of blocked resources in Robots.txt
  • Ensure your page is not provided with a no-index meta robots tag or a canonical tag pointing elsewhere (a self-referencing canonical tag is something you may want to consider but not compulsory at all).
  • Check whether other pages have a canonical tag pointing to your URL of focus. Irrelevant or poorly-done canonical tags tend to get ignored by Google — you can check if that is the case in the URL Inspection tool.
  • Ensure your site (not just your page) is free from any non-SEO friendly JavaScript that can alter key on-page elements (such as headers, body content, internal links, etc.).
  • Ensure your page is linked internally on the site and present in your XML sitemap.

Understand search intent

  • Search intent is a fascinating topic in and of itself, and there are a lot of great resources on the subject if you want to delve deeper into it.
  • Put simply, you should always research what the SERP looks like for the topic of interest: by analyzing the SERP and all its features (organic and non), you can get a much better understanding of what search engines are looking for in order to match intent.
  • By auditing the SERP, you should be able to answer the following questions:
    • What type of content is Google favoring here: transactional, navigational, informational?
    • How competitive are the keywords of focus and how authoritative are those competitors ranking highly for them?
    • What content format is Google showcasing in the SERP?
    • How comprehensive should my content be to get a chance to rank in page one?
    • What keywords are used in the competitor’s metadata?
    • What organic features should I consider addressing with my content (things like featured snippets, people also ask, top images, etc.)?
  • Hopefully all the questions above will also give you a realistic view of your chances of ranking on Google’s first page. Don’t be afraid to switch your focus to PPC for some very competitive keywords where your real possibility of organic rankings are slim.

Map your pages against the right keywords

  • This is a necessary step to make sure you have a clear understanding of not only what keywords you want to rank for, but also what keywords you are eligible to rank for.
  • Don’t overdo it and be realistic about your ranking possibilities: mapping your page against several keywords variations, all of which show very different SERPs and intents, is not realistic.
  • My suggestion is to pick two or three primary keyword variations and focus on getting your content as relevant as possible to those terms.

Write great metadata

  • Title tags are still an incredibly important on-page ranking factor, so dedicate the right time when writing unique and keyword-rich titles.
  • Meta descriptions are not a ranking factor anymore, but they still play a part in enticing the user to click on a search result. So from a CTR perspective, they still matter.
  • SEO keyword research is the obvious choice to write compelling metadata, but don’t forget about PPC ad copies — check what PPC ad copies work best for your site and take learnings from them.
  • Don’t change metadata too often, though: make sure you do your homework and give enough time to properly test new metadata, once implemented.

Make the right content amends

  • Based on the intent audit and keyword mapping insights, you’re now ready to work on your actual page content.
  • By now, you’ve done your homework, so you just need to focus on writing great content for the user (and not for Google).
  • Readability is a very important part of a page. Tricks that I’ve learned from colleagues over the years are the following:
    • Read the content out loud and try to objectively assess how interesting it is for your target audience.
    • Make sure to use enough spacing between lines and paragraphs. People’s attention span these days is very short, and chances are people will skim through your content rather than dedicating 100% of their attention to it (I’m sure some of YOU readers are doing it right now!).
    • Make sure your tone of voice and language match your target audience (if you can write things in plain English vs. highly technical jargon, do so and don’t over-complicate your life).
  • Make sure you’ve thought about all internal linking possibilities across the site. Not only for the same type of page (transactional page to transactional page, for instance) but also across different types (transactional page to video/blog post, if that helps people make a decision, for example).
  • Optional step: once everything is ready, request indexing of your page in Google Search Console with the URL inspection tool.

Final thoughts

Underperforming content is a very common issue and should not take you by surprise, especially considering that content is considered among (if not the) most important ranking factors in 2020. With the right tools and process in place, solving this issue is something everyone can learn: SEO is not black magic, the answer tends to be logical.

First, understand the cause(s) for your underperforming content. Once you’re certain you’re compliant with Google’s technical guidelines, move on to determining what intent you’re trying to satisfy. Your research on intent should be comprehensive: this is what’s going to decide what changes you’ll need to make to your content. At that point, you’ll be ready to make the necessary SEO and content changes to best match your findings.

I hope this article is useful! Feel free to chat about any questions you may have in the comments or via Twitter or LinkedIn.


To help us serve you better, please consider taking the 2020 Moz Blog Reader Survey, which asks about who you are, what challenges you face, and what you'd like to see more of on the Moz Blog.

Take the Survey

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 25, 2020

Accessible Machine Learning for SEOs — Whiteboard Friday

Posted by BritneyMuller

Machine learning — a branch of artificial intelligence that studies the automatic improvement of computer algorithms — might seem far outside the scope of your SEO work. MozCon speaker (and all-around SEO genius) Britney Muller is here with a special edition of Whiteboard Friday to tell you why that's not true, and to go through a few steps to get you started. 

To see more on machine learning from Britney and our other MozCon 2020 speakers, check out this year's video bundle. 

Get my MozCon 2020 video bundle

Accessible Machine Learning

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

Video Transcription

Hey, Moz fans. Welcome to this special edition of Whiteboard Friday. Today we are taking a sneak peek at what I spoke about at MozCon 2020, where I made machine learning accessible to SEOs everywhere.

This is so, so exciting because it is readily at your fingertips today, and I'm going to show you exactly how to get started. 

So to kick things off, I learned about this weird concept called brood parasites this summer, and it's fascinating. It's basically where one animal tricks another animal of the same species to raise its young.

It's fascinating, and the more I learned about it, the more I realized: oh my gosh, I'm sort of like a brood parasite when it comes to programming and machine learning! I latch on and find these great models that do all the work — all of the raising — and I put in my data and my ideas, and it does things for me.

So we are going to use this concept to our advantage. In fact, I have been able to teach my dad most of these models that, again, are readily available to you today within a tool called Colab. Let me just walk you through what that looks like. 

Models to get you started

So to get started, if you want to start warming up right now, just start practicing clicking "Shift" and then click "Enter".

Just start practicing that right now. It's half the battle. You're about to be firing up some really cool models. 



All right. What are some examples of that? What does that look like? So some of the models you can play with today are things like DeOldify, which is where you repair and colorize old photos. It's really, really fun. 

Another one is a text generator. I created one with GTP-2 — super silly, it's this excuse generator. You can manipulate it and make it do different things for you. 

There's also a really, really great forecasting model, where you basically put in a chunk of time series data and it predicts what the future might have in store. It's really, really powerful and fun.

You can summarize text, which is really valuable. Think about meta descriptions, all that good stuff. 

You can also automate keyword research grouping, which I'll show you here in a second. 

You can do really powerful internal link analysis, set up a notebook for that.

Perhaps one of the most powerful things is you can extract entities and categories as Google perceives them. It's one of my favorite APIs. It's through Google's NLP API. I pull it into a notebook, and you basically put the URLs you want to extract this information from and you can compare how your URL compares to competitors.

It's really, really valuable, fun stuff. So most importantly, you cannot break any of this. Do not be intimidated by any of the code whatsoever. Lots of seasoned developers don't know what's happening in some of those code blocks. It's okay.

Using Colab

We get to play in this environment. It's hosted in Google Drive, and so there's no fear of this breaking anything on your computer or with your data or anything. So just get ready to dive in with me. Please, it's going to be so much fun. Okay, so like I said, this is through a free tool called Colab. So you know how Google basically took Excel and made Google Sheets?

They did the same thing with what's known as Jupyter Notebooks. So these were locally on computers. It's one of the most popular notebook environments. But it requires some setup, and it can be somewhat clunky. It gets confused with different versions and yada, yada. Google put that into the cloud and is now calling it Colab. It's unbelievably powerful.

So, again, it's free. It's available to you right now if you want to open it up in a new tab. There is zero setup. Google also gives you access to free GPU and TPU computing, which is great. It has a 12-hour runtime. 

Some cons is that you can hit limits. So I hit the limits, and now I'm paying $9.99 a month for the Pro version and I've had no problems.

Again, I'm not affiliated with this whatsoever. I'm just super passionate about it, and the fact that they offer you a free version is so exciting. I've already seen a lot of people get started in this. It's also something to note that it's probably not as secure or robust as Google's Enterprise solution. So if you're doing this for a large company or you're getting really serious about this, you should probably check out some other options. But if you're just kind of dabbling and want to explore and have fun, let's keep this party going. 

Using pandas

All right. So again, this is basically a cloud hosted notebook environment. So one thing that I want to really focus on here, because I think it's the most valuable for SEOs, is this library known as "pandas".

Pandas is a data frame library, where you basically run one — or two — lines of code. You can choose your file from your local computer, so I usually just upload CSVs. This silly example is one that I really did run with Google Search Console data.

So you run this in a notebook. Again, I'm sharing this entire notebook with you today. So if you just go to it and you do this, it brings you through the cells. It's not as intimidating as it looks. So if you just click into that first cell, even if it's just that text cell, "Shift + Enter", it will bring you through the notebook. 


So once you get past and once you fire up this chunk of code right here, upload your CSV. Then once you upload it, you are going to name your data frame. 


So these are the only two cells you need to really change or do anything with if you want. Well, you need to. 

So we are uploading your file, and then we are grabbing that file name. In this case, mine was just "gsc-example.csv". Again, once you upload it, you will see the name in that output here. So you just put that within this code block, run this, and then you can do some really easy lines of code to check to make sure that your data is in there.


So one of the first ones that most people do is "df". This is your data frame that you named with your file right here. So you just do "df.head()". This shows you the first five rows of your data frame. You can also do "df.tail()", and it shows you the last five rows of your data frame.

You can even put in a number in here to modify how many rows you want to explore. So maybe you do "df.head(30)", and then you see the first 30 rows. It's that easy just to get it in there and to see it. Now comes the really fun stuff, and this is just tip of the iceberg.

So you can run this really, really cool code cell here to create a filterable table. What's powerful about this, especially with your Google Search Console data, is you can easily extract and explore keywords that have high click-through rate and a low ranking in search. It's one of my favorite ways to explore keyword opportunities for clients, and it couldn't be easier.

So check that out. This is kind of the money part right here. 

If you're doing keyword research, which can take a lot, right, you're trying to bucket keywords, you're trying to organize topics and all that good stuff, you can instantly create a new column with pandas with branded keyword terms.

So just to walk you through this, we're going "df["Branded"]". This is the name of the new column we're going to create. We have this query string "contains," and this is just regex, ("moz|rand|ose"). So any keywords that contain one of those words gets in the "Branded" column a "True".

So now that makes filtering and exploring that so much faster. You can even do this in ways where you can create an entirely different data frame table. So sometimes if you have lots and lots of data, you can use the other cell in that example. All of these examples will be in the notebook.

You can use that and export your keywords into buckets like that, and there's no stall time. Things don't freeze up like Excel. You can account for misspellings and all sorts of good stuff so, so easily with regular expressions. So super, super cool.

Conclusion

Again, this is just tip of the iceberg, my friends. I am most excited to sort of plant this seed within all of you so that you guys can come back and teach me what you've been able to accomplish. I think we have so much more to explore in this space. It is going to be so much fun. If you get a kick out of this and you want to continue exploring different models, different programs within Colab, I highly suggest you download the Colab Chrome extension.

It just makes opening up the notebook so much easier. You can save a copy to your drive and play with it all you want. It's so much fun. I hope this kind of sparked some inspiration in some of you, and I am so excited to hear what all of you think and create. I really appreciate you watching.

So thank you so much. I will see you all next time. Bye.

Video transcription by Speechpad.com


Ready for more?

You'll uncover even more SEO goodness in the MozCon 2020 video bundle. At this year's special low price of $129, this is invaluable content you can access again and again throughout the year to inspire and ignite your SEO strategy:

  • 21 full-length videos from some of the brightest minds in digital marketing
  • Instant downloads and streaming to your computer, tablet, or mobile device
  • Downloadable slide decks for presentations

Get my MozCon 2020 video bundle


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!