About frans

Website:
frans has written 4625 articles so far, you can find them below.

Outdated SEO Concepts People Still Think are Reality

Posted by katemorris

Blaise Alleyne

It’s on the internet, so it’s true.

The bane of the existence of all search marketers is old or incorrect information given to clients at any point in time that they still hang on to. This post was inspired by an interaction with a client’s co-workers, people that are not thinking about SEO on a regular basis. This is not to knock them, but to bring to the attention of everyone that there is a continual need for education. These concepts have a way of hanging around.

And this isn’t about just clients either. This is about friends, parents, and partners. Does anyone else still get asked if they make pop-up ads when they try to explain what they do? (Just me? Crap.)

Doing research for this post, I noticed there are a ton of SEO misconceptions out there, and people are talking about them regularly, but many are related to content marketing or online marketing overall. I’m not covering all misconceptions, but those concepts that seem to be stuck to the idea of SEO and will not let go. Then I’ll give you resources to help educate the people that believe these misconceptions and alternate solutions to give them.


Hiding Cat by Aftab Uzzaman

Putting text behind an image

The inspiration. The client is struggling with balancing revenue and content on the page. There is a large image on the page now and we suggested editing the page to add content about the product. The question was asked if we could just put the content behind the image and solve both problems.

My client stepped in and answered the question wonderfully, but it brought to mind how many times I’ve seen overstuffed alt text attributes and content in a noscript tag that doesn’t match what’s in the Flash.

Additional resource

A Comprehensive Guide to Hidden Text

Alternate solution

In this instance, we recommended putting text below the fold for the users that wanted the information and keeping the current image for returning users. Balance that satisfies both user needs and the business goals.


Copying a competitor’s actions

This isn’t as obvious as hiding text, but it’s something that companies refuse to stop doing. It’s the concept that if a competitor is doing something, it must be worth doing. This goes for competitors ranking above a business, but it also covers competitors that the business just dislikes. We all have those competitors we want to “beat” and sometimes that makes us do things that are not fully researched and planned.

Amazon.com is my biggest annoyance. I can’t count how many times I’ve heard the reasoning “but Amazon does it” by major brands that other businesses look up to. Amazon, like most major companies, tests many things, and there is a different person behind each test. If you work for a large company, you understand what I mean.

Additional resource

Stop Copying Your Competitors, They Don’t Know What They are Doing Either

Alternate solution

Everyone is on the hunt for the best results and bringing in new customers, retaining current customers, and making other stakeholders happy. The way you beat competitors is to listen to your stakeholders (customers, clients, partners, employees, investors) and make decisions based on their feedback as well as what is going on in the market.


Sheer number of links equals ranking

This has been debunked so many times it makes my head swim. That doesn’t change how many people still think that the total number of links (as reported by a third party tool like Moz, Majestic, or AHREFs) is the sole factor in ranking. Want to do better in SERPs? Well, we need to hire someone to build us some links! I’m going to leave one screen shot here (Search: “insurance”) and then we’ll get into resources and solutions for when you have to face this.

Additional resource

Moz Search Ranking Factors

Alternate solution

This is more of an “additional solution,” as links and mentions are still very important, but as seen above, it’s far from the only factor in ranking. It’s best to explain the different ranking factors like content relevance to the query, some social data, query deserves freshness, local, news, personalization, and all of the other things that can impact ranking. Focus on a marketing strategy that will not only result in links, but also send new customers through those links and engage the customers into lifelong evangelists.


A loss in traffic means you’ve been penalized

The next two are focused on the issue of penalties. So many people are afraid of being penalized. I think this goes back to the days of black marks in your school record. That or people are worried about losing revenue. Maybe that.

The media gets involved with SEO when there is a penalty and so that is what most people hear about. FTD and Overstock types of situations. Then disaster strikes and revenue falls unexpectedly. After some digging, they find that website traffic is down. This paired with emails business owners get at least once a quarter (in a good year) from fly by night SEO companies telling them they can help with SEO, promise the moon and warn of penalties.

