To discuss and provide feedback on our products, join the official Google Ads Discord channel in the Google Advertising and Measurement Community server.

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 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

Valuetrack parameters for Upgraded URLs

Serving URL expansion rules

Reports Stay organized with collections Save and categorize content based on your preferences.

Sample queries

Reports