searchlove boston 2016 | paul shapiro | how to automate your keyword research
TRANSCRIPT
![Page 1: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/1.jpg)
HOW TO AUTOMATE YOUR KEYWORD RESEARCH
Paul Shapiro – Organic Search Director at CatalystSearchLove Boston – May 4th,
2016
![Page 2: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/2.jpg)
@fighto
2
Without Automation
![Page 3: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/3.jpg)
@fighto
3
With Automation
![Page 4: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/4.jpg)
@fighto
WHO AM I?
4
![Page 5: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/5.jpg)
@fighto
5
Tool Data Sources
Visualization
+ +
![Page 6: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/6.jpg)
@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
![Page 7: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/7.jpg)
MANUAL KEYWORD RESEARCH IS
OFTEN BLAND &TIME CONSUMING
7
![Page 8: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/8.jpg)
@fighto
8
![Page 9: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/9.jpg)
@fighto
9
Most Keyword Research Looks Like This
![Page 10: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/10.jpg)
@fighto
10
That’s just a Google
Keyword Planner Export
![Page 11: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/11.jpg)
@fighto
TYPICAL TIME INVESTMENT FOR KEYWORD RESEARCH
Micro (0-49 pages) Small (50-99 pages) Medium (100-249 pages)
Large (250-499 pages) Extra Large (>500 pages)
0
5
10
15
20
25
30
58
12
21 21
6
10
18
22
28
Hours to Complete Keyword Research by Site Size
Average (Low End) Average (High End)
11
![Page 12: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/12.jpg)
@fighto
12
AIN’T NOBODY GOT TIME FOR MANUAL KEYWORD RESEARCH!
![Page 13: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/13.jpg)
@fighto
SIZE OF THE DATA SET
13
vs.
![Page 14: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/14.jpg)
@fighto
14
We can do better!
![Page 15: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/15.jpg)
WE CAN SAVE TIME WITH AUTOMATION
![Page 16: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/16.jpg)
@fighto
TYPICAL TIME INVESTMENT FOR KEYWORD RESEARCH
Micro (0-49 pages) Small (50-99 pages) Medium (100-249 pages)
Large (250-499 pages) Extra Large (>500 pages)
0
5
10
15
20
25
30
58
12
21 21
6
10
18
22
28
Hours to Complete Keyword Research by Site Size
Average (Low End) Average (High End)
16
![Page 17: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/17.jpg)
@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/
![Page 18: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/18.jpg)
WE CAN DO BETTER THAN AN EXCEL SPREADSHEET
![Page 19: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/19.jpg)
@fighto
THAT’S MORE LIKE IT!
19h/t @victorpan
![Page 20: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/20.jpg)
@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.
![Page 21: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/21.jpg)
@fighto
21
That’s much better! actionability.
![Page 22: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/22.jpg)
MY KEYWORD RESEARCH AUTOMATION PROCESS
![Page 23: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/23.jpg)
@fighto
23
https://www.knime.orgIt starts with a tool…
![Page 24: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/24.jpg)
@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
![Page 25: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/25.jpg)
THE BASICS OF KNIME
![Page 26: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/26.jpg)
@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
![Page 27: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/27.jpg)
@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
![Page 28: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/28.jpg)
@fighto
HOW DO YOU CONFIGURE & RUN NODES?
Configuring Nodes
Running Workflows
28
OR
![Page 29: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/29.jpg)
APIs 101
29
![Page 30: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/30.jpg)
@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
![Page 31: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/31.jpg)
@fighto
31
Output = XML
Parse me!
![Page 32: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/32.jpg)
A KNIME-API EXAMPLE
32
![Page 33: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/33.jpg)
@fighto
STEP 1: LIST OF KEYWORDS
33
![Page 34: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/34.jpg)
@fighto
STEP 2: ENCODE SPACES IN KEYWORD PHRASES
34
Space Character
![Page 35: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/35.jpg)
@fighto
STEP 3: CONCATENATE API URL + KEYWORDS
35
![Page 36: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/36.jpg)
@fighto
STEP 4: DOWNLOAD API OUTPUT
36
![Page 37: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/37.jpg)
@fighto
STEP 6: LOOP THROUGH EACH KEYWORD
37
![Page 38: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/38.jpg)
@fighto
STEP 7: PARSE THE XML OUTPUT FORM THE API
38
![Page 39: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/39.jpg)
@fighto
39
Auto-CompleteSuggestions
![Page 40: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/40.jpg)
@fighto
40
![Page 41: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/41.jpg)
@fighto
FYI: I’M NOT A KNIME SALESMAN
41
![Page 42: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/42.jpg)
DATA INPUTS / SOURCES
![Page 43: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/43.jpg)
@fighto
43# of primary data sources to aggregate
![Page 44: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/44.jpg)
@fighto
44 http://searchwilderness.com/gwmt-data-python/
Google Search Analytics – Historical MySQL Database via Python Script
![Page 45: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/45.jpg)
@fighto
45
AdWords - Search Query Report API or CSV
![Page 46: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/46.jpg)
@fighto
46
SEMRush – API (if <100,000) or Domain vs. Domain:
Competitor Keywords (Advanced Mode)
https://www.semrush.com/info/domain_vs_domain
![Page 47: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/47.jpg)
@fighto
47
GrepWords API – For Google Keyword Planner related query suggestions &
search volumes
http://grepwords.com/
![Page 48: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/48.jpg)
@fighto
48
Google Autosuggest API or Emulation with Selenium
![Page 49: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/49.jpg)
@fighto
49
Rank Checking/Full SERP API - GetSTAT
https://getstat.com/
![Page 50: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/50.jpg)
@fighto
50
MarketMuse – Semantic Keyword Recommendations
https://www.marketmuse.com/
Alternative: http://pshapi.ro/SemanticKWR
![Page 51: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/51.jpg)
@fighto
51
Moz API + Moz Nodes
https://tech.knime.org/book/mmi-labs-nodeshttps://moz.com/products/mozscape/access
![Page 52: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/52.jpg)
@fighto
52
Google Trends – Unofficial API
https://github.com/GeneralMills/pytrendsScript soon to follow: http://pshapi.ro/slopetrends
![Page 53: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/53.jpg)
@fighto
53
More data sources:http://pshapi.ro/kwmetrics
![Page 54: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/54.jpg)
THE DATA-TO-KNIME PROCESS
54
![Page 55: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/55.jpg)
@fighto
Filtering + Data
Manipula-tions
ONE BIG KEYWORD LIST
Seed Keywords- List- GWMT- SEMRush Comp. KWs- SQR Keywords
Keyword Planner Suggestions (via
GrepWords)Google
Autocomplete
Semantic Keyword Recommendations (via MarketMuse)
Google Autocomplete
SEMRush Domain vs.
Domain KeywordsGoogle
Autocomplete
55
![Page 56: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/56.jpg)
@fighto
STRING ‘EM ALL TOGETHER AND THEN…
56
![Page 57: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/57.jpg)
@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
![Page 58: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/58.jpg)
@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
![Page 59: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/59.jpg)
@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 keywords
Keyword Trends
59
![Page 60: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/60.jpg)
@fighto
60
![Page 61: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/61.jpg)
@fighto
61
Reusable
5-Minutes
![Page 62: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/62.jpg)
@fighto
62
You can use this data to filter keywords and reduce massive list... OR, you can leverage data visualization!
![Page 63: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/63.jpg)
VISUALIZING KEYWORD RESEARCH
![Page 64: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/64.jpg)
@fighto
64
We have a few
options…
![Page 65: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/65.jpg)
@fighto
OPTION: EXCEL + BUBBLE CHART
65
Not Recommended
![Page 66: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/66.jpg)
@fighto
OPTION: TABLEAU
66
![Page 67: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/67.jpg)
@fighto
OPTION: PYTHON + BOKEH CHARTS IN KNIME
67
![Page 68: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/68.jpg)
@fighto
THEY’RE INTERACTIVE…
68
![Page 69: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/69.jpg)
@fighto
69
Sample Python Code:http://pshapi.ro/SLBokeh
![Page 70: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/70.jpg)
@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…
![Page 71: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/71.jpg)
@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
![Page 72: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/72.jpg)
@fighto
RESOURCES: DATA SOURCES > KNIME
72
Data Source KNIME Node(s)Google Search Analytics Database Table Connector/ReaderAdWords Search Query Report XLS ReaderSEMRush 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 ResourceMOZ Moz API Connector/URL Metrics nodesGoogle Trends TBD – Either CSV or Python Script nodes
![Page 73: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/73.jpg)
@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
![Page 74: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/74.jpg)
@fighto
Questions?
74
![Page 75: SearchLove Boston 2016 | Paul Shapiro | How to Automate Your Keyword Research](https://reader033.vdocuments.us/reader033/viewer/2022051709/587312ef1a28ab673e8b466f/html5/thumbnails/75.jpg)
THANK YOU!@fightohttp://
searchwilderness.comhttp://catalystdigital.com