Re: Equal rows for report with AdGroupStatus

[Pavel G]

Hi Anthony,

Thank you for response.
I have no discrepancy between UI and API. I just want to understand how API 
works. In my post I gave 2 examples of requests made one after another to 
the same report. The first request returns one row with 250 impressions, 
and the second request returns two rows of 125 impressions. The only 
difference in these requests is that the second has *AdGroupStatus* field. 
Why second response contains 2 rows with the same *AdGroupStatus *values 
but not one row as we have in first response?

In my code I assume that response from Adwords API can contain only one row 
with a unique set of values if the date field is included in the report. 
But looks like it is wrong assumption.

On Wednesday, April 29, 2020 at 10:01:16 PM UTC+3, adsapiforumadvisor wrote:
>
> Hi Pavel,
>
> The Final URL Report maps to this section 
> 
>  
> of the UI. The data there should match your API report. As you can see, if 
> you add/remove Ad Group, you will get a different number of results.
>
> Regards,
> Anthony
> Google Ads API Team
>
> ref:_00D1U1174p._5001UaSkkX:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/f54fb8c6-533c-434f-803e-4e21085ae2d2%40googlegroups.com.

Fetch report with all values of AdGroupStatus and CampaignStatus

[Pavel G]

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


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.