UserList
A user list. This is a list of users a customer may target.
Columns
| Name | Type | Behavior | Description |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| UserListAccessReason | String | ATTRIBUTE | Output only. Indicates the reason this account has been granted access to the list. The reason can be SHARED, OWNED, LICENSED or SUBSCRIBED. This field is read-only.
使用できる値は次のとおりです。AFFILIATED, LICENSED, OWNED, SHARED, SUBSCRIBED, UNKNOWN, UNSPECIFIED |
| UserListAccountUserListStatus | String | ATTRIBUTE | Indicates if this share is still enabled. When a UserList is shared with the user this field is set to ENABLED. Later the userList owner can decide to revoke the share and make it DISABLED. The default value of this field is set to ENABLED.
使用できる値は次のとおりです。DISABLED, ENABLED, UNKNOWN, UNSPECIFIED |
| UserListBasicUserListActions | String | ATTRIBUTE | Actions associated with this user list. |
| UserListClosingReason | String | ATTRIBUTE | Indicating the reason why this user list membership status is closed. It is only populated on lists that were automatically closed due to inactivity, and will be cleared once the list membership status becomes open.
使用できる値は次のとおりです。UNKNOWN, UNSPECIFIED, UNUSED |
| UserListCrmBasedUserListAppId | String | ATTRIBUTE | A string that uniquely identifies a mobile application from which the data was collected. For iOS, the ID string is the 9 digit string that appears at the end of an App Store URL (for example, '476943146' for 'Flood-It! 2' whose App Store link is http://itunes.apple.com/us/app/flood-it!-2/id476943146). For Android, the ID string is the application's package name (for example, 'com.labpixies.colordrips' for 'Color Drips' given Google Play link https://play.google.com/store/apps/details?id=com.labpixies.colordrips). Required when creating CrmBasedUserList for uploading mobile advertising IDs. |
| UserListCrmBasedUserListDataSourceType | String | ATTRIBUTE | Data source of the list. Default value is FIRST_PARTY. Only customers on the allow-list can create third-party sourced CRM lists.
使用できる値は次のとおりです。FIRST_PARTY, THIRD_PARTY_CREDIT_BUREAU, THIRD_PARTY_VOTER_FILE, UNKNOWN, UNSPECIFIED |
| UserListCrmBasedUserListUploadKeyType | String | ATTRIBUTE | Matching key type of the list. Mixed data types are not allowed on the same list. This field is required for an ADD operation.
使用できる値は次のとおりです。CONTACT_INFO, CRM_ID, MOBILE_ADVERTISING_ID, UNKNOWN, UNSPECIFIED |
| UserListDescription | String | ATTRIBUTE | Description of this user list. |
| UserListEligibleForDisplay | Bool | ATTRIBUTE | Output only. Indicates this user list is eligible for Google Display Network. This field is read-only. |
| UserListEligibleForSearch | Bool | ATTRIBUTE | Indicates if this user list is eligible for Google Search Network. |
| UserListId | Long | ATTRIBUTE | Output only. Id of the user list. |
| UserListIntegrationCode | String | ATTRIBUTE | An ID from external system. It is used by user list sellers to correlate IDs on their systems. |
| UserListLogicalUserListRules | String | ATTRIBUTE | Logical list rules that define this user list. The rules are defined as a logical operator (ALL/ANY/NONE) and a list of user lists. All the rules are ANDed when they are evaluated. Required for creating a logical user list. |
| UserListLookalikeUserListCountryCodes | String | ATTRIBUTE | Countries targeted by the Lookalike. Two-letter country code as defined by ISO-3166 |
| UserListLookalikeUserListExpansionLevel | String | ATTRIBUTE | Expansion level, reflecting the size of the lookalike audience
使用できる値は次のとおりです。BALANCED, BROAD, NARROW, UNKNOWN, UNSPECIFIED |
| UserListLookalikeUserListSeedUserListIds | String | ATTRIBUTE | Seed UserList ID from which this list is derived, provided by user. |
| UserListMatchRatePercentage | Int | ATTRIBUTE | Output only. Indicates match rate for Customer Match lists. The range of this field is [0-100]. This will be null for other list types or when it's not possible to calculate the match rate. This field is read-only. |
| UserListMembershipLifeSpan | Long | ATTRIBUTE | Number of days a user's cookie stays on your list since its most recent addition to the list. This field must be between 0 and 540 inclusive. However, for CRM based userlists, this field can be set to 10000 which means no expiration. This field is ignored for logical_user_list and rule_based_user_list types. Membership to lists of these types depends on the rules defined by the lists. |
| UserListMembershipStatus | String | ATTRIBUTE | Membership status of this user list. Indicates whether a user list is open or active. Only open user lists can accumulate more users and can be targeted to.
使用できる値は次のとおりです。CLOSED, OPEN, UNKNOWN, UNSPECIFIED |
| UserListName | String | ATTRIBUTE | Name of this user list. Depending on its access_reason, the user list name may not be unique (for example, if access_reason=SHARED) |
| UserListReadOnly | Bool | ATTRIBUTE | Output only. An option that indicates if a user may edit a list. Depends on the list ownership and list type. For example, external remarketing user lists are not editable. This field is read-only. |
| UserListResourceName | String | ATTRIBUTE | Immutable. The resource name of the user list. User list resource names have the form: customers/{customer_id}/userLists/{user_list_id} |
| UserListRuleBasedUserListFlexibleRuleUserListExclusiveOperands | String | ATTRIBUTE | Rules representing users that should be excluded from the user list. These are located on the right side of the AND_NOT operator, and joined together by OR. |
| UserListRuleBasedUserListFlexibleRuleUserListInclusiveOperands | String | ATTRIBUTE | Rules representing users that should be included in the user list. These are located on the left side of the AND_NOT operator, and joined together by either AND/OR as specified by the inclusive_rule_operator. |
| UserListRuleBasedUserListFlexibleRuleUserListInclusiveRuleOperator | String | ATTRIBUTE | Operator that defines how the inclusive operands are combined.
使用できる値は次のとおりです。AND, OR, UNKNOWN, UNSPECIFIED |
| UserListRuleBasedUserListPrepopulationStatus | String | ATTRIBUTE | The status of pre-population. The field is default to NONE if not set which means the previous users will not be considered. If set to REQUESTED, past site visitors or app users who match the list definition will be included in the list (works on the Display Network only). This will only add past users from within the last 30 days, depending on the list's membership duration and the date when the remarketing tag is added. The status will be updated to FINISHED once request is processed, or FAILED if the request fails.
使用できる値は次のとおりです。FAILED, FINISHED, REQUESTED, UNKNOWN, UNSPECIFIED |
| UserListSimilarUserListSeedUserList | String | ATTRIBUTE | Seed UserList from which this list is derived. |
| UserListSizeForDisplay | Long | ATTRIBUTE | Output only. Estimated number of users in this user list, on the Google Display Network. This value is null if the number of users has not yet been determined. This field is read-only. |
| UserListSizeForSearch | Long | ATTRIBUTE | Output only. Estimated number of users in this user list in the google.com domain. These are the users available for targeting in Search campaigns. This value is null if the number of users has not yet been determined. This field is read-only. |
| UserListSizeRangeForDisplay | String | ATTRIBUTE | Output only. Size range in terms of number of users of the UserList, on the Google Display Network. This field is read-only.
使用できる値は次のとおりです。FIFTY_THOUSAND_TO_ONE_HUNDRED_THOUSAND, FIVE_HUNDRED_THOUSAND_TO_ONE_MILLION, FIVE_MILLION_TO_TEN_MILLION, LESS_THAN_FIVE_HUNDRED, LESS_THAN_ONE_THOUSAND, ONE_HUNDRED_THOUSAND_TO_THREE_HUNDRED_THOUSAND, ONE_MILLION_TO_TWO_MILLION, ONE_THOUSAND_TO_TEN_THOUSAND, OVER_FIFTY_MILLION, TEN_MILLION_TO_TWENTY_MILLION, TEN_THOUSAND_TO_FIFTY_THOUSAND, THIRTY_MILLION_TO_FIFTY_MILLION, THREE_HUNDRED_THOUSAND_TO_FIVE_HUNDRED_THOUSAND, THREE_MILLION_TO_FIVE_MILLION, TWENTY_MILLION_TO_THIRTY_MILLION, TWO_MILLION_TO_THREE_MILLION, UNKNOWN, UNSPECIFIED |
| UserListSizeRangeForSearch | String | ATTRIBUTE | Output only. Size range in terms of number of users of the UserList, for Search ads. This field is read-only.
使用できる値は次のとおりです。FIFTY_THOUSAND_TO_ONE_HUNDRED_THOUSAND, FIVE_HUNDRED_THOUSAND_TO_ONE_MILLION, FIVE_MILLION_TO_TEN_MILLION, LESS_THAN_FIVE_HUNDRED, LESS_THAN_ONE_THOUSAND, ONE_HUNDRED_THOUSAND_TO_THREE_HUNDRED_THOUSAND, ONE_MILLION_TO_TWO_MILLION, ONE_THOUSAND_TO_TEN_THOUSAND, OVER_FIFTY_MILLION, TEN_MILLION_TO_TWENTY_MILLION, TEN_THOUSAND_TO_FIFTY_THOUSAND, THIRTY_MILLION_TO_FIFTY_MILLION, THREE_HUNDRED_THOUSAND_TO_FIVE_HUNDRED_THOUSAND, THREE_MILLION_TO_FIVE_MILLION, TWENTY_MILLION_TO_THIRTY_MILLION, TWO_MILLION_TO_THREE_MILLION, UNKNOWN, UNSPECIFIED |
| UserListType | String | ATTRIBUTE | Output only. Type of this list. This field is read-only.
使用できる値は次のとおりです。CRM_BASED, EXTERNAL_REMARKETING, LOGICAL, LOOKALIKE, REMARKETING, RULE_BASED, SIMILAR, UNKNOWN, UNSPECIFIED |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |