Re: Get data table of a shopping campaign

[Google Ads API Forum Advisor Prod]

Hi Gloria,

Thank you for your follow ups and the information you have provided.

However, before proceeding further, could you also provide your customer ID and 
if possible, the complete screenshots(s) and details of the Google Ads UI views 
you are referring to in English?

You may send the requested details using the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino
Google Ads API Team
ref:_00D1U1174p._5004Q27umBR: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/2Wsf50QKOXSC00JAlmSwq-Q9SpZttZ8ZHV7Q%40sfdc.net.

Re: Get data table of a shopping campaign

[Exos Solutions]

Hi Peter,
I have been doing tests with the proposed fields and with some more.

This is the query I have used:

*SELEC ad_group.id, ad_group.name, ad_group.status, ad_group.type,*
*metrics.average_cpc, metrics.conversions,*
*metrics.clicks, metrics.impressions, metrics.ctr,*
*metrics.cost_per_all_conversions, metrics.cost_per_conversion,*
*metrics.all_conversions_from_interactions_rate, metrics.cost_micros,*
*ad_group.effective_target_cpa_micros*
*FROM ad_group WHERE campaign.id = *

These are the data obtained:

*results {*
*  ad_group {*
*resource_name: "customers/xxx/adGroups/xxx"*
*status: ENABLED*
*type: SEARCH_STANDARD*
*id: *
*name: "Marca 365rider"*
*effective_target_cpa_micros: 59*
*  }*
*  metrics {*
*clicks: 166994*
*conversions: 9889.532028*
*cost_micros: 228473*
*cost_per_all_conversions: 100981.89366606968*
*cost_per_conversion: 231025.08728737594*
*ctr: 0.6617738554269388*
*all_conversions_from_interactions_rate: 0.13548477869264766*
*average_cpc: 13681.509515311927*
*impressions: 252343*
*  }*
*}*

And these are the data that appear in Google Ads:

[image: data.PNG]

As you can see, they are nothing alike.
What am I doing wrong? I need to get the image data, how can I do it? If 
these data do not exist in the tables and they are calculated, what are the 
formulas?  

Thanks and regards,
Gloria Muñoz.
El lunes, 30 de noviembre de 2020 a las 14:25:50 UTC+1, Exos Solutions 
escribió:

> Hi Peter,
>
> Thanks for your information.
> The translations *Tasa de conversión (Covnersion rate)* and *CPC Máx. de 
> referencia (Reference CPC Max)* are correct.
> I will try with the extraction of fields that you mention and those that 
> are missing I will try to extract them mathematically.
>
> The two other red boxes in the lower left, that are grayed out, are the 
> names of the products that come from the Merchant Center.  I have not found 
> the name field in product_group_view or shopping_performance_view.  Where 
> can I get it from?
>
> Best regards,
> Gloria Muñoz.
>
> El viernes, 27 de noviembre de 2020 a las 11:34:49 UTC+1, 
> adsapiforumadvisor escribió:
>
>> Hi Gloria,
>>
>> Thank you for your follow up.
>>
>> Based in the screenshots you attached, it appears that the first one 
>> (Grupos de anuncios) is showing the Ad Group view in the UI. That said, you 
>> may refer below for the possible fields to use from the ad_group 
>>  view 
>> of the API :
>>
>> *Tipo (Type) *- ad_group.type 
>> 
>> *Presupuesto (Budget)* - Since budgets are assigned at the campaign 
>> level, you can try to retrieve this through the campaign resource's 
>> campaign.campaign_budget 
>> 
>>  
>> field.
>> *Nivel de optimizacion (Optimization level)* - This does not appear to 
>> be supported in the API's fields.
>> *Cpc Max predeterminado (Default Max CPC)* - You may try and retrieve 
>> this using the ad_group.cpc_bid_micros 
>> 
>>  
>> field.
>> *Coste (Cost)* - metrics.cost_micros 
>> 
>> *Tasa de conversion (Conversion rate)*  - Could you confirm if the 
>> translation is correct? I asked because what is available in the AdWords 
>> API is the AllConversionRate 
>> 
>>  
>> field and the equivalent of this field in the Google Ads API is the 
>> metrics.all_conversions_from_interactions_rate 
>> 
>>  
>> field.
>>
>> As for the second screenshot, the Grupos de productos or the Product 
>> groups view :
>>
>> *Tipo (Type) *- This is not supported in the product_group_view 
>> . 
>> This maybe referring to the ad_group.type 
>> 
>>  
>> field
>> *CPC Max* - you can try and retrieve this from the ad_group resource 
>> ad_group.cpc_bid_micros 
>> 
>>  
>> field
>> *CPC Max de referencia (Reference CPC Max)* - Can you also confirm if 
>> the translation is correct? It appears that this field is not supported.
>>
>> I also noticed two other red boxes, however, they are grayed out. Could 
>> you confirm if you are also seeking assistance with those as well?
>>
>> Moving forward, you may refer to our metrics 
>> , 
>> segments 
>> 