The only logical conclusion is a penalty! We have all seen it and most reputable agencies pipelines are filled with leads from companies in this exact situation. The thing is that we never know if there is a penalty unless we dive into the situation, but I have seen times where there is no penalty.

Many things could have happened including:

  • A developer added a noindex tag to a section of the site when meaning to add it to one page or they disallowed that section.
  • The site was redesigned with URL changes that can drop the traffic coming into many sites if not done correctly.
  • PPC traffic stopped due to a corporate card expiring and not being updated.

Additional resource

Guide to Common SEO Penalties and How to Recover From Them

Alternate solution

Rather than paying the first person that will call you back, first look into what part of the site lost traffic and where that traffic was coming from in the past few months. Did you lose traffic from organic search, paid search, referral traffic, or social media? Try to narrow down what happened and figure it out from there. If you’re sure it was organic search, look into the date and ask your developers if anything changed about the site. If nothing did, check Google Webmaster Tools for any messages from Google about a penalty. If you’re sure it’s organic search and there are no messages, that’s a good time to contact a reputable agency. 


Duplicate content can incur a penalty

Penalty by Daniele Zanni

I did a talk on this very topic a few years back at Pubcon. So many people don’t take the time to understand what duplicate content is and how to fix it. More importantly, there is a misunderstanding that duplicate content can cause or is a penalty. 

Most clients assume that having duplicate content will incur the “search engine gods’ ” wrath, and that just isn’t true (for the most part; I mean, if your whole site is a copy of someone else’s site …). Duplicate content is a hindrance to site performance most of the time, but most likely not the cause for a substantial drop in traffic and definitely not a penalty from the search engines. 

Additional resource

Google’s Guidelines for Duplicate Content

Alternate solution

Don’t fret. Take the time to visit Webmaster Tools regularly and check out your duplicated title tags and meta descriptions for an easy look into what might be causing duplicate content or crawling issues on your site. Maintenance is the best medicine!


A call to educate

Education by Sean MacEntee

We sometimes live in a bubble where we think people know everything we do and take for granted information like everything above. If someone asked you how to create a P&L Statement, could you? Maybe, maybe not, but you get what I mean. Take the time to answer questions, whether from clients or colleagues if you are in-house. You would be amazed how much more YOU can learn from teaching others. 

So what are your horror stories? Let me know in the comments below!


Photo credits (all images are linked):

  • Internet Open by Blaise Alleyne
  • Hiding Cat by Aftab Uzzaman
  • Penalty by Daniele Zanni
  • Educate by Sean MacEntee

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!

Continue reading →

Ways to Proactively Welcome Women Into Online Marketing

Posted by EricaMcGillivray

A lot of my life’s work has been focused on increasing the visibility of women and other minorities in male-dominated professional fields. I’m not here to give you an intersectional Feminism 101 lesson or explain to you that institutional sexism is indeed alive and systemically present in online marketing. Instead, in the spirit of the Moz blog, I want to give you tips and tricks to make our corner of the world more welcoming to women. Several of these tips can also easily be adjusted and applied to other groups of marginalized people. Some can really just be applied broadly to life. According to our 2013 industry survey, 28.3% of online marketers are women, and at MozCon 2014, 31% of the audience self-identified as female (up 11% from 2013). We’ve been here for a while.

If this post gets your bristles up and you’re ready to yell at me in the comments, I ask you to  check out the many resources at the bottom to help build the basics to better understanding the “whys” and realizing “yes, this is a thing.”

Equality doesn't mean Justice cartoon

In order to be better marketers and better people, we need to open ourselves up to the experiences of others, particularly to the voices of people whose backgrounds are different than ours. But because of how our cultural biases work, we often must actively and consciously work at creating more welcoming environments. It sucks to think we’re any less than awesome, and even when we consider ourselves non-prejudiced, our behavior can still support systems of sexism, racism, ableism, homophobia, transphobia, and more.

Let’s dive in and shake up the industry!


Never assume someone’s gender, especially in online communications. If you’re in doubt, either ask or use a gender-neutral pronoun.

