• FAQs

          Search engine optimization (SEO) helps businesses drive visits to their website through organic search traffic. Given that the top organic search results receive a third of the clicks, a decline in ranking could be detrimental for your business. Implementing SEO best practices on your website will help to ensure that your web content is seen by as many potential customers as possible. The more visitors you have, the better your chances are of converting those visits into sales!

          Local search engine optimization (SEO) helps local businesses gain visibility by optimizing their local business listings for local search. A business that leverages local SEO will include its address, phone number, local opening times, and exact location in the form of a local citation. The goal is to rank for local searches which are usually performed by people in a specific geographical region looking for a business near them.

          We typically see results within the first 30 to 60 days, but when it comes to SEO, there are many factors at play. It's important to remember that SEO is a long-term strategy and results may not come as fast at you wish.

        • FAQs

          Digital advertising uses the internet to send advertisements to customers who are online through different websites and social media platforms like Google, Bing, LinkedIn and Facebook.

          The price for Google Ads management depends on the monthly ad spend. For accounts with $1,000 in monthly ad spend, the price is $550/month. Between $1,000 and $5,000 a month in ad spend, the price is $950/month. For $5,000 to $10,000 a month in ad spend, the price is $2,000/month. For more than $10,000 a month in ad spend, the price is $4,500/month.

          The price for Social Media Ads management depends on the monthly ad spend. For accounts with $1,000 in monthly ad spend, the price is $550/month. Between $1,000 and $5,000 a month in ad spend, the price is $950/month. For $5,000 to $10,000 a month in ad spend, the price is $2,000/month. For more than $10,000 a month in ad spend, the price is $4,500/month.

        • FAQs

          This depends on the complexity and size of a redesign and if eCommerce is needed. On average, it takes around 14-18 weeks from the web design intensive stage to launch.

          If your website experiences the following issues: it’s not responsive on all devices, has a slow loading speed, the design appears old and tired, users don’t spend long on the site, sales are stagnant, or your business is going through a rebranding - your website needs a redesign to boost your brand awareness and sales.

          Sometimes there’s no need to rebuild a website. Minor edits, refreshing page content and images, or restructuring page layout for SEO best practices can boost traffic and sales.

        • FAQs

          Semantic search launched in 2013 with the release of Google's Hummingbird update. Since then, Google's search engine has become more complex. The integration of machine learning, with RankBrain, and NLP, with BERT, has enabled the search engine to better understand the context of a query and deliver more personalized and targeted results. Semantic SEO is the process of creating machine-readable content using structured data and linked open data to help search engines better understand your content.

          On-page SEO is the practice of optimizing individual web pages in order to rank higher and earn more relevant traffic in search engines. On-page SEO refers to both the content and HTML source code of a page that can be optimized, as opposed to off-page SEO which refers to links and other external signals. From meta tags to page content, website structure, and HTML, on-page optimization services are focused on making your website more visible to search engines.

          Structured data refers to any organized data that conforms to a certain format, such as information in a relational database. When information is highly structured and predictable, search engines can more easily organize and display it in creative ways. Structured data involves using a piece of code that is laid out in a specific format easily understood by search engines. The search engines read the code and use it to display search results in a more dynamic way.

        • FAQs

          An SEO agency has experts in different areas of search engine optimization that may be out of the realm of your marketing team's abilities. SEO can be very complex and time-consuming. Furthermore, as search engine algorithms change it can be difficult to stay current on the latest ranking factors and strategies for improving online visibility. You will likely see a greater return on investment and better results from using a professional SEO agency than you would from tackling this on your own.

          As a digital marketing agency, SMA Marketing provides products and services in four areas: SEO, Local SEO, Digital Advertising, and Web Design

          We focus on building authentic, long-lasting relationships with our clients. We’re goal oriented and results driven and believe in doing good and making a difference in the world.

  • Contact

Quick SEO Crawl and Audit with Screaming Frog and Google Sheets

Need to run a quick crawl of a website? Want to visualize the insights fast so you can decide what to do next? In this video, I’ll walk you through how to do a quick, high-level crawl of a site using Screaming Frog SEO Spider. Then we will visualize some key data points with the help of Google Sheets.


Video Transcript: 

