Hi, I hope this message finds you well.
We are managing over 200 ad accounts under our MCC account and are looking to automate the process of fetching all "Conflicting Negative Keywords" for these accounts. Our goal is to generate a consolidated report that includes this data for all the ad accounts within the MCC. Could you kindly provide guidance on how we can achieve this using the Google Ads API? Specifically, we would appreciate: 1. The necessary API queries to identify and retrieve conflicting negative keywords. 2. Best practices for automating this process across multiple ad accounts under the MCC. 3. Any additional considerations or resources to facilitate this implementation. Thank you in advance for your support and expertise. Best regards, *Lutfor Raju* On Monday, January 6, 2025 at 9:12:24 PM UTC+6 Google Ads API Forum Advisor wrote: > Hi Lutfor, > > Thank you for reaching out to the Google Ads API support team. > > To fetch the negative keywords at the campaign level, you may use the > below query with campaign_criterion > <https://developers.google.com/google-ads/api/fields/v18/campaign_criterion> > report: > > > > SELECT campaign_criterion.negative, campaign_criterion.type, > campaign_criterion.keyword.text, campaign_criterion.keyword.match_type, > campaign.id > FROM campaign_criterion > WHERE campaign_criterion.type='KEYWORD'" > } > > Also, you can get the negative keywords at the ad group level using the > ad_group_criterion > <https://developers.google.com/google-ads/api/fields/latest/ad_group_criterion> > report: > > > > SELECT ad_group_criterion.negative, ad_group_criterion.keyword.match_type, > ad_group_criterion.type, ad_group_criterion.keyword.text, ad_group.id > FROM ad_group_criterion > WHERE ad_group_criterion.type = 'KEYWORD' > > On the other hand, customer_negative_criterion > <https://developers.google.com/google-ads/api/fields/v18/customer_negative_criterion> > is > indeed a negative criterion for exclusions at the customer level. > > If you are not looking for the above reports, please share the uncropped > screenshot of the Google Ads UI by highlighting the specific fields of the > report that you are trying to fetch via the Google Ads API > <https://developers.google.com/google-ads/api/docs/start>? > > You can send the details via *Reply privately to the author option*, or > *direct > private reply* to this email. > > This message is in relation to case > "ref:!00D1U01174p.!5004Q02vGrVi:ref" (ADR-00280578) > > Thanks, > > [image: Google Logo] Google Ads API Team > Feedback > How was our support today? > > [image: rating1] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002vGrVi> > > [image: rating2] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002vGrVi> > > [image: rating3] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002vGrVi> > > [image: rating4] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002vGrVi> > > [image: rating5] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002vGrVi> > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords 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 visit https://groups.google.com/d/msgid/adwords-api/30c0d670-77e1-449c-9170-1c71c909e23cn%40googlegroups.com.
