Acquia CDP
Customer 360 Profiles API
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:
Acquia CDPapplication or json0The following are the best practices for a smooth integration:
fields parameter to only fetch the resources that you needThe following sections specify the requirements of the 360 Customer Profile API.
Before integrating with CDP’s 360 Profiles APIs, you must request the following values or variables from your implementation consultant:
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 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 Integration management.
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:
HTTPS GET request method.HTTP Basic Auth mechanism (base64 encoded).application or json.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:
HTTPS POST request method.HTTP Basic Auth mechanism (base64 encoded).application or json.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:
application or json0By 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.
Customer records can be retrieved by an attributes specific search. For example, you can search for customer records with the John* pattern in the first name and Smith* in the last name.
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?fq=<attribute-value patterns> (HTTP Get operation)
CDP supports the following attributes in the search:
Example:
https://<environmentSubdomain2>.agilone.com/v2/<tenantId>/dw/a360/customers?fq=[{"lastName":["eq","smith*"],"firstName":["eq","john*"]}]
If you are using a GCP cluster to make the API call, the search results can display an unwanted port value in the customer profile URL. If you face such an issue, send Key and Value as X-Forwarded-Port and 443 respectively in the request payload.
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.
The API supports the following parameters:
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:
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>
}The API supports the following parameters:
?limit=<what you want> to your request URL? fields=["customersummary","transaction"] to your request URL. The resource options includes: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.
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.
}]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>}
]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>
}],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>The following are the return codes on the response:
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:
The success rate of the customer 360 Profiles API is approximately 98%.
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.
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.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"
}
]
}
}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
}
]
}If this content did not answer your questions, try searching or contacting our support team for further assistance.
If this content did not answer your questions, try searching or contacting our support team for further assistance.