Reports

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