Five Steps to an Effective Pay Per Click Keyword Database

If you’re still building pay-per-click (PPC) campaigns from a traditional keyword list, it’s not doing your business any favors. A spreadsheet is an inefficient, outdated way to manage keywords for search marketing, leading to wasted dollars and lost time.
A keyword database is a completely different approach to research and manage PPC keywords. Compared to a keyword list, it’s:

• Private and proprietary
• Easier to organize and manage
• Easier to update and expand
• More actionable
• Collaborative

Essentially, it’s a flexible infrastructure that enables you to work with large numbers of keywords and quickly determine which pockets of keywords have the most business value. You can then translate your database into a highly effective PPC campaign structure.
Building a keyword database isn’t difficult, and as your campaigns scale, you’ll find it much faster and easier to keep things running smoothly. Here’s the five-step process to build an effective keyword database.


Step 1: Start your PPC keyword research
The most important part of a keyword database, naturally, is keywords! To build a comprehensive, up-to-date database, it’s important to look at keyword research as an ongoing process, aggregating keywords from multiple sources.


Here are four sources, both public and private, that will help you gain a complete picture of the terms you should be using in your campaigns:

• Public keyword tools: A traditional Web-based is based on popularity; remember that overall popularity doesn’t guarantee relevance to your audience.

• Historical site logs: Your server logs are a great source of keyword data—they contain a record of the real search queries that have led people to your site.

• Web analytics: The keyword reports in your analytics provide a continuous stream of new keywords. Incorporate those new insights into your research.

• Search query reports: The search query reports in AdWords Editor are another source of real data. These tell you the actual search queries that have triggered your PPC ads.

Pooling these sources gives you a personalized database that is highly relevant to your business. Be sure to keep your research up-to-date with traffic and conversion stats to see which keywords do the most work in your PPC campaigns.


Step 2: Segment and organize your keywords
Better keyword research gets you a lot closer to more profitable PPC campaigns, but to reap the full benefits of your research, it’s crucial to organize your keywords into small, manageable groups of closely related terms. This process will improve your campaigns by enabling:

• Better landing pages: It’s easier to write targeted, high-ranking copy around close-knit keyword groups.

• Better ads: Similarly, you can quickly write relevant, compelling text ads for well-structured keyword groups (aka ad groups).

• Better click-through rates: More relevant pages and ads grab a more qualified audience, so your CTRs and conversion rates improve.

• Better Quality Scores: High CTR and relevance lead to high Quality Scores, so you pay less for better positioning.

A well-organized database structure makes everything else you do for PPC, from adding new keywords to managing bids, simpler and more effective.


Step 3: Cut out waste with negative keywords
With strong keyword research, you can identify profitable keyword opportunities. But for high ROI, it’s equally important to identify and eliminate waste. This means discovering negative keywords, or irrelevant terms that eat up pay-per-click advertising budgets without generating quality leads.


Here are a few ways to find negative keyword candidates:

• Generic negative keyword lists: These aren’t a bad way to get started, but remember that generic negative keywords may not apply to your specific niche, and many are likely missing.

• During regular keyword research: When looking for relevant keywords, also keep your eyes open for suggestions that aren’t relevant to your business.

• Search query reports: Regularly look through your search query reports in AdWords and remove irrelevant keywords from your ad groups.

• Organic log files: By using your own log files for negative keyword discovery, you can catch irrelevant keywords before they trigger your ads.

Step 4: Create strong, targeted text ads
The next step is to write text ads for each keyword/ad group. If you followed the above process, your ad groups are already highly targeted, so it should be simple to write strong, targeted ads. Here are some tips for writing effective PPC ad copy:

• Include the top traffic: driving keywords in the title, text, and display URL of the ad when possible.

• Don’t overgeneralize: address a specific segment of your audience.

• Test several ads for each ad group. Google will rotate the ads so you can see which works best.

• Always include a call to action.

In addition, to maximize Quality Score, your ads should clearly be relevant to their associated landing pages.


Step 5: Repeat as necessary to maintain gains
One of the benefits of a keyword database is the ability to expand your research without losing control. So keep monitoring, testing, and tweaking your campaigns to improve results. And keep adding keywords from your analytics! The keywords your clients use to find you are among your most valuable marketing assets.