the best seo advice you will never hear

150
The Best SEO Advice That You Will Never Hear

Upload: kerry-dean-seo

Post on 02-Jul-2015

840 views

Category:

Marketing


2 download

DESCRIPTION

My presentation from the State of Search Conference in Dallas, TX on Nov. 18, 2014.

TRANSCRIPT

Page 1: The Best SEO Advice You Will Never Hear

The Best SEO Advice That You Will Never Hear

Page 2: The Best SEO Advice You Will Never Hear

REDUCING SEO TO 2 BUCKETS

Getting the most out of the site you already have.

Building new content and features to drive new traffic.

Imma talk aboot this.

Page 3: The Best SEO Advice You Will Never Hear

EVERYBODY’S GOT AN AGENDA

1. Platforms2. Content3. Ecommerce4. Onsite Search5. Quick Break6. Quick Hits7. Not Provided8. Reporting9. Speed Round

Page 4: The Best SEO Advice You Will Never Hear

1. THE TRUTH ABOUT PLATFORMS & CMS

Page 5: The Best SEO Advice You Will Never Hear

POPULAR PLATFORMS & CMS

• Demandware• eBay GSI Commerce• IBM Websphere• Hybris• Oracle ATG• RedPrairie• Wordpress• Drupal• Joomla• Magento

and many more…

Page 6: The Best SEO Advice You Will Never Hear

THE TRUTH

Because the organic search channel drives such a large percentage of overall site traffic and revenue, companies that build platforms cannot afford to have crappy and/or non-existent SEO features.

TL;DR If the platform isn’t SEO friendly, nobody will buy it.

Page 7: The Best SEO Advice You Will Never Hear

They send in their best sales people.

Page 8: The Best SEO Advice You Will Never Hear

And then this guy asks: “What about SEO?”

Page 9: The Best SEO Advice You Will Never Hear

“What my associate is trying to say is that, uh, our new platform is really cool.”

Page 10: The Best SEO Advice You Will Never Hear

But don’t look under the hood…

Page 11: The Best SEO Advice You Will Never Hear

“OMG.”

Page 12: The Best SEO Advice You Will Never Hear

TIPS ON WHAT TO EXPECT

• Today’s platforms are so much better for SEO compared to 5-10 years ago.

• Every platform has limitations.

• Figure out what they are early on.

• People love when you can take Dev work off their list. (Hint: It’s because their Dev calendar is already full.)

Page 13: The Best SEO Advice You Will Never Hear

TIPS ON WHAT TO EXPECT

PRO TIP:

Allocate a developer to create workarounds and solutions to speed up platform processes related to SEO.

Page 14: The Best SEO Advice You Will Never Hear

QUESTIONS TO ASK

• Ask specific questions about the platform’s SEO features:

o How do I bulk update all meta tags?o How do I edit robots.txt files?o How do I edit on-page copy (product names & desc)?o How do I bulk edit H tags and Alt tags?o Where can I create redirects (single & bulk)?o Where can I add rel-alternate tags?o Where can I add HREFLANG tags?o How do I generate XML sitemaps?o How do I do all of that stuff for the mobile site?o How do I add schema.org tags to the source code on

specific templates?

Page 15: The Best SEO Advice You Will Never Hear

TIPS ON WHAT TO EXPECT

PRO TIP:

“Yes, our platform can do that.”

Make them show you how to do everything you are asking them about.

SHOW ME

Page 16: The Best SEO Advice You Will Never Hear

NEXT STEP: FIND THE GOOD STUFF

• Find out what makes your platform good for SEO.

• Does your platform offer you any competitive advantages?

• What features does it have that the other platforms don’t have?

Page 17: The Best SEO Advice You Will Never Hear

And that brings us to…

Page 18: The Best SEO Advice You Will Never Hear

2. UNDERAPPRECIATED CONTENT OPPORTUNITIES

Page 19: The Best SEO Advice You Will Never Hear

HERE’S A GREAT EXAMPLE

Source: http://searchengineland.com/twitter-seo-more-visitors-208160

Page 20: The Best SEO Advice You Will Never Hear

HOW DID THEY DO IT?

Page 21: The Best SEO Advice You Will Never Hear