If we had a nickel for every time the all-female-identified community team was emailed or Facebook messaged as “Dear Sirs” because we work for a SaaS technology company, we’d be rolling in nickels Scrooge McDuck-style.

Nothing can instill imposter syndrome or make someone personally upset like being misgendered. Human culture is so sensitive to displays of gender and identification of gender that a misplaced “sir” or “ma’am” can be incredibly insulting. If the person being misgendered is genderqueer or transgendered, they may be even more sensitive due to the vulnerability of displaying to the world who they are as opposed to who society thinks they should be.

If you’re ever communicating with someone whose gender you’re unsure of, it’s better to ask than to use an errant pronoun. So rip out that “Dear Sir” and replace it instead with “To Whom It May Concern,” or better yet, something more specifically personal. Dump the he, she, or s/he and just use an epicene “they.” If emailing my team, try “Hi, awesome community team…” You’ll probably see better success with your request by not starting out on the wrong foot.


Girls vs. women: Refer to groups of adults with words that imply adulthood, especially in professional settings.

Perhaps one of my top offenses as a professional woman: being labeled as a girl or seeing another woman or group of women labeled as such. The worst is when it’s the “men and the girls” or “the guys and the girls.” Stop infantilizing women!

Again, this elicits imposter syndrome and also makes women appear inferior, as children have more to learn than adults. So please stop referring to us as girls and conjuring up images of pink, pigtails, and Barbie dolls. We’re professionals and grown-ups.

The girls are gushing... tweet

The tweet above was sent out by a company I’ve worked with and expected more from. The webinar was with two women I’ve also worked with and are some of the sharpest, smartest minds out there in our industry. They were talking about online marketing, and it was completely inappropriate for the company hosting the webinar to refer to them as “girls.” (Neither of these women worked or have worked for said company in the past.)

And before anyone mentions the phenomena of the term “geek girls,” let me take a moment to address it. I know there are many organizations that are working hard to bring the achievements of women in all forms of geekdom, including tech, and inviting more women to join that call themselves “geek girls” or have some variation in their name. This is fine. This is their group’s choice for self-identification, branding, and rolls-off-the-tongue alliteration. However, you would never say “All the girls going to Geek Girl dinners…” They’re adult women.


It’s not appropriate to have value judgments about the way a person looks in a professional setting.

Unfortunately, because women are too often seen as objects instead of people, those objects are given value judgements on their appearances. Women shouldn’t be treated like you’re picking out the best sofa for your living room. It doesn’t matter how cute you may think a woman in the industry is, she likely doesn’t want to hear it or doesn’t care.

Constantly judging women based on our appearances damages self-esteem. It entrenches stereotypes about beauty having been a woman’s most important asset since she was a little girl. It also puts women who don’t fit up to traditional Western beauty standards—maybe they’re plus-sized, women of color, genderqueer, etc.—at a disadvantage to gaining the professional attention of anyone. Think twice before commenting to a woman how beautiful she is. Or, conversely, how unattractive. (Same goes for men, by the way.)

At the end of the day, what matters most is brainpower, so let’s actually act like it.

Hillary Clinton is asked about who designs her clothing, and she asks if men ever get that question.
When I think of highly successful women, who are constantly judged on their attractiveness, Hillary Clinton’s a powerful example. Do we pay the same attention to current US Secretary of State John Kerry’s pantsuits?

For more things not to say to women in a professional setting, I highly suggest reading Ruth Burr’s Things You Think Aren’t Sexist, But Really Are.


Follow more women on social media.

Particularly on social media that’s public and open like Twitter. With networks like Facebook, many women I know actually don’t “friend” people they have met face-to-face or actually consider friends for safety reasons. Sadly, on networks such as Twitter and even the female-dominated Pinterest, men are followed at higher rates than women.

In a perfect world, content on social networks would be shared based entirely on merit. We’d only share the funniest tweet, the cutest cat photo, the most insightful post on Google Analytics, or the best hack we learned today. The best people and brands would have millions of followers. We’d have no internal biases.

But the truth is that as the world gets smaller, in that we’re more connected, and as technology serves “smarter” content, we’re only going to see people more like ourselves. Eli Pariser called this the “filter bubble.” And while he particularly noted the consequences of this in politics and being attuned to world events, this also applies to the experiences of people who are not like you demographically.

