Retrieve all bucket attributes
Retrieves a list of all bucket attributes for the specified master entity.
| Request Method | Service URL |
|---|---|
|
|
/api-metadata/v1/{access-key}/metadata/aggregatedtables/{aggregatedTableId}/buckets
|
|
Request Headers |
|
Examples
Request
Retrieve all bucket attributes for the "mastercustomer" master entity:
GET http://{accountURL}/api-metadata/v1/e2a7a0df2410470d85ef69c8dad2bdb8/metadata/aggregatedtables/mastercustomer/buckets
Response
{
"tenantId": 100173,
"name": "Life Time Value Bands",
"versionTS": 1583969463352,
"active": true,
"lastModifiedBy": "system",
"createdTS": 1562190929002,
"tableId": "MasterCustomer",
"bucketingId": "total_spent_amt_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "total_spent_amt"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Number of Orders Bands",
"versionTS": 1583969463568,
"active": true,
"lastModifiedBy": "system",
"createdTS": 1562190929116,
"tableId": "MasterCustomer",
"bucketingId": "total_order_count_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "total_order_count"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Total Email Opens Bands",
"versionTS": 1583969463754,
"active": false,
"lastModifiedBy": "system",
"createdTS": 1562190929215,
"tableId": "MasterCustomer",
"bucketingId": "total_opened_count_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "total_opened_count"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Total Email Sends Bands",
"versionTS": 1583969463934,
"active": false,
"lastModifiedBy": "system",
"createdTS": 1562190929319,
"tableId": "MasterCustomer",
"bucketingId": "total_delivered_count_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "total_delivered_count"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Total Email Clicks Bands",
"versionTS": 1583969464117,
"active": false,
"lastModifiedBy": "system",
"createdTS": 1562190929425,
"tableId": "MasterCustomer",
"bucketingId": "total_clicked_count_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "total_clicked_count"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Days since Last Order Bands",
"versionTS": 1583969464295,
"active": true,
"lastModifiedBy": "system",
"createdTS": 1562190929528,
"tableId": "MasterCustomer",
"bucketingId": "days_since_last_purchase_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "days_since_last_purchase"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Days since last Email open Bands",
"versionTS": 1583969464488,
"active": false,
"lastModifiedBy": "system",
"createdTS": 1562190929631,
"tableId": "MasterCustomer",
"bucketingId": "days_since_last_opened_event_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "days_since_last_opened_event"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 20,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Shortest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 20,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 40,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Short"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 40,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 60,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 60,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 80,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Long"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 80,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Longest"
}
}
]
},
{
"tenantId": 100173,
"name": "Days since last Email click Bands",
"versionTS": 1583969464682,
"active": false,
"lastModifiedBy": "system",
"createdTS": 1562190929735,
"tableId": "MasterCustomer",
"bucketingId": "days_since_last_clicked_event_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "days_since_last_clicked_event"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 20,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Shortest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 20,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 40,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Short"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 40,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 60,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 60,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 80,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Long"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 80,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Longest"
}
}
]
},
{
"tenantId": 100173,
"name": "Average Purchased Item Value Bands",
"versionTS": 1583969464848,
"active": true,
"lastModifiedBy": "system",
"createdTS": 1562190929832,
"tableId": "MasterCustomer",
"bucketingId": "aov_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "AOV"
},
"type": "PERCENTILE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Lowest"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 10,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Low"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 25,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Average"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 75,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "High"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 90,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 100,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Highest"
}
}
]
},
{
"tenantId": 100173,
"name": "Age group Bands",
"versionTS": 1583969465003,
"active": true,
"lastModifiedBy": "system",
"createdTS": 1562190929928,
"tableId": "MasterCustomer",
"bucketingId": "age_bands",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "MasterCustomer",
"attributeName": "Age"
},
"type": "VALUE",
"configs": [
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 0,
"type": "INCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 18,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "Under 18"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 18,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 44,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "18-44"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 44,
"type": "EXCLUSIVE"
},
"upperBound": {
"atype": ".RangeAttribute",
"data": 64,
"type": "INCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "45-64"
}
},
{
"lowerBound": {
"atype": ".RangeAttribute",
"data": 64,
"type": "EXCLUSIVE"
},
"rangeValue": {
"atype": ".StaticAttribute",
"data": "65+"
}
}
]
}