QueryMetadata

  • QueryMetadata contains metadata about a query execution job and is stored in the metadata field of the google.longrunning.Operation returned by a query execution request.

  • The JSON representation of QueryMetadata includes fields such as queryResourceName, queryTitle, customerId, adsDataCustomerId, matchDataCustomerId, parameterValues, startTime, endTime, queryText, and a union field for output which can be destTable, userListId, or algorithmId.

  • Fields like queryResourceName, queryTitle, customerId, adsDataCustomerId, matchDataCustomerId, parameterValues, startTime, endTime, and queryText provide details about the query and its execution.

  • The output field indicates where the query results are stored, depending on the type of query, such as a destination table for analysis queries, a user list for user list queries, or an algorithm ID for custom bidding queries.

Metadata about a query execution job. This is stored in the metadata field of the google.longrunning.Operation returned by a query execution request.

JSON representation 
{
  "queryResourceName": string,
  "queryTitle": string,
  "customerId": string,
  "adsDataCustomerId": string,
  "matchDataCustomerId": string,
  "parameterValues": {
    string: {
      object (ParameterValue)
    },
    ...
  },
  "startTime": string,
  "endTime": string,
  "queryText": string,

  // Union field output can be only one of the following:
  "destTable": string,
  "userListId": string,
  "algorithmId": string
  // End of list of possible types for union field output.
}
Fields
queryResourceName

string

Name of the query resource that was executed, e.g. customers/123/analysisQueries/abcd1234 Only present for stored query execution.
queryTitle

string

Title of the query executed.
customerId

string (int64 format)

The Ads Data Hub customer ID that executed the query.
adsDataCustomerId

string (int64 format)

Ads Data Hub customer ID used for ads data.
matchDataCustomerId

string (int64 format)

Ads Data Hub customer ID used for match table data.
parameterValues

map (key: string, value: object (ParameterValue))

Parameter values used in the query. Maps each argument name to its bound value.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.
startTime

string (Timestamp format)

Query execution start time.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".
endTime

string (Timestamp format)

Query execution end time.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".
queryText

string

Text of the query executed. Note that this field will only be set in the response of google.longrunning.Operations.GetOperation call. It will be omitted in the response of google.longrunning.Operations.ListOperations call or any other calls.
Union field output. Location where query results get stored. output can be only one of the following:
destTable

string

Destination table for query results. Used for analysis queries.
userListId

string (int64 format)

User list to populate with query results. Used for user list queries.
algorithmId

string (int64 format)

Custom bidding algorithm ID to populate with query results. Used for custom bidding queries only. Populated on QueryType.QUERY_TYPE_CUSTOM_BIDDING_ALGORITHM only.