SIMPLE SETUP IN GOOGLE SHEETS
All SEO audits end up in a spreadsheet, so we built the WQA to save time by running directly Google Sheets. We’ve leveraged the full potential of Sheets to pull and aggregate data like no software on the market does.
X
WEBSITE QUALITY AUDIT
THE PERFECT SEO AUDIT
X
- Assess the “quality” of your site from Google’s perspective
- Easily identify and clean up low performing pages
- Improve quality and performing of key pages on your site
WAIT…WHAT IS
“WEBSITE QUALITY”?
Search engines send traffic to websites they deem as “high quality”. That means a few things…
- Technically sound websites that are coded and structured according to Google Webmaster guidelines.
- Sites that satisfy “searcher intent” through relevant, authoritative, quality content.
- “Popular” websites, i.e. getting mentioned across the web.
That’s a grossly oversimplified assessment, but point is Google’s algorithm uses known metrics to assess ranking.
WHY DOES IT MATTER?
Google’s algorithm assigns a “quality score” to websites to help with ranking. Having a “low quality” website will cause Google to lose trust in your website and crawl, index and rank it less and less over time.
“Google (Almost Certainly) Has an Organic Quality Score (Or Something a Lot Like It) that SEOs Need to Optimize For”
RAND FISHKIN
We can assess quality of your website by looking at a number of data inputs, including inbound links, on page content, site architecture, organic traffic performance, keyword rankings, SERP Click Through Rate and more.
For this reason, we developed the “Website Quality Audit”. The tool scrapes all URLs on your site and crosswalks them against vital SEO data sources.
This allows us to make decisions about the “quality” of every page on your website and what SEO action we need to take to improve it.
HOW DOES
1
2
PULLS IN DATA FROM YOUR FAVORITE SEO TOOLS
The WQA pulls in data on links, KW rankings, traffic, conversions, revenue, word count, page title, SERP CTR and aggregates it at the page level. You’re left with every piece of SEO data imaginable for every URL on your website.
3
MAKE DATA DRIVEN DECISIONS ABOUT EVERY PAGE ON YOUR SITE
This data lets you analyze the “quality” of your pages. Use “URL actions” to determine how you’ll handle each page in your SEO campaign. Watch our step by step trainings and use cases to understand how to run this report at scale for all your clients.
WHAT DATA GOES IN?
Our report is custom built to give you the metrics needed to kickoff an SEO campaign.
GRAB EVERY URL ON YOUR SITE
- Account for every URL on your site with a full crawl. We use Screaming Frog because the crawl is free.
- The file will also pull through key data points like word count, page title, page meta, status code, canonical link element and page type.
GRAB EVERY URL ON YOUR SITE
- Account for every URL on your site with a full crawl. We use Screaming Frog because the crawl is free.
- The file will also pull through key data points like word count, page title, page meta, status code, canonical link element and page type.
FIND OUT WHAT'S MISSING
- Pings your Sitemap(s) files in to check if any important pages are excluded.
- Accounts for multiple sitemaps (for images, video, site sections, etc).
FIND OUT WHAT'S MISSING
- Pings your Sitemap(s) files in to check if any important pages are excluded.
- Accounts for multiple sitemaps (for images, video, site sections, etc).
EVERY PAGE'S BEST KEYWORD
- Pulls keyword ranking data from SEMrush to find the “best” keyword for each page
- Quickly understand the keyword performance of every page on your site.
EVERY PAGE'S BEST KEYWORD
- Pulls keyword ranking data from SEMrush to find the “best” keyword for each page
- Quickly understand the keyword performance of every page on your site.
TRAFFIC, LEADS AND SALES DATA
- Organic sessions over the last 12 months
- Organic conversions / sales over last 12 months
- If that URL is losing / gaining traffic over time
TRAFFIC, LEADS AND SALES DATA
- Organic sessions over the last 12 months
- Organic conversions / sales over last 12 months
- If that URL is losing / gaining traffic over time
DETAILED SERP PERFORMANCE
- Pulls CTR, clicks and impressions data into the fold.
- This data becomes a powerful crosswalk to understand quick improvements to boost page level SERP engagements.
DETAILED SERP PERFORMANCE
- Pulls CTR, clicks and impressions data into the fold.
- This data becomes a powerful crosswalk to understand quick improvements to boost page level SERP engagements.
DISCOVER RANKING POWER
- Pulls in the number of FOLLOWED links and referring domains for each URL on your site.
DISCOVER RANKING POWER
- Pulls in the number of FOLLOWED links and referring domains for each URL on your site.
WHAT COMES OUT?
“PRUNE” POOR QUALITY PAGES
Identify poor pages on your site that are hindering your crawl rate and quality score with Google - it's the perfect content audit tool.
PAGES WITH QUICK SEO WINS
Find "low hanging fruit" pages on your site that can quickly turn around organic traffic when optimized.
A LONG TERM SEO STRATEGY
It's "swiss army knife" of audits because it bends into every other aspect needed for an SEO campaign.
And so much more. The use cases are endless…
We run it at the beginning of EVERY client campaign. It gives us the data we need to increase organic traffic quickly. We can’t operate without it.”
CESAR COBO, SEO Consultant
WHAT COMES WITH
YOUR PURCHASE?
UNLIMITED USAGE, NO
RECURRING PAYMENTS
- Google Sheets integrates with…just about everything. Our tools leverage the powerful automations, APIs and apps of the Google Suite.
- Allows you to work real time in the cloud. STOP chasing down “latest versions” of deliverables and client files.
- Cancel TONS of expensive software. Our system uses the Google Suite to manage your entire agency with no ongoing costs.
ONGOING SUPPORT AND
CONSULTING VIA SLACK
- Get access to 50+ videos breaking down advanced project management tactics. Learn how to build internal processes to manage your agency and scale.
- Learn the same system we used to scale our agency to $1.1M ARR in just 16 months time.
- The training videos are built for “hands free” training of your next project manager. Pass your login to your next empployee and let us do the heavy lifting.
SOPS, TEMPLATES AND
TRAINING FOR YOUR AGENCY
- We’ve taken an advanced SEO audit and broken it down so even an beginner can run it. Follow along with step by step SOPs and videos to run and analyze the data.
- Allows you to work real time in the cloud. STOP chasing down “latest versions” of deliverables and client files.
- Pass this to a VA overseas
ACCESS TO BLUEPRINT
TRAINING VIDEOS
A deep look at the WQA video course you’ll get access to.
What You’ll LEARN
- What it is and why it’s important. Understanding what “website quality” is and how it impacts organic performance
- The inputs to the report and how we analyze them. All the data that goes into the report and how to take action on it
- The outputs and how it impacts your campaign going forward. This file is our Swiss Army Knife – it drives the majority of our campaigns. It’s part tech audit, part content audit, part SEO strategy
What You’ll LEARN
- How to setup and run the report, step by step overview
- The report generally takes between 10 – 12 minutes to run, once you’ve gotten the hang of it
What You’ll LEARN
- After all your data has made it into the WQA, it’s time to clean it up for your analyst.
What You’ll LEARN
- Adding in a “tag” for page type helps us to better analyze the data. It allows us to segment the site and better prioritize pages / keywords to focus on.
- Compare apples to apples. When analyzing pages, we can’t compare a contact page to a blog post – they’re different page types with different goals, etc.
- I’ve given you 8 page types, you can add more. Our agency changes page type depending on the client, all you need to do is change the “data validation” in the file.
What You’ll LEARN
- Define the pages on your client’s site according to their purpose (ie Product Page, Local Lander, etc).
- You can filter by page paths to apply categories in bulk.
- Add new options for page categories on the ‘Settings’ tab.
What You’ll LEARN
- After each page on the site is classified into category, we can bulk assess page for quality. We assign each page a “URL Action” to determine what to do with every page on a site.
- There “URL Actions” dictate…
- Which pages to clean up (i.e. redirect, NOINDEX, etc)
- Which pages have no potential for traffic and to ignore (i.e. contact page)
- Which pages we will focus on for the campaign (i.e. perform KW research, update “on page” elements, target with links).
What You’ll LEARN
- A live look at assigning URL actions for a client site.
What You’ll LEARN
A live look at assigning URL actions for a client site.
What You’ll LEARN
- Move into action items tab. A project management solution to ensuring items get implemented. We also use this audit to push directly into the next steps of the campaign.
What You’ll LEARN
- Build a presentation deck. If you are working with clients, you can’t send over a spreadsheet of this size. You need to format the data in a more digestible way and present it with easy to understand insights.
- Send to the client. It’s a complicated deliverable that requires extra attention from your communications. We have an email template for you to borrow to get you started.
Get Your
Website Quality Audit!
BLUEPRINT MEMBERS ONLY
The beautiful thing about our system is how easily and often we can upgrade it. Unlike traditional software that goes through development cycles, we can crank out full upgrades in less than a day.
FULL REPORT
- WEBSITE QUALITY AUDIT
- DETAILED GUIDEANCE
- REPORT TEMPLATE
- SOP FOR WQA
Included
READY TO TAKE YOUR SEO AGENCY TO THE NEXT LEVEL?
FAQ
Got a question?
Yes, this report can only be run on websites with 10,000 pages or less.
Any websites higher than that require more firepower than this audit can handle. We have an enterprise report that runs through Google BigQuery that can handle sites into the millions.
For enterprise reporting, please contact us directly.
No, you don’t.
The tool was built to work off data exports from industry standard SEO tools.
Yes, we do.
The WQA is updated on a regular basis, as new best practices are added to the SOP and new data fields become available.
Yes, we do.
You will get access to a private Slack community where our team is standing by to answer questions and troubleshoot issues.
Yes, there are.
The tool is built to use data exports from the following SEO tools:
- Ahrefs
- Google Search Console
- Google Analytics
- SEMrush
- Screaming Frog
The free version of all of these will work for the report. However, you will need to pay for SuperMetrics to run this report.