We're hiring

We love digital - Call
03332 207 677
and say hello - Mon - Fri, 9am - 5pm

Call 03332 207 677

Graeme Benge

Screaming Analytics! A Guide to Google Analytics Integration in Screaming Frog

1st Sep 2015 Analytics 4 minutes to read


Screaming Analytics! A Guide to Google Analytics Integration in Screaming Frog

A long-trusted servant of mine, Screaming Frog, had itself a little upgrade back in June. A number of changes were made but the standout features that caught my attention were the new ‘Custom Extraction’ and, OMG… GOOGLE ANALYTICS INTEGRATION!

SEOs, digital marketers and all other Holistic Inbound Internet Botherers rejoiced at the news, for at last there would be a means to combine Google Analytics data with HTML elements in a more convenient format than tinkering with the inner workings of the Google Analytics interface.

In this post, we’ll set ourselves up and consider and touch on what we can do with the results of the crawl.

Point of order: crawl responsibly, folks. There are things to bear in mind when crawling a website, as you are sending a lot of requests to a server in a very short space of time. 

Setting Up Google Analytics In Screaming Frog

1. Before you start a crawl, you need to enable access to the GA API. Go to Configuration –> API Access –> Google Analytics and a box will appear:

Google Analytics Integration Into Screaming Screaming Frog

2. Click ‘Connect to New Account’ and use the email address linked to your Google Analytics account:

Google Analytics Integration Into Screaming Screaming Frog - Sign In

3. Now you can pick the Google Analytics account, property and view for the domain you’re looking to crawl. Do this from the drop-down menus and don’t hit ‘OK’ just yet:

Google Analytics Integration Into Screaming Screaming Frog - Account Picker

4. Now pick your date range. Sadly, there isn’t a comparison function here, that would be even sweeter:

Google Analytics Integration Into Screaming Screaming Frog - Date Picker

5. Let’s choose some metrics to look at. Currently, the limit is 20. For a set of 10 metrics, the API call is much smaller and therefore much quicker to execute. As a result, you’ll see a default set of 10:

Google Analytics Integration Into Screaming Screaming Frog - Metric Picker

Get Crawling!

Once you’re happy with your set-up (and have added a domain to crawl!), hit the Start button and go get a coffee.

On your return, that shouty frog, as he is known at Koozai HQ, will have returned a crawl of all the HTML pages and the console will look a little like this:

Google Analytics Integration Into Screaming Screaming Frog - Analytics Console View

Note that the Export drop down has three pre-defined segments ready to export:

• Sessions Above 0
• Bounce Rate Above 70%
• No GA Data

But we can do even better than that. By switching to the Internal tab and then selecting the HTML option from the Export drop-down, we can see the Google Analytics data alongside the other HTML elements extracted from the crawl:

Google Analytics Integration Into Screaming Screaming Frog - Internal HTML Console View

I open up the CSV export in Excel and get tinkering. First of all, I hide the following, mainly because they aren’t needed:

• Content
• Status
• Meta Keyword
• Meta Keywords 1 Length
• The tag lengths
• Meta Refresh 1
• Size
• Hash
• Response Time
• Last Modified

What’s left can let me know where there are HTML improvements to make as well as the various GA metrics you may want to look at.

You may have different preferences or scenarios but these choices work for me as regards combining GA data with the key elements of a page that should be, or have been, optimised and should have their performance checked.

Now, on to practical uses. I’m going to look at a few ways to use this data to analyse your content.

When you first start working on a project, you will typically run a crawl of your site as well as pick through the various Google Analytics reports to build up a picture of the site you’re looking at.

Now you can add the GA data and specify as large a date range as possible to see meta data like title tags, header status next to Pageview or ecommerce data.

For an SEO focus, if you set up the API access details to pull specifically Organic sessions, you can pinpoint certain performance measures that cover SEO and conversion analysis:

Google Analytics Integration Into Screaming Screaming Frog - Organic Segment

In your export, add a filter to each column and freeze panes so your URL remains in view and get busy isolating pages by a common theme (subfolder), for instance.

From here, you may look for pages that stand out. These can then be investigated further and improved from a usability, conversion or search engine perspective. Here are some suggestions:

• High bounce rates and low conversions – Is the meta optimised? What is the word count? When was the last content audit?

• Pages duplicating meta or URLs with/without trailing ‘/’ – Which has had the most sessions? This could point you in the right direction of which URL to canonicalise.

• For a range of products, are there any conversion or session outliers that significantly outperform the rest? What can be replicated or what needs removing?

Summary

Screaming Frog was always one of the most popular tools used by SEOs and the like. Ideally, you should use as few tools as possible, but a one-stop SEO shop doesn’t yet exist. That said, with Google Analytics integration, Screaming Frog is now a step closer to that.

Share this post

Graeme Benge
About the author

Graeme Benge

Graeme is a self-confessed chocolate addict and his carefully curated physique reflects this. His beard is better than yours and if you ever want to see such a majestic creature you can find him in the ‘room of doom’ listening to rock and heavy metal.

4 Comments

What do you think?

  • aspect-ratio
    Nicola Churchill

    The Psychology Of Colour In Marketing

    When it comes to building a content marketing campaign, it can be difficult to know where to start. You may have an initial idea but bringing it to life and getting your message seen are always harder than initially thought.
    (more…)

    Nicola Churchill
    @with_nic
    30th Jun 2017
    Content Marketing
  • aspect-ratio
    Cat Birch

    Koozai Launches Free Breakfast & Learn Events

    We’re excited to announce that we’re launching a series of free Breakfast & Learn events for brand-side marketers. Our digital marketing experts will help you to boost your SEO, paid media, paid social and content marketing knowledge over breakfast.
    (more…)

    Cat Birch
    @MissCatBirch
    25th May 2017
    News

Digital Ideas Monthly

Sign up now and get our free monthly email. It’s filled with our favourite pieces of the news from the industry, SEO, PPC, Social Media and more. And, don’t forget - it’s free, so why haven’t you signed up already?