Are you tapping into automation for keyword research? If not, why not? When it comes to SEO, automation is awesome. For starters, it can help free up a lot of time that is normally spent on menial tasks. What’s more, it can also aid deep analysis, and even facilitate innovation. If you are still doing keyword research manually, this is a must-attend session. Paul will show you how to get started with automated keyword research, using some easy-to-use tools. You’ll see first-hand how they can help you uncover valuable insights automatically. Overall, you will walk away with an immediately actionable plan to start automating your keyword research today.
6. @fighto
WHAT YOU WILL LEARN
• The problems with the standard keyword research process
• How you can save time on keyword research with automation
• How to automate keyword research with a powerful, but easy-to-use
tool
• How APIs work and how to leverage them
• What data sources are useful for keyword research automation
• How to use data visualization to make keyword research decisions
6
11. @fighto
TYPICAL TIME INVESTMENT FOR KEYWORD RESEARCH
5
8
12
21 21
6
10
18
22
28
0
5
10
15
20
25
30
Micro (0-49 pages) Small (50-99 pages) Medium (100-249 pages) Large (250-499 pages) Extra Large (>500 pages)
Hours to Complete Keyword Research by Site Size
Average (Low End) Average (High End)
11
16. @fighto
TYPICAL TIME INVESTMENT FOR KEYWORD RESEARCH
5
8
12
21 21
6
10
18
22
28
0
5
10
15
20
25
30
Micro (0-49 pages) Small (50-99 pages) Medium (100-249 pages) Large (250-499 pages) Extra Large (>500 pages)
Hours to Complete Keyword Research by Site Size
Average (Low End) Average (High End)
16
17. @fighto 17
If we do keyword research
once per month, we will save
around 24 to 45 full days
over a 5-year period using
automation.
http://xkcd.com/1205/
20. @fighto
HOW TO USE FOR KEYWORD SELECTION / TARGETING
20
This top-right quadrant contains
keywords with:
• Low competition
• Good growth
Larger bubbles show higher
search volumes.
You can alternatively use
current rank on the x-axis to
signal organic market share like
a traditional growth-share
matrix.
24. @fighto
WHY KNIME?
• Singular tool for data collection,
manipulation, analysis, and reporting
• Easy to use and no development skills
necessary
• If you are a developer, it provides faster
prototyping
• Large library of built-in “nodes”
• Free/Open Source
• Run on Windows/Mac/Linux
• Infinitely expandable
24
26. @fighto
WHAT’S A NODE?
• Nodes are prebuilt, drag and drop modules designed perform a singular task
• Nodes are strung together like a chain to accomplish larger, more complex tasks
• Nodes can be grouped together into “meta-nodes”, which can be configured in unison
26
27. @fighto
HOW DO YOU ADD NODES & HOW DO THEY CONNECT?
How do you add nodes to your “workflow”?
How do you string nodes together?
27
28. @fighto
HOW DO YOU CONFIGURE & RUN NODES?
Configuring Nodes
Running Workflows
28
OR
30. @fighto
EASY & APPLICABLE API: GOOGLE AUTOSUGGEST
http://suggestqueries.google.com/complete/search?output=toolbar&hl=en&q=ninja%20turtles
30
Simple API using “GET Request”
This is a variable
that changes
57. @fighto
DATA MANIPULATIONS / CALCULATIONS
• Get top 10 results from rank checking API (i.e., GetSTAT)
• Use Moz API nodes and find average PA to assess
competiveness.
• Optionally, use SEMRush’s Keyword Difficulty API
Organic
Competition
Search Volume
Keyword Trends
57
58. @fighto
DATA MANIPULATIONS / CALCULATIONS
• Get top 10 results from rank checking API (i.e., GetSTAT)
• Use Moz API nodes and find average PA to assess
competiveness.
• Optionally, use SEMRush’s Keyword Difficulty API
Organic
Competition
• Get Search Volumes via SEMRush API or via GrepWords APISearch Volume
Keyword Trends
58
59. @fighto
DATA MANIPULATIONS / CALCULATIONS
• Get top 10 results from rank checking API (i.e., GetSTAT)
• Use Moz API nodes and find average PA to assess
competiveness.
• Optionally, use SEMRush’s Keyword Difficulty API
Organic
Competition
• Get Search Volumes via SEMRush API or via GrepWords APISearch Volume
• Use 2 Years of Google Trends data to calculate slope and
determine growing/declining keywordsKeyword Trends
59
70. @fighto
SO WHAT…
• Free up time spend doing mundane, repetitive work and spend more doing impactful, strategic work
• Free up staffing resources and utilize them in other ways
• Extract and analyze a larger pool of data for greater data pool
70
From this… To this…
71. @fighto
SUMMARY
• You should rethink how your currently do keyword research.
• Keyword research is often bland, time consuming, and not as actionable as it can be.
• KNIME provides an easy-to-use interface for automating your keyword research
• APIs are easier to use than they sound; Use them
• There are great data sources you can leverage via APIs/built-in KNIME nodes
• Visualize your keywords using a growth-share matrix like-graph to make keyword usage
decisions
• Emojis are awesome
71
72. @fighto
RESOURCES: DATA SOURCES > KNIME
72
Data Source KNIME Node(s)
Google Search Analytics Database Table Connector/Reader
AdWords Search Query Report XLS Reader
SEMRush Domain vs. Domain (or API if less
than 100,000 keyword)
XLS/CSV Reader or GET Resource & Read
REST Representation
Google Keyword Planner/GrepWords GET Resource & Read REST Representation
Google Autosuggest
GET Resource & Read REST Representation
(or Selenium nodes)
Rank Checking (via GetSTAT) GET Resource & Read REST Representation
Semantic Keywords/MarketMuse POST Resource
MOZ Moz API Connector/URL Metrics nodes
Google Trends TBD – Either CSV or Python Script nodes
73. @fighto
ADDITIONAL RESOURCES
• KNIME Version to install: “KNIME Analytics Platform + all free extensions”
• To install KNIME Add-ons, Choose Help->Install New Software
• Moz nodes
• Should come with Nightly Builds. If not can add http://update.knime.org/community-
contributions/3.1 as a repository.
• Add-on Selenium nodes
• http://seleniumnodes.com/
• Search Engine Land article addressing additional data inputs: http://pshapi.ro/kwmetrics
• Information about Growth-share matrices:
https://en.wikipedia.org/wiki/Growth%E2%80%93share_matrix
• Sanple Python + Bokeh script for an interactive keyword research visualization in KNIME:
http://pshapi.ro/SLBokeh
73