RE: No extensions returned when they should

[Google Ads API Forum Advisor]

Hello Oliver,

Thanks for reaching out to the Google Ads API support. I have checked the GAQL query you shared into the Google Ads Query Builder page for the query validation on Google Ads API, the query got invalid because of the reason format issue – “Malformed operand: "(ENABLED)AND asset.policy_summary.approval_status NOT IN (\'DISAPPROVED\')". Filtering conditions on the "campaign_asset.status" field using the "IN" operator must contain an operand that takes the format of parentheses containing a comma separated list of enum values on the field campaign_asset.status. The following are valid enum values: ENABLED, PAUSED, REMOVED, UNKNOWN”.

Please find the attached screenshot to your reference to fix the query and call the API again. Hope this information helps. Give it a try and let me know if you have any questions on this.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2aPyIb:ref

[Google Ads API Forum Advisor]

Hello Oliver,

Thanks for reaching out to the Google Ads API forum. I would like to inform you first that I am going to delete your initial post as it contains sensitive information. I just pasted the context of your concern below without the sensitive information:

I have checked the GAQL query you shared into the Google Ads Query Builder page for the query validation on Google Ads API, the query got invalid because of the reason format issue – “Malformed operand: "(ENABLED)AND asset.policy_summary.approval_status NOT IN (\'DISAPPROVED\')". Filtering conditions on the "campaign_asset.status" field using the "IN" operator must contain an operand that takes the format of parentheses containing a comma separated list of enum values on the field campaign_asset.status. The following are valid enum values: ENABLED, PAUSED, REMOVED, UNKNOWN”.

Please find the attached screenshots to your reference to fix the query and call the Ads API again. Hope this information helps. Give it a try and let me know if you have any questions on this.

Best regards,

[Oliver]

Hi,

Thanks for your response.   The formatting issue picked up by the Query Builder happened due to copy & paste of the string here.  However, the query is formatted correctly in our code and is running correctly in production.  In any case, the issue is still there even if we remove all the WHERE conditions.  Please run the below query on the accounts we mentioned and you will see that no sitelinks are returned when infact the account has a lot of active sitelinks.

SELECT asset.policy_summary.approval_status, campaign_asset.campaign, campaign_asset.resource_name, campaign_asset.field_type, campaign_asset.status FROM campaign_asset 

Please advise.

Oliver

[Google Ads API Forum Advisor]

Hello Oliver,

Thank you for your reply. As per this guide, it states that "Feed-based extensions will no longer generate new data after migration".
That being said, could you try and confirm using this other section, if indeed migration has been completed for your account? I asked because your feed items may no longer be generating metrics as they may have already been migrated.

Feel free to reply back if you have any questions.

Best regards,

[Oliver]

Hi Jakeia,

I'm not sure why we're talking about feed-based extensions here.  According to Google's announcement, all sitelinks extensions (in every account in the world) have now migrated to asset-based extensions.  We're not trying to access any feed-based metrics here.  We're using campaign_asset which accesses only asset-based extensions.  If all sitelink extension have indeed been migrated to asset-based extensions (like Google says), then the campaign_asset query should return them.

If the above argument is correct, can you please look into why we're not getting back any sitelink extensions when querying camapign_asset?  This is happening with some (but not all) of our customer accounts.

Oliver

[Google Ads API Forum Advisor]

Hello Oliver,

Thanks for getting back.
Allow me to raise this to the rest of the team. Rest assured that we will reach out to you as soon as possible.

Best regards,

[Google Ads API Forum Advisor]

Hi Oliver,

I appreciate your patience here. I am also a member of the Google Ads API team and let me provide support to your concern.

I tried impersonating the report on my end and I wasn't able to get any data as well. With this, could you try this instruction so that we will know if your account is indeed now migrated to asset-based extensions. Please note that the migration is happening in phases, so it is possible for some extensions to be migrated and others not. Please provide the complete request and response logs with request ID and request header generated after trying the provided instruction.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2aPyIb:ref