The Website Quality Audit Tool

A Scalable SEO recipe using BigQuery

 

The WQA tool summary page with action recommendations

 

Discover an automated and scalable way to make decisions by aggregating data from multiple sources.

 

Imagine if you could have a tool that collects and analyzes data from each of your sites and gives you automated improvement suggestions. You would save the time you would otherwise use in repetitive analysis and use it for activities that add more value to your business and your clients.

 

Usually, an SEO analyst spends 2 hours every day analyzing data. This usually ends up taking away a whole work week in just organizing and analyzing the data. This is time that you can use on activities of greater value.

 

On average, an agency spends $500 to $1500 every month on data management and analysis. We have automated this whole solution to not only reduce costs but also save enough time to scale your SEO campaigns.

 

Website Quality Audit (WQA) – A BigQuery recipe to automate your SEO analysis

SEO analysis is a task that takes time and money and you’ll find yourself doing the same things over and over again.

 

What makes the WQA so special is that it:

– Pulls and blends data from Google Analytics, Search Console and DeepCrawl.

– Provides page-level SEO decision making.

– Refreshes data every day.

 

Ready to jump in? Our data analytics specialist will reach out to you get you started with the first free month of website quality audit recipe.



 

What do you get from the WQA?

– Raw data output in Google sheets and Bigquery tables.

– Google Data Studio dashboard

– Action/recommendation logic across technical, On-page and site structure.

An Image of the WQA Google Data Studio Dashboard

 

Ease of use and speed to results

As soon as the setup is complete, you can watch data flow every day from Google Analytics, Search Console, and DeepCrawl. The WQA tool will query your data and provide prebuilt recommendations automatically based on those queries.

 

As an SEO agency, we’ve faced similar challenges as you

Like you, we also faced this very problem in the past. We had large volumes of data from our own site and client sites. Every time we got a new client, the amount of time and money for data analysis grew exponentially. Then one day, the WQA idea sprang to mind.

 

As you can imagine, it was not as easy as it sounds. We had to write code to collect data from the application programming interfaces (APIs) of the tools. Then we had to find a way to combine this data, visualize it, and transform it into insights and recommendations.

 

SQL Query running on BigQuery and its results

 

Here’s what makes the WQA tool a must-have

The WQA tool is a cutting edge tool that will give you:

 

Practical SEO recommendations: Analyze your website based on a combination of Google Analytics, Search Console, and DeepCrawl data. Based on this analysis, the WQA recommends changes that you should make to your site to improve its search engine optimization (SEO). The recommendations are grouped into:

– HTTP status: fixing any unintentional 404 pages.

– Crawl: adding pages to the crawl, or blocking them from being crawled.

– Indexation: setting zero-traffic pages to NoIndex

– Canonicalization: setting canonical URLs for any pages missing them

– Sitemaps: adding or removing pages to/from a sitemap

 

Unified page-level data: The power of the WQA tool is in bringing all this data together into a single view. For example, imagine that for a single page, you have crawl data, Google Analytics Data, and Search Console data for each day of the year.

 

With this data, you can see the current status of that page, how this has changed compared to the last time, and what the trend has been for the whole year. It is with this data that the WQA tool makes recommendations.

 

BigData analysis through BigQuery: The WQA tool collects data from Google Analytics and Search Console on a daily basis. It also collects data from DeepCrawl on a monthly basis.

 

This data is collected from each tool’s API through an app that runs on the Google Cloud Platform. Once the data is collected, it is stored in a Google Cloud Storage bucket which also lives in the Google Cloud Platform.

 

This Cloud Storage bucket is then connected to BigQuery as an external source. We then visualize this data in Google Data Studio and also provide a Google Sheets spreadsheet with the data.

 

Deliverables

Here’s what you get:

An app that runs in your Google Cloud Platform account – The app collects data from Google Analytics, Search Console, and DeepCrawl. From Google Analytics and Search Console, data is collected daily. From DeepCrawl, data is collected monthly.

 

A Google Data Studio dashboard – The dashboard uses charts to visualize the data and show the recommended actions in an easy to consume way. The dashboard also has a date picker that allows you to see the recommendations over time.

 

A Google Sheets workbook – The workbook shows the data for each page, giving you the ability to use custom spreadsheet formulas, filtering, and conditional formating that gives you more insights for your specific industry.

 

How much does the WQA tool cost?

Since the WQA is still in the beta phase, it is free to use. As a beta client, you can check the tool out and benefit from it free of charge for the first month.

 

Use the WQA Tool For Free Now!

We are open to get your feedback and deliver a rich experience to you. This way we request that you leave us comments to help us further improve the WQA tool so that it gives you maximum benefit.

 

Ready to jump in? Our data analytics specialist will reach out to you get you started with the first free month of website quality audit recipe.