Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Luis,

Unfortunately, it won't be possible to replicate the behavior you are looking 
for through the API. You will need to use the query from Approach 2 to get 
details on both your campaign and ad groups.

Regards,
Anthony

Anthony Madrigal
Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/IfpgD0QS8JHS0042AoZYhUR_um1wOkKpzzgA%40sfdc.net.

Re: Getting report totals in new Google Ads API

[Luis Pandolfi]

Hi Ernie,

Let me explain with the following scenario.

Lets say there are two campaigns with the following ad groups:

- Campaign 1
 - Ad group 1: nice ads
 - Ad group 2: really nice ads
 - Ad group 3: ugly ads
- Campaign 2
 - Ad group 4: some nice ads
 - Ad group 5: others ads

I want to get the average cost aggregated at the campaign level but only 
for the ad groups with the text "nice" in its name.
Notice I can do it in Data Studio.

The expected result is:
campaign.name, metrics.average_cost
Campaign 1, 456
Campaign 2, 789


Approach 1:

SELECT campaign.name, metrics.average_cost
FROM campaign
WHERE ad_group.name CONTAINS 'nice' AND segments.date DURING LAST_30_DAYS

This query result in an error, because I cannot filter by ad_group when 
querying campaign in the FROM.


Approach 2:

SELECT campagn.name, metrics.average_cost
FROM ad_group
WHERE ad_group.name CONTAINS 'nice' AND segments.date DURING LAST_30_DAYS

This query works, but is aggregated at the ad_group level, resulting in 
duplicates campaigns.
An example of this query result:
campaign.name, metrics.average_cost
Campaign 1, 367 <-- from Ad group 1
Campaign 1, 523 <-- from Ad group 2
Campaign 2, 789


How can I resolve that query?

Best regards,
Luis Pandolfi
 

El martes, 27 de abril de 2021 a la(s) 00:03:23 UTC-3, adsapiforumadvisor 
escribió:

> Hi Luis,
>
> Could you clarify what fields in the ad group resource that you want to 
> filter and provide sample set of data that you want to get? I would suggest 
> checking the campaign builder 
> 
>  as 
> it may help you construct your query report including the filters for ad 
> group resource.
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5001UAqWq9: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/e2e8e6ae-b254-4cf6-b338-1fd70da99d21n%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Luis,

Could you clarify what fields in the ad group resource that you want to filter 
and provide sample set of data that you want to get? I would suggest checking 
the campaign builder as it may help you construct your query report including 
the filters for ad group resource.

Regards,

Ernie John Blanca Tacata
Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/XAm4B0QS7CFO00PV1lgJB_RfqHwIssj5dSGg%40sfdc.net.

Re: Getting report totals in new Google Ads API

[Luis Pandolfi]

Hi Xiaoming,

I want the metric aggregated at the campaign level but filtering in the 
ad_group level.
I noticed that:
- If I query in the campaing level I cannot filter in the ad_group level, 
because ad_group is lower in the hierarchy.
- If I query in the ad_group level I can filter ad groups, but the metric 
is aggregated in the ad_group level and I cannot get total values for each 
campaign.

I want total values for each campaign and filter by some fields in the 
ad_group.
Is this an API restriction or can I do it in some way?

Best regards,
Luis

El viernes, 23 de abril de 2021 a la(s) 17:08:59 UTC-3, adsapiforumadvisor 
escribió:

> Hi Luis,
>
> Thank you for reaching out. There is no other way to get the total 
> metrics.average_cost by campaign when you query the ad_group resource, but 
> if you need it on the ad_group level then you could directly query the 
> metrics.average_cost 
> 
> .
>
>
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>  
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5001UAqWq9: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/9bcd7e53-dba6-4c96-a969-a04748b32eb1n%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Luis,

Thank you for reaching out. There is no other way to get the total 
metrics.average_cost by campaign when you query the ad_group resource, but if 
you need it on the ad_group level then you could directly query the 
metrics.average_cost.

Thanks and regards,
Xiaoming, Google Ads API Team


Xiaoming
Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/W3qnt0QS19AM00c8nGhN1-Q5KujSvcbtG6wg%40sfdc.net.

Re: Getting report totals in new Google Ads API

[Luis Pandolfi]

Hi Xiaoming,

The issue in my case when querying the campaign level is that I cannot 
filter by fields of the ad_group resource.
I can achieve that using Data Studio, I guess Data Studio is not using 
neither GAQL nor AWQL then.
Is there any other way to do it?

Best regards,
Luis