UPDATE THE ROBOTS.TXT

FEB. 25, 2014 FEB. 26, 2014

https://twitter.com/robots.txt

Note: Twitter updated the exclusions for all other search engines as well.

Page 22: The Best SEO Advice You Will Never Hear

JUST SO WE’RE CLEAR

Before Feb-25th, hashtag URLs were not being crawled and/or indexed.

As of Feb-26th, Twitter allows crawling and indexing of URLs in the /hashtag/ sub-directory.Example URLs include:

• https://twitter.com/hashtag/worldcup• https://twitter.com/hashtag/mikebrown• https://twitter.com/hashtag/fb• https://twitter.com/hashtag/ukraine

Page 23: The Best SEO Advice You Will Never Hear

URL SPECIFICALLY FOR #WORLDCUP

Page 24: The Best SEO Advice You Will Never Hear

IT WORKS!!!

Page 25: The Best SEO Advice You Will Never Hear

The Takeaway here is:

In terms of its value to searchers, Google likes the ‘hashtag’ page

more than any single Tweet and/or any single Twitter account

related to the World Cup.

Page 26: The Best SEO Advice You Will Never Hear

We have seen this before…but where?

Page 27: The Best SEO Advice You Will Never Hear

TUMBLR.COM ‘TAGGED’ PAGES

Page 28: The Best SEO Advice You Will Never Hear

CHUCK NORRIS

Page 29: The Best SEO Advice You Will Never Hear

TUMBLR.COM RANKS FOR STUFF

POSITIONS 5 & 6!!!

Page 30: The Best SEO Advice You Will Never Hear

IT’S SO RELEVANT. DUH!

“Just look at all that value!” - Google

Page 31: The Best SEO Advice You Will Never Hear

ONCE AGAIN…

The Takeaway here is:

In terms of its value to searchers, Google likes the

‘tagged’ page more than any single Tumblr post and/or any single Tumblr account related

to ‘Chuck Norris gifs’.

Page 32: The Best SEO Advice You Will Never Hear

Does anyone else do this?

Page 33: The Best SEO Advice You Will Never Hear

SOMETHING SOMETHING DARK SIDE

Page 34: The Best SEO Advice You Will Never Hear

HOW MANY /TAG/ PAGES?

Page 35: The Best SEO Advice You Will Never Hear

‘TAG’ PAGES RANK FOR STUFF.

Page 36: The Best SEO Advice You Will Never Hear

RELEVANT FOR ‘STAR WARS DAY’

“Just look at all that value!” - Google

Page 37: The Best SEO Advice You Will Never Hear

Small Case Study (Kinda)

Page 38: The Best SEO Advice You Will Never Hear

Time Frame: June 1st – August 31st

Data:• Roughly 5,000 pages indexed• 810 /tag/ pages driving traffic

Total Organic Visits: 78,767Organic Visits to /tag/ pages: 7,803

Results: /tag/ pages generated 10% of organic visits

FROM ONE OF MY SITES

Page 39: The Best SEO Advice You Will Never Hear

What about a big site on Wordpress?

Page 40: The Best SEO Advice You Will Never Hear

WAIT. HOW MANY /TAG/ PAGES?!

36% of their indexed pages are /tag/ URLs.

Page 41: The Best SEO Advice You Will Never Hear

preziwattpadretailmenotmodclothsurvey monkeystumbleuponpolyvoreone kings lanevuduwarby parkeryahoo japanvkontaktesongzajibjabustreampractice fusionjackthreads

hipmunkgroupmekindle paperwhiterebtelanswers.comtinychatretail me notodeskdiapers.comslideshareamazon freshurban spoonstatcounterpopcorn timethumbtackticketflyhotel tonight

Page 42: The Best SEO Advice You Will Never Hear

OKAY. I GET IT ALREADY.

“Just look at all that value!” - Google

Page 43: The Best SEO Advice You Will Never Hear

But wait. There’s more!

Page 44: The Best SEO Advice You Will Never Hear

THIS.CHANGES.EVERYTHING.

Page 45: The Best SEO Advice You Will Never Hear

#TCE because now we’re

talking about money.

“Reasonably.”

Page 46: The Best SEO Advice You Will Never Hear

“Reasonably.”

