Wo do I find the script 'Negative Keyword Conflicts'?

• Version for a single Google Ads Account
• MCC (Manager Account) version

 Problems with the Google Ads Script 'Negative Keyword Conflicts'

Google is a bit sloopy wit it. Sometimes you must edit the script to make it run or the (translated) documentation is not up to date. Here three common problems:

• Script stops immediately with this message:
  Exception: Invalid reporting query: UNSUPPORTED_VERSION: RequestError.UNSUPPORTED_VERSION.
• Script seems to work but the spreadsheet is empty. At the bottom of the Log is written:
  Incorrect range width, was 7 but should be 6
• Script seems to work but the spreadsheet is empty. At the bottom of the Log is written:
  Exceeded maximum execution time

 Exception: Invalid reporting query: UNSUPPORTED_VERSION

The solution is very simple. Find the line apiVersion: 'v201605' (ignore the number) and write two // before so you get // apiVersion: 'v201605'.
Then the script should work fine.

 Incorrect range width, was 7 but should be 6

In version 1.3.3 Google implemented a long wanted feature: The name of the negative keyword lists are reported now.

But Google didn't update all translations so e.g. in the German translation the link to the template spreadsheet has not been updated.

Here the right version from the English description: template spreadsheet for 'Negative Keyword Conflicts' (Version 1.3.3)

 Exceeded maximum execution time

The solution depends on if you are using the MCC version or the single account version of the script.

Solution for the MCC version

Divide your accounts into groups and give them different labels. Install the script as often as you defined label groups. We named the labels zz_negKeyConflict 1, zz_negKeyConflict 2 etc.

Edit the Google Ads Scripts so that each script considers just the accounts with a specific label:
ACCOUNT_LABEL: 'zz_negKeyConflict 1', (every script with a different number)

Solution for single account version

Divide your campaigns into groups and give them different labels. Install the script as often as you defined label groups. We named the labels zz_negKeyConflict 1, zz_negKeyConflict 2 etc.

Edit the Google Ads Scripts so that each script considers just the accounts with a specific label:
CAMPAIGN_LABEL: 'zz_negKeyConflict 1', (every script with a different number)