“Advanced Keyword Modelling” How to Quickly Uncover How People Search in Your Niche

Richard Baxter, Founder, SEOgadget

............................................................................................................................. ..................................................................

How to make decisions on your

navigation with KW categorisation

Required reading:

http://mz.cm/kwcategories

............................................................................................................................. ..................................................................

WE’RE GOING TO BUILD THIS: 1

6

11

16

21

26

0

1000

2000

3000

4000

5000

6000

7000

ou

tdoo

r to

ys

pad

dlin

g p

ools

"min

i mic

ro"

sco

ote

r

girl

s b

ikes

bab

y sw

ings

bab

y sw

ing

kid

s sc

oo

ters

wen

dy h

ou

se

boy

s b

ikes

* p

edal

go-

kart

s

child

rens

sco

ote

rs

wen

dy

ho

uses

3-w

hee

l sco

oter

3 w

hee

l sco

ote

r

"wen

dy

ho

uses

"

kid

s m

oto

rbik

es

grac

o b

aby

swin

g

go k

art

s fo

r ki

ds

kid

s sl

ides

wen

dy h

ous

es f

or c

hild

ren

bab

y tr

ampo

line

child

ren

s sw

ings

kid

s go

kar

ts

pla

y te

nts

child

ren

s o

utd

oor

toys

pla

y te

nt

bab

y sw

ing

seat

out

doo

r to

ys f

or

kid

s

kid

s o

utd

oo

r to

ys

fish

er p

rice

bab

y sw

ing

trik

es f

or

tod

dle

rs

bed

ten

t

bab

y sw

ings

an

d b

ou

nce

rs

kid

s te

nts

kid

s ou

tdo

or

pla

y eq

uip

men

t

pop

up

ten

ts f

or k

ids

child

ren

s ri

de

on

toys

3 w

hee

led

sco

oter

child

ren

s te

nts

girl

s b

mx

bik

es

out

doo

r to

ys d

irec

t

chea

p g

irls

bik

es

child

ren

s go

kar

ts

kid

s ga

rden

to

ys

gard

en t

oys

fo

r ki

ds

pla

y te

nts

for

kid

s

bab

y sw

ing

chai

r

ped

al c

ars

for

kid

s

po

p u

p p

lay

ten

t

bab

y g

ard

en s

win

g /'

#'/

kid

s go

kar

t

ou

tdoo

r b

aby

swin

g

3 w

hee

l sco

ote

rs

wo

oden

out

doo

r to

ys

toy

cast

les

for

bo

ys

bab

y g

ard

en s

win

g

out

doo

r to

ys f

or

tod

dle

rs

Today’s lesson: construct a beautiful chart just like this one using VLOOKUP and Pivot

charts

............................................................................................................................. ..................................................................

LET’S DO SOME

Time to do a live demonstration – take a look at these two posts for further info: http://seogadget.co.uk/how-to-make-a-pivot-table-and-chart-in-excel/ and http://www.seomoz.org/blog/keyword-research-using-

categories

............................................................................................................................. ..................................................................

(International) Keyword Expansion

Required reading:

http://bit.ly/adwordsapi

............................................................................................................................. ..................................................................

GOOGLE SUGGEST

Ubersuggest. THE Google suggest scraper tool. Also scrapes Google News!

............................................................................................................................. ..................................................................

Scrape Ubersuggest with XPathonURL. Simples!

Language query can be changed

for most geo locations

............................................................................................................................. ..................................................................

GOOGLE ADWORDS API PLUGIN FOR EXCEL

1) You’ll need an API Key: http://code.google.com/apis/adwords/

2) Download: http://seogadget.co.uk/google-adwords-plugin-excel/

3) Sit back and generate your keyword volumes

Capture search volumes and seasonality data straight into Excel

http://seogadget.co.uk/google-adwords-plugin-excel/

=getAdWordStats()

=getAdWordIdeas()

............................................................................................................................. ..................................................................

SUGGEST SERVICE IN TAIWAN

The ArrayGetAdwords ideas query fetches suggested keywords from the Adwords API for

ANY country code

Richard Baxter, Founder, SEOgadget

Twitter: @richardbaxter

Blog: seogadget.co.uk

Email me: richard@seogadget.co.uk

Thanks for listening!

............................................................................................................................. ..................................................................

Appendix Stuff there’s no time to talk about

at SES but too useful to delete!

............................................................................................................................. ..................................................................

WHERE DO I RANK FOR THESE KEYWORDS?

Rank checking is never perfect, but If you’re using a decent proxy service located in the correct host

location, the data is useful – especially for measuring visibility by keyword group / content type

............................................................................................................................. ..................................................................

YOU CAN GET RANKINGS VIA GDOCS

Check out the point made by Tom Critchlow about the use of the &time query for larger scrapes here:

http://seogadget.co.uk/playing-around-with-importxml-in-google-spreadsheets/

............................................................................................................................. ..................................................................

QA FORUMS ARE AWESOME FOR BLOG POST IDEAS

View this Gdocs spreadsheet: http://bit.ly/9Fs7aF via:

http://seogadget.co.uk/playing-around-with-importxml-in-google-spreadsheets/

http://www.seomoz.org/q/browse?utf8=%E2%9C%93&visibility=0&time_range=0&sor

t=0&x=54&y=9&limit=10

............................................................................................................................. ..................................................................

GENERATE CONTENT IDEAS

Using Google Docs to generate awesome content ideas:

http://seogadget.co.uk/using-google-docs-to-generate-hot-content-strategies/

1. Google Discussions

2. Google News

3. Bing News (best

match)

4. Bing News (most

recent)

5. Digg (most dugg)

6. Digg (most recent)

7. Reddit (Top)

8. YouTube Top Rated

9. Topsy Latest Tweets

10. Topsy Latest Top

Trending Tweets

11. Blog Catalog

12. Yahoo Answers (most

answered)

13. Twittorati Search

14. AllThingsNow (Most

popular FB shares)

15. Fark (latest)

16. Fark (most popular)

17. How Stuff Works

18. Redux

19. Helium

20. Cracked

21. Wiki Answers

............................................................................................................................. ..................................................................

LEARN HOW PEOPLE ARE ASKING QUESTIONS

I like this! https://freekeywords.wordtracker.com/keyword-questions