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,
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 = 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
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,
[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/55a50e92-707d-4f07-9d2b-226c20309005n%40googlegroups.com.