For example, over the Memorial Day weekend this past May, Google released a Penguin update. My Twitter stream was full of Penguin talk by male-identified SEOs. What were the women talking about that weekend? #yesallwomen. I couldn’t help but wonder if male SEOs, who followed other SEOs primarily, which is a male-dominated industry, even saw the hashtag actively in their streams? Did they know how big the #yesallwomen hashtag was until they saw news stories? I hope for the best, but realistically think about the bubble.

“The internet is showing us what it thinks we want to see, but not necessarily what we need to see.” — Eli Pariser

So how do we see the world we need to see? How do we work to essentially outsmart these built-in features? On Twitter, it’s actually pretty easy to find and follow people who aren’t like you.

Twitter’s own analytics and our own Followerwonk will break down the gender of who follows you and whom you follow. Here are some breakdowns of my own Twitter account and those of my fellow Twitter-loving Mozzers, including the genders of the people we follow:

Mozzer Twitter followers gender breakdown

Here’s Twitter’s own analytics on the gender breakdown of who follows me (which I think speaks volumes about our industry as “SEO” is the top interest of people following me):

Gender breakdown of my Twitter followers according to Twitter Analytics

It’s worth noting that Twitter has categorized every account as either male or female. This is problematic because some accounts are companies, not people, and it discounts people who do not identify with either gender or are somewhere in the middle. Twitter’s using a mix of self-reported demographics (what Followerwonk picked up), name categorization of gender, and natural language processing to look for gender signifiers. My recommendation for Twitter: join Facebook in giving people more gender options and toss those companies out.

Recently, our own Rand Fishkin took a close examination of his followers and those he followed back, in a concerted effort to follow more women on Twitter. Rand was pretty shocked to learn how many more male followers he had than female, and he was perhaps more shocked about my followers, given that my Twitter bio identifies me as a feminist and I tweet more about social justice than online marketing.

Rand wants to have a more gender balanced Twitter following

In addition to following more women, look at the gender balance of people you retweet and whose voices you’re helping amplify. Twee-Q analyzes your last 100 tweets and shows the gender balance who you’ve been retweeting. Entrepreneur Anil Dash talked about how he spent a year only retweeting women. Even if you don’t follow Dash’s footsteps, it’s pretty eye opening to see just who you’re retweeting.

My twee-q score
I swear I did not stage this equal RTing result. Usually, I skew toward more women than men.


Create inclusive community guidelines or a code of conduct for your site, blog, forums, reviews, social media, events, etc.

As a community manager, I’m a little obsessed with keeping the virtual living room free of hatred, especially on sites directly owned by a brand. I love, for example, that the comments on the Moz Blog are actually valuable to read, unlike almost every other site out there.

It’s hard to backpedal and bring order to your community; we all watched YouTube integrate G+ and Huffington Post hire an army of comment moderators. But most of us aren’t managing a community with millions of incoming comments and forum posts. Community guidelines or a code of conduct give you more room to be explicit about expectations for behavior on your properties.

For example, Moz works in the SEO space. So while it’s not very TAGFEE to put a spammy link in a comment, it saves argument time that it’s actually outlined in our community etiquette. While not directly tied to stopping discrimination, you can easily see how parallels in explicitly outlining what kinds of speech your brand won’t tolerate. “Be excellent to each other” can just bring on too many arguments from the person you’re moderating.

The allowance of hate-fueled user-generated content sends a signal loud and clear to women, minorities, and allies just what your brand is about, and this feeling is only amplified when we all meet face-to-face.

This year at MozCon, we implemented a Code of Conduct. For those that don’t know, in the events space, there’s been an increasing awareness of harassment at conferences. One way organizers are combating it and making attendees safer is by explicitly laying out a policy against this behavior and how event organizers will respond to said bad behavior. Again, this should be solvable simply by saying “be TAGFEE”—or whatever other motto your brand chooses—but unfortunately, this is not the case.