Page 47: The Best SEO Advice You Will Never Hear

And that brings us to…

Page 48: The Best SEO Advice You Will Never Hear

3. ECOMMERCE

Page 49: The Best SEO Advice You Will Never Hear

EVERY SEARCH IS A BATTLE FOR THE TOP SPOT.

Page 50: The Best SEO Advice You Will Never Hear

“If it don’t make dollars, it don’t make sense.”

- Deion Sanders#PrimeTime

Page 51: The Best SEO Advice You Will Never Hear

“You don't solve money problems with money.”

- Dr. Phil#DayTime

“You solve money problems with lifestyle, values and priorities.”

Page 52: The Best SEO Advice You Will Never Hear

SO, KERRY, WHAT’S THE BIG DEAL?

Techcrunch.com has a /tag/ page that is ranking on Page 1 of Google for a *product* keyword:

This tells us something about the power of creating pages that group several pieces of specific content related to one keyword or phrase. In retail, this is a Category page.

Page 53: The Best SEO Advice You Will Never Hear

JESSE PINKMAN IS EXCITED ABOUT THIS.

Page 54: The Best SEO Advice You Will Never Hear

How do we use that information? I’m glad I asked.

Page 55: The Best SEO Advice You Will Never Hear

EXAMPLE OF A CATEGORY PAGE

Page 56: The Best SEO Advice You Will Never Hear

EXAMPLE OF A CATEGORY PAGE continued…

Page 57: The Best SEO Advice You Will Never Hear

WHAT ABOUT SMALL SUBSETS OF CATEGORIES?

These websites are building pages specifically for

‘womens green sweaters’!

Page 58: The Best SEO Advice You Will Never Hear

ALSO, THE URLS ARE PRETTY.

Google Results:

1. http://www.amazon.com/s?rh=n%3A1044456%2Cp_n_size_browse-vebin%3A2343355011

2. http://www.landsend.com/shop/womens-sweaters-cardigans-green/-/N-fy2Zt2

3. http://shop.nordstrom.com/c/womens-sweaters/green

4. http://www1.macys.com/cms/slp/2/Green-Sweater

8. http://www.target.com/th/womens+green+cardigan+sweater

Page 59: The Best SEO Advice You Will Never Hear

THE PAGE IS OPTIMIZED.

Key Takeaway:

These pages are optimized for longtail searches AND they deliver on the intent and expectation of the searcher.

Page 60: The Best SEO Advice You Will Never Hear

How do I create pages like this?

Page 61: The Best SEO Advice You Will Never Hear

GETTING STARTED

1.Determine your platforms capabilities.2.Be sure you can do it in a way that doesn’t

violate Google Webmaster Guidelines.(i.e. Know your platform!)

3.Take a look at your product inventory.4.Take a look at the filters for categories and

products.5.Mix & match the filters with the categories and

products.6.Build the pages that need to be built.

Page 62: The Best SEO Advice You Will Never Hear

EXAMPLE: womens small blue cardigan sweaters

Page 63: The Best SEO Advice You Will Never Hear

NICE, INDEXABLE URLS FOR FILTERS. OR NOT.

Sweaters URL: http://www.target.com/c/sweaters-women-s-clothing/-/N-5xtbx#?lnk=ct_menu_01_9&intc=1865087|null

Canonical: http://www.target.com/c/sweaters-women-s-clothing/-/N-5xtbx

Womens small blue cardigan http://www.target.com/c/sweaters-women-s-clothing/-/N-5xtbx#navigation=true&category=5xtbx&searchTerm=&view_type=large&sort_by=Featured&faceted_value=55zkqZ5y70hZ5y34v&offset=0&response_group=Items&isLeaf=true&parent_category_id=5xtcm&custom_price=false&min_price=from&max_price=to

Canonical: http://www.target.com/c/sweaters-women-s-clothing/-/N-5xtbx

Page 64: The Best SEO Advice You Will Never Hear

IT’S LIKE A GIGANTIC DATABASE OF MASHUPS

Page 65: The Best SEO Advice You Will Never Hear

IT’S LIKE A GIGANTIC DATABASE OF MASHUPS

Think about your categories and products like SyFy thinks about its movie line-up. What combinations