In the latest episode of Hack My Growth, I’m going to walk you through a quick SEO crawl using Screaming Frog SEO Spider, as well as how we can quickly visualize that data using a Google Sheets template. Hey, thanks for checking out this video. If you’ve enjoyed the videos we’ve created on this channel, please hit subscribe, and don’t forget to turn on that notification button. We create new content each week to help you get the most out of your digital marketing efforts.

So as I talked about in the opener, we’re going to be walking through how we can set up a quick SEO crawl using Screaming Frog SEO Spider. This is a really great tool. It’s a tool that we use pretty much every single day here at the agency. And it helps us get both a 30,000 foot view of a website as well as a extremely granular detailed view of a website. And today we’re talking all about a quick audit. This is going to allow us to see a site from a very basic level, but help give us an understanding of maybe some big or quick wins that we could use with a client or a possible prospect.

SEO Crawl with Screaming Frog

All right, let’s get into the content. All right, so in this video, I’m going to walk you really quickly into an overview of a basic site crawl using Screaming Frog. Screaming Frog SEO Spider is probably one of the most useful tools for any SEO or really any site owner that really wants to understand more about their website. We’re just going to go a quick overview of how it works, how you’d set it up and how you’d run it. And then I’m also going to share quickly just a very simple report visualization that we can do within Google Sheets.


So the first thing you’re going to do with Screaming Frog is you can add your URL in here and if you just want to go, you can go ahead and hit start. But there’s a number of ways to actually run this crawl. You can do your whole domain here, but if you want to just run a few pages, you can do that as well. You’ve got different modes here. So you can run a list, you can actually pull data from the search results and then you can compare. So this is an extremely useful tool if you want to really understand your website, maybe a list of pages, as well as the search results themselves.

Now in this video, we’re talking specifically about crawling our own website. Now, I like to go in here first and do some configurations. If you’re going to do a deep crawl, you’re going to want to probably have a lot of these things clicked and checked off.

But if you want to just get a quick site crawl and understand just at a very basic level how optimized the site is or what’s the foundations of this site, you don’t have to actually crawl and restore all of these different things. It will take longer if you crawl the images in the CSS in a JavaScript. And if you’re doing an in-depth crawl and you want to get a very in-depth view of that website, I highly recommend that you have these checked.

But if you’re really just looking to get a basic idea of what’s going on with a website, or maybe you’re doing a quick audit, or maybe someone’s asked you like, “Hey, do you want to work with our site?” You don’t have to go super deep in that first go around to really see whether or not this site is something that you want to get involved with.

But now, as you can see, you can crawl all of these different elements. You can crawl different page links. You can shift how the crawl behavior is. You can even crawl the site maps if you want to as well.


There’s a number of things you can extract as well with Screaming Frog, which is really cool. You can do page titles in metas, but you can also do JSON-LD, RDFa and schema.org. All of that stuff. So if you want to see are they using structured data, you want to have these checked. You can also store the HTML as well.


Here you’d set your limits. So how many pages do you want to crawl? Depending on your business, you could crawl pages with 50 links, you could crawl pages through up to 10,030. We’ve done crawls with over 30,000 links. It takes a lot of time, but it’s definitely a tool that that can handle that kind of work for you. So this is where you really want to set up those settings here. How many redirects you want to follow, right? So if they’ve got a redirect chain going on and all the different URLs and how deep you want to go.


Rendering, this allows you to crawl sites that maybe don’t play nice with crawlers. Right now, it’s set to text only, so it’s just rendering the text itself. And as you can see, if you hover over it, it’ll tell you a little bit more about it. And you can shift this to see if you get different results. So there’s other modes here like Old Ajax crawling as well as JavaScript. Now, some sites you’ll have to use JavaScript in order to crawl them because of the way that they’re built. So if you start crawling a site and you notice you’re not getting any links, try some of these different rendering settings, and you might actually start to pull the data you’re looking to pull.

Advance & Preferences

Screaming Frog’s got a lot of advanced features as well in preferences, and you can set all of these customizations here. All the different rules that you want to set to really help your crawl do what you want it to do.


