Information for: DEVELOPERS   PARTNERS   SUPPORT

Customer 360 Profiles API Documentation

Introduction

Customer Data Platform (CDP) integrates all your customer data, processes the ingested customer records, standardize these individual customer records and de-dupes the records into a single master customer record, utilizing exact and fuzzy matching techniques. CDP links all customer activities into this single customer profile, and enhances the profile with behavioral and predictive analytics. This is collectively referred to as the “360 degree profile of a customer” and gives you a single customer record that you can leverage for all your marketing activities and customer interaction.

The CDP 360 Profile API is secure REST API to search and find specific customers, and to access this 360 degree profile of the customer. The search API queries the data from the individual customer records, and for each search result, there is a link to the 360 profile of that customer. The 360 API is built to be configurable to meet unique business needs of our clients. See below for further details.

For all APIs please specify Content-Type as application/json and the content-length as 0.

Best Practices

Here are some best practices to insure a smooth integration. When possible, please:

  • 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, specify the “fields” parameter to only fetch the resources that you need

Requirements

Subdomains

Before you can integrate with CDP’s 360 Profiles APIs you need to request the following values/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

Examples 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 Client Success Manager.

Client user credentials (Authorization)

Client users or system users require appropriate 360 read role or permissions to invoke the 360 APIs. For information about how to provision a 360 client user, see the Before you begin section of Self-service integration.

Authentication via Access Tokens

The first step to access any API from CDP is to retrieve an access token by invoking the authentication API. First attempt to fetch an existing active token via a GET request to:

https://<environmentSubdomain1>.agilone.com/token

Use the HTTPS GET request method, and pass your Username and Password via HTTP Basic Auth mechanism (base64 encoded). The Content-Type is application/json and the content-length should be 0. If no existing tokens are available, then login via a POST request to:

https://<environmentSubdomain1>.agilone.com/authentication?action=login

Use the HTTPS POST request method, and again pass your Username and Password via HTTP Basic Auth mechanism (base64 encoded). The Content-Type is application/ json and the content-length should be 0.

In both instances, the response json includes the “access_token” with “token_type as bearer”. This is the bearer token that you must pass with all subsequent 360 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: application/json
  • Content-Length: 0

A single client user is limited to 10 tokens by default. If a client user is being shared across several human users, then each concurrent session that shares the same client user should share the same bearer token. Do not log in and instantiate a new bearer token for each concurrent read session because this will cause 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 and the primary address attributes (address1, address2, zip, state, country).

We support two mechanisms for search - keyword search and attribute specific search. The results are always ranked by relevance based on the search criteria.

Search Results

Each result returned in the JSON includes a link to access the 360 profile of that customer along with select attributes for that record to help identify the customer you are looking for.  For example, these attributes included in the response can be shown as a preview of those records in the results shown in a UI, without having to get the full individual records.

When the results are a longer list the API will paginate 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.

Important

If you’re using GCP cluster to make the API call, the search results might display an unwanted port value in customer profile URL. If you face such an issue, send Key and Value as X-Forwarded-Port and 443 respectively in the request payload.

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 a later section below.

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 - the offset allows you to paginate through the child customer records returned in the response. The default offset is 0. If 40 records are returned (e.g. a limit is not specified and the search matches >40 records), then to review the next 40 records you should set the offset to 40.

360 Customer Profile 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 details of the 360 profile of a customer which includes:

  1. Customer Summary Attributes
  2. Details of Transaction made by that customer
  3. Events related to that customer showcasing the customer journey
  4. Individual customer record details (the customer records that were de-duped into this master customer record)
  5. Household Summary

In addition to this standard functionality, tenant-specific configurations can tailor this to your unique business needs. See the section below for more details on what can be added via 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

