Reports
Stay organized with collections
Save and categorize content based on your preferences.
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 in the following
example:
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
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[null,null,["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eTracking templates, final URLs, final mobile URLs, and custom parameters can be retrieved as attributes in reports.\u003c/p\u003e\n"],["\u003cp\u003eFinal URLs and final mobile URLs are displayed as repeated string values within the report data.\u003c/p\u003e\n"],["\u003cp\u003eCustom parameters are presented as repeated message objects of the \u003ccode\u003eCustomParameter\u003c/code\u003e type.\u003c/p\u003e\n"],["\u003cp\u003eSample queries demonstrate how to retrieve final URLs from expanded text ads and URL custom parameters from search ads.\u003c/p\u003e\n"]]],[],null,["# Reports\n\nTracking templates, final URLs, final mobile URLs, and custom parameters are all\navailable as attributes when retrieving reports. Keep in mind that final URLs\nand final mobile URLs are rendered in the report as repeated string values: \n\n final_urls {\n value: \"http://www.example.com/locations/mars/\"\n }\n final_urls {\n value: \"http://www.example.com/cruise/space/\"\n }\n\nSample queries\n--------------\n\nThe following query retrieves the final URLs from all expanded text ads: \n\n SELECT\n ad_group_ad.ad.name,\n ad_group_ad.ad.final_urls\n FROM ad_group_ad\n WHERE ad_group_ad.ad.type = EXPANDED_TEXT_AD\n\nCustom parameters are returned as repeated message objects of the type\n[`CustomParameter`](/google-ads/api/reference/rpc/v21/CustomParameter), as shown in the following\nexample: \n\n url_custom_parameters {\n key {\n value: \"promocode\"\n }\n value {\n value: \"NYC123\"\n }\n }\n url_custom_parameters {\n key {\n value: \"season\"\n }\n value {\n value: \"spring\"\n }\n }\n\nThe following query retrieves the URL custom parameters from all search ads: \n\n SELECT\n ad_group.name,\n ad_group.url_custom_parameters\n FROM ad_group\n WHERE ad_group.type = SEARCH_STANDARD"]]