El viernes, 23 de abril de 2021 a la(s) 16:18:07 UTC-3, adsapiforumadvisor 
escribió:

> Hi Luis,
>
> Thank you for reaching out. The GAQL and the AWQL don’t support the group 
> by functionality. As for your concern, it’s more appropriate to query the 
> campaign  
> resource rather than the ad_group resource. You could query the  
> metrics.average_cost 
> 
>  
> from the campaign 
>  
> resource to obtain the average amount you pay per interaction on the 
> campaign level. This amount is the total cost of your ads divided by the 
> total number of interactions.
>
>
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>  
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5001UAqWq9: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/bfc522a8-fc82-46ef-a47e-7cb5f2e142e1n%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Luis,

Thank you for reaching out. The GAQL and the AWQL don’t support the group by 
functionality. As for your concern, it’s more appropriate to query the campaign 
resource rather than the ad_group resource. You could query the 
metrics.average_cost from the campaign resource to obtain the average amount 
you pay per interaction on the campaign level. This amount is the total cost of 
your ads divided by the total number of interactions.

Thanks and regards,
Xiaoming, Google Ads API Team


Xiaoming
Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/PQH4l0QS16XQ00R_uz5glkSWuSgSEL5iBY3w%40sfdc.net.

Re: Getting report totals in new Google Ads API

[Luis Pandolfi]

Hi, just another question related to getting totals.

How can I get column totals? I mean, total like in a group by.

For example, I query at the adgroup level, and filter a subset of adgroup. 
I select campaign.name, and metrics.average_cost.
The result is aggregated at the adgroup level, one row per adgroup, so the 
result could have repeated campaigns. I want to get the total 
metrics.average_cost by campaign.

Is it possible with the API? I see Data Studio does it.

Best regards,
Luis
El viernes, 23 de abril de 2021 a la(s) 10:55:13 UTC-3, Luis Pandolfi 
escribió:

> Thank you! you saved my day.
>
> El viernes, 23 de abril de 2021 a la(s) 10:45:48 UTC-3, 
> nangsawxru...@gmail.com escribió:
>
>>
>> ในวันที่ ศ. 23 เม.ย. 2021 20:27 Google Ads API Forum Advisor Prod <
>> adsapifor...@gmail.com> เขียนว่า:
>>
>>> Hi Stefano,
>>>
>>> Thank you for sharing the information to help out other people.
>>>  
>>>
>>> - Luis,
>>>
>>> Let us know if you have any further questions.
>>>  
>>>
>>> Thanks and regards,
>>> Xiaoming, Google Ads API Team
>>>
>>>
>>> [image: Google Logo] 
>>> Xiaoming 
>>> Google Ads API Team 
>>>   
>>>
>>> ref:_00D1U1174p._5001UAqWq9: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 adwor...@googlegroups.com
>>> To unsubscribe from this group, send email to
>>> adwords-api...@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...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/adwords-api/9erlt0QS0QQD00oLcNVYL2Rp-IXpuZ61tugQ%40sfdc.net
>>>  
>>> 
>>> .
>>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/32edd0b2-ca6a-4f46-b82d-0d262655ff1fn%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[Luis Pandolfi]

Thank you! you saved my day.

El viernes, 23 de abril de 2021 a la(s) 10:45:48 UTC-3, 
nangsawxru...@gmail.com escribió:

>
> ในวันที่ ศ. 23 เม.ย. 2021 20:27 Google Ads API Forum Advisor Prod <
> adsapifor...@gmail.com> เขียนว่า:
>
>> Hi Stefano,
>>
>> Thank you for sharing the information to help out other people.
>>  
>>
>> - Luis,
>>
>> Let us know if you have any further questions.
>>  
>>
>> Thanks and regards,
>> Xiaoming, Google Ads API Team
>>
>>
>> [image: Google Logo] 
>> Xiaoming 
>> Google Ads API Team 
>>   
>>
>> ref:_00D1U1174p._5001UAqWq9: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 adwor...@googlegroups.com
>> To unsubscribe from this group, send email to
>> adwords-api...@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...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/adwords-api/9erlt0QS0QQD00oLcNVYL2Rp-IXpuZ61tugQ%40sfdc.net
>>  
>> 
>> .
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/16f62078-9685-4639-b065-a4fc896e30f5n%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[นางสาวอรุณรักษ์ บุญลือ]

ในวันที่ ศ. 23 เม.ย. 2021 20:27 Google Ads API Forum Advisor Prod <
adsapiforumadvi...@gmail.com> เขียนว่า:

