#pubcon @ashnallawalla lateral keywords for writers ( when the google keyword planner isn’t...
TRANSCRIPT
#pubcon
http://ash.nallawalla.com
@ashnallawalla
Lateral Keywords for Writers(When the Google Keyword Planner isn’t enough)
Presented by: Ash NallawallaSEO Strategist, Suncorp Insurance
#pubcon
http://ash.nallawalla.com
@ashnallawalla
2
About Ash
• SEO consultant, currently at Suncorp Insurance (eight brands)
• Moderator at Webmasterworld forums
• Previously in enterprise SEO roles, notably NAB, ANZ Bank, Ubank, Optus and Yellow Pages
#pubcon
http://ash.nallawalla.com
@ashnallawalla
KEYWORD RESEARCH BASICS
No longer enough
#pubcon
http://ash.nallawalla.com
@ashnallawalla
4
Everybody’s doing it
• Most of us use the Google Keyword Planner to get a feel for the most searched terms.
• Our competitors do that too.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
5
Search volume alone isn’t enough
• But we need a starting point.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
6
Search intent is important
• Intent can be Navigational, Informational, Commercial, Transactional.
• Yes, check out some tools.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
CHECK OUT THE COMPETITION
So who is “winning” in your niche?
(additional slides are in the full pack)
#pubcon
http://ash.nallawalla.com
@ashnallawalla
8
Ranking spreadsheet
• “Visibility” is important, but what is your way to measure it?
• Which competitor is more visible?
#pubcon
http://ash.nallawalla.com
@ashnallawalla
9
The content writer’s dilemma
• The spreadsheet shows the “winners”, not the “losers”. We can see who is using the most searched phrases.
• Others are using the same tools.• So what content are they using
that you are not using?• (Note: Ranking involves many other factors
and this is also about Selling!)
#pubcon
http://ash.nallawalla.com
@ashnallawalla
DEEP DIVE – TERM FREQUENCY
Looking for that lightbulb moment?
#pubcon
http://ash.nallawalla.com
@ashnallawalla
11
Hat Tip to Eric Enge
• See his articles in Moz:– Just Google “Eric Enge TF-IDF” for the URLs.
(click the image below if you have the PPT)
#pubcon
http://ash.nallawalla.com
@ashnallawalla
12
Term Frequency – Two ways to measure
• Term Frequency – how frequently the term appears in a document (incl. stop words)
Or
If Raw Term Count > 0, TF = 1+log10(Raw Term Count)If Raw Term Count = 0, TF = 0
#pubcon
http://ash.nallawalla.com
@ashnallawalla
13
TF-IDF example
• Say, a document with 100 words contains the term “cat” 3 times.
• The TF is 3/100 x 0.5 + 0.5 = 0.515• Google has, say, 30 trillion pages and the word “cat”
appears in 1.7 billion pages.• The IDF is log(30,000,000,000,000 /1,700,000,000)
or log(730,2.718281828) = 6.593044535• The TF-IDF (or TF*IDF) weight is the product of:
0.515 x 6.593044535 = 3.395417935
#pubcon
http://ash.nallawalla.com
@ashnallawalla
14
Getting back to Term Frequency…
• Search for your keyword.• Visit the page/s of the highest
ranking company and the next four top rankers.
• Note their URLs.• Note the URL of your own page.• Do a Term Frequency analysis
and, perhapsInverse Document Frequency analysis (TF-IDF).
#pubcon
http://ash.nallawalla.com
@ashnallawalla
15
Get n-grams
• Use one of the old “keyword density” tools to get 1-word, 2-word, and 3-word pairs from your site and the five competitors.
• Collate, de-dupe n-grams and place in Eric’s spreadsheet.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
16
TF – one worksheet per keyword
• Six sets of n-grams on the left and de-duped list in grey zone.
Eric’s spreadsheet
#pubcon
http://ash.nallawalla.com
@ashnallawalla
17
TF – close-up
• Get a count of each word or phrase used by the top five pages and by yours
#pubcon
http://ash.nallawalla.com
@ashnallawalla
18
TF – close-up
• Next, do the TF number crunching, i.e.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
19
TF – close-up
• Use conditional formatting to pick a range of TF values and compare your TF column with the average TF of the competitors.
• You will now see “significant” words to consider.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
20
The extracted words
• The pages I was analysing did not contain some “obvious” words – this is the beauty of this technique.
#pubcon
http://ash.nallawalla.com
@ashnallawalla
21
The future?
• Working on a web version
• Takes minutes, not hours.
Sliders
Gems
Beta: http://www.lateralkeywords.com
#pubcon
http://ash.nallawalla.com
@ashnallawalla
22
Summary
• Keyword research requires more than the Google tool. Do lateral keyword research.
• Do consider Term Frequency at least. Also look into Inverse Document Frequency.
• Download full PPT from:http://www.trainsem.com/pubcon
Ash Nallawalla• Twitter: @ashnallawalla• Email: [email protected]• Web: http://ash.nallawalla.com