Get data table of a shopping campaign

[Exos Solutions]

Hello everyone,

We are new to using the Google Ads API and need to get the data from the image table to save it to the customer database.

We use eclipse and java for programming. What object or report has all these columns? Thank you and regards.

Gloria M.

[Google Ads API Forum Advisor Prod]

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,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q27umBR:ref

[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.

[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.

[Exos Solutions]

That is just what I needed!!!

Thank you very much.

Gloria M.

[Exos Solutions]

Hi again,

In the end we decided to adopt the Google Ads API solution. We have been reviewing the data / statistics that can be obtained from product_group_view and shopping_performance_view, but there are still some fields that we did not identify. I have marked them in red in the attached images.

Please, what are those columns called in the tables? 

 

Thanks and regards,

Gloria M.

[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

[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.

[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 = 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:

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.

[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.