So we started our initial view, of all the keywords that could be used to find our website. But what we want to do, is start downloading all those keywords into some form of manageable document. I find a spreadsheet to be the most obvious, and easiest for managing these keywords, because the amount keywords you have is going to be directly relational to the amount of products or information, you want to push through your website. So it's possible that these lists could be in the thousands or tens of thousands of key words.
Here's a couple of things that you need to keep in mind as you start this initial process. I'm starting in keyword discovery, which allows me to pull all this keyword data, and see which keywords are related to my business. So I can go through and put a check in the checkbox of the keywords that are relevant. As you can see, I can also add the entire column into my keyword project. So I want to find all the relevant keywords and sometimes maybe I'll just add an entire column into that so I can just look at that later.
But if the vast majority look relevant, I'm going to go ahead and add them. So, I can get as big a picture as possible. Usually when I'm going through this, I'll create an individual project for each grouping of keywords. So this group of keywords is about the spa and resort vacations. All of my keywords are going to be related to that vertical. My hiking keywords for the other products, I'm going to save those and add them to a different project so I can manage them differently.
Now once I've got all these keyword in my project, I know I've already added them because there's a check mark next to them, and I can still go though and see what I've of missed, and what's open and just keep looking at pages and pages of additional keywords to add to the project. Now once I'm ready and I feel like I've got a good grasp, of the entire market of keywords, then I'll go to export them. And almost every tool has an export feature, that will allow you to determine which format you should export, what you want to include such as how many searches, what does the keyword data include as far as competition or occurrences or daily.
And then how you want to look at it? And then you simply export it and open it up in a spreadsheet and that will prepare you then to start filtering and organizing all of the keywords based on your specific business and products.
Author
Updated
10/12/2017Released
2/27/2014- Understanding how keywords work
- Using long-tail keywords, phrase patterns, and plurals
- Organizing keyword data with a keyword spreadsheet
- Interpreting data and discovering searcher intent
- Measuring keyword competitiveness and brand impact
- Examining keyword demand and keyword trends
- Applying keywords to your website for maximum searchability
- Creating effective PPC ads based on keywords
- Understanding PPC bidding strategies to avoid costly mistakes
- Measuring results so you can further prioritize marketing efforts
Skill Level Intermediate
Duration
Views
Q: This course was updated on 10/12/2017. What changed?
A: The following topic was updated: Moz. In addition, new videos were added that cover the Wordtracker keyword tool and SEO in Google Analytics.
-
Introduction
-
Welcome1m 13s
-
-
1. Mine the Rich Resources of Keywords
-
What are keywords?4m 11s
-
The implications of keywords6m 36s
-
How can we use keywords?5m 27s
-
View the keyword universe3m 25s
-
-
2. Managing Keyword Data for Maximum Insights
-
Find initial keywords2m 18s
-
Utilize the long tail4m 25s
-
Find phrase patterns2m 15s
-
Search for synonyms3m 19s
-
Plan for plurals1m 56s
-
3. Find Searcher Intent from Keyword Searches
-
Find searcher intent1m 48s
-
Measure brand impact2m 26s
-
Assess the right searcher5m 45s
-
Assess competitive data4m 5s
-
-
4. Adding Three-Dimensional Keyword Data
-
Compare keyword trends5m 15s
-
Asking why3m 22s
-
Articulating strategy2m 35s
-
5. Using Keyword Management Tools
-
Raven tools3m 55s
-
Moz4m 26s
-
SEMrush2m 27s
-
Wordtracker keyword tool4m 36s
-
6. Apply Keywords to Your Website
-
Understand page structure3m 40s
-
7. Apply Keywords to Your PPC Campaign
-
Create effective ads4m 16s
-
Avoid costly mistakes4m 48s
-
Focus on negative keywords3m 16s
-
-
8. Measure Your Results
-
Do not be fooled by rankings3m 35s
-
Measure the right outcomes6m 19s
-
SEO in Google Analytics4m 43s
-
-
Conclusion
-
Next steps2m 25s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating a keyword spreadsheet