Get callout/sitelink extensions metrics

[marsel...@gmail.com]

Hi! I'm trying to get metrics for extensions via GAQL api (as in the screenshot)

I tried through different resources, campaign_asset, asset_field_type_view, extension_feed_item, but everywhere I get different numbers, and they do not match the indicators from the web dashboard. please tell me what resource should be used to get these metrics via GAQL?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to our API support team.

If the call out extensions are already asset based and are created or associated at the campaign level, then the campaign_asset report should be able to return those records. However, in order for our team to better investigate, could you also share your complete request and response logs, and request-id?

In addition, could you also share your complete UI report screenshot?

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2ePTNx:ref

[marsel...@gmail.com]

thanks i sent you the info

пятница, 16 сентября 2022 г. в 21:52:17 UTC+3, adsapi:

[Google Ads API Forum Advisor]

Hi Mawran,

Thank you for providing the requested details. I am also a member of the Google Ads API team and let me provide support to your concern.

Upon checking, it appears that the reason why you can't get the values is because the GAQL is not properly mapped with the UI. With this, you can use the below query instead to get the information in the provided UI:

SELECT asset.callout_asset.callout_text, metrics.absolute_top_impression_percentage, metrics.all_conversions, 
metrics.all_conversions_from_interactions_rate, metrics.cost_micros, metrics.conversions_value, 
metrics.conversions_from_interactions_rate, metrics.conversions, metrics.clicks, metrics.average_cpm, 
metrics.average_cpc, metrics.average_cost, metrics.all_conversions_value, metrics.average_cpe, 
metrics.average_cpv, metrics.cost_per_all_conversions, metrics.cost_per_conversion, 
metrics.cross_device_conversions, metrics.ctr, metrics.engagement_rate, metrics.engagements, 
metrics.impressions, metrics.interaction_event_types, metrics.interaction_rate, metrics.interactions, 
metrics.phone_calls, metrics.phone_impressions, metrics.phone_through_rate, metrics.top_impression_percentage, 
metrics.value_per_all_conversions, metrics.value_per_conversion, metrics.video_view_rate, metrics.video_views, 
campaign_asset.field_type, campaign.id FROM campaign_asset where campaign_asset.field_type = CALLOUT and 
segments.date < '2022-09-16' and segments.date >= '2013-09-25' AND campaign.id = 15443369170

Let me know if you have further questions.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2ePTNx:ref