Re: Get data table of a shopping campaign

[Exos Solutions]

Hi Peter,

Thanks for your information.
The translations *Tasa de conversión (Covnersion rate)* and *CPC Máx. de 
referencia (Reference CPC Max)* are correct.
I will try with the extraction of fields that you mention and those that 
are missing I will try to extract them mathematically.

The two other red boxes in the lower left, that are grayed out, are the 
names of the products that come from the Merchant Center.  I have not found 
the name field in product_group_view or shopping_performance_view.  Where 
can I get it from?

Best regards,
Gloria Muñoz.

El viernes, 27 de noviembre de 2020 a las 11:34:49 UTC+1, 
adsapiforumadvisor escribió:

> Hi Gloria,
>
> Thank you for your follow up.
>
> Based in the screenshots you attached, it appears that the first one 
> (Grupos de anuncios) is showing the Ad Group view in the UI. That said, you 
> may refer below for the possible fields to use from the ad_group 
>  view of 
> the API :
>
> *Tipo (Type) *- ad_group.type 
> 
> *Presupuesto (Budget)* - Since budgets are assigned at the campaign 
> level, you can try to retrieve this through the campaign resource's 
> campaign.campaign_budget 
> 
>  
> field.
> *Nivel de optimizacion (Optimization level)* - This does not appear to be 
> supported in the API's fields.
> *Cpc Max predeterminado (Default Max CPC)* - You may try and retrieve 
> this using the ad_group.cpc_bid_micros 
> 
>  
> field.
> *Coste (Cost)* - metrics.cost_micros 
> 
> *Tasa de conversion (Conversion rate)*  - Could you confirm if the 
> translation is correct? I asked because what is available in the AdWords 
> API is the AllConversionRate 
> 
>  
> field and the equivalent of this field in the Google Ads API is the 
> metrics.all_conversions_from_interactions_rate 
> 
>  
> field.
>
> As for the second screenshot, the Grupos de productos or the Product 
> groups view :
>
> *Tipo (Type) *- This is not supported in the product_group_view 
> . 
> This maybe referring to the ad_group.type 
> 
>  
> field
> *CPC Max* - you can try and retrieve this from the ad_group resource 
> ad_group.cpc_bid_micros 
> 
>  
> field
> *CPC Max de referencia (Reference CPC Max)* - Can you also confirm if the 
> translation is correct? It appears that this field is not supported.
>
> I also noticed two other red boxes, however, they are grayed out. Could 
> you confirm if you are also seeking assistance with those as well?
>
> Moving forward, you may refer to our metrics 
> , segments 
> , 
> resources with metrics and resources without metrics guides (via this link 
> ) to 
> know which fields are available in the Google Ads API's reports.
>
> Best regards,
>
> [image: Google Logo] 
> Peter Laurence Napa Oliquino 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q27umBR: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/b7f482fe-9b0d-4414-a989-77e69a53e50dn%40googlegroups.com.