Some of you have speculated about what happened to make the MozCon committee decide we needed a code of conduct. We created the code to be proactive. This is just one more way to improve our conference and be welcoming to marketers of all stripes.


MozCon 2014 attendees having breakfast before the show.


Make your brand voice and design guides inclusive instead of exclusive.

Many people make employment choices, not to mention purchase decisions, based on “culture.” Culture is a nebulous idea, and while it’s formed by the combination of how people in your company act and brand perception, you can start out on the right foot. Culture’s not a top-down dictate, but the signals come from both directions, and a strong brand voice and design guide can help company communication on what’s implicitly acceptable and what’s not.

Most of us work for brands that are gender-neutral. We don’t cater to an exclusively female-identified or male-identified audience. However, we tend to adopt cultural tones that identify our band as a specific gender, and furthermore our industry as exclusive, instead of inclusive.

You’re probably thinking about how Moz’s own Roger Mozbot uses the male pronoun. While Roger’s name and his use of the male pronoun will likely never change, those of us who work on Roger as a mascot strive to make him as gender neutral as possible. He doesn’t use specific masculine language, and despite many requests from our community, he doesn’t have a love interest. Roger’s first love is SEO, after all. He’s beloved by all our community members, not just the male-identified ones.

Not all companies think about these nuances. For example, why is banking portrayed as a masculine industry? Why does it need to support stereotypes that women are bad with money, math, and the financial market? Doesn’t every adult need a bank account, retirement savings, and access to their money? Does the marketing-bias only reflect the hiring bias?

JPMorgan and Chase's hiring page
Who’s getting interviewed here? Who looks most like a banker? Who should apply here?

Brands who do live in a sphere where they can say 80%+ of their audience comes from a particular gender should also pay attention. If none of your competitors are going after that other ~20% of audience share, you have a market opportunity. At the very least, small tweaks to your voice—like using that epicene “they”—or adding a pop color not commonly associated with your industry’s dominant gender can make you the friendly, go-to brand for those who feel like outsiders in your niche.

ExOfficio shows actual customers fishing, not just models in the clothing.

Outdoor and travel clothing brand ExOfficio is known for their fishing clothing. Fishing is considered a male market, but they do a great job making the same fishing clothing for women too. Sure, they might add in different styling and colors and offer some variations geared toward women’s fashion, but their imagery and their core offering of fishing clothing doesn’t shout out that these are women fishing.

Let’s also look at a cautionary tale of what can happen when brands try to be more inclusive toward women: the pinkification of the market.

While yes, this is marketed toward girls, not women, this fishing set nicely illustrates pinkification. Turning it pink and labeling it with Barbie somehow makes it “for girls.” But what really makes me upset is the language. Behold the “Purse” of fishing, which contains the exact same actual equipment as the Spider-Man one marketed toward boys.

While this may seem a bit consumer-focused, the products you put out the world and the marketing behind them reflect directly if someone can see themselves working at your brand. When I first heard Apple announce the iPad, my gut reaction was to ask if there was a single woman working on the Apple marketing/product team. Because to me, this MAD TV sketch about the then-newly released iPad (possibly NSFW) said all the things I was thinking.

Conversely, if your employees know this matters, when something bothers them, they’ll likely bring it up. Recently at Moz, our team worked hard on new customer personas. At the end of the day, four were chosen as Moz’s current target market and the rest put on hold as future markets. While the personas were gender-balanced overall, it so happened that three of the four current customer personas were male. Because of Moz’s culture, multiple people approached the persona team questioning this. The team then pivoted to change the names to be gender neutral selections and edit the accompanying art and descriptive text to reflect this.


Publishing an image of your company, what’s the gender balance?

While we’re thinking about how your brand looks to potential employees, what images are out there of your company? Are they only men? Is there only one type of woman?

Recruiting at Moz

Unfortunately, this main image on our recruiting page presents Moz as looking for a certain type of employee: a young, fit, white professional, preferably with light-colored hair. This doesn’t reflect the actual makeup of Moz, especially at 140+ people. But what if this was the only image? What would a potential employee or recruit who didn’t fit that image think?

