Identify duplicate keywords within the same publisher account and recommend which keyword should remain active based on recent keyword performance.

What can I do with this?

• Review duplicate keyword
• Use the output report to create a bulk upload to pause the duplicate keywords

Example

How it works

The script reviews each account for duplicate active keywords. It creates a report with the identified keywords and emails it, including a recommendation on which keyword to keep based on:

• Cost
• Quality Score
• Conversion Rate
• Impression Share

If all keywords in a campaign are losing, it will also recommend a new name for the campaign. The aim being to pause campaigns containing only keywords that will be (or are) paused. Renaming allows to quickly identify these campaigns as old.

The classification dimension allows to make sure the suggestions only offer to pause legacy versions of a campaign, as long as the keyword in those legacy campaigns also exist in a “new” campaign.

Requirements

Setup

• The client needs to have 8 columns defined to hold the duplicate information. See code for details

Report

• See code below for required columns in the report

Customization

• Adjust metric used to determine the winning keyword
• Change naming convention for renaming campaigns