Total active products in each Performance Campaign

[Benjamin Davis]

I'd love to be able to get a report that had a list of all my PMax campaigns and then the total active product count next to it. Is this possible with Google Ads Script?

For example,

Campaign Name x, 35 products

Campaign Name x, 1000 products

[Google Ads API Forum Advisor]

Hi Benjamin,

I hope you're doing well. Thank you for posting your concern.

Regarding your concern, you mentioned that you want to know if getting a report that had a list of all my PMax campaigns and then the total active product count next to it is possible with the Google Ads Scripts. However, please note that our team provides support to Google Ads API-related concerns only. Having said that, I would recommend reaching out to the Google Ads Scripts Forum as this appears to be related to Google Ads Scripts.

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2jXg2t:ref

[shahids...@gmail.com]

Hi, How can I get the count using Google Ads API?

[Google Ads API Forum Advisor]

Hello,

Thank you for chiming in on this thread.

Can you please provide more details with your concern so that we can guide you accordingly? Are you looking to retrieve the  total number of PMAX campaigns in your account using Google Ads API?

Regards,

[shahids...@gmail.com]

Hi, 

Thanks for replying. I am just looking to get the list of products that a certain PMAX campaign has.

[Benjamin Davis]

I'm looking for the same thing. I've been able to build reports that can show the number of products receiving impressions in each campaign but I just want active products

[Google Ads API Forum Advisor]

Hello All,

Thank you for reachout out.

I understand that you wish to obtain a list of products that belongs to a PMax campaign and you have made a report that obtains products receiving impressions in each campaign but you just want to get the active products

Can you please provide me with an uncropped screenshot of the Google Ads UI that shows the data you wish to obtain using the API? I am asking this so our team can provide accurate recommendations on this.

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com. 

Regards,

[shahids...@gmail.com]

I just want to get all products inside a PMax campaign. 

[Google Ads API Forum Advisor]

Hi,

Thank you for providing the requested information.

Can you also provide the complete request and response logs with request-id where you were able to build reports that can show the number of products receiving impressions in each campaign as well for our reference? These would greatly help us in our investigation.

Reference links:
request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
request-id - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id

Regards,

[shahids...@gmail.com]

Hey,

I didn't build a request as I don't know how to request products from a PMax campaign. I just want to know the resource which I should use to fetch the products from a PMax campaign as shown in the screenshot that I posted. That's all that I need.

[Zeyuan Gu]

Hi Benjamin,

I came across your question on the Google Ads API forum. I‘m still interested in the problem you raised in the forum. Is it possible if we can schedule some time to chat and talk about the challenges you have getting reports from Google Ads using GAQL? 

I'm a ex-Google software engineer and I worked on Google Ads for 3.5 years. I'm currently building this software called Adzviser which takes your natural language query and translates it to GAQL. You can ask questions in lines of "How much did I spend on search campaigns last month" and the results will be shown right there for you (video demo). However, the use case that you have related with performance max campaigns and product counts is not something I'm familiar with yet. I'd love to understand your problem better and see if I could solve it with natural language understanding. 

Thank you. This is my schedule.