Exclude Non Brand in Shopping Branded Campaign

733 views
Skip to first unread message

Maggie Von Bernard

unread,
Jul 15, 2022, 1:53:18 PM7/15/22
to Google Ads Scripts Forum
Is it possible to create a script that automatically excludes search terms that don't include the brand's name in Shopping Campaigns ? 

Also is it possible that this script work with the condition that it excludes only non brand terms that have at least spent money or reached 1000 impressiones? So it doesnt exclude every single term with 1 impression and reaching the max 20K kw limit.?

Thanks!

Nils Rooijmans

unread,
Jul 16, 2022, 5:01:14 AM7/16/22
to Google Ads Scripts Forum
Yes, this is possible.

You can use a GAQL query to get data from the search term view  ( https://developers.google.com/google-ads/api/fields/v11/search_term_view
Based on this data you get a list of potential negative keyword candidates.
I recommend adding the keywords to a negative keyword list that is attached to your Shopping campaigns.
In order to prevent the list from reaching the max number of keywords too soon you can use another script to remove redundant negative keywords from the  list. For example: if 'free' (broad match) is already in the list, the negative "for free" (broad, phrase or exact match) can be removed.

Hope this helps to get you started, or you can contact me if you want me to create the scrips for you.

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/ 

Google Ads Scripts Forum Advisor

unread,
Jul 18, 2022, 2:35:34 AM7/18/22
to adwords...@googlegroups.com

Hello Maggie,

I’m James from the Google Ads scripts support team. Thank you for contacting us.

I agree with the given suggestion by Nils. You may try it on your end, and let me know if you need anything else from us. 

@Nils - Thank you for sharing your insights with this issue. We greatly appreciate your efforts.

Regards,

Google Logo
James Howell
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2cWaOk:ref

Maggie Von Bernard

unread,
Jul 19, 2022, 12:30:04 PM7/19/22
to Google Ads Scripts Forum
Thank you Nils and James.

We have a brand Shopping Campaign and a Non Brand Shopping Campaign. In the Non Brand Campaign it's simple because we exclude the brand's name in negative keywords. But in the brand campaign is more complicated because we want to exclude everything that does NOT include the name of the brand, so we really can't begin with a list of negative keywords like "for free" because it might include our brand's name in that search phrase.

I have recently created a negative keyword list with our brand's name and every other possible way you can spell it. Is it possible in this script to exclude every term that does not match with that list? This script will only be applied to the Brand Campaigns.

Also, how can I create that second script to remove redundant kws?

Thank you so much!
Message has been deleted

Google Ads Scripts Forum Advisor

unread,
Jul 20, 2022, 2:46:33 AM7/20/22
to adwords...@googlegroups.com

Hello Maggie,

Thank you for getting back to us. Can you please provide more details about the mentioned context about your brand campaign so that we can have a better understanding on what you are trying to achieve? It would be greatly helpful if you could discuss in a bullet format and you could provide us with the following details below:

  • Screenshots that describes the thing you want to achieve
  • Google Ads account ID / CID
  • Spreadsheet link, if there are any


Kindly send those requested information through `Reply to privately to author` option.

Regards,

Reply all
Reply to author
Forward
0 new messages