Hi there, Based on what I understood from your last response, *metrics.interactions *should be compatible with *segments.asset_interaction_target.interaction_on_this_asset *otherwise how does it qualifies the example you gave above?
But running in query validator (query result here) https://gaql-query-builder.uc.r.appspot.com/v9/share?q=SELECT%20campaign_asset.campaign%2C%20metrics.interactions%2C%20metrics.interaction_rate%2Csegments.asset_interaction_target.interaction_on_this_asset%20FROM%20campaign_asset%20WHERE%20campaign_asset.status%20%3D%20'ENABLED'%20%20AND%20segments.date%20BETWEEN%20%222022-01-01%22%20AND%20%222022-01-31%22 I get the following errors - Result: Invalid Query (errors below) - 'segments.asset_interaction_target.interaction_on_this_asset' is incompatible with 'metrics.interactions'. - 'segments.asset_interaction_target.interaction_on_this_asset' is incompatible with 'metrics.interaction_rate'. Is that a bug or a reason for this combination getting deprecated? Looking forward for your response, Thanks. On Thursday, February 24, 2022 at 2:31:57 PM UTC+5:30 Arshdeep Singh Bhargav wrote: > Hi Aryeh, > > Thanks for the detailed explanation and for the example. > This makes it clearer about what to expect from this resource. However, I > have one more question which arose from the said response. > And that is, > When we say the campaign 'C' with an asset served/clicked 'n' no of times. > Does that include the count for interactions or impressions from an > *AdGroup* getting served which is linked to the same asset and part of > this original campaign 'A'? In other words, I want to understand how much > does the *AdGroupAsset* data coincide with *CampaignAsset* data? > > Regards, > Arshdeep > > On Wednesday, February 23, 2022 at 8:30:21 PM UTC+5:30 adsapi wrote: > >> Hi Arshdeep, >> >> I work with Teejay and will assist you. You are correct that AdWords has >> no campaign_asset equivalent due to AdWords not having support for asset >> based extensions. In general, for a report that worked in AdWords, we do >> recommend to use the Query Migration Tool >> <https://developers.google.com/google-ads/api/docs/migration/query-migration-tool> >> to >> migrate, then check for incompatibilities between fields found by using the >> query >> validator >> <https://developers.google.com/google-ads/api/fields/v10/query_validator> >> . >> >> Segmenting by campaign fields causes that campaigns linked to asset based >> extension that had 0 metrics for the date range (due to no serving of >> campaign with asset) don't show a row in the report. >> >> Without using >> 'segments.asset_interaction_target.interaction_on_this_asset' or >> 'segments.asset_interaction_target.asset' the metrics for the campaign when >> served with the asset based extension will show and there will be no asset >> interaction metrics shown. Adding >> 'segments.asset_interaction_target.interaction_on_this_asset' or >> 'segments.asset_interaction_target.asset' will add a row with metrics on >> the asset itself when served with that campaign. >> >> For example, if the campaign with the asset served 200 times and without >> the asset 1,000 times and when the campaign served with the asset the >> campaign itself as a whole was clicked 50 times while of those 50 times >> the asset was clicked 20 times then the segmenting mentioned above will >> show for the campaign 200 impressions and 50 clicks and there will be >> another row for the asset showing it was served 200 times with 20 clicks. >> >> Regards, >> >> [image: Google Logo] >> Aryeh >> Google Ads API Team >> >> >> ref:_00D1U1174p._5004Q2WxbMG:ref >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/3e6a7ad6-8636-450c-a5de-cd62833e4112n%40googlegroups.com.
