Creating Negative Keyword Lists Based on History

[Charles Michael]

I'm interested in switching from exact to broad matches and making use of negative keyword lists, but I'm having a hard time finding a way to create the negative keyword lists for keywords that I can't anticipate/predict. Is there a way to see what keywords a surfer used to come to our site and creating a negative keyword list based on this? I'm looking for actual keywords used, not ones that matched my account settings. For example, if I'm targeting "red widgets" and someone searched for "the best red free widgets", I would like to block this, but I have no way of knowing that was the phrase they used. I believe the dynamic insertion tool can inject a keyword into the url so we can track it this way, but I believe this tool will only report the keyword on my account that matched, not the raw keyword that a surfer used on Google. Has anyone had experience in creating precise negative keyword lists by looking at the history of searches/hits that came to their site? 

[Google Ads Scripts Forum Advisor Prod]

Hi Charles,

Thanks for posting your concern.

I understand that since you are switching to keywords with broad match type, your ads will regularly show as close variations of the keyword, related searches, and other relevant variations will be considered. However, my apologies as there is currently no available script that could create a negative keyword list based on the irrelevant searches and will direct to your sites.

As a workaround, I would recommend to keep using the keywords with exact match type as it will only consider the close variations of that exact term with the same meaning. The other way is to create a negative keyword list manually by using the Master Negative List solution script (this is the MCC version of this solution script).

Let me know if you have further questions/clarifications.

Regards,
Ejay
Google Ads Scripts Team

ref:_00D1U1174p._5001UHGE5s:ref

[Charles Michael]

Unfortunately its the keywords I can't anticipate or think of that I'm trying to find. There could be an infinite number of possible variations and some may be relevant and others could be way off. That's why I really need to see the actual keyword that a surfer used so I can review which to allow and which to add to the negative list. 

[Google Ads Scripts Forum Advisor]

Hi Charles,

Thanks for the reply.

It appears that you want to get the search terms of every keywords. First, to give an idea with the search term, it is the word or phrase that someone enters into a search engine which have relations to your keywords. In order to get this, I would suggest to use the Search Query Performance Report and include the KeywordTextMatchingQuery field and Query field. I suggested this so that you will know the search terms made by user for your specific keywords.

Since you mentioned that there could be an infinite number of possible variations, you would need to create a validation on your end using the above suggestion. You may reach out to me if you have any questions regarding this implementation.

[Charles Michael]

I think this will work, thank you.