Now I’ve already set a crawl here that we don’t have to look at it. And as you can see up here, we’ve got all the different tabs. There’s a ton of data that Screaming Frog is going to pull. We’ve got the URL, all the site data. Anytime you click on one of these links, you’re going to get more and more information, as you can see right here, which is really, really cool. Allows you to see pretty much anything about the website.

Over here they always give us a summary, and the summaries always have these nice little visualizations as well. So I can look at all the URLs that we’ve encountered. I can look at how that crawl data was seen. I can look at the security of the site itself. And as you notice over here, the pane also changes. I can look at the different URL structures and the page titles and all this really cool data that I can now use to go optimize.

Let’s say you going to take this data, and you want to do some basic analysis from just a copy and paste standpoint. Well, what you can do is go to this internal tab here and click export. This is going to build a CSV file. You can also select any of the other things that you want to select here. Google Sheets or whatnot. And go ahead and save that file. That is going to allow you now to copy and paste this file into Google Sheets.

And I’m going to share this Google Sheets with you. All you have to do is paste this data here, and this is all the crawl data, the internal crawl data. So you’ve got everything like the page type, the status codes of those pages. Are they good? Are they live pages? Are they being redirected? What’s the indexability? I mean, list goes on and on and on and on. As you can see here, we’ve got everything from word count, text ratio, crawl depth.

If you want to get this score right here, this is called Link Score, and this is a Screaming Frog metric for internal links. After you run this crawl here, you can actually go up here to hit crawl analysis and hit start.

What this will do is it’ll run another analysis on top of this crawl data, and that is where you’re going to get the Link Score. And the Link Score is basically an internal page rank of your pages that’s been calculated by Screaming Frog. So, if you want to see how strong a specific page is compared to the rest of the other pages, like we see here that this page has a 100, but then these pages are like in the 30s, and as it goes lower and lower now, because we’ve ranked it there, these pages have maybe less weight. Or these are maybe pages that we need to get some more internal links to, so that we can improve the link score of those pages. So it’s like an internal link metric, which is pretty cool.

Within the thing that we built, right now, just the quick overview, we don’t have this in there. But it’s a nice little thing here that you can do and again, you just go to crawl analysis and hit start. But as you can see, we’ve got all of this data, and sometimes it’s hard. Like when you’re just looking at a website or somebody comes to you and says, “Hey, can you do a quick audit? I want to see a high level view of what’s going on with the website.” You don’t really have all the time to go through this data, and you just want to see some big things and go, “Okay, yeah. There’s some opportunities here, or maybe there’s not.”

So after you paste the data in here, you can go over to this visualization tab. And what we did here is we just narrowed it down to some of the high level things that we wanted to look at. So we’ve got the URL, the total URL’s crawled with this website, what’s the average word count of the pages that we crawled? What’s the indexability status of these pages? Are they indexable, or are they not? What are the response codes? Do we have a lot of broken pages, things like that?

And as you can see, we’ve pulled all the data over here, and this is all done just with some Excel commands, and then we visualized it here. So, okay. We can do some title tag optimization. There’s some meta tag optimization need to be done. Probably need to work on canonicalization. And the crawl depths pretty good, but there’s a lot of pages here that are three and four clicks away. How can we flatten this site out and maybe make it a little bit better?

So this is not your in-depth crawl. This is not going to tell you everything about the website, because we’re doing this from a quick standpoint. This is a quick SEO crawl to help give us just a 1,000 foot view over this website that we can do really quickly using Screaming Frog. And then we built some visualizations here to let us go, “Okay, we see that there are some quick opportunities here that we can do something about.” Now you can go back to your crawl, and you can find what those pages are, and you can really start to manipulate the data to put it back to work for you, so now you can implement these changes.

So this was a quick SEO crawl with some visualizations using Google Sheets. I hope you found this helpful. If you’ve got any questions about Google Sheets or maybe Screaming Frog and how you can set that up, please let us know. We’d love to continue that conversation with you. And until next time, happy marketing.

New call-to-action

Search by Topic

  • All Resources
  • SEO
  • Digital Advertising
  • Content Marketing
  • Web Development

Get Up-To-Date Digital Marketing Tips and Tricks Delivered Straight to Your Inbox!

SMA Marketing Digital Marketing Agency Giving Back to Kiva Making Loans