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
使用できる値は次のとおりです。AFFILIATED, LICENSED, OWNED, SHARED, SUBSCRIBED, UNKNOWN |
| UserListAccountUserListStatus | String | ATTRIBUTE | Indicates if this share is still enabled. When a UserList is shared with
使用できる値は次のとおりです。DISABLED, ENABLED, UNKNOWN |
| 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
使用できる値は次のとおりです。UNKNOWN, 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_PARTNER_DATA, THIRD_PARTY_VOTER_FILE, UNKNOWN |
| 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 |
| UserListDescription | String | ATTRIBUTE | Description of this user list. |
| UserListEligibleForDisplay | Bool | ATTRIBUTE | Output only. Indicates this user list is eligible for Google Display |
| 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 |
| 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 |
| 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 |
| UserListMembershipLifeSpan | Long | ATTRIBUTE | Number of days a user's cookie stays on your list since its most recent |
| UserListMembershipStatus | String | ATTRIBUTE | Membership status of this user list. Indicates whether a user list is open
使用できる値は次のとおりです。CLOSED, OPEN, UNKNOWN |
| UserListName | String | ATTRIBUTE | Name of this user list. |
| UserListReadOnly | Bool | ATTRIBUTE | Output only. An option that indicates if a user may edit a list. Depends on |
| UserListResourceName | String | ATTRIBUTE | Immutable. The resource name of the user list. |
| 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 |
| 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 |
| 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 |
| UserListSizeForSearch | Long | ATTRIBUTE | Output only. Estimated number of users in this user list in the google.com |
| UserListSizeRangeForDisplay | String | ATTRIBUTE | Output only. Size range in terms of number of users of the UserList, on the
使用できる値は次のとおりです。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 |
| UserListSizeRangeForSearch | String | ATTRIBUTE | Output only. Size range in terms of number of users of the UserList, for
使用できる値は次のとおりです。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 |
| UserListType | String | ATTRIBUTE | Output only. Type of this list.
使用できる値は次のとおりです。CRM_BASED, EXTERNAL_REMARKETING, LOGICAL, LOOKALIKE, REMARKETING, RULE_BASED, SIMILAR, UNKNOWN |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |