Query to pull all negative keywords

[b...@venturestreet.com]

I was very excited about the prospect of being able to submit a single query in the Google Ads API to pull all campaign level negative keywords for an entire account.  However, when I submit the query, it only returns a subset of the keywords for each campaign.  I have had to resort to making a separate call for each individual campaign which is much slower and less efficient.  

Should I be able to make the single call?

I have approx. 400 campaigns with a total of 50K campaign level negative keywords across all campaigns.  

SELECT campaign_criterion.criterion_id

, campaign.id

, campaign_criterion.keyword.text

, campaign_criterion.keyword.match_type 

FROM campaign_criterion 

WHERE campaign_criterion.type = 'KEYWORD' 

AND campaign.status NOT IN ('REMOVED') 

AND campaign.advertising_channel_type NOT IN ('DISPLAY') 

AND campaign_criterion.negative = TRUE

This single query only pulls about 10K negative keywords.  It pulls a subset of each campaign's negative keywords.  For example, one of the campaigns has 65 negative keywords and the query on pulls 15 of them.

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

Since you mentioned that single query only pulls about 10K negative keywords instead of 400 campaigns with a total of 50K campaign level negative keywords across all campaigns, could you provide us with the complete request and response logs with the request-id, so our team can better check?

For the client library, logging can be enabled by navigating to the Client libraries > Your client library (ex Java) > Logging documentation, which you can access from this link. You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2a2T40:ref