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 = xxxx*
These are the data obtained:
*results {*
* ad_group {*
* resource_name: "customers/xxx/adGroups/xxx"*
* status: ENABLED*
* type: SEARCH_STANDARD*
* id: xxxx*
* name: "Marca 365rider"*
* effective_target_cpa_micros: 590000*
* }*
* metrics {*
* clicks: 166994*
* conversions: 9889.532028*
* cost_micros: 2284730000*
* 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
>> <https://developers.google.com/google-ads/api/fields/v6/ad_group> view
>> of the API :
>>
>> *Tipo (Type) *- ad_group.type
>> <https://developers.google.com/google-ads/api/fields/v6/ad_group#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
>> <https://developers.google.com/google-ads/api/fields/v6/campaign#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
>> <https://developers.google.com/google-ads/api/fields/v2/ad_group#ad_group.cpc_bid_micros>
>>
>> field.
>> *Coste (Cost)* - metrics.cost_micros
>> <https://developers.google.com/google-ads/api/fields/v2/ad_group#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
>> <https://developers.google.com/adwords/api/docs/appendix/reports/all-reports#allconversionrate>
>>
>> field and the equivalent of this field in the Google Ads API is the
>> metrics.all_conversions_from_interactions_rate
>> <https://developers.google.com/google-ads/api/fields/v6/ad_group#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
>> <https://developers.google.com/google-ads/api/fields/v6/product_group_view>.
>> This maybe referring to the ad_group.type
>> <https://developers.google.com/google-ads/api/fields/v6/ad_group#ad_group.type>
>>
>> field
>> *CPC Max* - you can try and retrieve this from the ad_group resource
>> ad_group.cpc_bid_micros
>> <https://developers.google.com/google-ads/api/fields/v2/ad_group#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
>> <https://developers.google.com/google-ads/api/fields/v6/metrics>,
>> segments
>> <https://developers.google.com/google-ads/api/fields/v6/segments>,
>> resources with metrics and resources without metrics guides (via this
>> link <https://developers.google.com/google-ads/api/fields/v6/overview>)
>> 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/161e3940-b478-4609-b492-307fcb689e9en%40googlegroups.com.