This can be particularly challenging for small businesses. You also don’t want your employees to feel tokenized for their gender identity or minority status. Perhaps it’s time to think more about what a photo means to applicants. BarkBox had 30 employees in early 2014, and here’s their simple, yet more welcoming recruiting image:

BarkBox's recruiting image

It only takes a little extra effort to go a long way.


Include women in interviews, quotes, and other articles and events touting industry experts.

There’s simply no excuse for an article or an event full of industry experts and to not have the final lineup include a single woman. While there’s no “magical number” to achieve diversity, it’s simply bad practice when a lineup features only men. If you seriously can’t think of a single woman expert in your field, you’re doing something wrong.

There’s a strong correlation between seeing yourself demographically and dreaming that you could do that job too. We all need inspiration and heroes to look up to and aspire to be like. And great marketers, we come from all kinds of backgrounds and make this industry a better place because of that.

If you’re a white man asked to speak as an industry expert, it’s time to ask who else is being featured or speaking. Turn down engagements that only have male voices. Ask more of authors and conference runners. If you’re the author or event curator, reach out to someone in the industry who’s opinion you respect for ideas of experts you’re not thinking of. I’ll gladly send you my binders full of women marketing experts.

SMX East 2014 speaker lineup
A sample of the speakers at SMX East 2014


When you witness sexist behavior, say something.

I saved this tip for last because it is one of the most powerful. Simply not keeping quiet and speaking up can change the world. We all have to work together.

“People will not listen unless you are an old, white man, so I’m an old white man, and I will use that to help people who need it.” — Sir Patrick Stewart

Unfortunately when women call people out on sexist behavior, it’s not as powerful as men saying the same thing. Same goes for a black person calling a white person out on racist behavior, etc. And when a woman calls a man out, she’s making a “political” statement and suffers real consequences in her life. Despite laws in many countries against these things, complaints of any kind can lead to economic consequences of losing jobs or clients and to safety concerns about harassment both online and offline.

A recent study actually showed that whistle-blowing or any kind of confrontation wasn’t even necessary for economic consequences. Women and people of color who promoted other women and people of color and/or valued diversity in the workplace received lower performance reviews than white men who did the same.

Male-identified friends, if you see someone or a company doing these things, please help and speak up. Please stand up for those who are doing this hard work and please be aware of your own biases.


More resources…

Basic resources:
White Privilege: Unpacking the Invisible Knapsack by Peggy McIntosh
The Male Privilege Checklist by Barry Deutsch
30+ Examples of Heterosexual Privilege in the US by Sam Killermann
Straight White Male: The Lowest Difficulty Setting There Is by John Scalzi
The Problem When Sexism Just Sounds So Darn Friendly… by Melanie Tannenbaum
Derailing For Dummies
Aamer Rahman from Fear of a Brown Planet on “Reverse Racism”
8 Things White People Really Need to Understand About Race by James Utt
An open letter to privileged people who play devil’s advocate by Juliana Britto
Yes, All Men: Every Man Needs to Understand Internalized Misogyny and Male Violence by Tom Hawking
Roll up, roll up, to see a man talking about feminism. What could possibly go wrong? by Robert Webb

SEO, tech, and startup specific resources:
Not all men. Not all industries. But nearly always men in my industry by Martin Belam
Why Women Aren’t Welcome on the Internet by Amanda Hess
Women as Entertainment in the SEO Industry by Jane Copland
The Problem with ‘Brogrammers’: Why is Silicon Valley so stubbornly white and male? by Rebecca Burns
Meritocracy [in Tech] is Almost as Real as this Unicorn by Tara Hunt
Death by a thousand cuts: the reality of being a woman in tech by Meg Kierstead
In Tech Marketing Jobs, Women’s Successes Are Rarely Recognized by Laura Sydell
Eve wasn’t invited: Integrating women into the Apple community by Brianna Wu
Gender Bias in Online Marketing: Data Shows Women Are Undervalued by 21% by Larry Kim

