Tracking templates, final URLs, final mobile URLs, and custom parameters are all available as attributes when retrieving reports. Keep in mind that final URLs and final mobile URLs are rendered in the report as repeated string values:
final_urls {
value: "http://www.example.com/locations/mars/"
}
final_urls {
value: "http://www.example.com/cruise/space/"
}
Sample queries
The following query retrieves the final URLs from all expanded text ads:
SELECT
ad_group_ad.ad.name,
ad_group_ad.ad.final_urls
FROM ad_group_ad
WHERE ad_group_ad.ad.type = EXPANDED_TEXT_AD
Custom parameters are returned as repeated message objects of the type
CustomParameter, as shown below:
url_custom_parameters {
key {
value: "promocode"
}
value {
value: "NYC123"
}
}
url_custom_parameters {
key {
value: "season"
}
value {
value: "spring"
}
}
The following query retrieves the URL custom parameters from all search ads:
SELECT
ad_group.name,
ad_group.url_custom_parameters
FROM ad_group
WHERE ad_group.type = SEARCH_STANDARD