Acquia CDP

Customer 360 Profiles API

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 application or json

  • 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 fields parameter 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.

Client user credentials (Authorization)

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

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:

  1. Use the HTTPS GET request method.

  2. Enter your username and password through the HTTP Basic Auth mechanism (base64 encoded).

  3. Ensure that:

    • Content-Type is set to application or json.

    • Content-Length is set to 0.

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:

  1. Use the HTTPS POST request method.

  2. Enter your username and password through the HTTP Basic Auth mechanism (base64 encoded).

  3. Ensure that:

    • Content-Type is set to application or json.

    • Content-Length is set to 0.

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: application or json

  • 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.

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. rowKey is not consumed downstream.

  • displayResourceKey: No direct application of this field in the Snowflake

    database.

  • 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
}
]
}