Central Perk

marți, 16 septembrie 2014

How to Combine Screaming Frog Data with Google Analytics Data

Posted: 15 Sep 2014 03:52 PM PDT

This post was originally in YouMoz, and was promoted to the main blog because it provides great value and interest to our community. The author's views are entirely his or her own and may not reflect the views of Moz, Inc.

I love Screaming Frog. It is without doubt the best SEO tool I use on a daily basis (no offense, Moz). The sheer amount of data you can get about your website, or someone else's website, is incredible. You can find broken links, you can check for your Google Analytics (or any other) code on all pages through the custom search, and you can even go so far as to follow all the redirects and find out the redirect paths in a website.

In this quick guide, I'm going to show how Screaming Frog data can be used to help perform a content audit.

The data in Screaming Frog is incredible, but one thing it can't do (yet…give it time) is tell you how popular your pages are. For that, you need an analytics package. We're going to be working with Google Analytics on this one, as it's probably the most well known (and well used) of the analytics services out there, and we're going to combine the two data streams into one to give you a full overview of your content and just how popular it is. As this data is from a website I work with (rather than my own), I'm going to hide the URLs in the screenshots for obvious reasons.

Why would you want to do this?

Combining Google Analytics data with your Screaming Frog data has a myriad of advantages. You can get an overall picture of your site and identify any issues that are occurring on popular pages. You can see which pages within your site have no page views at all, or the ones that have very few page views. Maybe there are issues on these pages that become immediately apparent when you combine the two datasets.

Getting your data

Step 1: Screaming Frog

Spider the website you're working with in Screaming Frog. Just type the URL in the box and click go, and off it goes getting all the data from your website.

Filter the list to just include HTML and hit export:

Step 2: Google Analytics

Head over to Google Analytics and go to the "All Pages" tab:

Set a decent data range of a couple of months so you get some decent data (especially if it's a low traffic site), and set "show rows" at the bottom to 5,000 so you get as much data as possible.

"Hang on a minute, Jim," you're saying….I have a lot more than 5,000 in my list. How do I get the rest? Well, that's a simple hack. Go to the URL at the top and look at the end of it for the 5000. It will look something like this:

Now just up that figure to cover all of your page views, and you'll have a huge long list. I have 9,347 on my list, so I'm going to up it to 10,000.

Great. Now export that data to an Excel file:

Now you have the two sets of data in Microsoft Excel format. Next, we're going to combine these two data sources into one

First step. Open them up and put them both into a single excel file on different worksheets, then label them so you know which is which:

Now, make a third empty worksheet for your compiled data. Here's a view of the worksheets you should have at this point:

To make this work, we'll need the URL (page name column) to be the same on both sheets. The Screaming Frog data contains the domain, where as the GA data doesn't, so use find and replace on the Screaming Frog data to remove the domain up to the first trailing slash. The two data sources should now have URLs that match.

With me so far? Great. Now it's time to link the data sets together and get that lovely combined data in your third worksheet.

Linking the data

OK. Go to your Screaming Frog worksheet and select all the data and on the formula tab, click define name – give it an easily identifiable name (I would name it the same as your worksheet).

Then do the same with the GA data: Select it > Formula Tab > Define name > Name it the same as the worksheet.

Got both of them defined? Groovy, time to put this data together.

Save your file.

Go to your third worksheet, named "compiled data."

Then on the data tab, select "From Other Sources" then From Microsoft Query.

It will then ask you to choose your data source, choose excel file from the options and click OK. Then, find your saved Excel file and select it; you'll be given the option to include your two named data sources.

Select both, and add them to columns in your query. Click next, you'll then be presented with what looks like an error message (but isn't really).

Click OK.

Then drag "Page" on the GA Data onto "Address" on the Screaming Frog Data like this

And, you'll notice all the data from the two data sources below will reorganise itself.

Then, click file > "Return data to Microsoft Excel."

On the next one, just click ok… and that's it. You should now have a single worksheet with the combined data from Screaming Frog and Google Analytics to play with and do what you want.

Hope my little tutorial made sense and people find it of use. I'd love to hear what other people use this tutorial to accomplish in the comments :-)

Thanks all!

Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

The Graze Box – An Employee’s Survival Kit

Posted: 16 Sep 2014 02:05 AM PDT

I have to admit, I am a bit of a sucker for a free trial or a free gift. I am also the type of person who never stops being hungry and who cancels their free trial just before the 30 days are up. Until now, I think I’ve found one I won’t be cancelling.

The Company

Originally started by 7 friends who love food and wanted more from snacking, they began inventing snacks that showed off healthy eating’s more pleasurable side and working out the best way to get snacks to their customers.

With a kitchen in London, their team of snacking inventors are forever busy coming up with new and inventive, tasty ideas and have so far created over one hundred snacks.

Their motto – "Healthy snacks delivered straight to your door". And they do exactly what they say on the tin, or should I say box? A healthy snacking company that has been around for a couple of years now after exploding onto the food scene, bang on trend when the world was starting to question where their food came from.

How does Graze work?

In a nutshell, Graze is a selection of snacks that are delivered right to your work or home. You receive a box in the post with four well branded plastic containers of randomly selected snacks. There is a variety of food ranging from small puddings to seeds and flapjacks. They are also the only snack delivery business that offers dips with their snacks, like their incredible Salsa Fresca snack.

The Graze Website

The Graze website has a remarkable amount of options for a simple product. The main thing Graze has going for them? The choice of 100 different and yummy snacks. Once you receive your randomly selected snack box, you can rate how much you like it. Or simply navigate around the site to review their products before you’ve even received your box in the post.

