Private message regarding: pmax missing in campaign_asset resource
Hi Google Ads API Team, Thanks for your reply. Unfortunately, I'm not sure, if this is the answer of mentioned issue. From my point of view, this does not explain results, which I get via campaign resource. Within that API request I'm also requesting segment segments.asset_interaction_target.asset which includes the asset resource of specific interactions: Response (698 results in total): [{'results': [{'campaign': {'resourceName': 'customers/4879915890/campaigns/ 18083992061', 'id': '18083992061'}, 'metrics': {'clicks': '6', 'conversionsFromInteractionsRate': 0, 'conversionsValue': 0, 'conversions': 0, 'costMicros': '1484', '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, several clicks and impressions were generated on 2023-07-25 on segment'assetInteractionTarget': {'asset': 'customers/4879915890/assets/32610980'} Besides that, it would also not explain the fact, that I'm receiving results via asset_group_product_group_view. As far as I know, asset_groups could only be created, if they include at least one asset_id. So that means, if I'm receiving results on asset_group level, there have to be also assets. So based on results of campaign and asset_group_product_group_view resource I would also expect similar results via campaign_asset resource. Could you please let me know, if I'm wrong and if not, why campaign_asset resource is reporting zero results and the other both resources are not? Best regards, Hannes On Friday, July 28, 2023 at 8:36:59 PM UTC+2 Google Ads API and AdWords API Forum wrote: 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 = 00 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 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\'
Re: pmax missing in campaign_asset resource
Hi Google Ads API Team, Thanks for your reply. I'm not sure, if your answer is an explanation for mentioned issue, as I'm receiving results via campaign resource on segment "segments.asset_interaction_target.asset": Response (698 results in total): [{'results': [{'campaign': {'resourceName': 'customers/4879915890/campaigns/ 18083992061', 'id': '18083992061'}, 'metrics': {'clicks': '6', 'conversionsFromInteractionsRate': 0, 'conversionsValue': 0, 'conversions': 0, 'costMicros': '1484', '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 from the response, impressions and clicks were generated on segment 'assetInteractionTarget': {'asset': 'customers/4879915890/assets/32610980'}. So from my understanding, values for that assets exists for that date and that campaign. Besides that I'm also receiving results via asset_group_product_group_view resource. Of course this results are aggregated on asset_group level, but as far as I know, asset_groups could only be created if at least one asset is linked to that asset_group. This would mean, if I'm receiving results on asset_group level, there also have to be assets. So from my point of view and with reference to the results of the campaign and asset_group_product_group_view resource, I would also expect similar results by using campaign_asset resource. Could you please let me know, if I'm wrong and if not, why campaign_assets includes rows with zero metrics, but the other both resources are not? Best regards, Hannes On Friday, July 28, 2023 at 8:36:59 PM UTC+2 Google Ads API and AdWords API Forum wrote: 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 = 00 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 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
Re: pmax missing in campaign_asset resource
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 = 00 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 >
PMax missing in campaign_asset resource
Hello everyone, we noticed, that PERFORMANCE_MAX campaigns are missing within campaign_asset resource. Is there any reason why this kind of campaigns are missing? Best regards, Hannes -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f5cd40ee-0b34-4e09-8da3-ee6dfcbe5b05n%40googlegroups.com.