How can I query a list of Negative Keywords By Campaign.Id?

43 views

Skip to first unread message

Dylan McBurnett

unread,

Sep 27, 2019, 10:56:30 AM9/27/19

to AdWords API and Google Ads API Forum

Hi,

I'm trying to find a query that will return a list of the Negative Keywords set at the Campaign level.

I could not find a way to do this with the Query Builder, but I can view a list of Negatives by Campaign in the UI.

Is it possible with queries?

I have the query below for negative keywords set at the Ad Group but it does not list negatives set at the campaign level.

    query_neg_keywords = ( 'SELECT keyword_view.resource_name, campaign.id, ad_group_criterion.keyword.text FROM keyword_view WHERE ad_group_criterion.negative = TRUE') # WHERE campaign.id = \'241463475\'

Any help would be greatly appreciated!

Google Ads API Forum Advisor Prod

unread,

Sep 27, 2019, 4:46:51 PM9/27/19

to dylan.m...@mightyhive.com, adwor...@googlegroups.com

Hello Dylan,

Thank you for writing to us today. You could use the campaign_criterion resource to retrieve the list of all the negative keywords set at the campaign level by specifying the campaign_criterion.negative field to true in your report query. Please find below the sample report query to list all the negative keywords set at campaign level. Let us know if you need any additional information.
"SELECT campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = TRUE"

Regards,
Nikisha Patel, Google Ads API Team