Further resources:
On being an ally and being called out on your privilege by Andrew David Thaler
TEDxWomen Talk from Anita Sarkeesian about Online Harassment & Cyber Mobs
Dissent Unheard Of, real and economic impact of speaking out by Ashe Dryden
Dos and Don’ts To Combat Online Sexism by Leigh Alexander
In Which We Teach You How To Be A Woman In Any Boys’ Club by Molly Lambert
The Confidence Gap by Katty Kay and Claire Shipman
“Raving Amazons”: Antiblackness and Misogynoir in Social Media by I’Nasah Crockett
Visibility Conundrums of Being Queer by Erica McGillivray


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!

Continue reading →

How to Combine Screaming Frog Data with Google Analytics Data

Posted by Iamoldskool

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!

Continue reading →

Teach Google About Your Entities by Using Topical Hubs – Whiteboard Friday

Posted by gfiorelli1

I’m not so sure it’s correct to say—as is so common lately—that today’s SEO is a new one, especially with regard to on-site SEO.

Many of the things that are necessary today were also necessary in the past: a well-designed information architecture, a great navigation structure, good internal linking, etc.

We should talk instead of a new emphasis we must give to some factors as old as SEO itself.

Today I’ll talk about one of these factors—Topical Hubs—that, although it has been important in the past, is even more so today with Hummingbird and the increasing weight Google gives to semantics and thematic consistency of the sites.

[Disclaimer about my accent in the video: I swear, my English is not so bad, even if it really sounds Italian; just the idea that I was in Seattle shooting a WBF stressed every cell in my body].

For reference, here’s a still of this week’s whiteboard!

Video Transcription

Hola, Moz fans. I’m Gianluca Fiorelli. Finally, you are going to see my face and not just my picture or avatar.

I’m here not to talk about  how to snap faces, but about topical hubs. 

What are topical hubs? We are going to discover it. 

Why are we talking about topical hubs? We are going to talk about it because of Hummingbird. Hummingbird, we know that it’s not a really well-known algorithm, but it has really changed how Google works.

One thing we know is that it is simplifying the results [SERPs]. 

One thing that is not working anymore, that was really, really a goldmine for SEO, was working on long, long tails. You can remember maybe many sites targeting millions of pages about every kind of long queries possible. This is not so anymore because Hummingbird has simplified [everything]. If query A, query B, and query C are the same when query D, Google will always show query D [SERPs].

In order to optimize your site for this kind of new semantic understanding that Google has of the queries – especially conversational query – we must understand that we have to think in entities and not in keywords. We have to think about the connection between the entities, and we have to be really sure about the context of the content that we are creating

All these three things then will guide our keyword research.

How can we do this?

We should start our job not from keywords but from entities. 

These are a few tools that we can use, like directly using the Freebase APIs, which is directly using a Google source (as Freebase is Google), or we can use the AlchemyAPI, which can make our job easier. 

There are also other tools, like  ConceptNetYahoo Glimmer, and Bottlenose. Bottlenose… I suggest it to you if you are going to create or craft a site about something which is really mainstream, but has concepts stemming especially from social. Bottlenose is really good because it’s taking care also of entity recognition in social media. 

There is  RelFinder, which is a really nice tool for free. It is relying on the dBASE, the Wikipedia database.

From there, using these tools, we can understand, for instance, let’s say we are talking about pizza because we are a pizzeria (I’m Italian). 

Using these tools, we can understand what the concepts are related to pizza: What kind of pizza (thin, crunchy, regular pizza, with tomatoes, without tomatoes, Neapolitan or Romana, so many kinds), but also the history of pizza, because Pizza Margherita was named from an Italian queen. 

We can discover also that pizza can be related to geography also because pizza is Italian, but the World Championship of Acrobatic Pizza (which is a sport) is Spanish. 

We can understand many, many entities, many, many facts around the concept of pizza that can populate our site about pizzas.

Let’s say that we are a pizzeria. We have a local site, and we are maybe in Tribeca. We shouldn’t just focus ourselves on the entity search of “pizzas,” but we should start also thinking about entity searches for entities related to Tribeca, so New York Movie Festival, Robert De Niro, etc.

