Re: Equal rows for report with AdGroupStatus

[Google Ads API Forum Advisor Prod]

Hi Pavel,

The behavior of the API and UI should match. Since you are adding 
AdGroupStatus, it is segmenting your data by ad group. If you would like more 
details to the behavior of this report, I'd recommend reaching out to the 
product team as they would be better suited to assist you.

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/rVtrm0Q9LS5H00ITPp5ksaQfCp-nEGnH03xA%40sfdc.net.

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.

RE: Equal rows for report with AdGroupStatus

[Google Ads API Forum Advisor Prod]

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/KYm7f0Q9KCTF00aWVYpwK-Sb23gQoyBJAZEQ%40sfdc.net.

Equal rows for report with AdGroupStatus

[Pavel Grivachev]

Hi, 

When I use request without AdGroupStatus field I have one row result.

Request:
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 FROM FINAL_URL_REPORT WHERE CampaignId={
CampaignId} AND Device=DESKTOP DURING+20191230,20191230&__fmt=CSV" \
https://adwords.google.com/api/adwords/reportdownload/v201809


I get the following result (some values are hidden). 
Response:
"FINAL_URL_REPORT (Dec 30, 2019)"
Impressions,Network,Conversions,Final URL,Campaign ID,Device,Campaign,Clicks
,Views,Cost,Day,Interaction Types
250,Search Network,0.00,{EffectiveFinalUrl},{CampaignId},Computers,{
CampaignName},0,0,0,2019-12-30, --
Total, --,0.00, --, --, --, --,0,0,0, --, --


When I use request with AdGroupStatus field I have two row result:

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 Device=DESKTOP 
DURING+20191230,20191230&__fmt=CSV" \
https://adwords.google.com/api/adwords/reportdownload/v201809

Response:
"FINAL_URL_REPORT (Dec 30, 2019)"
Impressions,Network,Conversions,Final URL,Campaign ID,Device,Campaign,Clicks
,Views,Cost,Day,Interaction Types,Ad group state
125,Search Network,0.00,{EffectiveFinalUrl},{CampaignId},Computers,{
CampaignName},0,0,0,2019-12-30, --,enabled
125,Search Network,0.00,{EffectiveFinalUrl},{CampaignId},Computers,{
CampaignName},0,0,0,2019-12-30, --,enabled
Total, --,0.00, --, --, --, --,0,0,0, --, --, --

These two rows are equal (all fields have the same values). Why in the 
second case I have two equal rows with AdGroupStatus == enabled? In my 
understanding it should be two rows only if they have different values. Am 
I wrong?

If it is expected behavior, can I somehow add id for each row to to 
distinguish rows from each other? May be add some field that guaranteed 
unique for each row?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/c4f57236-b7a6-4a5d-bbed-dac278e32d83%40googlegroups.com.