your customers want to see?

Page 66: The Best SEO Advice You Will Never Hear

SOME PEOPLE AUTOMATE IT…

…by creating systems that build a

database of URLs based on product

feeds data and analytics data.

Page 67: The Best SEO Advice You Will Never Hear

THAT’S A LITTLE OVERBOARD.

Page 68: The Best SEO Advice You Will Never Hear

How can we do it?

Page 69: The Best SEO Advice You Will Never Hear

4. ONSITE SEARCH

Page 70: The Best SEO Advice You Will Never Hear

If you’re not looking at your

website’s onsite search data, this owl disapproves of your entire SEO

campaign.

Page 71: The Best SEO Advice You Will Never Hear

If this is your first time to look at your website’s

onsite search data, brace yourselves.

Page 72: The Best SEO Advice You Will Never Hear

KEY TAKEAWAYS

1. Look at your site’s onsite search data.2. Use that data to determine what your

customers are looking for.3. Take all of that and build some pages

that target your customers’ needs.

Page 73: The Best SEO Advice You Will Never Hear

5. QUICK BREAK

Page 74: The Best SEO Advice You Will Never Hear

LET’S SEND A MESSAGE TO MATT CUTTS

Page 75: The Best SEO Advice You Will Never Hear

HI, MATT! WE MISS YOU, BUT PLEASE TAKE AS MUCH TIME AS

YOU NEED!

Page 76: The Best SEO Advice You Will Never Hear

6. QUICK HITS

Page 77: The Best SEO Advice You Will Never Hear

Site Stability & Reliability

Page 78: The Best SEO Advice You Will Never Hear

SITE STABILITY & ITS EFFECTS ON RANKINGS

Lesson: Google is fast to drop you out of the SERPs.

Site 1: Server errors for 3-4 days.

Page 79: The Best SEO Advice You Will Never Hear

SITE STABILITY & ITS EFFECTS ON RANKINGS

Lesson: Google is fast to drop you out of the SERPs.

Site 2: Site down for 8 weeks.

Page 80: The Best SEO Advice You Will Never Hear

YOU SEE…WEBSITES ARE KINDA LIKE FAMILIES.

Page 81: The Best SEO Advice You Will Never Hear

LOVELY PARENTS, BEAUTIFUL KIDS, NICE HOUSE…

Page 82: The Best SEO Advice You Will Never Hear

BUT DON’T FORGET ABOUT YOUR COUSIN.

“SH!TTER WAS FULL!”

Page 83: The Best SEO Advice You Will Never Hear

“IT’S TIME TO CLEAN UP YOUR SH!T.” - @kerrydean

Site B

Lesson: Fix your 4xx & 5xx status codes.

Page 84: The Best SEO Advice You Will Never Hear

XML Sitemaps

Page 85: The Best SEO Advice You Will Never Hear

REMEMBER THESE THINGS?

Everyone takes it for granted that their sitemaps are complete, accurate, and up-to-date.

Page 86: The Best SEO Advice You Will Never Hear

DUANE’S ADVICE

“Right, because if you start showing me 301s in here, rel=canonicals, 404 errors, all of that, I'm going to start distrusting your sitemap and I'm just not going to bother with it anymore.”- @DuaneForrester (Mar. 3, 2011)

Source: http://moz.com/blog/bings-duane-forrester-on-webmaster-tools-metrics-and-sitemap-quality-thresholds

Page 87: The Best SEO Advice You Will Never Hear

KERRY’S XML SITEMAPS TO-DO LIST

1. Go find all of your XML sitemap file(s)2. Make sure they are listed in your robots.txt3. Crawl all of your sitemaps4. Look for any URLs that are no returning a 200

status code; fix them or remove them from the sitemap.

5. If possible, break your sitemaps into groups by products and/or categories.

6. If you can, break them into smaller batches. It makes it easier to diagnose problems.

Page 88: The Best SEO Advice You Will Never Hear

Rel=Alternate Tags for Your International Sites

Page 89: The Best SEO Advice You Will Never Hear

URL SPECIFICALLY FOR #WORLDCUP

Page 90: The Best SEO Advice You Will Never Hear