Once we have all of these entities, we should start thinking about the ontology we want to use, that we can extract from these entities, how to group them and create our categories for the site. 

The categories of a site substantially are our topical hubs.

Going to another kind of website, let’s think of a classical real estate classified site. 

We usually have in every classified site the homepage, then the category and product pages. People always say, “How can we make our category pages rank?”

Consider them to be topical hubs. 

A good site for topical hubs could be a microsite. We have just to think of our site as if it was a composition of microsites all contextually connected

So the category page in this case should be considered as a new site all about, for instance, Tribeca or all about Harlem, or Capitol Hill in Seattle, or any other neighborhood if we are talking about real estate.

From there, once we have decided our categories, we can start doing the keyword research, but using a trick, we must credit Dan Shure for the tip, which is to find keywords related to the entities

Now Dan Shure is suggesting to us to do this: going to Keyword Planner and instead of putting a few keywords to retrieve new ones, use a Wikipedia page of the entity related to the content that we are going to optimize. Goggle will start suggesting us keyword groups, and those keyword groups are all related to a specific subset of the entity we are talking about.

So we can start optimizing our page, our content hub, with the keywords Google itself is extracting from the best SERPs of entities (Freebase or Wikipedia). In doing so, we are creating a page which is really well optimized on the keywords side, but also on the entity side, because all of those keywords we are using are keywords that Google relates to specific entities.

But that’s not all, because when we talk about topical hubs, we have to talk, again, about the context, and the context is not just writing the classic, old SEO text. It’s also giving value to the category page.

So if we have done a good audience analysis, maybe we can understand that in Capitol Hill, there is a certain demographic. So we can organize the content on the hub page focusing on that demographic, and we know that we will have our text talking about the neighborhood, but we also have our initial listings. Maybe we can see, for instance, if a neighborhood is really appreciated, or if the demographic is young families with two kids and so on. Maybe we can add values, like Zillow is doing: has school close to or in the neighborhood, or parks close to the neighborhood, or where to go to eat in the neighborhood, or landmarks in the neighborhood.

All of this content, which is adding value for the user, is also adding contextual value and semantic value for Google.

One tip. When you are optimizing a page, especially category pages, let’s say you have the category page Capitol Hill, Seattle for your real estate site. Tag it with the Schema.org property sameAs, the Capitol Hill word, and link that sameAs to the Wikipedia page of Capitol Hill. If it doesn’t exist, write yourself a web page about Capitol Hill. You are going to tell Google that your page is exactly about that entity.

So when we have all of these things, we can start thinking about the content we can create, which is contextually relevant both to our entity search (we did a keyword search related to the entities) and also to the audience analysis we did.

So, returning to my pizzeria, we know that we can start doing recipes and tag them with recipe micro data. We can do videos and mark that them with a video object. We can do short forms, and especially we can try to do the long forms and tag them with the article schema and trying to be included in the in-depth article box. We can start writing guides. We can start thinking about UGC and Q&A.

We can try especially to create things about the location where we are set, which in my pizzeria case was Tribeca, creating a news board to talk and discuss about the news of what’s happening in Tribeca, what the people of Tribeca are doing, and if we are lucky, we can also think to do newsjacking, which we know is really strong.

For instance, do you remember the Oscar night when  the guy with the pizza was entering on the stage? Well, maybe we could do something similar in Tribeca, because there’s a movie festival there. So, maybe during the red carpet show our person goes to all of the celebrities and starts giving pizza to them, or at least a Coke?

So doing these things we are creating something which is really, really thought about in a semantic way, because we are really targeting our site to all of the entities related to our micro-topic. We have it optimized also on a keyword level, and we have it optimized on a semantic search level. We have created it crossing our search with the audience search.

We’re creating content which is responding both to our audience and Google

And doing so, we are not going to need to create millions of pages targeting long, long tails. 

We just need really strong topical hubs that stem content, which will be able to respond properly to all the queries we were targeting before.

I hope you enjoyed this Whiteboard Friday.

And, again, I beg your pardon for my accent (luckily you have the transcript).

Video transcription by Speechpad.com


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!

Continue reading →