Re: Get data table of a shopping campaign

[Google Ads API Forum Advisor Prod]

Hi Gloria,

Thank you for your follow up.

Based in the screenshots you attached, it appears that the first one (Grupos de 
anuncios) is showing the Ad Group view in the UI. That said, you may refer 
below for the possible fields to use from the ad_group view of the API :

Tipo (Type) - ad_group.type
Presupuesto (Budget) - Since budgets are assigned at the campaign level, you 
can try to retrieve this through the campaign resource's 
campaign.campaign_budget field.
Nivel de optimizacion (Optimization level) - This does not appear to be 
supported in the API's fields.
Cpc Max predeterminado (Default Max CPC) - You may try and retrieve this using 
the ad_group.cpc_bid_micros field.
Coste (Cost) - metrics.cost_micros
Tasa de conversion (Conversion rate) - Could you confirm if the translation is 
correct? I asked because what is available in the AdWords API is the 
AllConversionRate field and the equivalent of this field in the Google Ads API 
is the metrics.all_conversions_from_interactions_rate field.

As for the second screenshot, the Grupos de productos or the Product groups 
view :

Tipo (Type) - This is not supported in the product_group_view. This maybe 
referring to the ad_group.type field
CPC Max - you can try and retrieve this from the ad_group resource 
ad_group.cpc_bid_micros field
CPC Max de referencia (Reference CPC Max) - Can you also confirm if the 
translation is correct? It appears that this field is not supported.

I also noticed two other red boxes, however, they are grayed out. Could you 
confirm if you are also seeking assistance with those as well?

Moving forward, you may refer to our metrics, segments, resources with metrics 
and resources without metrics guides (via this link) to know which fields are 
available in the Google Ads API's reports.

Best regards,

Peter Laurence Napa Oliquino
Google Ads API Team
ref:_00D1U1174p._5004Q27umBR: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/FycLr0QKGAPF00uDFUS_-CQv20EpVLibRd6w%40sfdc.net.

Re: Get data table of a shopping campaign

[Exos Solutions]

That is just what I needed!!!

Thank you very much.

Gloria M.

El viernes, 20 de noviembre de 2020 a las 3:04:33 UTC+1, adsapiforumadvisor 
escribió:

> Hi Gloria,
>
> Thanks for letting me know that you are using AdWords API.
>
> You can use the Product Partition Report 
> 
>  as 
> it is mapped to the UI that you provided as discussed on this guide 
> .
>
> Let me know if you have further questions.
>
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q27umBR: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/8c87d9d7-8a72-4d49-9d38-ea55f990954dn%40googlegroups.com.

Re: Get data table of a shopping campaign

[Google Ads API Forum Advisor Prod]

Hi Gloria,

Thanks for letting me know that you are using AdWords API.

You can use the Product Partition Report as it is mapped to the UI that you 
provided as discussed on this guide.

Let me know if you have further questions.

Regards,

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

Re: Get data table of a shopping campaign

[Exos Solutions]

Hi,

Thanks, but I think that won't work for me. I'm using Adwords API.
Any idea for Adwords API?

Regards,
Gloria.

El jueves, 19 de noviembre de 2020 a las 9:39:22 UTC+1, adsapiforumadvisor 
escribió:

> Hi,
>
> Thanks for posting your concern.
>
> It appears that you want to get the product groups in your account. That 
> said, you may use the product_group_view 
> 
>  
> to get the data / statistics of the product groups in your account.
>
> Additionally, to get the statistics aggregated at several product 
> dimension levels, you can use shopping_performance_view 
> 
>  instead.
>
> Let me know if this will help.
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q27umBR: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/f14695fe-cb28-4e6b-a355-27fa3a2cad8an%40googlegroups.com.