Get Product Click Stats for Performance Max Campaigns?

[Brett Hadley]

Hi

We currently rely on the BigQuery transfer service to automations/insights from our MCA product click stats. However this doesn't include stats for performance max campaigns.

https://cloud.google.com/bigquery/docs/adwords-transfer

p_ShoppingProductStats_{customer_id}

Where can I access PMAX product level aggregations?

Thanks.

[Google Ads API Forum Advisor]

Hi Brett,

Thank you for reaching out to our API support team. 

You can use the Google Ads API's (see setup) reporting feature directly instead, to retrieve statistics of your Performance Max campaigns, and you may refer to this reporting guide for more details.

I hope this helps.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2dKlCV:ref

[Brett Hadley]

Hi

Thanks for the reply but we're looking for a BigQuery transfer service as there is a very large amount of data we have to deal with.

Over 15000 active ads account

Over 2B active products in the MCA's

When will this be added to the data transfer service?

Thanks

[Google Ads API Forum Advisor]

Hi Brett,

Thank you for the reply.

Please note that this channel can only provide assistance to issues/concerns related to the AdWords API /Google Ads API and since you mentioned performance max campaign, that’s why my colleague Peter offered you documentations that will help you to retrieve statistics of your Performance Max campaigns.

Moving forward, "BigQuery data transfer service" is already outside of our scope. With this, I suggest you reach out to the BigQuery team through the support channels available here , as they are more knowledgeable in order to provide further comment on your concern.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2dKlCV:ref

[Brett Hadley]

Hi Heidi

Thanks I will raise the request there too.

In the meantime can you point me to the resource which will provide the MCA product ID & performance metrics such as clicks, conversations, impressions for performance max campaigns?

Thanks

Brett Hadley​ Head of Engineering T: +44 (0)330 127 3969 E: brett....@redbrain.com W: www.redbrain.com Redbrain Ltd is a company registered in England and Wales with registered number 10434678. Registered office: Office 3, St Ann's House, Guildford Road, Lightwater, Surrey, GU18 5RA, United Kingdom. Redbrain Ltd accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing [other than by email]. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[Google Ads API Forum Advisor]

Hi Brett,

Thank you for your reply.

Performance max campaigns statistics is currently limited as discussed in the key point section of the guide. For granularity, you may for now be able to retrieve details of your performance max listing groups via the asset_group_listing_group_filter report. However, statistics or metrics fields support at this level is currently not available.

If a Google Ads UI view currently has reports that support performance max related metrics fields at a lower level, including product details, you may provide those to our team so we can include those when we create a feature request, subject for review, for its support in the Google Ads API.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2dKlCV:ref

[Google Ads API Forum Advisor]

Hi Brett,

Upon checking further, you should be able to use the asset_group_product_group_view for statistics of your Performance Max campaigns listing groups. Let me know if this helps.

[Brett Hadley]

Hi

That doesn't appear to give the MCA ItemId

In the Google UI I'm looking to replicate this report which does include performance max clicks. You can see here "Item ID" this is Product level aggregation within the MCA.

w

[Brett Hadley]

The following search query doesn't include performance max campaigns. How can I replicate the above UI query in GAQL?


SELECT

segments.product_item_id,

metrics.clicks,

metrics.impressions,

metrics.all_conversions,

campaign.end_date,

campaign.id

FROM shopping_performance_view

WHERE

campaign.end_date BETWEEN '2022-07-01' AND '2022-07-31'

ORDER BY

metrics.clicks DESC

Thanks

[Google Ads API Forum Advisor]

Hi Brett,

Thank you for the reply. We would like to test the report on our end, could you please provide your complete API request and response logs with request-id and login-customer-id that are generated on your end?

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You can provide it via the Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2dKlCV:ref

[Mat]

Hi Brett,

replace "campaign.end_date" with "segments.date" and you should be good.

Regards

Mat