Example syntax snippet is below:

  {
"_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. Per resource the default limit is 40 objects to be returned, however you can alter this behavior with the limit parameter. For example, if you want more events than the default 40 events to be returned, then 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 which resources you would like returned. For example, if you want just the master customer profile and transactions to be returned, then you can append “? fields=[“customersummary”,”transaction”]” to your request URL. The resource options include:
    • customersummary
    • customer
    • transaction
    • event
    • household
    • utoprecommendations

Customer summary (master customer) attributes

Customer summary attributes returned in the JSON include basic profile attributes, preferences including opt-in/opt-out info 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, and you can refer to the Actions documentation for more details on what each attribute means.

  1. Customer Name (customersummary.FirstName, customersummary.LastName, customersummary.MiddleName)
  2. customersummary.Gender
  3. Customersummary.email
  4. customersummary.EmailStatus
  5. customersummary.MasterCustomerID //Internal to CDP, the id of the de-duped master customer record
  6. The primary address of the customer (customersummary.Address1, customersummary.Address2, customersummary.City, customersummary.State, customersummary.Country, customersummary.ZipCode)
  7. customersummary.AddressCertified
  8. ustomersummary.PrimaryPhone
  9. customersummary.MobilePhone
  10. customersummary.averagediscountrate
  11. customersummary.closeststore
  12. customersummary.FirstTransactionDate
  13. customersummary.frequency
  14. customersummary.Preferences //This includes the DNE, DNM flags for opt-in info.
  15. customersummary.primarystore
  16. customersummary.primaryOrganization
  17. customersummary.Tenuredays
  18. customersummary.TotalClickCount31_60Days
  19. customersummary.TotalClickCountLast30Days
  20. customersummary.TotalOpenCount31_60Days
  21. customersummary.TotalOpenCountLast30Days
  22. customersummary.TotalSendCount31_60Days
  23. customersummary.TotalSendCountLast30Days
  24. customersummary.TotalRevenue
  25. customersummary.TotalRevenue_Last12Months
  26. customersummary.TotalRevenue_Last13_24Months
  27. customersummary.TotalTransactionCount
  28. customersummary.TotalTransactionCount_Last12Months
  29. customersummary.TotalTransactionCount_Last13_24Months
  30. customersummary.TotalVisitCount31_60Days
  31. customersummary.TotalVisitCountLast30Days

Example syntax snippet in the returned JSON for customer summary attributes below:

"{\"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 as well as the related transaction items. Note that these are the transactions across all channels (web and store).

See Appendix below for the attributes included in the Transaction and TransactionItem.

Additional configurations can be done so that other transaction and transaction item attributes are returned - see the configuration section below for details.

Example Syntax Snippet is below:

  {\"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 may send.

Note that transactions are in the separate transactions section of the JSON (see above) and are not included in the events section.

For example, on the product browsed event, children section includes the sourceProductNumber of the products browsed. On the email events, the message name is included in the details.

Example Syntax Snippet is below:

  "{\"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 info 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.

Example Syntax Snippet is below:

  ""{\"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 operations team.
  • 200: Successful call.

Additional Configuration Options

The 360 API is built to be configurable to meet the unique business needs of all CDP clients. Contact your Customer Success Manager for further details. The following are some of the supported customizations:

  1. Household details
  2. Product recommendations (user to product recommendations)
  3. Cross-brand customer details (master customer group summary)
  4. Custom attributes on customer summary, transaction (item), event.
  5. Custom events in the customer journey
  6. Custom entities related to the customer (pets, wishlist, call center record)

Appendix

Appendix 1: Sample attributes in 360 profile

Below are some of 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 Cancelled), 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.

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 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\\[email protected]\\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\\[email protected]\\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\\[email protected]$\\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\\[email protected] \\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\\[email protected]\\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\\[email protected]\\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\\[email protected]\\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\\[email protected]\\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\\[email protected]\\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\\[email protected]\\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\\[email protected]\\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\\[email protected]/\\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\\[email protected]|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\\[email protected]$\\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\\[email protected]\\[email protected]\\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
}
]
}