Posts

Adding STAT Reports to Google Sheets Using App Scripts

Image
The team at MacMillan Search has generated a lot of value by combining automated STAT reports with Google Sheets. From adding ranking details to other tool’s outputs, to giving the content teams up-to-date “People Also Ask” reports, the end result has proven to be a great time-saver in our week-to-week SEO workflows by reducing manual work and providing standard outputs that easily integrate with any spreadsheet. Why did we create this script? STAT’s wealth of keyword rankings details is very useful for enterprise SEOs to understand both the macro and micro details of their rankings. Google Sheets is one of the most common cloud-based spreadsheets platforms, and is easy to share between teams and organizations. That’s why SEOs use both of these tools regularly when analyzing keyword data. Despite this, documentation on how to integrate STAT into Google Sheets is limited. To address this gap, we created our own script! It’s proven useful for several reasons: Not everyone likes C...

22 Smart Google SEO Tips for 2022

Image
We're back with a brand new season of Whiteboard Friday episodes for your viewing pleasure. First up: SEO expert Cyrus Shepard shares his top 22 tips for successful Google SEO in 2022. Watch to find out what to prioritize and what to look out for in the year ahead! Click on the whiteboard image above to open a high resolution version in a new tab! Video Transcription Howdy, Moz fans. Welcome to another edition of Whiteboard Friday, a very special edition, our annual SEO tips of the year edition. This year it is 22 smart SEO tips for 2022. I'm going to be talking about some of the most talked about things in the SEO industry over the past year plus a few tips from last year that we wanted to pull over because they were just that important. Because we've got 22 of them and we don't want this video to take forever, we're going to be going through these pretty quick, but for you we've linked to some resources in the transcript below so you can explore al...

2022 Local SEO Success: The Year of Everywhere

Image
“Everywhere!” is going to be the ebullient byword for approaching a brand new year of local search marketing with gusto. In 2022, the opportunity is there for local businesses to be everywhere customers are looking at a time when they are particularly open to change, whether that’s exploring new companies, testing new brands, or trying new modes of communication. Public health, and its direct impacts on local businesses, will remain unpredictable. However, what’s as sure a bet as you’ll find anywhere these days is that if the companies you market can be found and liked by customers, you can significantly expand the number of neighbors you get to serve with care, compassion, and a commitment to making this a very good year for brick-and-mortar shops and SABs. Let’s set you up for success with seven local SEO precepts for the year ahead, some expert commentary, and many signs of good things to come! 1. Converse with customers everywhere, with extra kindness “What the world needs now...

Hit Me With Your Best Blogs: The Top 25 Moz Blogs of 2021

2021 was a big year for Moz: we joined the Ziff Davis family , held our second all-virtual MozCon , added a technical SEO certification to Moz Academy, released new and improved guides for topics like  local SEO , link building , and Google Analytics , and launched exciting betas for Moz Pro — Performance Metrics and True Competitor .  We also published 186 posts on the Moz Blog this year, and as is tradition, it's time to look back at the most popular ones! You’ll find Whiteboard Friday episodes, technical SEO insights, search engine updates, and tips for analytics, among several other topics.  Enjoy this look-back, and have a safe and happy new year, Moz friends! See you in 2022.  *The top 25 Moz Blog posts published between January 1 - December 28, 2021, in order by pageviews generated during that timeframe. 1. 21 Smart Google SEO Tips Author: Cyrus Shepard | Published: January 8, 2021 Moz SEO expert Cyrus Shepard shares...

Local SEO Statistics that Tell Our Industry’s Story

Image
What a gift it is that local SEOs put hours of research into facets of our industry and then freely share their findings! Today, I’m going to bundle the most important recent local search marketing statistics and survey takeaways into a single gift basket, which you can draw from when you need to create a compelling narrative which clients can quickly understand, demonstrate the value of a particular campaign to bosses and co-workers in order to get buy-in on an initiative, or even just explain to mystified friends and family what you do for a living.  With sincere thanks to all the people cited in this column for your brilliant and useful work, here are my top local SEO stat picks that tell the story of our local SEO present and future. Local search and localism are going strong!  The stats Small Business Saturday 2021 saw record-high $23.3 billion spending in the US , with 70% of survey respondents saying American Express’ campaign inspires them to encourage their c...

3 Effective Ways to Quickly Identify Your SaaS Brand’s Top SEO Competitors

Image
There are over 22,600 software-as-a-service (SaaS) companies in the world right now, according to Crunchbase . On Capterra, there are more than 800 software categories. Research by Statista indicates that the market size of the SaaS industry has grown from $5.56 billion in 2008 to over $156 billion in 2020 . What do these figures show? It’s simple. The SaaS industry landscape is becoming more competitive by the day. To stay on top of your game as a SaaS business, you must identify the companies you're competing with from an SEO standpoint. That way, you’ll know the content strategies to focus on, the keywords to target, and the type of backlinks to acquire. In this post, you’ll learn three effective ways to do this quickly. Why care about your SEO competitors as a SaaS brand? If you don’t know your SEO competitors, you’re leaving so much on the table, while they occupy the top spots on the SERPs. 1. You can identify the top keywords they’re targeting and how they’re acquirin...