Download Negative Keyword Report -via api

[Yael Zalcman]

HI!
I'm trying to download from Google Ads - Negative Keyword Report , using Adwords\v201809, I found this CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT report in Google\AdsApi\AdWords\v201809\cm\ReportDefinitionReportType class, 

my query was "SELECT Criteria FROMCAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT"

 my problem is that I want to download all negative keywords includes Ad-Group level, and not only the Campaign level. 

please help!

Thanks

Yael

[Google Ads API Forum Advisor]

Hello Yael,

Thank you for reaching out to us.

Since you're concern is getting all negative keywords (includes Ad-Group level, and not only the Campaign level), you can utilize the Keywords Performance Report since this report already includes all statistics aggregated at the keyword level. To capture those negatives, add a predicate for IsNegative IN [true, false] or IsNegative = true.

Hope this helps.

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2LmIVP:ref

[Yael Zalcman]

Thank you for answering! 

I tried to do it but I got an empty report, 

do you know if the IsNegative property is something I need to set, or it's automotive?

or do you know why I got an empty report, 

this is my code in php:

$builder = new ReportQueryBuilder(); $builder->from(ReportDefinitionReportType::KEYWORDS_PERFORMANCE_REPORT )->select(['Criteria'])->where('IsNegative')->equalTo('true'); the query is : SELECT Criteria FROM KEYWORDS_PERFORMANCE_REPORT WHERE IsNegative = true; Very appreciate Thanks!

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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 a topic in the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/ozptjQctlbU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/lpvsR000000000000000000000000000000000000000000000QXPJF600Qwuo_gheQny6mNXlSMUBYQ%40sfdc.net.

--

		Yael Zalcman
		Software Engineer
		yael.zalcman@autoleadstar.com (216) 242-1320

This email message from AutoLeadStar and any attachments thereto contain confidential and privileged information and are for the sole use of the intended recipient(s).
If you are not the intended recipient, you are not authorized to use, disclose, copy, distribute, or retain this message or any part of it and you are asked to contact the sender by reply email and destroy all copies of the original message.

[Google Ads API Forum Advisor]

Hello Yael,

Thank you for getting back to us.

Looking on your query, that should be able to generate those negative keywords coming from the KEYWORDS_PERFORMANCE_REPORT. So our team can better check on this, could you also share to us the Customer ID (clientCustomerId) used when running that report?

Regards,

[Google Ads API Forum Advisor]

Hi Yael,

We tried to reach you twice and unfortunately it didn't go through so let me repost what my colleague Ernie had sent you privately on August 17th:

 Hi Yael,

I appreciate your patience to this concern. I received an update from the team and let me share it to you.

You may try to set 'true' to the includeZeroImpressions field of the request header so that the report will also return the negative keywords with zero impression. 

Let me know how it goes after trying the provided suggestion.

Regards,

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2LmIVP:ref