CustomerClientLink
Represents customer client link relationship.
View-Specific Information
Select
Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are returned. In general, these defaults are the same fields that are exposed through the Ads console. To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.
Query the CustomerClientLink table to get a list of the linked Customer Client Ids subaccounts, starting from the ManagerId specified in the connection property. If you wish to retreive the listing, from a different hierarchy level you can do so by filtering with the CustomerId pseudo-column, specifying the customer id of the accout for which you want to get the linked subaccounts. If you want to avoid the full hierarchy listing and only get subaccounts for a specific manager/CustomerId set RecurseChildren connection property to false.
Note that ManagerId property should be specified to be able to get data from this table.
SELECT * FROM CustomerClientLink WHERE CustomerId = '2705304492'
Columns
| Name | Type | Behavior | Description |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| CustomerClientLinkClientCustomer | String | ATTRIBUTE | Immutable. The client customer linked to this customer. |
| CustomerClientLinkHidden | Bool | ATTRIBUTE | The visibility of the link. Users can choose whether or not to see hidden |
| CustomerClientLinkManagerLinkId | Long | ATTRIBUTE | Output only. This is uniquely identifies a customer client link. Read only. |
| CustomerClientLinkResourceName | String | ATTRIBUTE | Immutable. Name of the resource. |
| CustomerClientLinkStatus | String | ATTRIBUTE | This is the status of the link between client and manager.
The allowed values are ACTIVE, CANCELED, INACTIVE, PENDING, REFUSED, UNKNOWN. |
| LinkedManagerId | String | ATTRIBUTE | Id of the linked manager. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |