How to implement MCC shared libary neg lists to multiple accounts

[Dan Perach]

I tried to implement this solution: https://developers.google.com/adwords/scripts/docs/solutions/mccapp-master-negative-list

however,  i don't see in the implementation doc where to input the url for the google doc housing the negative list...

which i will then apply to all campaigns in selected child id accounts

[Paul Justine de Honor]

Hi Dan,

You can set the spreadsheet URL by changing the value of the variable below:

var SPREADSHEET_URL = 'INSERT_SPREADSHEET_URL_HERE';

Also, please perform the following steps when running the Master Negative List solution:

1. Open the template spreadsheet in the same browser where the AdWords account is logged in
2. Go to File -> Make a Copy
3. Copy the URL of the new version from the browser
4. Place this URL in between ' ' in script. For example: var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/'

Thanks,

Paul Justine De Honor

AdWords Scripts Team

[Dan Perach]

Last check		Powered by AdWords Scripts
Master Negatives Script - dashboard		555-555-5555
Label for campaigns to be processed	Bulk negatives	Leave this field empty to process all the campaigns in an account.
Name for negative keyword list	Master negative keywords	A negative keyword list of this name would be created in each account being processed.
Name for negative placement list	Master negative placements	A negative placments list of this name would be created in each account being processed.
Email address	em...@example.com	Enter a valid email address.
Customer IDs		Enter a comma separated list of customer IDs to be processed. Leave empty to process all accounts under the advertiser manager account.

i've copied this into my account, and chose the customer ids, but i'm not sure about:

do we only populate the yellow cells?

are the negative kws meant to be supplied here? if so, not good for me.

i need to pull the neg kws for the neg list from a separate doc

seems that this solution is asking for the neg kws to be input here, in C4?  if my list has 5,000 neg kws, some phrase some exact... that's not ideal.

also, does the script than apply to the selected ids or does it create and sync the neg kws into each child account?

thx,

[Paul Justine de Honor]

Hi Dan,

Kindly see my responses below:

• Do we only populate the yellow cells?
• Yes, you just need to define the list names if you have already Campaign Negative Keywords List and Campaign Placement Exclusions List existing under your account.
• If none, a new list would be created on your account with names indicated in C4 and C5 cells.
• Are the negative kws meant to be supplied here?
• No. The new values of negative keywords should be populated under "Keywords" tab.
• Does the script than apply to the selected ids or does it create and sync the neg kws into each child account?
• All the neg kws would be synced on each child selected account under C7 value.

Thanks,

Paul Justine De Honor

AdWords Scripts Team

On Monday, January 2, 2017 at 10:39:39 PM UTC+8, Dan Perach wrote:

[Dan Perach]

thx for reply.

where is the keyword tab?

still not clear how/where to sync the google doc that houses the negative list, ie. from where to draw the neg kws for list?

this script works for one neg list at a time, correct?

[Paul Justine de Honor]

Hi Dan,

The "Keywords" tab can be found at the bottom of the spreadsheet. Kindly see attached image for your reference.

The google doc which contains the negative list will not be synced to your account. You have to copy all the keywords from your google doc to the template spreadsheet under Keywords tab.

Yes, you can only run one negative list at a time.

Thanks,

Paul Justine De Honor

AdWords Scripts Team

On Monday, January 2, 2017 at 10:39:39 PM UTC+8, Dan Perach wrote:

[Dan Perach]

hi paul,

thx for reply. when i copied the mater template, it did not copy the other 2 tabs, my bad.

ok, i've moved forward and now have this error:  TypeError: Cannot call method "getValues" of null. (line 479)

var values = spreadsheet.getRangeByName('ConfigurationValues').getValues();

thanks for your help

[Paul Justine de Honor]

Hi Dan,

It seems that the issue is due to the incorrect sheet name on the spreadsheet. Can you confirm if you have "Sheet 1" on your spreadsheet? If yes, you need to change it to "ConfigurationValues".

As I mentioned on my previous response, please perform the following steps to avoid errors when running the Master Negative List solution:

