Hi,
We need to fetch report that contains the fields we need, but with all
statuses of AdGroupStatus and CampaignStatus fields.
In this forum I found suggestions that I need to add the following code to
my request:
WHERE AdGroupStatus IN ['ENABLED','PAUSED','REMOVED'] AND CampaignStatus IN
['ENABLED','PAUSED','REMOVED']
But after some tests I got results with CampaignStatus == 'REMOVED'.without
this condition. The following *curls* return the same results with 5 rows
for me (their CampaignStatus is 'REMOVED'):
curl --http1.1 \
--header "Authorization : Bearer {token}" \
--header "developerToken : {developerToken}" \
--header "includeZeroImpressions: false" \
--header "clientCustomerId : {clientCustomerId}" \
--data "__rdquery=SELECT Impressions, AdNetworkType1, Conversions,
EffectiveFinalUrl, CampaignId, Device, CampaignName, Clicks, VideoViews,
Cost, Date, InteractionTypes, AdGroupStatus FROM FINAL_URL_REPORT WHERE
CampaignId={CampaignId} *AND *
*CampaignStatus IN ['ENABLED','PAUSED','REMOVED']*
DURING+20190708,20190708&__fmt=CSV" \
https://adwords.google.com/api/adwords/reportdownload/v201809
<http://adwords.google.com/api/adwords/reportdownload/v201809>
curl --http1.1 \
--header "Authorization : Bearer {token}" \
--header "developerToken : {developerToken}" \
--header "includeZeroImpressions: false" \
--header "clientCustomerId : {clientCustomerId}" \
--data "__rdquery=SELECT Impressions, AdNetworkType1, Conversions,
EffectiveFinalUrl, CampaignId, Device, CampaignName, Clicks, VideoViews,
Cost, Date, InteractionTypes, AdGroupStatus FROM FINAL_URL_REPORT WHERE
CampaignId={CampaignId} DURING+20190708,20190708&__fmt=CSV" \
https://adwords.google.com/api/adwords/reportdownload/v201809
The only difference is that the second *curl* have no CampaignStatus IN [
'ENABLED','PAUSED','REMOVED'] condition.
My question is it *mandatory* to have this WHERE condition if we want to
fetch report with all statuses of AdGroupStatus and CampaignStatus, or may
be it is *mandatory* for only some types of reports? Do you have any
information about this in you documentation?
Thanks in advance.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"AdWords API and Google Ads 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 on the web visit
https://groups.google.com/d/msgid/adwords-api/93438976-56d9-4c14-80fb-cbcfde93d28b%40googlegroups.com.