<link rel="canonical" href="https://twitter.com/hashtag/worldcup"><link rel="alternate" hreflang="x-default" href="https://twitter.com/search?hashtag=worldcup"><link rel="alternate" hreflang="fr" href="https://twitter.com/search?hashtag=worldcup&amp;lang=fr"><link rel="alternate" hreflang="en" href="https://twitter.com/search?hashtag=worldcup&amp;lang=en"><link rel="alternate" hreflang="ar" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ar"><link rel="alternate" hreflang="ja" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ja"><link rel="alternate" hreflang="es" href="https://twitter.com/search?hashtag=worldcup&amp;lang=es"><link rel="alternate" hreflang="de" href="https://twitter.com/search?hashtag=worldcup&amp;lang=de"><link rel="alternate" hreflang="it" href="https://twitter.com/search?hashtag=worldcup&amp;lang=it"><link rel="alternate" hreflang="id" href="https://twitter.com/search?hashtag=worldcup&amp;lang=id"><link rel="alternate" hreflang="pt" href="https://twitter.com/search?hashtag=worldcup&amp;lang=pt"><link rel="alternate" hreflang="ko" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ko"><link rel="alternate" hreflang="tr" href="https://twitter.com/search?hashtag=worldcup&amp;lang=tr"><link rel="alternate" hreflang="ru" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ru"><link rel="alternate" hreflang="nl" href="https://twitter.com/search?hashtag=worldcup&amp;lang=nl"><link rel="alternate" hreflang="hi" href="https://twitter.com/search?hashtag=worldcup&amp;lang=hi"><link rel="alternate" hreflang="no" href="https://twitter.com/search?hashtag=worldcup&amp;lang=no"><link rel="alternate" hreflang="sv" href="https://twitter.com/search?hashtag=worldcup&amp;lang=sv"><link rel="alternate" hreflang="fi" href="https://twitter.com/search?hashtag=worldcup&amp;lang=fi"><link rel="alternate" hreflang="da" href="https://twitter.com/search?hashtag=worldcup&amp;lang=da"><link rel="alternate" hreflang="pl" href="https://twitter.com/search?hashtag=worldcup&amp;lang=pl"><link rel="alternate" hreflang="hu" href="https://twitter.com/search?hashtag=worldcup&amp;lang=hu"><link rel="alternate" hreflang="fa" href="https://twitter.com/search?hashtag=worldcup&amp;lang=fa"><link rel="alternate" hreflang="he" href="https://twitter.com/search?hashtag=worldcup&amp;lang=he"><link rel="alternate" hreflang="th" href="https://twitter.com/search?hashtag=worldcup&amp;lang=th"><link rel="alternate" hreflang="uk" href="https://twitter.com/search?hashtag=worldcup&amp;lang=uk"><link rel="alternate" hreflang="ca" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ca"><link rel="alternate" hreflang="el" href="https://twitter.com/search?hashtag=worldcup&amp;lang=el"><link rel="alternate" hreflang="eu" href="https://twitter.com/search?hashtag=worldcup&amp;lang=eu"><link rel="alternate" hreflang="cs" href="https://twitter.com/search?hashtag=worldcup&amp;lang=cs"><link rel="alternate" hreflang="gl" href="https://twitter.com/search?hashtag=worldcup&amp;lang=gl"><link rel="alternate" hreflang="ro" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ro"><link rel="alternate" hreflang="vi" href="https://twitter.com/search?hashtag=worldcup&amp;lang=vi"><link rel="alternate" hreflang="bn" href="https://twitter.com/search?hashtag=worldcup&amp;lang=bn"><link rel="alternate" hreflang="fil" href="https://twitter.com/search?hashtag=worldcup&amp;lang=fil"><link rel="alternate" hreflang="ms" href="https://twitter.com/search?hashtag=worldcup&amp;lang=ms"><link rel="alternate" hreflang="zh-tw" href="https://twitter.com/search?hashtag=worldcup&amp;lang=zh-tw"><link rel="alternate" hreflang="zh-cn" href="https://twitter.com/search?hashtag=worldcup&amp;lang=zh-cn"><link rel="alternate" hreflang="en-gb" href="https://twitter.com/search?hashtag=worldcup&amp;lang=en-gb">

