CampaignAsset resource interaction_on_this_asset parameter

[Arshdeep Singh Bhargav]

Hi there,

I have been trying to migrate to new Api in my application. Unfortunately for CampaignAsset (Google Ads API) resource, the  interaction_on_this_asset attribute doesn't seem to be supported with campaign.id. 
I have been trying this query in query validator: SELECT metrics.impressions,campaign.id,segments.asset_interaction_target.interaction_on_this_asset FROM campaign_asset



This, earlier was supported, for example, for feed based extensions via Placeholder Feed Item Report IsSelfAction was supported, even when segmented by CampaignId. (AdWords API) --  

- Does that mean segmenting by campaign.id here means the row returned (since it is segmented further by campaign) indicates data from the same asset itself?

- On same note I have another question. Are the rows in CampaignAsset segmented at campaign and the asset level or just on an asset level?

Looking forward to your response.

Best,
Arshdeep

[Zorion]

Hi Arshdeep,

If you don't mind getting campaign.resource_name instead of campaign.id you may try campaign_asset.campaign, which is an attribute, so it doesn't segment the metrics.

SELECT metrics.impressions, campaign_asset.campaign, segments.asset_interaction_target.interaction_on_this_asset FROM campaign_asset

I haven't tried it myself but the validator doesn't have problems with this.

You should be able to extract easily the campaign.id from its resource_name.

From the campaign_asset help I understand that asset is not segmenting but an attribute resource.

Campaign and ad_group are segmenting resources there.

Best regards,

Zorion

[Google Ads API Forum Advisor]

Hi Zorion,

Thank you for sharing your knowledge to the community.

@Arshdeep,

You may try what Zorion suggested. Also, since you mentioned that you were migrating your report to Google Ads API, then we would recommend utilizing Query Migration Tool which will convert your AWQL to GAQL automatically.

Regards,

Teejay Wennie Google Ads API Team

 

ref:_00D1U1174p._5004Q2WxbMG:ref

[Arshdeep Singh Bhargav]

Zorion,
really appreciate you for your response.

From what I understand looking at the documentation for the campaign_asset resource is that, campaign_asset.campaign will only represent the campaign resource to which current asset is linked. Now, the requested metrics might still represent performance from any other campaign as well (other campaigns to which this asset is linked). So, segmenting with campaign becomes crucial in this case to get campaign specific information.
If I am getting this wrong, then this gives rise to another question, "How would campaign_asset view be different if it is segmented by campaign.id vs not segmented by campaign.id ? Will it be any different at all ?" 
I could really use a help understanding this, if you please @Zorion

Now, in AdWords API as I mentioned the same information could be requested by segmenting by CampaignId and further IsSelfAction=True (to get "this extension" data) but post migration of extensions to asset the incompatibility of these segmentations is like a big deprecation, which is not documented at all, so I assume it is a bug.

@Google Ads Team 
I would really appreciate your help with this, as there is a view of data we could get earlier from an old api but it suddenly seems to be unavailable.

Thank you and Regards.

[Arshdeep Singh Bhargav]

Also to add onto Query Migration Tool  , 

I think that only helps migrating AWQL to GAQL, but that doesn't help for reporting changes due to Feed based extensions getting migrated to Asset based extensions with New Google ads API.

Best,
Arshdeep

[Google Ads API Forum Advisor]

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 to migrate, then check for incompatibilities between fields found by using the 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,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2WxbMG:ref

[Arshdeep Singh Bhargav]

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

[Arshdeep Singh Bhargav]

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. 

[Google Ads API Forum Advisor]

Hi Arshdeep,

campaign_asset can be segmented by ad_group, that will show metrics for assets linked at campaign level only broken down by which ad group it served with. This will not report on assets when linked at ad group level. For reporting on assets linked at ad group level you can use  ad_group_asset.

Regarding incompatible fields, note that the API can only be a conduit to the Ads product as exposed in the UI. Could you privately send us a full screen screenshot of the UI where these fields are compatible? You may reach out to product support for assistance and requests. Once it's available in the UI we may be able to offer it.

'metrics.interactions' has a specific meaning that doesn't have to do with which asset was interacted with. Product support can explain it and here's an example.