How do we get only Search keywords and ignore negative keywords from *ad_group_criterion *service?
I've used like this: SELECT ad_group_criterion.criterion_id,ad_group_criterion.keyword.text,ad_group_criterion.status FROM ad_group_criterion where ad_group_criterion.status NOT IN ('UNKNOWN' ,'REMOVED') and ad_group_criterion.negative=true I would need only Search Keywords. I tried different ways, but count is not matching On Wednesday, March 10, 2021 at 9:33:08 PM UTC+5:30 adsapiforumadvisor wrote: > Hi Harshi, > > Thank you for reaching out. You could add ad_group_criterion.negative > <https://developers.google.com/google-ads/api/fields/v6/ad_group_criterion#ad_group_criterion.negative> > in > your query to check whether the keyword is excluded (`true`) or > targeted(`false`). > > > > Thanks and regards, > Xiaoming, Google Ads API Team > > > [image: Google Logo] > Xiaoming > Google Ads API Team > > > ref:_00D1U1174p._5004Q2AHc6C:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/59a7efe2-7046-48c9-8401-c50666094d05n%40googlegroups.com.