Look at all those rel-alternate tags in their source code!

If you have international versions of your site, you should think about this.

Page 91: The Best SEO Advice You Will Never Hear

I Built a Spreadsheet

Page 92: The Best SEO Advice You Will Never Hear

CAN YOU SPOT THE ALGO UPDATES?

Page 93: The Best SEO Advice You Will Never Hear

WAS MY SITE AFFECTED BY AN UPDATE?

Page 94: The Best SEO Advice You Will Never Hear

3 DAYS BEFORE AND AFTER

Page 95: The Best SEO Advice You Will Never Hear

7 DAYS BEFORE AND AFTER

Page 96: The Best SEO Advice You Will Never Hear

30 DAYS BEFORE AND AFTER

Page 97: The Best SEO Advice You Will Never Hear

FULL VIEW!

Using your organic visits data (from Google) will give you some ideas about the effects of

any particular algorithm update.

Page 98: The Best SEO Advice You Will Never Hear

DO THE SAME THING WITH RANKINGS DATA.

Page 99: The Best SEO Advice You Will Never Hear

7. NOT PROVIDED

Page 100: The Best SEO Advice You Will Never Hear

Not Provided? Uggghhh…

Page 101: The Best SEO Advice You Will Never Hear

“I can’t be worried about that shit. Life goes on, man.”

Page 102: The Best SEO Advice You Will Never Hear

BEST QUOTE OF 2014

“I’m so over ‘Not Provided’.”- @Rhea

Page 103: The Best SEO Advice You Will Never Hear

QUOTING MYSELF

“If you haven’t figured out how to move forward after

Not Provided, grab a watch -because you’re late!”

- @KerryDean

Page 104: The Best SEO Advice You Will Never Hear

ME, TOO.

“Yeah, well, that’s just, like, your opinion, man.”

Page 105: The Best SEO Advice You Will Never Hear

Okay…so what can you do about ‘Not Provided’?

Page 106: The Best SEO Advice You Will Never Hear

THE EASIEST THING TO DO

ORGANIC CHANNEL LANDING PAGE

Page 107: The Best SEO Advice You Will Never Hear

COUNT THE NUMBER OF LANDING PAGES

THAT NUMBER RIGHT THERE

Page 108: The Best SEO Advice You Will Never Hear

TREND IT & LOOK FOR NOTEABLE SHIFTS

Page 109: The Best SEO Advice You Will Never Hear

8. SEO REPORTING

Page 110: The Best SEO Advice You Will Never Hear

30+ KPI’Sx 3 DEVICE TYPESx 3 OPERATING SYSTEMSx 3 BROWSERSx SOME OTHER DIMENSIONS= A LOT OF REPORTS!

SO MANY REPORTS, SO MUCH TIME…RIGHT?

“Napoleon, like anyone can even know that.”

Page 111: The Best SEO Advice You Will Never Hear

TODAY, WE HAVE TO DRILL DEEPER.

Page 112: The Best SEO Advice You Will Never Hear

BUT SOMETIMES LOOKING FOR INSIGHTS CAN SEEM LIKE THIS.

Page 113: The Best SEO Advice You Will Never Hear

WE HAVE TO PUT ON OUR THINKING CAPS.

Page 114: The Best SEO Advice You Will Never Hear

SEO REPORTS ARE LIKE CATS – YOU CAN NEVER HAVE TOO MANY.

Page 115: The Best SEO Advice You Will Never Hear

WELL…UNTIL YOU BECOME THE CRAZY CAT LADY OF SEO.

Page 116: The Best SEO Advice You Will Never Hear

“Information is powerful. But it is how we use it that will define us.” - @Avinash

Page 117: The Best SEO Advice You Will Never Hear

#SMALLDATA

MY FAVORITE HASHTAG

Page 118: The Best SEO Advice You Will Never Hear

1. DETERMINE WHICH KPI’s MATTER TO YOUR CLIENT.

2. DETERMINE WHICH KPI’s ACCURATELY MEASURE THE SUCCESS/FAILURE OF YOUR SEO CAMPAIGN.

3. DETERMINE WHICH KPI’s ARE ACTIONABLE.

THE GOALS OF REPORTING

Page 119: The Best SEO Advice You Will Never Hear

