The next time you need to evaluate your search query reports, consider using PPC Campaign Generator.
The concept is pretty simple.
- Download your search query report from Google or Bing for a given time period
- Create a new campaign within PPC Campaign Generator
- Go to the Grouper tab
- Click the "Add" button
- Paste the raw search query list into PPC Campaign Generator
- Hit the "Clean" button to remove unwanted characters (Found in Settings)
- Hit the "Remove Duplicates" button
- Select F1 in the settings
- Hit "Analyze" to analyze the keyword density of one-word phrases
- Scroll through the list looking for keywords that should be negatives
- When you find a one-word phrase, right click, Select "Negative"
All keywords that contain the one-word negative phrase will be deleted from your main keyword list. The negative keyphrase will be added to the filter box within the program.
You can use the CTRL key on your keyboard to select multiple cells at once. With multiple cells selected, you can right-click and select Negative to identify multiple negative keywords in bulk.
Build PPC Campaigns Faster With
PPC Campaign Generator
Build PPC campaigns in 5 simple steps!
Simple enough for beginners, powerful enough for advanced users
Training videos and support
FREE stand-alone version of my Keyword Grouper software with purchase (Limited-time!)
Trackbacks/Pingbacks
[...] will also identify keywords you know you don't want to bid on. PPC Campaign Generator helps you identify negatives this way. With all your keywords grouped, you can do some clean-up on the groups tab and assign [...]