internet marketing tools Clever Gizmos Home Products Contact Log In Create Account
 
keyword organizer

Organize Keywords and Import CSV Files from the Google Keyword Planner.

Keyword Organizer is a Software Application that helps you Manage Keywords, arrange your Content Articles, and plan a Web Content Strategy for your website.

1723

Beautiful People

Have purchased Keyword Organizer.

Loading...

0

If you have ever used the infamous Google Keyword Planner, then you need to check this out! Get ready to say goodbye to the tedium of manually manipulating CSV files--in complicated Microsoft Excel spreadsheets.

Our app "Keyword Organizer" was built by Internet Marketers, for Internet Marketers.

It was designed (from the ground up) to be an all-in-one SEO solution--that allows you to manage both your keywords and website articles.

  • Need to manage thousands of keywords?
  • Need help writing SEO-Optimized website articles?
  • Want to organize an entire SEO website?

Then read on, and get ready to turn confusing keyword data into valuable information.

As Internet Marketers, we all understand the value of working with clear and concise keyword data. If you've ever done any SEO at all, then you're already familiar with the Google Keyword Planner--Google's amazing keyword tool that spits out heaps of great keyword data. It's the "first-stop" for ANY online SEO marketing campaign.

You've probably downloaded CSV files from the Keyword Planner, and perhaps worked with them in a spreadsheet program like Microsoft Excel.

  • Perhaps you've tried to separate the good keywords from the bad keywords.
  • Perhaps you've tried to organize your keywords into logical groups.
  • Perhaps you've tried to create SEO-optimized documents for your website, and found that, squeezing all these keywords into your articles can be a bit tricky.

And that's where the problem starts!

For years, I spent hours doing manual Keyword Research with various keyword tools. This was eating up a lot of valuable time! Trying to sort, segment, and make sense of a list of a thousand keywords takes forever. Not to mention, trying to organize this data into a concise keyword research report that would make sense to a client.

If you've ever spent five minutes trying to sort keyword data in Microsoft Excel, then you know how difficult working with large keyword lists can be!

organize keywords

Keyword Organizer can turn a list of thousands of keywords, into an actionable SEO Strategy.

We designed it to make the entire SEO process flow smoothly--from keyword generation, to content publishing, and all the steps in between. We've tried to think of everything!

Now, let's go over the 6 most foundational steps of SEO (Search Engine Optimization):

The 6 Foundational Steps of SEO

This is where Search Engine Optimization begins.

STEP 1

Gather Keyword CSV Files

STEP 2

Remove the Junk Keywords

STEP 3

Search for the Good Keywords

STEP 4

Organize the Good Keywords into Article Groups

STEP 5

Type the Good Keywords into your Article

STEP 6

Publish Your Content

Step 1: Gather Keyword CSV Files

In this step, you start by gathering a bunch of CSV files from the infamous Google Keyword Planner .

Now here's the tricky part: These files need to be merged into just one file. Also, the same keyword might often appear multiple times in multiple CSV files. So you'll need to remove the "duplicate keywords" too.

With Keyword Organizer, this is easy. Simply drag the CSV files into the app, and all of your keyword data is sorted for you. Duplicates are removed. And the incoming keywords (that you have "blacklisted" in the past) will, of course, be blacklisted again. So they won't interfere with your project.

Go to the next step

   download csv files from google

Watch the Webinar

In the below webinar we'll go over some uses of Keyword Organizer.

Keyword Organizer Webinar

In this video, we'll go over 10 ways that you can use Keyword Organizer in your web business.

Loading...

01:14 - Task 1. Import CSV files from the Google Keyword Planner
07:26 - Task 2. Search through your Keyword List
09:57 - Task 3. Clean up your Keyword List
13:37 - Task 4. Find a Domain Name for your Website
16:21 - Task 5. Find a name for your product with high SEO value
19:42 - Task 6. Analyze on-site SEO on a Webpage
23:35 - Task 7. Clean up your Article Content
25:30 - Task 8. Export your data to Microsoft Excel
26:37 - Task 9. Create SEO-Optimized Article Content
29:25 - Task 10. Layout a Content Strategy

 

Video 1:
Do SEO Faster with Keyword Organizer
   Video 2:
Import a list of keywords from Keyword Researcher
   Video 3:
Import, Sort, and Export keywords with ease
   Video 4:
The Negative Keyword List
   Video 5:
Exporting to WordPress
 

