CustomerClientLink

The links between customer client accounts and manager accounts

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be 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. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword 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

ClientCustomerId

String

Attribute

Hidden

String

Attribute

ManagerLinkId

String

Attribute

ResourceName

String

Attribute

Status

String

Attribute

LinkedManagerId

String

Attribute

Id of the linked manager.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

CustomerId

Long

CustomerId for which to get the linked client customer ids.

ManagerId

Long

Id of the manager account on behalf of which you are requesting customer data.

Last updated