> Hi Stefano,
>
> Thank you for sharing the information to help out other people.
>
>
> - Luis,
>
> Let us know if you have any further questions.
>
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>
> [image: Google Logo]
> Xiaoming
> Google Ads API Team
>
>
> ref:_00D1U1174p._5001UAqWq9: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/9erlt0QS0QQD00oLcNVYL2Rp-IXpuZ61tugQ%40sfdc.net
> 
> .
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/CALJ0C%3DmXhbKHs%2BZjxS%2BA%3DtxTkk9fTxUx6Z30NzhG%2BR9BdGk00A%40mail.gmail.com.

Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Stefano,

Thank you for sharing the information to help out other people.

- Luis,

Let us know if you have any further questions.

Thanks and regards,
Xiaoming, Google Ads API Team



Xiaoming
Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/9erlt0QS0QQD00oLcNVYL2Rp-IXpuZ61tugQ%40sfdc.net.

Re: Getting report totals in new Google Ads API

[stefano...@webrepublic.ch]

Hi Luis,

You can find an example 
here 
https://github.com/googleads/google-ads-python/issues/374#issuecomment-822559088

Cheers,
Stefano

On Friday, April 23, 2021 at 4:50:55 AM UTC+2 adsapiforumadvisor wrote:

> Hi Luis,
>
> Thank you for coming back to us.
>
> Getting the summary of the report is now supported in Google Ads API 
> reporting. You will just need to configure the summary_row_setting 
> 
>  
> of the GoogleAdsService.Search 
> 
>  
> or summary_row_setting 
> 
>  of GoogleAdsService.SearchStream 
> 
>  
> in order to do this.
>
> Let me know if you have further questions.
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5001UAqWq9: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/b44585fe-5fd6-4245-adc8-4385a252706bn%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Luis,

Thank you for coming back to us.

Getting the summary of the report is now supported in Google Ads API reporting. 
You will just need to configure the summary_row_setting of the 
GoogleAdsService.Search or summary_row_setting of GoogleAdsService.SearchStream 
in order to do this.

Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata
Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/ypsTb0QRZX8F00BO0kRXwYQqWnWGplV9kCSA%40sfdc.net.

Re: Getting report totals in new Google Ads API

[Luis Pandolfi]

Hi, sorry to resurect an old thread, but I still have the same questions.

I would like to know if currently there is some way to get the report 
summary using Google Ads API, otherwise if there is some concrete plan to 
include this and estimated time.

Best regards,
Luis Pandolfi
El jueves, 2 de enero de 2020 a la(s) 14:23:45 UTC-3, adsapiforumadvisor 
escribió:

> Hi Dorian,
>
> I am Nikisha from Google Ads API team. Please allow me to support your 
> concerns in the absence of my colleague Sai.
>
> A feature request for your concern has already been created internally 
> within our team, however, we do not have any timeline to share when this 
> feature will be available. Please keep an eye on our blog post 
>  for further updates and 
> announcements related to this.
>
> Regards,
> Nikisha Patel, Google Ads API Team
>
>
> ref:_00D1U1174p._5001UAqWq9: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/ae727037-f8d8-4ca5-8a1d-9037a15dac02n%40googlegroups.com.

Re: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Dorian,

I am Nikisha from Google Ads API team. Please allow me to support your concerns 
in the absence of my colleague Sai.

A feature request for your concern has already been created internally within 
our team, however, we do not have any timeline to share when this feature will 
be available. Please keep an eye on our blog post for further updates and 
announcements related to this.

Regards,
Nikisha Patel, Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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/_C-lo0Q3HPMV001k9bsX9_Sre4ewf_wY7I6A%40sfdc.net.

Re: Getting report totals in new Google Ads API

[Dorian Kind]

Hi there,

sorry to ressurect such an old thread, but I just wanted to inquire whether 
this feature has been added or is being considered for addition to the 
Google Ads API in the meanwhile.

Thanks & best regards,
Dorian

On Friday, 24 May 2019 22:54:12 UTC+2, adsapiforumadvisor wrote:
>
> Hello Dorian,
>
> I understand your concern. I will let my team know and update you when I 
> have more information.
>
> Regards,
> Sai Teja, Google Ads API Team
>
> ref:_00D1U1174p._5001UAqWq9: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/60d08c4f-aa41-45d3-9a59-c33873812f27%40googlegroups.com.

RE: Getting report totals in new Google Ads API

[Google Ads API Forum Advisor Prod]

Hello Dorian,

I understand your concern. I will let my team know and update you when I have 
more information.