THINGS YOU CAN DO WITH:

Page 120: The Best SEO Advice You Will Never Hear

+13 more: CH,DK,FI,HK,IE,IL,MX,NL,NO,PL,SE,SG,TR

Page 121: The Best SEO Advice You Will Never Hear

SEMRush Organic Research Positions

Page 122: The Best SEO Advice You Will Never Hear
Page 123: The Best SEO Advice You Will Never Hear

You can download this data by month going all the way back to Jan-2012.

DO IT!

Page 124: The Best SEO Advice You Will Never Hear

Once you have the data, there is only one thing left to do…

PIVOT

TABLES!

Page 125: The Best SEO Advice You Will Never Hear

First, add a few new columns.

Page 126: The Best SEO Advice You Will Never Hear

What can you do with this data?

Page 127: The Best SEO Advice You Will Never Hear

1. Ranking Trends for Keywords (Position Groups)

Page 128: The Best SEO Advice You Will Never Hear

2. # of Keywords Ranking for a Set of Keywords

Page 129: The Best SEO Advice You Will Never Hear

3. # of Keywords Ranking for All URLs

Page 130: The Best SEO Advice You Will Never Hear

3. (CONT…) # of Keywords Ranking for All URLs

Page 131: The Best SEO Advice You Will Never Hear

4. Keyword Tiers (Y/Y Comparisons)

Page 132: The Best SEO Advice You Will Never Hear

5. Trended Keyword Tiers

Page 133: The Best SEO Advice You Will Never Hear

6. Plot URL Ranking Data Over Actual Visits Data

Page 134: The Best SEO Advice You Will Never Hear

1. Segment groups of URLs by:o Producto Categoryo Sub-Catso Sub-Domains

2. Filter each group by:o Brand vs Non-Brando Search Volume Tiers

The SEMRush Data Allows You To:

Page 135: The Best SEO Advice You Will Never Hear

9. SPEED ROUND

Page 136: The Best SEO Advice You Will Never Hear

STOP READING ABOUT SEO.

START DOING SEO.

THE BEST SEO ADVICE EVER

Page 137: The Best SEO Advice You Will Never Hear

STOP READING SEO BLOGS.

START WRITING FOR SEO BLOGS.

THE BEST SEO ADVICE EVER

Page 138: The Best SEO Advice You Will Never Hear

STOP ENGAGING WITH OTHER PEOPLE’S CONTENT.

START CREATING YOUR OWN CONTENT.

THE BEST SEO ADVICE EVER

Page 139: The Best SEO Advice You Will Never Hear

REGARDING CONTENT:

THE BEST SEO ADVICE EVER

You should look at your content the same way Uncle Jesse looked at Aunt Becky. You should love it until death.

Page 140: The Best SEO Advice You Will Never Hear

You should love your content as much as Macho Man loved Miss Elizabeth.

Page 141: The Best SEO Advice You Will Never Hear

HULK HOGAN SHOULD BE POINTING AT YOU!

Page 142: The Best SEO Advice You Will Never Hear

REGARDING GOOGLE:

THE BEST SEO ADVICE EVER

THIS IS WHAT THEY DO. GET USED TO IT. FIND OPPORTUNITIES IN THE CHANGES.

Page 143: The Best SEO Advice You Will Never Hear

REGARDING YOUR CLIENTS:

THE BEST SEO ADVICE EVER

I suggest you gentlemen invent a way to put a square

peg in a round hole.

Page 144: The Best SEO Advice You Will Never Hear
Page 145: The Best SEO Advice You Will Never Hear

THE BEST SEO ADVICE EVER

“We've got to find a way to make this... fit into the hole for this... using nothing but that.”

Page 146: The Best SEO Advice You Will Never Hear

That is SEO.

Page 147: The Best SEO Advice You Will Never Hear

The good news is that SEO’s love a challenge.

Page 148: The Best SEO Advice You Will Never Hear

Meet every challenge with this statement:

Page 149: The Best SEO Advice You Will Never Hear

“I’m your Huckleberry.”

Page 150: The Best SEO Advice You Will Never Hear

ONE LAST PIECE OF ADVICE:

THANKS!

End every presentation with a cat gif.