1. Do SEO Faster with Keyword Organizer

In this video, we'll go over the most basic of SEO steps in on-site content creation. Those being:

  1. Gather a large list of keywords.
  2. Select keywords for my website.
  3. Assign these keywords to articles.
  4. Write the articles using these keywords.
Loading...

2. Import a list of keywords from Keyword Researcher.

In this video, we'll show you the best way to bring in keywords from my other app KeywordResearcher, and get some associated data for your words via the Google Keyword Planner.

Loading...

3. Import, Sort, and Export keywords with ease.

In this video, we'll talk about the most foundational needs of any keyword database app. It must be:

  1. Easy to import data.
  2. Easy to search within the data.
  3. Easy to filter the data.
  4. Easy to export data (to XLS or CSV files).
Loading...

4. The Negative Keyword List.

In this video, we'll talk about the importance of maintaining a solid "Negative Keyword List" in your website project. Briefly, a "Negative Keyword List" is just a list of keyword phrases that you do not want on your website. So why would it be important to maintain a record of keywords that you do not want? Well the answer to this question quickly becomes apparent after you've gathered a mere hundred keywords (or so) for your website. You'll find that it becomes very difficult to manage and arrange the keywords, without allowing redundant keywords into your project, or having to remove the same keyword twice. It's almost impossible to keep track of this many keywords without some type of keyword software. And of course, that's why Keyword Organizer was invented.

Loading...

5. Exporting to WordPress.

In this video, we'll show you how Keyword Organizer easily creates WordPress compatible documents. Once you've laid out your content strategy and you're ready to publish, with the press of a button you can export your content plan to your WordPress website. Keyword Organizer can generate a CSV file that can be read by the free CSV Importer Plugin. Meaning that you can move your content from the planning phase to the publishing phase with ease. You can also select if you'd like your content to be published as a WordPress Post or a WordPress"Page." If you don't use WordPress, you can of course also export to a Microsoft Excel file. And then, bring your content into any sort fcontent management system you prefer.

Loading...

What can Keyword Organizer do for you?

Let's list a few ways you might use the app in your business.

 

1. Import CSV files from the Google Keyword Planner.

Using the good ol' free Google Keyword Planner is great. It produces an un-ending supply of great keywords--from which you can create content on your website. But there's a problem. If you've ever actually sat down and tired to arrange these CSV files into a viable content strategy, then it becomes clear very fast how difficult the task is.

Keyword Organizer has been specifically designed to tame Google's CSV files for you. It gobbles up their data and displays the goods elegantly--in a clean, minimalistic interface that you'll find very easy to use.

 

2. Separate the good keywords from the bad keywords.

When you've got a few thousand keywords on your plate, then deciding which ones you're going to pursue can be a bit daunting.

Keyword Organizer has sophisticated sorting, searching, and categorization tools--all designed to help you weed out the keywords you don't need, and manage the keywords you'd like to target.

 

3. Assign your keywords to article groups.

Ultimately, your job in the creation of on-site content, primarily comes down to assigning keywords to logical groups. In SEO, we create content resources ("articles") out of these groups. And these resources act as the "lure" that draws search engine visitors to our website.

Keyword Organizer enables you to create Categories, Articles, and Paragraphs. Assigning keywords has never been easier--because you simply drag the keyword over to the article group.

 

4. Create SEO-Optimized Web Content.

Once you finally know which keywords you'd like to use in your content strategy, you need to actually write your article. In SEO, we "pepper in" our keywords into various locations in our article content.

Keyword Organizer examines your content while you type. And the keywords themselves will change color, based on if they do, or do not, appear in the article content.

 

5. Export your content directly to WordPress.

Writing a batch of articles for your website is hard enough. But actually publishing the content (article-by-article) to your website can be quite a chore.

Keyword Organizer has a built-in native WordPress XML exporter. Meaning that you can import your articels right into your WordPress database.

Keyword Organizer Screenshots

Yes, this is what Keyword Organizer looks like.

              
 

 

 

Table of Contents

content strategy What is a Content Strategy and why is it important?
find keywords Finding Keywords in your content.
choose keywords Selecting the right keywords for your website.
keyword groups Plan a Content Strategy and Cluster your keywords.
make titles Create your article titles
write article Write your article and use your keywords in the article content.

Content Strategy Basics

Create and deploy keyword-optimized content.

1. What is a Content Strategy and why is it important?

If you've ever wondered how Google is able to find the best webpage for your search query, the short answer is this:

