Missing info in shopping_performance_view for PERFORMANCE_MAX campaigns

[Iván López]

Hello,

We have a process which uses the shopping_performance_view to have the stats (clicks, conversions, etc.) info. Until now, we were only using it with shopping campaigns. But now we are trying to integrate it with PERFORMANCE_MAX campaigns.

But, when I ask for a query to this report with the campaign.id condition with one PERFORMANCE_MAX campaign, the result is empty, and the campaign does have products on it, I can see it on Google Ads.

Here is the query I am doing:

                SELECT
                  campaign.id,
                  campaign.status,
                  ad_group.status,
                  ad_group.id,
                  campaign.name,
                  ad_group.name,
                  metrics.clicks,
                  metrics.conversions,
                  metrics.cost_micros,
                  segments.product_custom_attribute4
                FROM
                  shopping_performance_view
                WHERE campaign.id = 17593385238
                AND campaign.status = 'ENABLED'
                AND segments.date BETWEEN 20220420 AND 20220719

I know there is confidential information in the query, but I think you need it to test it. The advertising account is: 749-031-9553.

Moreover, when we are doing this with shopping campaigns, we filter in the query by the ad group ID. But the shopping_performance_view is not related with asset_group. 

How can I get the asset_group where the product results from this query belongs? How can I get the relationship between this report and the asset_group?

Why am I getting an empty results for this query? Is it impossible to get the products report in a PERFORMANCE_MAX campaign? or should I use another report?

Thank you,

Iván

[Iván López]

Update:

The query is already giving me the results I was looking for. I have noticed that the problem was that I have fields in the Select clause with ad_group entity and this is not the case for PERFORMANCE_MAX campaigns. But, If you can help me with the other question, how can I get the asset group ID for this result?

Thank you

Ivan

[Google Ads API Forum Advisor]

Hi Ivan,

Thank you for raising your concern. Allow me to provide support.

As for your first concern and specifically for these questions "Why am I getting an empty results for this query? Is it impossible to get the products report in a PERFORMANCE_MAX campaign? or should I use another report?", I am happy that you found the workaround and I can confirm that it is correct. The reason is provided in this document that do not select an AdGroup when querying Performance Max campaigns, as no campaigns will be returned.

Moving to the second concern and specifically for these questions "How can I get the asset_group where the product results from this query belongs? How can I get the relationship between this report and the asset_group?", so that we can check the available resources in the Google Ads API that can be used to get this information, could you provide the screenshot of the UI showing it?

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

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2blXnq:ref