Invlaid During Clause for adwords reports

7 views

Skip to first unread message

Faisal Ijaz

unread,

Jun 27, 2019, 5:11:26 PM6/27/19

to AdWords API and Google Ads API Forum

Hi,
I am faceing issue while fetching report. I am following the syntax as per documentation https://developers.google.com/adwords/api/docs/guides/reporting.

Query is as follow:

SELECT AccountCurrencyCode,AccountDescriptiveName,AccountTimeZone,BaseCampaignId,CampaignId,CampaignName,CampaignStatus,Criteria,CustomerDescriptiveName,DisplayName,ExternalCustomerId,Id,IsNegative,KeywordMatchType,VerticalId FROM CAMPAIGN_NEGATIVE_PLACEMENTS_PERFORMANCE_REPORT WHERE IsNegative=FALSE DURING 20190627,20190627

Every time it gives me error for invalid during clause or date required.

Google Ads API Forum Advisor Prod

unread,

Jun 28, 2019, 2:49:48 AM6/28/19

to adwor...@googlegroups.com

Hi Faisal,

When using date ranges or the DURING clause, you would also need to include the Date field in your SELECT query as mentioned here. However, since the CAMPAIGN_NEGATIVE_PLACEMENTS_PERFORMANCE_REPORT does not support the Date field, you do not need to include the DURING clause as this would result in an error.

To know which report types support the Date field, you may refer to this guide.

Thanks and regards,
Peter
Google Ads API Team