They compare the words you type, with the words that appear in their database of all the websites of the Internet.

Basically, Google has downloaded the text of almost every website in the world. And they have organized these sentences into a large database. So, when you search Google, their computers crawl through this database and fetch the URLs of the websites that contain your search words.

This is, of course, an overly-simplistic summary of what's really going on. Search engines are much more sophisticated these days, and the mere presence of the word on the web page is only one factor in determining search rank.

Still, you can see why SEO (Search Engine Optimization) is taken so seriously. Because, in the least, a web page that does not contain the user's keywords, is less likely to actually be about the user's keywords.

So when we refer to the creation of a "Content Strategy," this typically entails the development of a group of keyword-optimized information articles.

  • First, the SEO guy (sometimes pretentiously called the "Content Strategist") will examine a body of keyword data, and select the keywords which he feels are conducive to the marketing of the product that the website caters to.
  • Then, a lot of time, money, and effort are attributed to "Content Writers" ("Content Developers") who create articles that satisfy (or partially satisfy) the spirit of the user's search query.

Such content is created for a couple reasons:

  • In a product-based web business model (e.g. a company selling baby toys or video courses), the site owner hopes that a visitor will serendipitously stumble upon his website, and, will be so impressed by the images, video, or content that he will ultimately become a paying customer.
  • In an advertising web business model (e.g. a magazine or blog), the site owner hopes to attract as many visitors as possible to his website. Because he knows that some percentage of these visitors will view an advertisement or (even better) click on an ad. The more clicks our site owner gets, the more money he makes.

2. Finding Keywords

Of foundational importance in the creation of a content strategy is the generation of list of keywords that people are actually searching for on the internet. This usually means starting your journey at the infamous Google Keyword Planner and typing various "seed keywords" into its search box.