Regards,
Sai Teja, Google Ads API Team
ref:_00D1U1174p._5001UAqWq9: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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/SLArp0PS10PU002W22EXo0S622ITFjQ_6RTA%40sfdc.net.
For more options, visit https://groups.google.com/d/optout.

Re: Getting report totals in new Google Ads API

[Dorian Kind]

Hi,

just wanted to follow up on this.

A reporting use case that we encounter quite frequently is to aggregate 
metrics for a specific set of campaigns of an account (e.g. "How are all my 
campaigns for product X doing?"). With the Adwords API, we can use the 
campaign report, set up appropriate filters and use the summary row of the 
report directly.

As Francis mentions, the complexity and feasibility of calculating 
totals on our end depends a lot on the chosen metrics. While it's simple to 
aggregate clicks, I wouldn't know how to calculate the total "Search lost 
absolute top impression share" for a subset of campaigns of an account—I'd 
assume it's weighted by impressions, but I don't think this is documented 
anywhere.

Thus, having a summary row available in the response of the 
GoogleAdsService.Search endpoint is essential for us.

Thanks and best regards,
Dorian

On Thursday, 13 December 2018 03:36:06 UTC+1, Luis Xander Talag (AdWords 
API Team) wrote:
>
> Hi Francis,
>
> I'm afraid the totals for metric values in reports in Google Ads API Beta 
> is not yet supported and is currently available only in AdWords API using 
> the skipReportSummary HTTP request 
> 
>  value. 
> I could not comment on if and when this feature will be supported in Google 
> Ads API Beta. However, you may follow our blog 
>  for any 
> updates on this.
>
> Thanks and regards,
> Luis
> AdWords API Team
>
> On Thursday, December 13, 2018 at 4:21:54 AM UTC+8, Francis Moore wrote:
>>
>> Hi all,
>>
>> I'm looking for a way to get the totals for the metrics of a report in 
>> the Google Ads Beta API. It is available in the current AdWords API with 
>> the CSV format, but not with the XML format.
>>
>> In the Google Ads API, it does not look to be available in the response, 
>> since all we get is an array of GoogleAdsRow
>>
>> https://developers.google.com/google-ads/api/reference/rpc/google.ads.googleads.v0.services#google.ads.googleads.v0.services.SearchGoogleAdsResponse
>>
>> I could of course just sum up the values, but many metrics just can't 
>> summed up like that, for example Search Impression Share. 
>>
>> Any idea? Thanks!
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/c06e4815-82eb-4178-a451-d591ed8a3b6b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Getting report totals in new Google Ads API

['Luis Xander Talag (AdWords API Team)' via AdWords API and Google Ads API Forum]

Hi Francis,

I'm afraid the totals for metric values in reports in Google Ads API Beta 
is not yet supported and is currently available only in AdWords API using 
the skipReportSummary HTTP request 

 value. 
I could not comment on if and when this feature will be supported in Google 
Ads API Beta. However, you may follow our blog 
 for any 
updates on this.

Thanks and regards,
Luis
AdWords API Team

On Thursday, December 13, 2018 at 4:21:54 AM UTC+8, Francis Moore wrote:
>
> Hi all,
>
> I'm looking for a way to get the totals for the metrics of a report in the 
> Google Ads Beta API. It is available in the current AdWords API with the 
> CSV format, but not with the XML format.
>
> In the Google Ads API, it does not look to be available in the response, 
> since all we get is an array of GoogleAdsRow
>
> https://developers.google.com/google-ads/api/reference/rpc/google.ads.googleads.v0.services#google.ads.googleads.v0.services.SearchGoogleAdsResponse
>
> I could of course just sum up the values, but many metrics just can't 
> summed up like that, for example Search Impression Share. 
>
> Any idea? Thanks!
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/d79e9df9-e241-4297-9054-055f530c82a0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Getting report totals in new Google Ads API

[Francis Moore]

Hi all,

I'm looking for a way to get the totals for the metrics of a report in the 
Google Ads Beta API. It is available in the current AdWords API with the 
CSV format, but not with the XML format.

In the Google Ads API, it does not look to be available in the response, 
since all we get is an array of GoogleAdsRow
https://developers.google.com/google-ads/api/reference/rpc/google.ads.googleads.v0.services#google.ads.googleads.v0.services.SearchGoogleAdsResponse

I could of course just sum up the values, but many metrics just can't 
summed up like that, for example Search Impression Share. 

Any idea? Thanks!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/d2dfdcdc-ff31-4c30-bc9b-9f4898fcd6db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.