You also have powerful control over the delivery frequency of your snacks. Navigation through the site is handled through the main menu at the top of the screen and it's probably where you would spend 90% of your time on the site. Unless you're like me and just want to browse through rows and rows of mouth-watering food!

The Menu

When you enter the site through the homepage (and you're logged in) you can see a list of categories on the left, some foods that have been sent to you recently, others that haven't. The main images on the homepage display what you have ordered recently and this is an easy way for you to rate the snacks that you've received.

Your Food Preferences

Graze has a simple to use rating system that will allow you to control the content of your boxes.

Graze Rating buttons - Bin, Try, Like, Love, Send Soon

Graze's food preference system works on four levels. Bin, Try, Like and Love. If you really want an item, click 'Send Soon' and Graze will do their best to get it to you in one of your next deliveries. If you didn't have time to set all of your preferences during signup, you can access this again from your control panel in your account under 'Your Snacks'. You can also adjust your ratings based on deliveries you receive. If you receive something that was on your 'try' list, and you end up loving it (or even hate it) you can rate the product accordingly.

When I used Graze the first time I went through to the snack categories on the left of the homepage and went through their snacks to see what they offered. It was at that time I rated the food – it was just me trying to save time in the future (and being nosey). When I had binned some of the items, Graze had noticed that I was eliminating certain foods with Almonds in and asked if I wanted to bin everything with Almonds in. This shows Graze has some sort of clever algorithm, making the menu selection just that bit easier!

Also on the food menu are three filters that allow you to list items based on your religion / dietary requirement. These include Non-Vegan, and Non-coeliac. Each of these areas has a quick button to bin all foods in that group so you dont have to search through every group to remove individual items. Clever eh?!

Getting your Graze Box

Deliveries is your second most important tab. From here you can control the frequency and destination of your Graze boxes. The centre screen shows your previous deliveries (as well as any that are currently being prepared), with the right displaying three tabs 'Holidays', 'One-Off boxes' and 'Your Weekly Boxes'. From this screen you can view / rate previous boxes, manage your upcoming deliveries and their frequency, tell Graze when you're on Holiday and wont be wanting your boxes, order single boxes, or manage your reoccurring deliveries.

Graze – Your Last Boxes

From here you can view all your previous boxes, as well as any boxes that are being prepared by Graze. You can view the contents of each box by clicking 'What did I get?', you can share the contents of this box on Facebook and Twitter, or you can send feedback to Graze about the box and its contents.

Your Holidays

From here you can schedule breaks in your Graze Deliveries by telling Graze the dates when you'll be away From and Until. This way no food will be sat in your mailbox while you're sunning yourself on a beach. This is also useful for scheduling occasional breaks from your Graze Boxes.

Your One-Off Boxes

From this section of the website you can tell Graze to send you a single box without creating a reoccurring delivery.This is useful should you need that little extra on a certain day, or just want to sample a different type of box.

Your Weekly Boxes

This is where you are able to control your deliveries and the frequency in which you receive your box. When you create a new reoccurring delivery it is automatically set to 'Weekly' for frequency. You can change this to 'Every two weeks' once you've initially set it up. Graze also allows deliveries to multiple addresses (I’ve recently set my Nibblebox to to be delivered to work and my breakfast box to my home address).

If at any point you decide to cancel your Graze Deliveries, you just need to remove your Weekly Boxes from here and your deliveries will stop.

Creating an account

So now you’ve taken a look around the site, how do you sign up? Creating your account is simple, all you have to do is press the ‘get started’ now button. There’s loads of them dotted around the site! It’s an email and password kind of thing and you select the type of box you want to receive, you have a choice of light snacks (low calorie), the breakfast box, nibblebox… the list goes on! I started with the nibblebox and then signed up for a breakfast box to be delivered as well!

Once you have your account basics set up, you then choose how often you want to recieve your box, monthly, fortightly or weekly. And then hey presto! Your 1st box is delivered to you as and when you requested it.

My Final Thoughts

I am so obsessed with this snack delivery service. The only downside of the product? I eat it all in one go because it always looks to good! My recommendation for the site though would be to offer different package types for customers. For example, a basic account would be 4 snacks, Silver package 6 snacks and a Gold package would be 8. All with different pay monthly charges. It just allows another option for the customer to customise their box.

One thing I have noticed is that there is no easy way to delete your Graze account. You can stop all deliveries and subscriptions in your account settings however I feel there needs to be an easier way for customers to cancel their account. A ‘delete account’ option in the drop down navigation from the account holders name would fit nicely and offer customers an easy route to delete their account.

Additionally, I want to take the time to mention their branding. I think they have it spot on. It’s unique, it looks quirky and contemporary but also has an ‘earthy’ edge. Do you like their branding? Have you used a snack delivery service? I’d love to hear your thoughts!

The post The Graze Box – An Employee’s Survival Kit appeared first on White.net.

Seth's Blog : People who like this stuff...

People who like this stuff...

like this stuff.

When you work in a genre (any genre), break all the rules at your own peril. Sure, you need to break some rules, need to do something worth talking about. But please understand who the work is for.

If it's for people outside the genre, you have a lot of evangelizing to do. And if it's for those that are already in it, you can't push too far, because they like the genre. That's why they're here.

Those who have walked away probably aren't just waiting around for you to fix it. Those who have never been don't think the genre has a problem they need solved. Blue sky thinking isn't really blue sky thinking. It's a slightly different shade of the blue that's already popular.

It's a little like the futility of the "Under New Management" sign on a restaurant. People who like the place don't want to hear you're changing everything, and people who didn't like the old place aren't in such a hurry for a new place that they'll form a line out the door.

The opportunity is to create a pathway, a series of ever-increasing expectations and experiences that moves people from here to there.