1. Open the template spreadsheet in the same browser where the AdWords account is logged in
2. Go to File -> Make a Copy
3. Copy the URL of the new version from the browser
4. Place this URL in between ' ' in script. For example: var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/'

Thanks,

Paul Justine De Honor

AdWords Scripts Team

On Monday, January 2, 2017 at 10:39:39 PM UTC+8, Dan Perach wrote:

[Dan Perach]

thanks paul for your reply.

it was named Configuration, and i now changed to ConfigurationValues

i left the Placements tab empty, that would only be used for placement urls negatives on display/video campaigns, right?

question:  the Keywords tab must be formatted with [ ] or " " for negative exact or negative phrase, correct? only one column with header row Keyword is ok?  not possible to have two columns a: for keyword and b: for match type?

if i have an additional tab of the original list named something else, is that a problem?

script is running in preview mode now for 10 minutes, applying to 12 accounts... 

should i try running script now?

[Dan Perach]

to clarify... the spreadsheet url is input only once in the script, correct?

[Dan Perach]

now getting this error:

TypeError: Cannot call method "getValues" of null. (line 479)

477 function readConfig() { 478 var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL); 479 var values = spreadsheet.getRangeByName('ConfigurationValues').getValues();

[Paul Justine de Honor]

Hi Dan,

Kindly see my responses below:

• I left the Placements tab empty, that would only be used for placement urls negatives on display/video campaigns, right?
• Generally, placements are for targeting content network only.
• The Keywords tab must be formatted with [ ] or " " for negative exact or negative phrase, correct?
• It must be enclosed with " " for PHRASE match, - for NEGATIVE match and [ ] for EXACT match.
• Only one column with header row Keyword is ok?
• Yes.
• Not possible to have two columns a: for keyword and b: for match type?
• You need to put the keywords with corresponding symbol to set the match type (e.g. +keyword for Broad match).
• If i have an additional tab of the original list named something else, is that a problem?
• It is fine to add an additional tab but may I ask what would be the purpose?

• the spreadsheet url is input only once in the script, correct?

• Yes.

Would you be able to provide us the CID along with the name of the script so we can further investigate? Please use reply privately to author. Also, please grant me permission to access the spreadsheet.

Thanks,

Paul Justine De Honor

AdWords Scripts Team

On Monday, January 2, 2017 at 10:39:39 PM UTC+8, Dan Perach wrote:

[Dan Perach]

ok, one list at a time, fine.  so if i want to run another list, just repeat process with another google sheet / another neg list.

[Dan Perach]

still getting this error: TypeError: Cannot call method "getValues" of null. (line 479)

[Dan Perach]

still getting this error: TypeError: Cannot call method "getValues" of null. (line 479)

[Dan Perach]

maybe this solution is redundant afterall... https://support.google.com/adwords/answer/7177954

it would be nice if MCC list could be applied across child accounts from same MCC interface, instead of needing to navigate to child accounts?

[keith.d...@click.co.uk]

Hi Dan,

Im wondering about the format for mobile apps, can you shed light on this?

Click Consult Limited, Registration Number 4798223

Please consider the environment before printing this e-mail

DISCLAIMER
This email and any files transmitted with it are confidential and intended solely for the attention and use of the individual or entity to whom they are addressed. No copyright or other intellectual rights to any material attached to this email, either inline or as an attachment are transferred to the recipient unless explicitly stated. If you have received this email in error please reply to inform us accordingly, prior to deleting the message. Do not use, copy or disclose the information contained in this message or in any attachment.

[Hiroyuki Miyauchi (AdWords Scripts Team)]

Hello,

Since this is an old thread, could you please create a new one with the complete details or context of your concern related to AdWords Scripts so we can provide appropriate information?

Regards,

Hiroyuki

AdWords Scripts Team

[Dan Perach]

972544850158 call

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "AdWords Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/auVzpQgHZxM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/f9b03d48-d128-4621-a869-7bb02124b50a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Dan Perach

972 54 4850158