AdWords Report Generation API Not Responding to Date Range

[Austin Smith]

Hi,

The date range I'm using in my DURING AWQL query doesn't seem to be having any effect.  For example, the following query which requests campaign object data (no stats):

SELECT

AccountCurrencyCode,

AccountDescriptiveName,

AccountTimeZone,

AdvertisingChannelSubType,

AdvertisingChannelType,

Amount,

BaseCampaignId,

BiddingStrategyId,

BiddingStrategyName,

BiddingStrategyType,

BidType,

BudgetId,

CampaignDesktopBidModifier,

CampaignGroupId,

CampaignId,

CampaignMobileBidModifier,

CampaignName,

CampaignStatus,

CampaignTabletBidModifier,

CampaignTrialType,

CustomerDescriptiveName,

EndDate,

EnhancedCpcEnabled,

EnhancedCpvEnabled,

ExternalCustomerId,

IsBudgetExplicitlyShared,

LabelIds,

Labels,

Period,

ServingStatus,

StartDate,

TrackingUrlTemplate,

UrlCustomParameters

FROM CAMPAIGN_PERFORMANCE_REPORT

DURING TODAY

Returns ALL campaigns under a specific account, instead of only campaigns that are running today.  I have noticed this behavior for other objects as well.

What am I doing wrong?  How can I filter reports to include campaigns/objects that are only currently running?

[Vincent Racaza (AdWords API Team)]

Hi Austin,

When you use the DURING clause in your query for the Campaign Performance Report, it will get the report statistics for all campaigns for the period you specify (e.g. DURING TODAY). This clause does not mean that it will get the report statistics for the campaigns which are running on the period you specify. This is also the same as UI. If you'll filter your campaigns by "Today", it will still return all campaigns but will show you the statistics which are for today.

If you want to get the campaigns which only runs for today, then you can filter your report by CampaignStatus = ENABLED and StartDate = '2017-10-27' (e.g. the date today).

Let me know if you have further clarifications.

Thanks,

Vincent

AdWords API Team