Features & Screenshots

MINING SEARCH QUERY REPORT

To improve the performance of PPC search campaigns, advertisers need to:
1. Add irrelevant keywords as negatives
2. Add new keyword opportunities for keyword expansion

This can be done through search query mining. However, it is difficult to implement this from raw search query report when there is large amount of data rows.

Add +ve and -ve keywords function makes tasks simple

Campaign Negative Before

Campaign Negative After

1. Add keyword as Positive
a. Campaign Level OR
b. Ad Group Level

2. Add Keywords as Negative
a. Campaign Level OR
b. Ad Group Level

All you need to do is:
- Download search query report
- Highlight the cell of keywords which you want to work upon
- Click on the relevant option.

On clicking the relevant option
- The raw data would be removed
- A new sheet would be created with predefined column heading & highlighted data ready for import.

Border

NO ACTION KEYWORDS (Based on No. of Words)

This function removes search queries of more then 10 words from search query report.

No Action Keywords

No Action Keywords After

To use this function you need to perform 2 steps:

Step 1: Open search query report for which you wish to take action
Step 2: Click on 'No Action> 10 Words' function of PPC Time Saver

No Action 10 Words

'No Action' function of PPC Time Saver removes search queries > 10 words and puts it in a new sheet.

Adwords does not allows adding keywords with more then 10 words.

Border

NO ACTION KEYWORDS (Based on No. of Characters)

This function removes search queries of more then 40 characters from search query report.

No Action Characters Before

No Action Characters - After

To use this function you need to perform 2 steps:

Step 1: Open search query report for which you wish to take action
Step 2: Click on 'No Action > 40 Characters' function of PPC Time Saver

NO Action of More then 40 characters

'No Action' function of PPC Time Saver removes search queries more then 40 characters and puts it in a separate sheet

Search queries more then 40 characters hardly has any search volume. It is therefore recommended that such queries are removed from addition or deletion

Border

Other Functions

Add Brackets & Quotes | Count Words & Characters | Convert to Modified Broad |
Change to Lowercase, Uppercase & Sentence case
| Create Ad & Keyword Template |
Remove Hyperlinks, Formulas & Extra Spaces | Insert Special Characters | Export Worksheet | Mine Search Query Report | Extract Domains

Border