If you're not familiar with the Google Keyword Planner, it's a web interface (owned by Google of course) that allows you to download a body of keyword data (in the form of CSV files). These files contain a wealth of important information like:

  • The Keyword Search Volume (The number of times the keyword is queried per month)
  • The Keyword Cost-Per-Click (The approximate amount that an Adwords publisher is paying--when his ad is displayed for this keyword.

So you can see why this information if valuable. Because, thanks to the Google Keyword Planner, we can actually see:

  • What types products or services people are searching for
  • The exact phrasing that people are using to search for products or services
  • And, how many people are searching for these products or services

Working with a large batch of CSV files from the Google Keyword Planner can be tricky. And that's why Keyword Organizer was invented. It takes in all this great keyword data, and consolidates it into workable database.

3. Selecting the right keywords for your website.

So how do you know which keywords to use?

organize keywords into categories
Don't get distracted by too many keywords.

This is one of the most difficult questions in SEO. And the answer is different for every business model.

Simply put, you should use keywords on your website that are conducive to the marketing of your product or service. Ultimately, the keyword-selection task is much easier if you have a deep understanding of your target demographic--prior to ever sitting down to look at a keyword spreadsheet.

But once you've gathered all your keywords together, it is sometimes best to try to "put yourself in the shoes" of the person who has just typed this phrase into Google.

You might start out by asking yourself:

  • Does the product or service I sell solve this person's problem?
  • Am I the answer to this person's question?
  • Do I personally know how to answer this user's question?
  • Can I ascertain what this user is looking for, based on the keyword phrase itself?
  • Can I create content for this query that will leave the user satisfied that they have completed their search successfully?
  • Do I have experience with people asking this question?

There is, of course, no perfect algorithmic method for deciding which keywords you will ultimately target in your web content. So if you're just starting out in your Search Engine Marketing efforts, you might want to start small. Simply pick a dozen keywords and create a few articles that genuinely cater to the searcher's needs.

4. Plan a Content Strategy and Cluster your keywords.

After you've chosen a batch of keywords to target, it's time to assign these keywords into distinct article groups.

organize keywords into categories
Organize your keywords into content article groups.

Typically, a few keywords will pop out at you, and you'll notice that they are similar enough, such that they'd fit nicely together into the same article.

Consider, for example, the following list of keyword phrases:

  • how to organize keywords
  • organize keywords for a website
  • arrange website keywords
  • keyword organization
  • keyword organizer software

Now it should be pretty obvious that such keywords should be clustered together and placed into one article. (Namely, the article you're reading right now.)

There wouldn't be much utility in fracturing this little keyword group into five individual articles! Rather, it is in my interest to simply make sure I cover "the letter and the spirit" of these five keyword phrases on this one web page.

The keywords in the above example are pretty easy. But, the subjective and stylistic nature of Content Strategy Planning becomes apparent when the keyword phrases are more ambiguous.

Take for example the phrase "web content writing." Now at first glance, it may appear that my web page may satisfy the commercial intent of this searcher. Helping people write web content is exactly what Keyword Organizer does!

But if we dig into this phrase a bit more, we'd probably find that the majority of people who type in this phrase are looking to either:

  • hire a web content writer
  • get a job as a web content writer
  • or to simply learn more about web content writing itself

It is unlikely that most of these searchers would be interested in actually purchasing Keyword Organizer at this time.

Hence, it would not be in my interest to actively pursue the keyword phrase ("web content writing") in my on-site and off-site content marketing efforts.

It would be much more beneficial for me to angle the content of this web page toward keywords that are more reflective of a person who is actively seeking a keyword organization app.

In any case, this is the thought process you must go through with each keyword you choose for your website. If you're familiar with your target market, then this task usually goes pretty quick. You should be able to glance at most keywords, and decide (in a couple seconds) if the keyword is (or is not) conducive to the marketing of your product.

When this part of the content planning process is done, all of your keywords will be arranged in nice little clusters (sometimes called "Keyword Groups"). And then it's time to start thinking of some article titles.

5. Create your article titles

Every internet document is indeed just that--a document. And all documents need a title.

So your next task is to create a unique title for your web document. This is an important step, because the document's title sets the theme for the entirety of the content. And is the most important single SEO element on the page.

As you glance at any given keyword group, you'll find that they often lend themselves to the creation of a rather obvious title. Consider this group:

  • low carb snack foods
  • best low carb snacks
  • no carb snacks
  • low carb snack recipes

Right away, we can see that we're going to be using the words "low carb snack" in our article somewhere. And this is the point where your copywriting skills come into play. We'll need to create a title that encapsulates most of our target keywords, and yet also has an alluring ring to it.

Creating a psychologically alluring title is important--because search engines will rank our document (in part) based on how many clicks the title is getting--relative to other articles on Google's Search Results Page (SERP). Hence, a title that has some stylistic panache, will (in theory) ultimately rank higher than a title that doesn't have anything eye-catching about it.

So, instead of just titling our document "Low Carb Snacks," we might try something like this:

"10 of the Best Low-Carb Snacks that you can make in 10 Minutes!"

6. Write your article and use your keywords in the article content.

Now that your keywords are arranged in logical groups, and each group has a unique article title, it's time for the hard part... You have to actually write something.

It is very easy to let the keyword data hinder the creative writing process. So be wary of this. Keywords can be very distracting and you don't want to let all this data hinder your writing efforts.

So let the keywords merely act as the locus for your article theme. Just casually glance at your keywords before writing. And then craft your articles into a useful web content article. An article that you know will be beneficial to your target demographic.

Then, once the writing process is nearing completion, that's when you pull out your keywords. And you carefully "pepper in" your keyword phrases into your article content. This usually involved merely replacing an occasional word, or adding additional headings between paragraphs.

use keywords in your article content
Pepper your keywords into your article content.

It's easy to tell if all your keywords are reflected in your article content with Keyword Organizer. Because, as you type your content into the Keyword Organizer article text editor, the article's associated keywords will change color.

  • The color green means that the whole keyword is in the article.
  • The color orange means that portions of the keyword phrase are in the article.
  • The color black means that the keyword phrase hasn't been used in the article yet.

So you can see how this is particularly useful when creating article content. Because Keyword Organizer is constantly watching your document while you type, and it visually depicts your keyword's location in the article content. So it's an essential tool if you're in the business of creating SEO-optimized (keyword-rich) documents.

Understanding the Keyword Organizer Software Interface.

In this video, we take a peek under the hood and I run through some of the main components of the Keyword Organizer User Interface.

Loading...

Webinar Index:

0:18 - The Google Keyword Planner - How to use the Google Keyword Planner to download CSV files.
0:52 - The Google Keyword Planner - Select Broad, Phrase, and Exact Match data.
1:05 - The Google Keyword Planner - Set the Google Keyword Planner "Display Language" to English mode.
1:40 - How to log in to Keyword Organizer.
2:10 - Play with the demo file.
2:30 - Import CSV files into Keyword Organizer.
2:50 - Understanding the White List, Grey List, and Black List.
3:01 - Using the keyword grid's filters.
3:45 - Understanding the article column.
4:08 - How to show or hide columns.
4:20 - The help form.
4:40 - Arranging your column width.
5:00 - Send a keyword to Google.com.
5:09 - Copy keywords to your Windows clipboard.
5:12 - Moving panels around in the interface.
5:45 - Assigning keywords to articles.
6:05 - Dragging and Dropping in the Article Tree.
6:25 - Understanding the Article Tree's data.
7:00 - Understanding the color meanings in the content creation screen.

SEO-Optimizing a Webpage with Keyword Organizer

In this video, we'll show you how to use Keyword Organizer's "Web Page Analyzer" tab to SEO-optimize a sample web document.

Loading...

Using the Search Tools

In this video, we'll show you how to use Keyword Organizer's search functions to sift through a large list of keywords and find the ones that are most reflective of your target market.

Loading...

A Time-Saving Shortcut.

In this video, we'll discuss a shortcut method to use the Negative Keyword List. When you have a long list of keywords to sort through, then it's quite common to find several undesirable keywords in your list. So you can of course, manually click the Black List button next to the keyword, or, you can add the keyword to the Negative Keyword List. And this will extract the word from your White and Black List. But this process can be a bit time-consuming.

But there's a better way. When you press the ALT button on your keyboard, and click on a word in your keyword grid, then the word will insert itself into the Negative Keyword List, and search the project for any instances of this word. When it finds one, Keyword Organizer will send this word to the Black List for you.

Loading...

Locating Keywords in Articles.

In this video, we'll show you how Keyword Organizer is able to locate your keywords in your article content. Sprinkling keywords into your article content can be a bit tricky--when you've got a list of dozens of keyword phrases in front of you. But thanks to the Keyword Icons in Keyword Organizer, you'll always know how your keywords are dispersed in your content.

Loading...

An informal "over-the-shoulder" walk-through of Keyword Organizer

In this video, we'll talk about the general theory of arranging keywords for the creation of an SEO-optimized website. And then we'll briefly walk through the tasks in Keyword Organizer.

Loading...

The evolution of Keyword Organizer

In this video, we run through all the versions of Keyword Organizer that have existed since 2009.

Loading...

 

Testimonials

Yes, these are real pictures of real human beings who
really like Keyword Organizer.

"I run an authority website in the personal finance niche and my main focus is content marketing. I use SEMRush for keyword research and then organize my long list of keywords in Keyword Organizer. Before this, it was a long and tedious task--playing with Excel all the time... But now all my keywords are imported in the software and bam! Keyword data management on steroids. I can't explain how much time it saves me."
Akbar Sheikh
HealthAndAutoInsurance.org

"I've used many different keyword applications over the years. None have impressed me as much as Keyword Organizer (and sister product, Keyword Research) for usability, functionality and, perhaps most of all, value for money. Anthony provides clear instructional videos for both novice and experienced users alike, as well as pushing out regular updates. Highly recommended."
Adrian Bold
BoldInternet.co.uk

"It KILLS me to think that this tool only became available recently! I've been working with SEO for a few years now and all those spreadsheets and whatnot was enough to make me cry! I really wish I had this when I started! It would've made my job SO much easier! Tracking, assigning articles to the right keywords, staying SANE! With that I now have more time to what I actually use SEO for: make money"
Bruno Picinini
Empreendedor-Digital.com

 

"This is a slick and easy to use tool to organize your content writing for keyword-rich copy. Its fast and eliminates the need for others tools I had used in the past."
Kelly Watt
PushOnlineMarketing.ca

"Organize keywords in a way that makes sense to you. All while keeping tracking of which keywords you've researched, excluded, and decided to use. I don't get lost in a sea of keywords and a maze of content."
Nic Windley
NicWindley.co.uk

"I have been using Keyword Organizer for a few months now and cannot think of a better way to tie in SEO to our content marketing efforts. Another "Must Have' tool in my arsenal."
Uri Lederman
SAASAffiliates.com

 

"Your Testimonial Here..." Contact us and we'd love to include your testimonial here.
Your Name Here
Your Website Here

Note: If you bought one of our products a while ago (on a different website), then CREATE A NEW ACCOUNT here. But, be sure you use the same email address that you used during your original purchase.

Log In:

If you already have a Clever Gizmos account then log in below.
If you forgot your password click
the link to reset it.
Email:
Password: