PMax missing in campaign_asset resource
Hannes Fischer
Hannes Fischer
Google Ads API Forum Advisor
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.
Thanks,
 |
Google Ads API Team |
Hannes Fischer
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):
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
Response (72 results in total):
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
Response (698 results in total):
Google Ads API and AdWords API Forum
Regards,
Google Ads API Team
Google Ads API and AdWords API Forum
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
Hannes Fischer
Google Ads API Forum Advisor
Hi,
Thanks for getting back with us.
With regards to your concern, upon checking the assets under the campaign ID in your request, I can confirm that it has no metrics. Please note that Zero metrics are always excluded when segmenting a report, however this is not the case in Google Ads UI. Rows whose selected metrics are all zero won't be returned in the Google Ads API query. Kindly also note that campaign resource and campaign_asset resource are two different reports. Campaign_asset report is used to get extensions attached to campaign level.
“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?”
- Kindly note that these are different reports, selecting all rows with no metrics at all won't be returned in the API. For the campaign and the asset_group_product_group_view are returned since at least one of the metrics contains data.
However, if you are seeing the said information in a different UI in Google Ads, then kindly note that Google Ads API mirrors the Google Ads UI. Meaning by using the Google Ads API, you can get and manage the data that you are seeing in the UI. With that being said, can you provide us with the full (not cropped) and non-redacted screenshot of the Google Ads UI data showing this information you want to retrieve in the Google Ads API? This is for us to be able to replicate the data on our side and suggest you proper guidance.
You may then send the requested information via the Reply privately to the author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.
Links included in this email:
- Google ads API - https://developers.google.com/google-ads/api/docs/start?hl=en
- Zero Metrics - https://developers.google.com/google-ads/api/docs/reporting/zero-metrics
- Campaign - https://developers.google.com/google-ads/api/fields/v14/campaign
- Campaign_asset - https://developers.google.com/google-ads/api/fields/v14/campaign_asset
- Ad_group_ad_asset_view - https://developers.google.com/google-ads/api/fields/v14/ad_group_ad_asset_view
Hannes Fischer
Google Ads API Forum Advisor
Thank you for returning to our team.
Kindly note that the report that you will use depends on the level of the data that you wish to retrieve. For example, you will use the campaign (https://developers.google.com/google-ads/api/fields/v14/campaign) report to get the campaign level data while you need to use the keyword_view (https://developers.google.com/google-ads/api/fields/v14/keyword_view) to pull keyword level data.
You may also see the differences of the 3 different reports included in this:
- campaign (https://developers.google.com/google-ads/api/fields/v14/campaign) - campaign level data
- campaign_asset (https://developers.google.com/google-ads/api/fields/v14/campaign_asset) - extensions attached to the campaign data
- asset_group_product_group_view (https://developers.google.com/google-ads/api/fields/v14/asset_group_product_group_view) - asset group product group data
As mentioned previously, there are several items to be considered in retrieving data via the Google Ads API such as :
- Segmentation (https://developers.google.com/google-ads/api/docs/reporting/segmentation) - segmentation that will affect your reporting such as "when adding some segments, the metrics in the summary row may decrease" and "the amount of rows can increase exponentially for each additional segment field included in your report query".
- Zero metrics (https://developers.google.com/google-ads/api/docs/reporting/zero-metrics) - With query results, you often want to obtain information about how your campaigns are performing. In this context, zero metrics may not be desirable. To produce a more useful report, you can explicitly exclude zero metrics.
Moreover, please note that Google Ads API mirrors the Google Ads UI. On that note, if the metrics you selected has 0 or no metrics value, then the Google Ads API won't be returning data because of the Zero metrics (https://developers.google.com/google-ads/api/docs/reporting/zero-metrics) effect. More information can be found in this guide (https://developers.google.com/google-ads/api/docs/reporting/overview) regarding reporting in the Google Ads API.
I hope this clarifies.
Hannes Fischer
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
AND campaign.advertising_channel_type = \'PERFORMANCE_MAX\'
Hannes Fischer
Hannes Fischer
On Friday, August 4, 2023 at 1:11:00 PM UTC+2 Hannes Fischer wrote:
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': '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, 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,HannesOn 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 = 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 TeamOn 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:
,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
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
Response (72 results in total):[{'results': [{'campaign': {'resourceName': 'customers/4879915890/campaigns/18083992061','id': '18083992061'}, '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
Response (698 results in total):[{'results': [{'campaign': {'resourceName': 'customers/4879915890/campaigns/18083992061','id': '18083992061'}, '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,