Max performance final urls

[asad mhagne]

Hi,
I'm using this query to pull data for max performance campaign,

SELECT  segments.date, customer.currency_code, campaign.id, segments.ad_network_type, metrics.conversions, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.engagements, metrics.interactions, metrics.search_exact_match_impression_share, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage, metrics.search_absolute_top_impression_share, metrics.search_top_impression_share, metrics.search_rank_lost_absolute_top_impression_share, metrics.search_budget_lost_absolute_top_impression_share, metrics.search_rank_lost_top_impression_share, metrics.search_budget_lost_top_impression_share, metrics.search_impression_share, metrics.search_rank_lost_impression_share, campaign.advertising_channel_type FROM campaign WHERE segments.date BETWEEN '2023-04-01' AND '2023-04-05' AND campaign.advertising_channel_type = 'PERFORMANCE_MAX'

I'm trying to pull final_urls as well in campaign level,is there a way to do it since I can see that there is a final url in the assets in google's UI.

I attached a screenshot of the UI.

Thanks,
Asa'd

[Google Ads API Forum Advisor]

Hi Asa’d,

Thank you for reaching out to Google Ads API Forum.

Upon checking your screenshot, I can see that you want to pull the final url in the asset group of a campaign. You may do this by pulling asset_group report (https://developers.google.com/google-ads/api/fields/v13/asset_group) and using the field asset_group.final_urls (https://developers.google.com/google-ads/api/fields/v13/asset_group#asset_group.final_urls) in your query since the campaign report is one of the attributed resources in using asset_group report. Please let us know how it goes.

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2lJEKz:ref

[asad mhagne]

Thank you,
Is there anyway to add asset_group.final_urls to the current query mentioned above?

[Google Ads API Forum Advisor]

Hi Asa’d,

Thank you for getting back to us.

It appears that campaign is specified in the FROM clause of the query you mentioned. Please note that as per this report (https://developers.google.com/google-ads/api/fields/v13/campaign), when you specify campaign in the FROM clause, some metrics and segments cannot be used. Since the asset_group.final_urls field is available when specifying asset_group in the FROM clause, I would suggest using asset_group report (https://developers.google.com/google-ads/api/fields/v13/asset_group) and you may also use the query builder (https://developers.google.com/google-ads/api/fields/v13/overview_query_builder?hl=en) and query validator (https://developers.google.com/google-ads/api/fields/v13/query_validator?hl=en) for building and validating your query.

This message is in relation to case "ref:_00D1U1174p._5004Q2lJEKz:ref"

Thanks,

 

Google Ads API Team