- Go to your AdWords account: bulk operations and scripts
- Click on: + Script to add a script
- Copy & paste the whole script
- Adjust settings:
- Adjust the period to be checked. All possible variations are listed in the script.
- Use the existing location spreadsheet or create a new one.
- In Google Drive, create a Google spreadsheet
- From the URL "https://developers.google.com/adwords/api/docs/appendix/geotargeting", upload all locations to the first tab of the Google spreadsheet.
- Name the sheet
- Copy the URL and paste it into LOCATIONS_URL
- For LOCATIONS_SHEET_NAME, specify the name of the sheet (See section 4.2.3.)
- Create a reporting sheet
- In Google Drive, create a new and empty Google spreadsheet
- Copy the URL and paste it into REPORTING_URL
- For MIN_CONVERSIONS, MIN_CLICKS, MIN_IMPRESSIONS, and MIN_COST, specify the minimum data for the locations.
- Specify the minimum and maximum bid the script may set. The minimum bid is 0.1 and the maximum bid is 10 (0.1 = -90%, 0.2 = -80%, 1= 0%, 2 = 100% and so on).
- Exclude the campaigns that the script should not edit. Each campaign must be separated by commas.
- Specify the minimum number of clicks a new campaign must have, in order for bidding to commence.
- Name the script
- Authorize the script by clicking the "Authorize Now" button.
- Start the preview and check whether the script runs properly.
- After the preview, save and close the script.
- Go to: +Create Schedule
- Specify frequency as "daily" and specify the time when the script should run.
- Authorize the script again.
- Save the script and run it.
- After the first run of the script, you can delete the first tab named "Tab 1" in your report (see section 4.4).
- The script creates a separate tab for each campaign, for which it finds locations to addand/or an for already added locations available for bidding.
- In each tab, the days of the week are specified.
- Every day, when the script is running, the column with the corresponding weekday is deleted and the current changes are added.
- Values that are showing location and a numeric value in brackets are new locations added by this script for the first time.
- Values that are only showing the location and the adjustment (no brackets), are locations that were already in the account or where created by this script before. So the script just sets the correct modifier.