Hi Hannes,
Thank you for coming back to us and providing additional information. I hope you are doing well today. With regards to your concern, upon checking in the Google Ads UI, the campaign asset doesn't have any metrics or it has zero metrics. Please also note that zero metrics are automatically excluded on the report as per this document (https://developers.google.com/google-ads/api/docs/reporting/zero-metrics). One of the suggestions is to include rows with zero metrics and to include another field that is not zero value. You may check this guide (https://developers.google.com/google-ads/api/docs/reporting/zero-metrics#rows_returned) for your reference. In addition to this matter, removing metrics from the sample query, we got results that are matched in Google Ads UI. See below for reference. SELECT campaign.id, campaign_asset.resource_name, campaign_asset.asset, campaign_asset.field_type, campaign_asset.source, campaign_asset.status, campaign_asset.campaign, campaign_asset.primary_status, campaign_asset.primary_status_details, campaign_asset.primary_status_reasons FROM campaign_asset WHERE campaign.id = 0000000000 AND segments.date = '2023-07-25' I hope it clarifies. You may check this also on your end and let us know how it goes. Have a great day. Regards, Google Ads API Team On Thursday, July 27, 2023 at 2:28:26 PM UTC+8 hannes....@piamedia.com wrote: > Hi, > > Thanks for your quick response. I did not checked UI yet, but I compared > results of mentioned resources (campaign_assets vs. campaign vs. ...). > Please find attached the GAQL statements which I'm using for comparison > including a campaign_id which is marked as PERFORMACNE_MAX: > > *campaign_assets:* > Request: > SELECT > campaign.id > ,campaign_asset.asset > ,campaign_asset.field_type > ,segments.date > ,segments.device > ,segments.ad_network_type > ,metrics.impressions > ,metrics.clicks > ,metrics.cost_micros > ,metrics.conversions > ,metrics.conversions_value > ,metrics.all_conversions > ,metrics.all_conversions_value > ,metrics.conversions_from_interactions_rate > > FROM campaign_asset > WHERE segments.date BETWEEN \'2023-07-25\' AND \'2023-07-25\' > AND campaign.id = 18083992061 <(808)%20399-2061> > > Response (0 results in total): > [] > > *asset_group_product_group_view:* > Request: > SELECT > campaign.id > ,asset_group.id > ,asset_group.ad_strength > ,asset_group.status > ,asset_group_listing_group_filter.type > ,segments.date > ,segments.device > ,segments.ad_network_type > ,metrics.impressions > ,metrics.clicks > ,metrics.cost_micros > ,metrics.conversions > ,metrics.conversions_value > ,metrics.all_conversions > ,metrics.all_conversions_value > ,metrics.conversions_from_interactions_rate > > FROM asset_group_product_group_view > WHERE segments.date BETWEEN \'2023-07-25\' AND \'2023-07-25\' > AND campaign.id = 18083992061 <(808)%20399-2061> > > Response (72 results in total): > [{'results': [{'campaign': {'resourceName': > 'customers/4879915890/campaigns/18083992061 <(808)%20399-2061>', > 'id': '18083992061 <(808)%20399-2061>'}, 'metrics': {'clicks': '54', > 'conversionsFromInteractionsRate': 0.022726625, 'conversionsValue': > 211.31132432, 'conversions': 1.272691, 'costMicros': '74382968', > 'allConversionsValue': 839.88001203, 'allConversions': 4.849734, > 'impressions': '13803'}, 'segments': {'device': 'DESKTOP', 'adNetworkType': > 'MIXED', 'date': '2023-07-25'}, 'assetGroup': {'resourceName': > 'customers/4879915890/assetGroups/6449777583', 'status': 'ENABLED', 'id': > '6449777583', 'adStrength': 'EXCELLENT'}, 'assetGroupListingGroupFilter': > {'resourceName': > 'customers/4879915890/assetGroupListingGroupFilters/6449777583~6559666915', > 'type': 'SUBDIVISION'}, 'assetGroupProductGroupView': {'resourceName': > 'customers/4879915890/assetGroupProductGroupViews/6449777583~6559666915'}},...] > > *campaign:* > Request: > SELECT > campaign.id > ,segments.asset_interaction_target.asset > ,segments.asset_interaction_target.interaction_on_this_asset > ,segments.date > ,segments.device > ,segments.ad_network_type > ,metrics.impressions > ,metrics.clicks > ,metrics.cost_micros > ,metrics.conversions > ,metrics.conversions_value > ,metrics.all_conversions > ,metrics.all_conversions_value > ,metrics.conversions_from_interactions_rate > > FROM campaign > WHERE segments.date BETWEEN \'2023-07-25\' AND \'2023-07-25\' > AND campaign.id = 18083992061 <(808)%20399-2061> > > Response (698 results in total): > [{'results': [{'campaign': {'resourceName': > 'customers/4879915890/campaigns/18083992061 <(808)%20399-2061>', > 'id': '18083992061 <(808)%20399-2061>'}, 'metrics': {'clicks': '6', > 'conversionsFromInteractionsRate': 0, 'conversionsValue': 0, 'conversions': > 0, 'costMicros': '14840000', 'allConversionsValue': 0, 'allConversions': 0, > 'impressions': '215'}, 'segments': {'device': 'DESKTOP', 'adNetworkType': > 'MIXED', 'date': '2023-07-25', 'assetInteractionTarget': {'asset': > 'customers/4879915890/assets/32610980'}}},...] > > As you can see, campaign and asset_group_product_group_view resources are > reporting results for mentioned campaign and specific date. Only response > from campaign_asset resource is empty. I also checked PERFORMANCE_MAX > campaigns of different customers and it seems, that almost all responses > are empty for those campaigns. > > Do you know, if there are any limitations for that resource? > > Best regards, > Hannes > On Wednesday, July 26, 2023 at 4:54:52 PM UTC+2 Google Ads API Forum > Advisor wrote: > >> Hi, >> >> Thanks for reaching out to the Google Ads API Team. I hope you are doing >> well today. >> >> With regards to your concern about the *“PERFORMANCE_MAX campaigns are >> missing within campaign_asset resource”*, could you please provide >> complete or uncropped screenshots from the Google Ads UI that shows the >> data that you are trying to retrieve and GAQL used to pull the data in API? >> This will help us to further compare, investigate, and validate why you are >> encountering issues, and to provide accurate information or recommendations >> on this matter. >> >> For additional information please see the *Assets in a Performance Max >> Campaign *( >> https://developers.google.com/google-ads/api/docs/performance-max/assets >> ). >> >> Your response is highly appreciated. Have a great day. >> >> This message is in relation to case "ref:_00D1U1174p._5004Q2nSmld:ref" >> >> Thanks, >> >> [image: Google Logo] Google Ads API Team >> >> >> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords 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/342baa58-4890-4dcc-8538-20220bb20e41n%40googlegroups.com.
