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.
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".
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.
Custom bidding algorithm ID to populate with query results. Used for custom bidding queries only. Populated on QueryType.QUERY_TYPE_CUSTOM_BIDDING_ALGORITHM only.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-18 UTC."],[[["\u003cp\u003eThis document outlines the metadata associated with a query execution job in Ads Data Hub, stored within the metadata field of a google.longrunning.Operation.\u003c/p\u003e\n"],["\u003cp\u003eThe metadata includes details such as query resource name, title, customer IDs, parameter values, start and end times, and the query text itself.\u003c/p\u003e\n"],["\u003cp\u003eIt also specifies the output location of the query results, which can be a destination table, user list ID, or a custom bidding algorithm ID.\u003c/p\u003e\n"],["\u003cp\u003eQuery text is only included in the response of a google.longrunning.Operations.GetOperation call and omitted in other calls like google.longrunning.Operations.ListOperations.\u003c/p\u003e\n"]]],["This data describes metadata for a query execution job, including: the `queryResourceName`, `queryTitle`, and associated customer IDs (`customerId`, `adsDataCustomerId`, `matchDataCustomerId`). It details `parameterValues` used, and the `startTime` and `endTime` of the execution. The `queryText` is also included, and it specifies the result's output location using either `destTable`, `userListId`, or `algorithmId`.\n"],null,["- [JSON representation](#SCHEMA_REPRESENTATION)\n\nMetadata about a query execution job. This is stored in the metadata field of the google.longrunning.Operation returned by a query execution request.\n\n| JSON representation |\n|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| ``` { \"queryResourceName\": string, \"queryTitle\": string, \"customerId\": string, \"adsDataCustomerId\": string, \"matchDataCustomerId\": string, \"parameterValues\": { string: { object (/ads-data-hub/marketers/reference/rest/v1/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`. } ``` |\n\n| Fields ||\n|-----------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `queryResourceName` | `string` Name of the query resource that was executed, e.g. customers/123/analysisQueries/abcd1234 Only present for stored query execution. |\n| `queryTitle` | `string` Title of the query executed. |\n| `customerId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` The Ads Data Hub customer ID that executed the query. |\n| `adsDataCustomerId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` Ads Data Hub customer ID used for ads data. |\n| `matchDataCustomerId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` Ads Data Hub customer ID used for match table data. |\n| `parameterValues` | `map (key: string, value: object (`[ParameterValue](/ads-data-hub/marketers/reference/rest/v1/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\" }`. |\n| `startTime` | `string (`[Timestamp](https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#google.protobuf.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\"`. |\n| `endTime` | `string (`[Timestamp](https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#google.protobuf.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\"`. |\n| `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. |\n| Union field `output`. Location where query results get stored. `output` can be only one of the following: ||\n| `destTable` | `string` Destination table for query results. Used for analysis queries. |\n| `userListId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` User list to populate with query results. Used for user list queries. |\n| `algorithmId` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` 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. |"]]