WordStream Internet Marketing Software

Import Keywords Tutorial - Importing Keywords and Keyword Lists

Importing keywords with WordStream is an altogether painless process.

This tutorial will show you how to instantly get thousands of keywords uploaded into your WordStream account. If you're just getting started with WordStream, you may want to take a look at our Getting Started Guide, which covers much of the same content here, and offers information on how to sync your Google AdWords account and on installing the WordStream Web analytics package.

The first step is to import keyword data into your account.

You can do this any of five ways:

  1. Import keywords through our Google Analytics Integration

  2. Import keywords using our Keyword Suggestion Tool

  3. Import keywords using our Spy on Competitor Keywords Tool

  4. Import keywords from a Text File (CSV or TSV; this would likely be for the importation of analytic files or data mined from third party keyword tools)

  5.  Import keywords by Copy & Pasting a list

  6. Import from Web Server Log Files

Import from Web Server Log Files

If you do not have access to your Google Analytics account or website code, this is a helpful workaround for uploading historical keyword data into WordStream. Server log files offer a thorough means of generating keyword lists.

In the Discover Keywords control panel click on the Web Server File Upload option.

Web Server Log File Upload

Download the WordStream Keyword Discovery Tool when prompted (also available at that link) and run it against your log files, as illustrated below. Note that this same executable file will work on Windows, Mac or Linux.

Contact your IT department or your webmaster, and have them get a hold of as much of your website's log data as possible. You can store these log files in folders locally on your computer (on your desktop, in a documents folder, etc.)

Run the application and follow these instructions:

  • Find your Log Files: Specify where your website's log files are located - ideally you should go as far back as you possibly can - the more the better. Click either the "Add File(s)" button to add a single log file, or "Add Folder" to add an entire directory (as shown in the following illustration). If your log files are in different directories, feel free to add multiple folders.
  • Enter your WordStream Login Info: Enter your assigned WordStream username and password (the same that you'll use to enter your account), and then click "Discover". This ensures that we store your valuable keyword data in the correct account.

The WordStream Keyword Discovery Tool will now start parsing through your log files, extracting keyword data and then sending that information into your live WordStream account so that you'll have plenty of relevant keywords to work with in optimizing your PPC campaigns.

Parse your website's log files to discover relevant keywords with WordStream's Keyword Discovery Tool.

Discovering keywords in your log files can take as little as a few minutes to as long as a few hours depending on how many log files you have, and how big they are. Here are some tips:

  • Run the Parser Locally: Depending on the volume of your website traffic, log files can range from very small to super huge. If your log files are in the 100's of gigabytes (or even terabytes) try copying the files over to your local computer before running the WordStream Keyword Discovery Tool, or alternatively, run the parser application on the computer that hosts the log files. This will substantially reduce file I/O and speed up the process considerably.
  • Use as Many Log Files as Possible: The way WordStream works is that the more data it has, the greater the number of keyword suggestions and pricing advantages offered you and your account. So if you can go back several years in terms of log file history, by all means go for it! Alternatively if you're eager to just get started as fast as possible, you can run it on say, the first year's data and run the WordStream Keyword Discovery Tool again at a later time on the rest of your data - the tool is smart enough to never count the same data twice.
  • You'll Need an Internet Connection: Obviously the parser needs to send your keyword data over to our WordStream servers and in order for this to work you'll need a speedy internet connection. Rest assured, your keyword data is stored in a private database and we'll never share it with other companies.
  • Grant WordStream Firewall Access: Along the same lines, if you're running Windows personal firewall and it asks you to grant the WordStream Keyword Discovery Tool access to a port, click "OK".

Import Keywords Using our Keyword Suggestion Tool

WordStream also includes a built-in keyword suggestion tool similar to the Google AdWords Keyword Tool. To use this option to import keyword suggestions, select Keyword Suggestion Tool. To get started, just start typing a few keyword phrases. The tool automatically generates a list of popular keywords relevant to that topic or website.

Keyword Suggestions

You can add to your list by selecting related keywords:

Related Keyword Suggestions

Alternatively, you can filter your list by viewing Google and Bing search trends, and then using one of the two delete options.

Keyword Search Trends

Delete a single keyword:

Delete Single Keyword

Delete a modifier from your entire keyword list:

Delete Keyword Modifier

When you are satisfied with your list you can add it to your WordStream database:

Add to Keyword Database

Import Keywords From a Spy Tool

To access this option simply click Spy on Competitor Keywords from the Discover Keywords control panel. Then, enter your competitor's home page, or a specific URL you are interested in.

Spy Competitor Keywords

You also have the option to scrape your competitor's entire website. This option is ideal if your competitor's business offerings are very closely aligned with yours.

Spy Competitor Website

When you're ready to add the keywords to your WordStream keyword database, you can click "Add to My Keywords."

Import Keywords From a Text File

The next option is to import keywords from a CSV or TSV file. This is also an easy process:

Select the CSV or TSV File Upload  option, and then attach the file you'd like to upload (much the same way you would with an email attachment).

CSV TSV File Upload

You will be asked to review your keywords and visit counts. Check to make sure you're uploading the correct keywords and adjust the visit counts if necessary.

Adjust Visit Counts

When you're ready to add the keywords to your WordStream keyword database, you can click "Add to My Keywords."

Import Keywords Via Copy/Paste

Finally, you can import keywords by copying and pasting them into a text field. First, select the Copy & Paste Keywords option from the Keyword Discovery control panel.

Simply export keyword data from analytics or a keyword research tool, then copy the data you'd like imported. Next, paste the copied data into the blank text field, and click "Next".

Copy Paste Keywords

You will be prompted to make sure you're importing the correct keywords, and that you've assigned the proper visit counts for each. When you're ready to add the keywords to your WordStream keyword database, you can click "Add to My Keywords."

That's it! You can now start to segment keywords, designate negatives, and more with WordStream!

Free Keyword Tool

Get thousands of relevent keyword suggestions - more,
faster, free!

Free Keyword Niche Finder

Discover profitable pockets of keywords for your

Free Negative Keyword Suggestion Tool

Identify wasted spend before it happens and increase
your paid search ROI.

Contact Us | Company | Support | Site Map | Trademarks | Privacy Policy © 2007-2014 WordStream, Inc. All rights reserved.