Introduction
CDP uses Exact and Fuzzy matching techniques to provide a 360 degree profile of a customer by:
- Integrating customer data
- Processing ingested customer records
- Standardizing individual customer records
- De-duplicating records into a single master customer record
CDP links all customer activities into this single customer profile, and enhances the profile with behavioral and predictive analytics. It gives you a single customer record that you can leverage for all your marketing activities and customer interaction.
The CDP 360 Profile API is a secure REST API to search and find specific customers. To access the 360 degree profile of a customer, the Search API queries the data from individual customer records. For each search result, there is a link to the 360 profile of that customer. You can configure the 360 Profile API to meet your unique business needs.
For all APIs, specify:
- Content-Type as
applicationorjson - Content-Length as
0
Best practices
The following are the best practices for a smooth integration:
- Avoid the Search API by going straight to the 360 Customer Profile API with the customer’s unique identifier
- Reuse the same authentication token across all servers
- For the 360 Customer Profile API, configure the
fieldsparameter to only fetch the resources that you need
Requirements
The following sections specify the requirements of the 360 Customer Profile API.
Subdomains
Before integrating with CDP’s 360 Profiles APIs, you must request the following values or variables from your implementation consultant:
- Pre-production (CS) environment:
- Environment Subdomain1 (string) - for /authentication endpoint
- Environment Subdomain2 (string) - for /dw/a360/ endpoint
- Tenant ID (integer)
- Production environment:
- Environment Subdomain1 (string) - for /authentication endpoint
- Environment Subdomain2 (string) - for /dw/a360/ endpoint
- Tenant ID (integer)
Example values for Environment Subdomain1:
| Environment | Pre-Production | Production |
|---|---|---|
| US AWS | cs-auth | auth |
| EU AWS | cs-auth.eu | auth.eu |
| US GCP | cs-gcp-auth | auth8 |
Example values for Environment Subdomain2:
| Environment | Pre-Production | Production |
|---|---|---|
| US AWS | cs-api6-green | api7 |
| EU AWS | cs-api6.eu | api6.eu |
| US GCP | cs-gcp-api6 | api8 |
Tenant IDs are client-specific and can only be provided by your implementation consultant or customer value manager.
Authentication through access tokens
To access any API from CDP, retrieve an access token by invoking the authentication API. You can fetch an existing active token through a GET request by:
https://<environmentSubdomain1>.agilone.com/token
To authenticate through access token:
- Use the
HTTPS GETrequest method. - Enter your username and password through the
HTTP Basic Authmechanism (base64 encoded). - Ensure that:
- Content-Type is set to
applicationorjson. - Content-Length is set to
0.
- Content-Type is set to
If no existing tokens are available, log in through a POST request:
https://<environmentSubdomain1>.agilone.com/authentication?action=login
To authenticate through a POST request:
- Use the
HTTPS POSTrequest method. - Enter your username and password through the
HTTP Basic Authmechanism (base64 encoded). - Ensure that:
- Content-Type is set to
applicationorjson. - Content-Length is set to
0.
- Content-Type is set to
In both the instances, the response json includes the access_token with token_type as bearer. You must pass the bearer token with all subsequent 360 Profile API calls. The response JSON also includes an expires_in attribute, which is the time in seconds in which the token expires. Subsequent API calls in this document require the following headers:
- Authorization: Bearer <your bearer token obtained from the auth API>
- Content-Type:
applicationorjson - Content-Length:
0
By default, a single client user is limited to 10 tokens. If a client user is shared among other users, each concurrent session that shares the same client user must share the same bearer token. Do not log in and instantiate a new bearer token for each concurrent read session because it causes your 10th oldest token to become logged out and denied.
Search API
Using Search API, you can search and find specific customers. Searchable attributes include:
- First name
- Last name
- Email address
- Source Customer Number
- Primary phone
- Primary address attributes (address1, address2, zip, state, country)
CDP supports the following mechanisms for search:
- Keyword search
- Attribute-specific search
The results are always ranked by relevance based on the search criteria.
Keyword search
This API supports a search, which is similar to a search engine search where you can pass a keyword or pattern as input and the search result includes any records where this keyword appears in any of the indexed attributes.
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?searchTerm=<your search term> (HTTP Get operation)
The search term supports various regression patterns. The most used pattern is the wild-card search with a * character. For example, searchTerm=john* includes search results that starts with the term john in any of the indexed attributes:
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?searchTerm=john*
Attribute-specific search
Using this API, you can search for values or patterns on specific attributes. For example, you can search for customer records with the John* pattern in the first name and Smith* in the last name.
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?fq=<attribute-value patterns> (HTTP Get operation)
CDP supports the following attributes in the search:
- FirstName
- LastName
- SourceCustomerNumber
- PrimaryPhone
- Zip
- Country
- State
- Address1
- Address2
Example:
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?fq=[{"lastName":["eq","smith*"],"firstName":["eq","john*"]}]
Important
If you are using a GCP cluster to make the API call, the search results can display an unwanted port value in the customer profile URL. If you face such an issue, send Key and Value as X-Forwarded-Port and 443 respectively in the request payload.
Search Results
To help identify the customer you are looking for, each result returned in the JSON includes a link to access the 360 profile of that customer along with select attributes for that record. For example, you can display these attributes included in the response as a preview of the records in the results as displayed in the UI, without having to get the full individual records.
When the results are a longer list, the API paginates the results it returns. You can pass limit and offset parameters in the request to page through a set of search results when the result set is larger.
Example:
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?fq=[{"lastName":["eq","smith*"],"firstName":["eq","john*"]}]&limit=10&offset=0
This fetches the first 10 search results.
Using the link provided on each result, you can access the 360 profile of that customer.
...
"_embedded": {
"resources": [{
"_links": {
"self": {"href": <link to the customer record>}
},
"zip": <value or null>,
"country": <value or null>,
"firstname": <value or null>,
"address2": <value or null>,
"address1": <value or null>,
"sourcecustomernumber": <value or null>,
"id": <value or null>,
"state": <value or null>,
"primaryphone": <value or null>,
"email": <value or null>,
"lastname": <value or null>
}, {
"_links:{..}, <attribute and values>
}]
}
An example of full JSON returned from search API is in the later section.
Parameters
The API supports the following parameters:
- limit - Limit affects the maximum number of child customer records that are returned. The default limit is 40.
- offset - Offset allows you to paginate through the child customer records returned in the response. The default offset is 0. For example, if the API returns 40 records, a limit is not specified and the search matches more that 40 records, then to review the next 40 records you must set the offset to 40.
360 Customer Profiles API
The 360 Customer Profile API is accessible here:
https://<environmentSubdomain2>.agilone.com/v2/<tenantID>/dw/a360/customers/<customerID>
From this API, you can access the following details of the 360 profile of a customer:
- Customer Summary attributes
- Transaction details of the customer
- Events related to the customer showcasing the customer journey
- Individual customer record details that were de-duplicated into this master customer record
- Household Summary
In addition to this standard functionality, tenant-specific configurations can tailor this to your unique business needs. The following section explains what you can add through configuration.
The returned JSON always includes a self link to this 360 customer profile.
Example:
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers/FTP_CSV_1_102720214
The following is the example syntax:
{
"_links":{
"self":{
"href": <link to this customer 360 profile>
}
Parameters
The API supports the following parameters:
- limit - Limit affects the maximum number of objects per resource that are returned. For each resource, the default return limit is 40 objects. However, you can alter this behavior with the limit parameter. For example, if you want more than 40 events to be returned, you can append
?limit=<what you want>to your request URL - fields - If you want only specific resources to be returned and not the entire customer 360 profile, then you can specify the array of resources you want to be returned. For example, if you want the master customer profile and transactions to be returned, then you can append
? fields=["customersummary","transaction"]to your request URL. The resource options includes:- customersummary
- customer
- transaction
- event
- household
- toprecommendations
Customer summary (master customer) attributes
Customer summary attributes returned in the JSON include basic profile attributes, preferences including opt-in or opt-out information for different marketing channels, summaries calculated by CDP based on transactions, summaries calculated by CDP based on events, and predictive analytics.
The attribute names are self-explanatory. For more information, see Customer Summary.
- Customer Name (customersummary.FirstName, customersummary.LastName, customersummary.MiddleName)
- customersummary.Gender
- Customersummary.email
- customersummary.EmailStatus
- customersummary.MasterCustomerID //Internal to CDP, the id of the de-duped master customer record
- The primary address of the customer (customersummary.Address1, customersummary.Address2, customersummary.City, customersummary.State, customersummary.Country, customersummary.ZipCode)
- customersummary.AddressCertified
- ustomersummary.PrimaryPhone
- customersummary.MobilePhone
- customersummary.averagediscountrate
- customersummary.closeststore
- customersummary.FirstTransactionDate
- customersummary.frequency
- customersummary.Preferences //This includes the DNE, DNM flags for opt-in information.
- customersummary.primarystore
- customersummary.primaryOrganization
- customersummary.Tenuredays
- customersummary.TotalClickCount31_60Days
- customersummary.TotalClickCountLast30Days
- customersummary.TotalOpenCount31_60Days
- customersummary.TotalOpenCountLast30Days
- customersummary.TotalSendCount31_60Days
- customersummary.TotalSendCountLast30Days
- customersummary.TotalRevenue
- customersummary.TotalRevenue_Last12Months
- customersummary.TotalRevenue_Last13_24Months
- customersummary.TotalTransactionCount
- customersummary.TotalTransactionCount_Last12Months
- customersummary.TotalTransactionCount_Last13_24Months
- customersummary.TotalVisitCount31_60Days
- customersummary.TotalVisitCountLast30Days
The following is the example syntax snippet in the returned JSON for customer summary attributes:
"{\"displayResourceKey\":\"$customersummaryAttributes\",\"resource\":\"customersummary\",\"layout\":\"cat\"}": [{
"values": [{
"layout": <layout info relevant to CDP customer 360 UI>,
"udmColumn": "customersummary.<attribute name>",
"value": <Value>
},
{<Similarly, details of other customer summary attribute>}
],
"children": [] //For any 1->many customerSummary attributes.
}]
Transaction details
The transactions linked to this master customer record are returned as part of the 360 profile. This includes the transaction details and the related transaction items. Note that these are the transactions across all channels (web and store).
For more information on the attributes included in the Transaction and TransactionItem, see Appendix.
You can have additional configurations so that other transaction and transaction item attributes are returned. For more information, see Additional Configuration.
The following is the example syntax:
{\"displayResourceKey\":\"$customerTransaction360\",\"resource\":\"transaction\",\"layout\":\"cat\"}":[
{<Details of the latest transaction including 'children' section for details of each transactionItem that is part of this transaction},
{<Details of next transaction and so on>}
]
Events
The events associated with this customer are returned in the JSON. These events include email, WebTag and other customer events the customer sends.
Note that the transactions are in the separate transactions section of the JSON and are not included in the events section.
For example, on the product browsed event, the children section includes the sourceProductNumber of the products browsed. On the email events, CDP includes the message name in the details.
The following is the example syntax:
"{\"displayResourceKey\":\"$customerJourney\",\"resource\":\"event\",\"layout\":\"cat\"}": [{
"values": [{
"layout": <layout info relevant to CDP customer 360 UI>,
"udmColumn": "event.EventTimeStamp",
"value": "1455639057000" //Timestamp value in UTC
}, {
"layout": <layout info relevant to CDP customer 360 UI>,
"udmColumn": "event.Type",
"value": <event type> //Ex: emailOpen
}],
"children": [
[<Additional details about this event>]
]
}, <Other events>
}],
Individual (child) customer records
The returned JSON includes information about the individual customer records, which are de-duped into this master customer record.
The collection attributes that are part of this record are returned in the children section. For example, multiple addresses can be related to a customer record and are returned in this section. For each address, the attributes returned include - address.Address1, address.Address2, address.Country, address. Zip, address.State, address.City, address.Certified.
The following is the example syntax:
""{\"displayResourceKey\":\"$customer\",\"resource\":\"customer\",\"layout\":\"cat\"}": [{
"values": [{
"layout": <layout info>,
"udmColumn": "customer.FirstName",
"value": <value>
},
//Similarly data for other attributes
],
"children": [
//For the 1->many info
[{
"layout": <layout info>,
"udmColumn": "customeraddressxref.DeleteFlag",
"value": <value>
}, <Other address attributes>
Return codes
The following are the return codes on the response:
- 404: Customer number was not found. It is not an error.
- 400: Bad request due to malformed or syntax error.
- 401: Unauthorized. Check the credentials.
- 500: 360 Client failed. Check with the operations team.
- 200: Successful call.
Additional Configuration Options
The 360 Profile API is built to be configurable to meet the unique business needs of your organization. For more information, contact your customer value manager.
The following are the supported customizations:
- Household details
- Product recommendations (user to product recommendations)
- Cross-brand customer details (master customer group summary)
- Custom attributes on customer summary, transaction (item), event.
- Custom events in the customer journey
- Custom entities related to the customer such as pets, wishlist, and call center record.
Success rate of 360 Profiles API
The success rate of the customer 360 Profiles API is approximately 98%.
Appendix
Appendix 1: Sample attributes in 360 profile
The following are the attributes returned in the 360 profile JSON for specific entities. Note that these could change in future. Also configurations can change the exact list returned when you invoke the API.
Transaction attributes: SourceTransactionNumber, Total, TransactionTimestamp, Type.
TransactionItem attributes: Discount, SaleRevenue, ShippingRevenue, ShipDate, Subtype (Shipped or Returned or Demand or Canceled), Type.
For each individual customer record, the attributes are: customer.lastName, customer.SourceSystemID, customer.SourceCustomerNumber, customer.Email, customer.EmailStatus.
Event attributes: event.EventTimeStamp and event.Type attributes. Additional event details are returned in the children section.
Excluded A360 response fields in the snowflake database
The following fields are not present in the Snowflake database:
rowKey: Fetches the records and debugs.rowKeyis not consumed downstream.
displayResourceKey: No direct application of this field in the Snowflakedatabase.
layout: No direct application of this field in the Snowflake database.ignore flag: No direct application of this field in the Snowflake database.
Appendix 2: Sample JSONs
JSON returned from search API
https://api7.agilone.com/v2/465/dw/a360/customers?fq=[{%22lastname%22:[%22eq%22,%22cartwright*%22],%22firstname%22:[%22eq%22,%22katey*%22]}]&limit=10&offset=0
returns:
{
"count": 3,
"_links": {
"self": {
"href": "https://api7.agilone.com/v2/465/dw/a360/customers"
},
"first": {
"href": "https://api7.agilone.com/v2/465/dw/a360/customers?offset=0&offset=0&limit=10&limit=10&fq=%5B%7B%22lastname%22:%5B%22eq%22,%22cartwright*%22%5D,%22firstname%22:%5B%22eq%22,%22katey*%22%5D%7D%5D"
},
"last": {
"href": "https://api7.agilone.com/v2/465/dw/a360/customers?offset=0&offset=0&limit=10&limit=10&fq=%5B%7B%22lastname%22:%5B%22eq%22,%22cartwright*%22%5D,%22firstname%22:%5B%22eq%22,%22katey*%22%5D%7D%5D"
}
},
"_embedded": {
"resources": [
{
"_links": {
"self": {
"href": "https://api7.agilone.com/v2/465/dw/a360/customers/FTP_CSV_1_360profile_customer_13"
}
},
"zip": "04473",
"country": "US",
"firstname": "Katey",
"address2": null,
"address1": "4 Colburn Dr",
"sourcecustomernumber": "360profile_customer_13",
"id": "FTP_CSV_1_360profile_customer_13",
"state": "ME",
"primaryphone": "2039124771",
"email": "[email protected]",
"lastname": "Cartwright"
},
{
"_links": {
"self": {
"href": "https://api7.agilone.com/v2/465/dw/a360/customers/FTP_CSV_1_360profile_customer_11"
}
},
"zip": "94043",
"country": "US",
"firstname": "Katey",
"address2": null,
"address1": "1091 N Shoreline Blvd",
"sourcecustomernumber": "360profile_customer_11",
"id": "FTP_CSV_1_360profile_customer_11",
"state": "CA",
"primaryphone": "(203) 912-4771",
"email": "[email protected]",
"lastname": "Cartwright"
},
{
"_links": {
"self": {
"href": "https://api7.agilone.com/v2/465/dw/a360/customers/FTP_CSV_1_360profile_customer_17"
}
},
"zip": "94043",
"country": "US",
"firstname": "Katey Cole",
"address2": null,
"address1": "1091 N Shoreline Blvd",
"sourcecustomernumber": "360profile_customer_17",
"id": "FTP_CSV_1_360profile_customer_17",
"state": "CA",
"primaryphone": null,
"email": "[email protected]",
"lastname": "Cartwright"
}
]
}
}
JSON returned from customer 360 Profile API
https://api7.agilone.com/v2/465/dw/a360/customers/FTP_CSV_1_360profile_customer_11?limit=25
returns:
{
"customerIds": [
"FTP_CSV_1_360profile_customer_11",
"FTP_CSV_1_360profile_customer_12",
"FTP_CSV_1_360profile_customer_13",
"FTP_CSV_1_360profile_customer_14",
"FTP_CSV_1_360profile_customer_15",
"FTP_CSV_1_360profile_customer_16",
"FTP_CSV_1_360profile_customer_17"
],
"householdCustomerIds": [
"FTP_CSV_1_360profile_customer_11"
],
"realtimeData": {},
"{\"displayResourceKey\":\"$householdSummary\",\"resource\":\"householdsummary\",\"layout\":\"customer\"}": [
{
"rowKey": " \\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF3\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_11",
"values": [
{
"udmColumn": "householdsummary.FirstTransactionDate",
"value": "1475638320000"
},
{
"udmColumn": "householdsummary.Frequency",
"value": "1.7892156862745099"
},
{
"udmColumn": "householdsummary.HouseholdID",
"value": "FTP_CSV_1_360profile_customer_11"
},
{
"udmColumn": "householdsummary.PrimaryBrand",
"value": "John Cordan"
},
{
"udmColumn": "householdsummary.PrimaryOrganization",
"value": "Physical"
},
{
"udmColumn": "householdsummary.primarystore",
"value": "Chicago store"
},
{
"udmColumn": "householdsummary.recencydays",
"value": "467"
},
{
"udmColumn": "householdsummary.State",
"value": "CT"
},
{
"udmColumn": "householdsummary.tenuredays",
"value": "1020"
},
{
"udmColumn": "householdsummary.TotalDiscount",
"value": "134"
},
{
"udmColumn": "householdsummary.TotalRevenue",
"value": "2840"
},
{
"udmColumn": "householdsummary.TotalRevenue_13_24Months",
"value": "2351"
},
{
"udmColumn": "householdsummary.TotalRevenue_Last12Months",
"value": "0"
},
{
"udmColumn": "householdsummary.TotalTransactionCount",
"value": "5"
},
{
"udmColumn": "householdsummary.TotalTransactionCount_Last12Months",
"value": "0"
},
{
"udmColumn": "householdsummary.TotalTransactionCount_Last13_24Months",
"value": "4"
},
{
"udmColumn": "householdsummary.Zipcode",
"value": "06880"
},
{
"udmColumn": "householdsummary.aovgroup",
"value": "500+"
},
{
"udmColumn": "householdsummary.LastTransactionDate",
"value": "1523414640000"
},
{
"udmColumn": "householdsummary.Address1",
"value": "17 Ferry Ln"
},
{
"udmColumn": "householdsummary.Address2",
"value": "Unknown"
},
{
"udmColumn": "householdsummary.averagediscountrate",
"value": "0-5%"
},
{
"udmColumn": "householdsummary.City",
"value": "Westport"
},
{
"udmColumn": "householdsummary.Country",
"value": "US"
}
],
"children": [],
"ignore": false
}
],
"{\"displayResourceKey\":\"$utoprecommendations\",\"resource\":\"utoprecommendations\",\"layout\":\"customer\"}": [
{
"rowKey": "\\x06\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFC\\x0E\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_11",
"values": [
{
"udmColumn": "utoprecommendations.MasterCustomerID",
"value": "FTP_CSV_1_360profile_customer_11"
}
],
"children": [
[
{
"udmColumn": "utoprecommendations.sourceproductnumber",
"value": "101203352"
},
{
"udmColumn": "utoprecommendations.ranknumber",
"value": "2"
},
{
"udmColumn": "product.name",
"value": "O handle casserole"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203352.png"
}
],
[
{
"udmColumn": "utoprecommendations.sourceproductnumber",
"value": "101203364"
},
{
"udmColumn": "utoprecommendations.ranknumber",
"value": "5"
},
{
"udmColumn": "product.name",
"value": "Caicos Sarah Maria"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203364.png"
}
],
[
{
"udmColumn": "utoprecommendations.sourceproductnumber",
"value": "101203356"
},
{
"udmColumn": "utoprecommendations.ranknumber",
"value": "4"
},
{
"udmColumn": "product.name",
"value": "Pitcher with rings"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203356.png"
}
],
[
{
"udmColumn": "utoprecommendations.sourceproductnumber",
"value": "101203358"
},
{
"udmColumn": "utoprecommendations.ranknumber",
"value": "3"
},
{
"udmColumn": "product.name",
"value": "oval serving dish glass melt"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203358.png"
}
],
[
{
"udmColumn": "utoprecommendations.sourceproductnumber",
"value": "101203362"
},
{
"udmColumn": "utoprecommendations.ranknumber",
"value": "1"
},
{
"udmColumn": "product.name",
"value": "Breakfast bundle"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203362.png"
}
]
],
"ignore": false
}
],
"{\"displayResourceKey\":\"$customerTransaction360\",\"resource\":\"transaction\",\"layout\":\"customer\"}": [
{
"rowKey": "%\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF5\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_14\\x00\\x00\\x01b\\xB2\\x96\\xA5\\x80I{\\xFA\\x18\\x82wE\\xF6LHb\\x8D\\xC0\\xC7\\xED\\x87\\xD7\\xE1\\xAD\\xBF",
"values": [
{
"udmColumn": "organization.type",
"value": "Physical"
},
{
"udmColumn": "transaction.CustomerID",
"value": "FTP_CSV_1_360profile_customer_14"
},
{
"udmColumn": "transaction.TransactionTimestamp",
"value": "1523414640000"
},
{
"udmColumn": "transaction.SourceTransactionNumber",
"value": "STORE7_20180410194400"
},
{
"udmColumn": "transaction.Total",
"value": "660"
},
{
"udmColumn": "transaction.Type",
"value": "Purchase"
}
],
"children": [
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "310"
},
{
"udmColumn": "product.Name",
"value": "Casserole dish"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203346"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Steve Arleo"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "25"
},
{
"udmColumn": "transactionitem.Discount",
"value": "20"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1523760240000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203346.png"
},
{
"udmColumn": "product.ID",
"value": "101203346"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203346.png"
},
{
"udmColumn": "product.Name",
"value": "Casserole dish"
},
{
"udmColumn": "product.BrandName",
"value": "Steve Arleo"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "260"
},
{
"udmColumn": "product.Name",
"value": "U handle coffee jar"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203354"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Steve Arleo"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "10"
},
{
"udmColumn": "transactionitem.Discount",
"value": "50"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1523760240000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203354.png"
},
{
"udmColumn": "product.ID",
"value": "101203354"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203354.png"
},
{
"udmColumn": "product.Name",
"value": "U handle coffee jar"
},
{
"udmColumn": "product.BrandName",
"value": "Steve Arleo"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "90"
},
{
"udmColumn": "product.Name",
"value": "Pencil drawn goat"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203365"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "10"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1523760240000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203365.png"
},
{
"udmColumn": "product.ID",
"value": "101203365"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203365.png"
},
{
"udmColumn": "product.Name",
"value": "Pencil drawn goat"
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
}
]
],
"ignore": false
},
{
"rowKey": "\"\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF5\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_11\\x00\\x00\\x01^\\xE5\\xC9y\\xE0$\\xFB\\xE1p\\x02\\xDA\\x13;VN\\x89\\x87x\\xB1c&\\xABvB\\x8A",
"values": [
{
"udmColumn": "organization.type",
"value": "Digital"
},
{
"udmColumn": "transaction.CustomerID",
"value": "FTP_CSV_1_360profile_customer_11"
},
{
"udmColumn": "transaction.TransactionTimestamp",
"value": "1507093740000"
},
{
"udmColumn": "transaction.SourceTransactionNumber",
"value": "9271969057"
},
{
"udmColumn": "transaction.Total",
"value": "1460"
},
{
"udmColumn": "transaction.Type",
"value": "Purchase"
}
],
"children": [
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "360"
},
{
"udmColumn": "product.Name",
"value": "round serving dish with melted glass"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203360"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Bryce Conlon"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "10"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1507363680000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203360.png"
},
{
"udmColumn": "product.ID",
"value": "101203360"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203360.png"
},
{
"udmColumn": "product.Name",
"value": "round serving dish with melted glass"
},
{
"udmColumn": "product.BrandName",
"value": "Bryce Conlon"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Returned"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "350"
},
{
"udmColumn": "product.Name",
"value": "Blue pasta bowl"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203357"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "0"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1507602120000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203357.png"
},
{
"udmColumn": "product.ID",
"value": "101203357"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203357.png"
},
{
"udmColumn": "product.Name",
"value": "Blue pasta bowl"
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "360"
},
{
"udmColumn": "product.Name",
"value": "puck handle blue casserole"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203361"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "0"
},
{
"udmColumn": "transactionitem.Discount",
"value": "17"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1507363680000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203361.png"
},
{
"udmColumn": "product.ID",
"value": "101203361"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203361.png"
},
{
"udmColumn": "product.Name",
"value": "puck handle blue casserole"
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "90"
},
{
"udmColumn": "product.Name",
"value": "Pitcher with rings"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203356"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "0"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1507363680000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203356.png"
},
{
"udmColumn": "product.ID",
"value": "101203356"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203356.png"
},
{
"udmColumn": "product.Name",
"value": "Pitcher with rings"
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Returned"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "300"
},
{
"udmColumn": "product.Name",
"value": "Caicos Sarah Maria"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203364"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "-5"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1507602120000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203364.png"
},
{
"udmColumn": "product.ID",
"value": "101203364"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203364.png"
},
{
"udmColumn": "product.Name",
"value": "Caicos Sarah Maria"
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
}
]
],
"ignore": false
},
{
"rowKey": "$\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF5\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_13\\x00\\x00\\x01^I\\xBF/\\xE0\\x11\\xC3\\x0B0\\x8Ed\\xC4f\\x84\\x06)N\\xAC\\xAE\\x142d\\x95\\xF1\\xE0",
"values": [
{
"udmColumn": "organization.type",
"value": "Physical"
},
{
"udmColumn": "transaction.CustomerID",
"value": "FTP_CSV_1_360profile_customer_13"
},
{
"udmColumn": "transaction.TransactionTimestamp",
"value": "1504475820000"
},
{
"udmColumn": "transaction.SourceTransactionNumber",
"value": "STORE1_20170903145700"
},
{
"udmColumn": "transaction.Total",
"value": "46"
},
{
"udmColumn": "transaction.Type",
"value": "Purchase"
}
],
"children": [
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "46"
},
{
"udmColumn": "product.Name",
"value": "Celadon salt pig"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203343"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "0"
},
{
"udmColumn": "transactionitem.Discount",
"value": "7"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1504801200000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203343.png"
},
{
"udmColumn": "product.ID",
"value": "101203343"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203343.png"
},
{
"udmColumn": "product.Name",
"value": "Celadon salt pig"
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
}
]
],
"ignore": false
},
{
"rowKey": "$\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF5\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_13\\x00\\x00\\x01]\\xBD\\xE1\\xD4\\x00 ?\\x8F\\x00\\xE8\\xE9$*(\\xAB\\xDF\\xA2s\\xC4_\\xE6|\\xE7K1",
"values": [
{
"udmColumn": "organization.type",
"value": "Physical"
},
{
"udmColumn": "transaction.CustomerID",
"value": "FTP_CSV_1_360profile_customer_13"
},
{
"udmColumn": "transaction.TransactionTimestamp",
"value": "1502129280000"
},
{
"udmColumn": "transaction.SourceTransactionNumber",
"value": "STORE1_20170807110800"
},
{
"udmColumn": "transaction.Total",
"value": "185"
},
{
"udmColumn": "transaction.Type",
"value": "Purchase"
}
],
"children": [
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "120"
},
{
"udmColumn": "product.Name",
"value": "puck handle casserole"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203355"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "David Paige"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "0"
},
{
"udmColumn": "transactionitem.Discount",
"value": "25"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1502520300000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203355.png"
},
{
"udmColumn": "product.ID",
"value": "101203355"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203355.png"
},
{
"udmColumn": "product.Name",
"value": "puck handle casserole"
},
{
"udmColumn": "product.BrandName",
"value": "David Paige"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "65"
},
{
"udmColumn": "product.Name",
"value": "Ottoman pantry"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203342"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "0"
},
{
"udmColumn": "transactionitem.Discount",
"value": "5"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1502520300000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203342.png"
},
{
"udmColumn": "product.ID",
"value": "101203342"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203342.png"
},
{
"udmColumn": "product.Name",
"value": "Ottoman pantry"
},
{
"udmColumn": "product.BrandName",
"value": "Sarah McConnell"
}
]
],
"ignore": false
},
{
"rowKey": "\"\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF5\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_11\\x00\\x00\\x01W\\x92\\xE5\\xDB\\x80\\xFA\\xDFJ\\xC6\\xEC\\x95\\xA6\\x99\\xD8h\\x82\\xCC\\xA2\\xCB\\xA8\\xE5\\xC2\\x02>\\x11",
"values": [
{
"udmColumn": "transaction.c_pickup_instore",
"value": "N"
},
{
"udmColumn": "transaction.c_dropship",
"value": "N"
},
{
"udmColumn": "organization.type",
"value": "Digital"
},
{
"udmColumn": "transaction.CustomerID",
"value": "FTP_CSV_1_360profile_customer_11"
},
{
"udmColumn": "transaction.TransactionTimestamp",
"value": "1475638320000"
},
{
"udmColumn": "transaction.SourceTransactionNumber",
"value": "9271969019"
},
{
"udmColumn": "transaction.Total",
"value": "489"
},
{
"udmColumn": "transaction.Type",
"value": "Purchase"
}
],
"children": [
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "120"
},
{
"udmColumn": "product.Name",
"value": "Floating blue bowl"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203344"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "15"
},
{
"udmColumn": "transactionitem.Discount",
"value": "10"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1475930280000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203344.png"
},
{
"udmColumn": "product.ID",
"value": "101203344"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203344.png"
},
{
"udmColumn": "product.Name",
"value": "Floating blue bowl"
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "199"
},
{
"udmColumn": "product.Name",
"value": "sake cup"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203348"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "5"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1475930280000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203348.png"
},
{
"udmColumn": "product.ID",
"value": "101203348"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203348.png"
},
{
"udmColumn": "product.Name",
"value": "sake cup"
},
{
"udmColumn": "product.BrandName",
"value": "John Cordan"
}
],
[
{
"udmColumn": "transactionitem.Type",
"value": "Purchase"
},
{
"udmColumn": "transactionitem.Subtype",
"value": "Shipped"
},
{
"udmColumn": "transactionitem.SaleRevenue",
"value": "170"
},
{
"udmColumn": "product.Name",
"value": "O handle casserole"
},
{
"udmColumn": "product.SourceProductNumber",
"value": "101203352"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.BrandName",
"value": "Bryce Conlon"
},
{
"udmColumn": "transactionitem.ShippingRevenue",
"value": "5"
},
{
"udmColumn": "transactionitem.Discount",
"value": "0"
},
{
"udmColumn": "transactionitem.ShipDate",
"value": "1475930280000"
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203352.png"
},
{
"udmColumn": "product.ID",
"value": "101203352"
},
{
"udmColumn": "product.ProductURL",
"value": null
},
{
"udmColumn": "product.ImageURL",
"value": "https://agilone.github.io/images-product/demo/101203352.png"
},
{
"udmColumn": "product.Name",
"value": "O handle casserole"
},
{
"udmColumn": "product.BrandName",
"value": "Bryce Conlon"
}
]
],
"ignore": false
}
],
"{\"displayResourceKey\":\"$customersummaryAttributes\",\"resource\":\"customersummary\",\"layout\":\"customer\"}": [
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF4\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_11",
"values": [
{
"udmColumn": "customersummary.Address2",
"value": "Unknown"
},
{
"udmColumn": "customersummary.Country",
"value": "US"
},
{
"udmColumn": "customersummary.ZipCode",
"value": "06880"
},
{
"udmColumn": "customersummary.State",
"value": "CT"
},
{
"udmColumn": "customersummary.City",
"value": "Westport"
},
{
"udmColumn": "customersummary.EmailStatus",
"value": "V"
},
{
"udmColumn": "customersummary.AddressCertified",
"value": "true"
},
{
"udmColumn": "customersummary.email",
"value": "[email protected]"
},
{
"udmColumn": "customersummary.Preferences",
"value": "DNE=N"
},
{
"udmColumn": "customersummary.PrimaryPhone",
"value": "(203) 912-4771"
},
{
"udmColumn": "customersummary.Gender",
"value": "Female"
},
{
"udmColumn": "customersummary.MasterCustomerID",
"value": "FTP_CSV_1_360profile_customer_11"
},
{
"udmColumn": "customersummary.averagediscountrate",
"value": "0-5%"
},
{
"udmColumn": "customersummary.frequencygroup",
"value": "2 - 3 orders/year"
},
{
"udmColumn": "customersummary.TotalRevenue_Last12Months",
"value": "0"
},
{
"udmColumn": "customersummary.TotalRevenue_Last13_24Months",
"value": "2351"
},
{
"udmColumn": "customersummary.TotalTransactionCount_Last12Months",
"value": "0"
},
{
"udmColumn": "customersummary.TotalTransactionCount_Last13_24Months",
"value": "4"
},
{
"udmColumn": "customersummary.primarystore",
"value": "Chicago store"
},
{
"udmColumn": "customersummary.FirstName",
"value": "Katey"
},
{
"udmColumn": "customersummary.closeststore",
"value": "Unknown"
},
{
"udmColumn": "customersummary.TotalVisitCount31_60Days",
"value": "3"
},
{
"udmColumn": "customersummary.TotalClickCountLast30Days",
"value": "1"
},
{
"udmColumn": "customersummary.TotalClickCount31_60Days",
"value": "1"
},
{
"udmColumn": "customersummary.TotalOpenCountLast30Days",
"value": "2"
},
{
"udmColumn": "customersummary.TotalOpenCount31_60Days",
"value": "2"
},
{
"udmColumn": "customersummary.TotalVisitCountLast30Days",
"value": "37"
},
{
"udmColumn": "customersummary.TotalTransactionCount",
"value": "5"
},
{
"udmColumn": "customersummary.totaltransactioncountgroup",
"value": "5"
},
{
"udmColumn": "customersummary.PrimaryOrganization",
"value": "Physical"
},
{
"udmColumn": "customersummary.LastName",
"value": "Cartwright"
},
{
"udmColumn": "customersummary.TotalSendCountLast30Days",
"value": "2"
},
{
"udmColumn": "customersummary.TotalSendCount31_60Days",
"value": "2"
},
{
"udmColumn": "customersummary.aovgroup",
"value": "500+"
},
{
"udmColumn": "customersummary.c_preferred_sales_associate",
"value": ""
},
{
"udmColumn": "customersummary.c_loyalty_level",
"value": "Silver"
},
{
"udmColumn": "customersummary.c_loyalty_points",
"value": "2468"
},
{
"udmColumn": "customersummary.DoNotCall",
"value": "Y"
},
{
"udmColumn": "customersummary.TotalRevenue",
"value": "2840"
},
{
"udmColumn": "customersummary.DoNotEmail",
"value": "N"
},
{
"udmColumn": "customersummary.DoNotMail",
"value": "N"
},
{
"udmColumn": "customersummary.DoNotText",
"value": "Unknown"
},
{
"udmColumn": "ml_out_mc_likelihood_lte_a.Probability",
"value": "0.2"
},
{
"udmColumn": "ml_out_mc_likelihood_lte_a.Decile",
"value": "8"
},
{
"udmColumn": "ml_out_mc_likelihood_lte_a.Value",
"value": "01 - High"
},
{
"udmColumn": "ml_out_mc_likelihood_lte_a.PartitionColumn",
"value": "201903"
},
{
"udmColumn": "customersummary.MiddleName",
"value": "Unknown"
},
{
"udmColumn": "customersummary.FirstTransactionDate",
"value": "1475638320000"
},
{
"udmColumn": "customersummary.Tenuredays",
"value": "1020"
},
{
"udmColumn": "customersummary.Address1",
"value": "17 Ferry Ln"
}
],
"children": [],
"ignore": false
}
],
"{\"displayResourceKey\":\"$customerJourney\",\"resource\":\"event\",\"layout\":\"customer\"}": [
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01l\\x15\\xCC4@c\\xAF\\xAAQ\\xA7_c4<\\xA7\\xB3\\xE0\\xE8\\xDE\\xAEFC\\x15\\x19\\x8F",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563733800000"
},
{
"udmColumn": "event.Type",
"value": "cortexDiscovery"
},
{
"udmColumn": "event.Subtype",
"value": "Recommended a high inventory product"
},
{
"udmColumn": "product.Name",
"value": "oval serving dish glass melt"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203358"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01l\\x10\\xA5\\xD8@\\xB2\\xC0\\xB9M\\xA9\\x15\\xABuf\\xD1\\xCD\\x18\\xAB\\xF4~\\x9E\\xFC\\xF4\\xEB\\x9F",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563647400000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "Blue pasta bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203357"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01l\\x0B\\x7F|@38q\\x92\\xF7.\\x8F\\xAF\\x8A\\x81\\xCC\\x9Dq\\xBF\\x82\\xF4\\x87\\xA8\\xE4\\xBB",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563561000000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "Caicos Sarah Maria"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203364"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01l\\x06Y @\\xD1_\\x9C\\xEFW\\xD7\\xB8\\xC24nbj\\xDF\\xFB\\xE39\\x8D\\x0A\\xF2\\x93",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563474600000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "round serving dish with melted glass"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203360"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01l\\x012\\xC4@o$\\x1D\\xF1x\\xFEM\\x85\\xDEw\\xC0\\xFEi\\x99\\xE5\\xA4K(\\x19\\xD3",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563388200000"
},
{
"udmColumn": "event.Type",
"value": "survey"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xFC\\x0Ch@x \\xA8\\x1B$\\x83\\x07G6H\\xA1\\x9D\\xF9e\\xD4\\xE3]\\xB7\\x87\\x8B",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563301800000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "Floating blue bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203344"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xF6\\xE6\\x0C@\\xC3\\x8C\\xE7\\xC3B&8\\xA9\\xA3k71\\x1F\\x1D\\xD0v\\x1A\\xD5\\xCC\\xF1",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563215400000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "Floating blue bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203344"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xF1\\xBF\\xB0@\\xB4(i\\xADH\\x1Ah\\xB4\\xEEaz\\xC2\\xC8H\\x04\\x9F\\xE1\\xF3\\x1Aj",
"values": [
{
"udmColumn": "event.c_supportcall_topic",
"value": "Defective product"
},
{
"udmColumn": "event.c_supportcall_representative",
"value": "Maria Gordon"
},
{
"udmColumn": "event.c_supportcall_status",
"value": "resolved"
},
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563129000000"
},
{
"udmColumn": "event.Type",
"value": "supportCall"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xEC\\x99T@\\xAA\\xBA\\x00\\x10\\xB37\\xFB?\\xEA\\xB28\\xBET\\x13\\xD5\\xFFi'\\x9D\\xBF",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1563042600000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "sake cup"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203348"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xE7r\\xF8@t\\xA8\\xBB\\xD9\\xA9'z\\x98\\xE04\\xC3\\xD8=\\xB3\\xBCCB\\xE1\\x9E{",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562956200000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "sake cup"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203348"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xE2L\\x9C@\\x9F:\\x07\\x98\\x98^\\x93\\xCE\\x89\\xAB\\xAA\\xC5\\x8C%\\xEA&\\x99\\xD5k\\xE5",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562869800000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "O handle casserole"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203352"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xDD&@@\\xFD6p9\\xD0\\x5C,G\\xC1\\x88\\xAF\\x02\\x14\\x0D\\x87\\x08\\xAC\\xEE,\\xB0",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562783400000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "O handle casserole"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203352"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xD7\\xFF\\xE4@B\\x9E\\xC0\\xFC\\xB5\\x9F\\x11\\xDD\\xCF\\xDB\\xB6_\\x5C\\xADDe:\\xB8\\xF4_",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562697000000"
},
{
"udmColumn": "event.Type",
"value": "checkout"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xD2\\xD9\\x88@\\xCE\\xC9\\xE1\\x17\\xAB}\\xBA\\x03\\x0FR\\xE0Q|T\\xBBh\\x9D\\xBE\\xCBq",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562610600000"
},
{
"udmColumn": "event.Type",
"value": "event"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xCD\\xB3,@\\x13e\\xAA\\xE5\\xFAqP*\\x99&\\xB8\\xD7\\x9C\\xBC\\xD6z\\x5C&\\xA9n",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562524200000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "Pitcher with rings"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203356"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC8\\x8C\\xD0@/\\xC1\\x06O|4-\\xBE\\x0EP9\\x1B\\xD4\\xA3pl\\xA5b0\\xB7",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562437800000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "Pitcher with rings"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203356"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC8n\\x11(7\\xE7\\xED\\x83\\x15\\xE7Y\\xB4\\xF6\\xE1\\x91\\x17KH\\xF0\\x95wh\"S",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562435785000"
},
{
"udmColumn": "event.Type",
"value": "cortexDiscovery"
},
{
"udmColumn": "event.Subtype",
"value": "Recommended a high inventory product"
},
{
"udmColumn": "product.Name",
"value": "oval serving dish glass melt"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203358"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC3ft@|7_p\\x89\\xE2\\xD5\\x03\\x09<\\x094\\x97H\\x00{S\\x1C\\xD7\\x06",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562351400000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "Blue pasta bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203357"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC3c,h\\xD1\\xE5\\x1D\\xE1\\xC3\\xD8\\xE79\\xE9\\xFC\\xD9\\xE4\\xF1\\xCA\\x02\\x90\\xBF+\\xD2\\x97",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562351185000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "Blue pasta bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203357"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC3bB\\x08\\x18\\x9E\\xE9JI\\x7Fv\\x83`\\x92\\xA4\\xAB\\x0D\\xE6\\x08\\x9B>\\x0B\\x15G",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562351125000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "Caicos Sarah Maria"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203364"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC3]\\xAE(E\\x9FMX\\x93\\x19\\xAB{\\xD2T6\\xD1\\x9B?GV \\xDCB\\x16",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562350825000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "round serving dish with melted glass"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203360"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC3[\\xD9h\\x9F\\x97\\xC1@$\\x14!\\xA8\\x87\\xDD\\x01\\x93z\\xB5\\xEE*\\xDB\\xD2S\\xE8",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562350705000"
},
{
"udmColumn": "event.Type",
"value": "productBrowsed"
},
{
"udmColumn": "product.Name",
"value": "Floating blue bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203344"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xC3Y\\x1AHS\\x14\\xC2\\xFC\\xDF\\x8B\\x0D\\xF8d\\xBAW\\x09\\xC1\\xDF\\x08\\xFB\\x13\\x1C\\xF1\\x99",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562350525000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "Floating blue bowl"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203344"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xBE@\\x18@\\x12\\x0A\\x09t\\xAFPhL\\x8D\\x05\\xEAG\\x10BUK\\xBCH\\xC4p",
"values": [
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562265000000"
},
{
"udmColumn": "event.Type",
"value": "cartUpdated"
},
{
"udmColumn": "product.Name",
"value": "puck handle blue casserole"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": "101203361"
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xEF\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16\\x00\\x00\\x01k\\xBE)\\x96\\x88U;\\xBA\\xB2p\\x96Z\\xA1\\xFD?\\x91\\x1B\\x82\\xFC\\x12\\xFB.\\x0F\\x9E\\xA6",
"values": [
{
"udmColumn": "event.c_supportcall_topic",
"value": "Defective product"
},
{
"udmColumn": "event.c_supportcall_representative",
"value": "Maria Gordon"
},
{
"udmColumn": "event.c_supportcall_status",
"value": "resolved"
},
{
"udmColumn": "event.CustomerID",
"value": "FTP_CSV_1_360profile_customer_16"
},
{
"udmColumn": "event.EventTimeStamp",
"value": "1562263525000"
},
{
"udmColumn": "event.Type",
"value": "supportCall"
}
],
"children": [
[
{
"udmColumn": "event.SourceProductNumber",
"value": null
}
]
],
"ignore": false
}
],
"{\"displayResourceKey\":\"$customer\",\"resource\":\"customer\",\"layout\":\"customer\"}": [
{
"rowKey": "\\x1F\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_11",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1538087350063"
},
{
"udmColumn": "customer.DoNotEmail",
"value": "N"
},
{
"udmColumn": "customer.DoNotMail",
"value": "N"
},
{
"udmColumn": "customer.DoNotCall",
"value": "Y"
},
{
"udmColumn": "customer.FirstName",
"value": "Katey"
},
{
"udmColumn": "customer.LastName",
"value": "Cartwright"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_11"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
},
{
"udmColumn": "customer.BirthDate",
"value": "575280000000"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": "1091 N Shoreline Blvd"
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": "US"
},
{
"udmColumn": "address.Zip",
"value": "94043"
},
{
"udmColumn": "address.State",
"value": "CA"
},
{
"udmColumn": "address.City",
"value": "Mountain View"
},
{
"udmColumn": "address.Certified",
"value": "true"
},
{
"udmColumn": "address.Name",
"value": null
}
],
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": "17 Ferry Ln"
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": "US"
},
{
"udmColumn": "address.Zip",
"value": "06880"
},
{
"udmColumn": "address.State",
"value": "CT"
},
{
"udmColumn": "address.City",
"value": "Westport"
},
{
"udmColumn": "address.Certified",
"value": "true"
},
{
"udmColumn": "address.Name",
"value": "Home"
}
],
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": "87 Irving Ave"
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": "US"
},
{
"udmColumn": "address.Zip",
"value": "02906"
},
{
"udmColumn": "address.State",
"value": "RI"
},
{
"udmColumn": "address.City",
"value": "Providence"
},
{
"udmColumn": "address.Certified",
"value": "true"
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": " \\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_12",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1538087350063"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_12"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": null
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": null
},
{
"udmColumn": "address.Zip",
"value": null
},
{
"udmColumn": "address.State",
"value": null
},
{
"udmColumn": "address.City",
"value": null
},
{
"udmColumn": "address.Certified",
"value": null
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "!\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_13",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1538087350063"
},
{
"udmColumn": "customer.DoNotCall",
"value": "Y"
},
{
"udmColumn": "customer.FirstName",
"value": "Katey"
},
{
"udmColumn": "customer.LastName",
"value": "Cartwright"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_13"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": "4 Colburn Dr"
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": "US"
},
{
"udmColumn": "address.Zip",
"value": "04473"
},
{
"udmColumn": "address.State",
"value": "ME"
},
{
"udmColumn": "address.City",
"value": "Orono"
},
{
"udmColumn": "address.Certified",
"value": "true"
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "\"\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_14",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1538087350063"
},
{
"udmColumn": "customer.DoNotEmail",
"value": "N"
},
{
"udmColumn": "customer.FirstName",
"value": "Katie"
},
{
"udmColumn": "customer.LastName",
"value": "Cartright"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_14"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": null
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": null
},
{
"udmColumn": "address.Zip",
"value": null
},
{
"udmColumn": "address.State",
"value": null
},
{
"udmColumn": "address.City",
"value": null
},
{
"udmColumn": "address.Certified",
"value": null
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "#\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_15",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1538087350063"
},
{
"udmColumn": "customer.DoNotMail",
"value": "N"
},
{
"udmColumn": "customer.FirstName",
"value": "Kate"
},
{
"udmColumn": "customer.LastName",
"value": "Cartwright"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_15"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": null
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": null
},
{
"udmColumn": "address.Zip",
"value": null
},
{
"udmColumn": "address.State",
"value": null
},
{
"udmColumn": "address.City",
"value": null
},
{
"udmColumn": "address.Certified",
"value": null
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "$\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_16",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1538087350063"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_16"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": null
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": null
},
{
"udmColumn": "address.Zip",
"value": null
},
{
"udmColumn": "address.State",
"value": null
},
{
"udmColumn": "address.City",
"value": null
},
{
"udmColumn": "address.Certified",
"value": null
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
},
{
"rowKey": "%\\x00\\x00\\x01\\xD1\\xFF\\xFF\\xFF\\xF2\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x01FTP_CSV_1_360profile_customer_17",
"values": [
{
"udmColumn": "customer.RowModified",
"value": "1558431306120"
},
{
"udmColumn": "customer.DoNotMail",
"value": "Y"
},
{
"udmColumn": "customer.FirstName",
"value": "Katey Cole"
},
{
"udmColumn": "customer.LastName",
"value": "Cartwright"
},
{
"udmColumn": "customer.SourceSystemID",
"value": "FTP_CSV_1"
},
{
"udmColumn": "customer.SourceCustomerNumber",
"value": "360profile_customer_17"
},
{
"udmColumn": "customer.Email",
"value": "[email protected]"
},
{
"udmColumn": "customer.EmailStatus",
"value": "V"
}
],
"children": [
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": "17 Ferry Ln"
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": "US"
},
{
"udmColumn": "address.Zip",
"value": "06880"
},
{
"udmColumn": "address.State",
"value": "CT"
},
{
"udmColumn": "address.City",
"value": "Westport"
},
{
"udmColumn": "address.Certified",
"value": "true"
},
{
"udmColumn": "address.Name",
"value": null
}
],
[
{
"udmColumn": "customeraddressxref.DeleteFlag",
"value": null
},
{
"udmColumn": "address.Address1",
"value": "1091 N Shoreline Blvd"
},
{
"udmColumn": "address.Address2",
"value": null
},
{
"udmColumn": "address.Country",
"value": "US"
},
{
"udmColumn": "address.Zip",
"value": "94043"
},
{
"udmColumn": "address.State",
"value": "CA"
},
{
"udmColumn": "address.City",
"value": "Mountain View"
},
{
"udmColumn": "address.Certified",
"value": "true"
},
{
"udmColumn": "address.Name",
"value": null
}
]
],
"ignore": false
}
]
}