How to add negative keywords to shopping campaigns via search pattern

[Rakesh]

Hello,

I'm new to this so please bear with me.

We are actually running shopping campaigns and lots of irrelevant queries are triggered and money is wasted on those. Obviously, as those terms are not our target audience. What we are looking for :

We want to match each query (for which the shopping ad is triggered) to a fixed pattern. For example :

The keywords which are TARGETED to our customers will contain a few particular words in them like:

flower, flowers, cake, cakes, shoes (If any of these words is found in a search term, that is a POSITIVE keyword for us). To be more clear, Red Flowers, Blue Flowers all are POSITVE keywords for us as they contain the word flower.

Other keywords, which don't have the words mentioned above should be automatically added as a negative keyword. Any ideas for me about how to do this on Ad group basis? Any help is highly appreciated. Even If any paid scripts, please guide me.

Rakesh.

[Anthony Madrigal]

Hi Rakesh,

Can you please have a look at this pre-built solution and see if it fits your needs?

You could create your own script for this task. For example, you could create a script that deletes keywords that are not in your preferred keywords list, and then you could manually upload the residual keywords in a negative keyword list.

You can download all current keywords to a spreadsheet in the UI. If you go to the keywords tab, you will see a download button on the right side of the screen. You can delete any columns that aren't of use to your task. Then you can add a column that contains your list of keywords that you want to keep and check for a match. If there is a current keyword that is not in your preferred keyword list, you can remove the keyword.

Although, we cannot write a custom script, please let me know if you have any specific questions.

Regards,

Anthony

AdWords Scripts Team