{"info":{"_postman_id":"b7c8120a-504a-492e-95b1-565343da0fe6","name":"Datitude Data API","description":"

The following documentation gives examples on how to use the Datitude Data API.

The provided examples show's and example for each of the possible functions of the API

Authorization is provided using Basic authentication headers which are generated from a supplied username and API key. To get your username and API key created please contact support: support@datitude.co.uk

The data fields of the Data API:

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field Name	Purpose
customer_id	The ID of the Customer in the Datitude Platform
email	The Customer emails address
title	The Customers Title
first_name	The Customers First Name
last_name	The Customers Last Name
home_telephone	The Home telephone number of a customer
work_telephone	The Work telephone number of a customer
mobile_telephone	The Mobile telephone number of the customer
contact_address_1	The contact address line 1 for the customer
contact_address_2	The contact address line 2 for the customer
contact_address_3	The contact address line 3 for the customer
contact_address_4	The contact address line 4 for the customer
contact_address_5	The contact address line 5 for the customer
contact_address_6	The contact address line 6 for the customer
contact_postcode	The contact address postcode for the customer
contact_country	The contact address country for the customer
contact_country_code	The contact address ISO Country code
mailing_address_1	The mailing address line 1 for the customer. The Mailing address is source from the other customer address that we hold. The mailing address is chose form the customer's contact, billing or delivery address depending on address quality.
mailing_address_2	The mailing address line 2 for the customer.
mailing_address_3	The mailing address line 3 for the customer.
mailing_address_4	The mailing address line 4 for the customer.
mailing_address_5	The mailing address line 5 for the customer.
mailing_address_6	The mailing address line 6 for the customer.
mailing_postcode	The mailing postcode for the customer.
mailing_postcode_no_white_space	The mailing postcode without whitespace customer.
mailing_country	The mailing country for the customer
mailing_country_code	the mailing address ISO Country code
mailing_paf_code	Contains one of the following values: Not Matched PAF Matched Not matched means we have been unable to validate the address against the Royal Mail address data PAF matched mean that the address was matched to a Royal mail address.
mailing_suppression	This shows if the customer has been suppressed from contacting. This field will contain 4 possible values: Suppression Match on Address Suppression Match ON eMail Suppression Match on Customer ID Not Suppressed The Not Suppressed value show that a customer is not suppressed and can be contacted. Any value with suppression means the customer should not be contacted
dedupe_key_line_1_postcode_country	A dedupe key used internally to dedupe customer address data.
dedupe_key_line_2_postcode_country	A dedupe key used internally to dedupe customer address data.
dedupe_key_line_1_2_postcode_country	A dedupe key used internally to dedupe customer address data.
dedupe_key_lastname_line_1_2_postcode_country	A dedupe key used internally to dedupe customer address data.
email_subscriber	T or F. Shows if the customer subscribed to email.
catalogue_subscriber	T or F. Shows if the customer subscribed to catalogues/mailings.
third_party_subscriber	T or F. Shows if the customer is subscribed to be contacted by selected third party's.
frequency_segment	The frequency segment of the customer as part of the RFM model
recency_segment	The recency segment of the customer as part of the RFM model
monetary_segment	The monetary segment of the customer as part of the RFM model
active_frequency_segment	The active frequency segment of the customer as part of the RFM model. Active is defined by the retailer as a number of months back from the current date. Typically the last 12 months.
active_recency_segment	The active frequency segment of the customer as part of the RFM model. Active is defined by the retailer as a number of months back from the current date. Typically the last 12 months.
active_monetary_segment	The active monetary segment of the customer as part of the RFM model. Active is defined by the retailer as a number of months back from the current date. Typically the last 12 months.
nursery_segment	The nursery segment of the customer. This relates to recent/new customers.
segmentation_cell	A retailer defined segment based on RFM rules set.
creation_date	The Creation Date of the customers account
first_order_id	The First order id for the customer
first_order_date	The first date the customer placed and order
first_order_net_demand_value	The customer first order demand value excluding taxes
first_order_gross_demand_value	The customer first order demand value including taxes
monetary_segment_of_first_order	The customers monetary segment of their first order.
second_order_id	The customers second order id
second_order_date	The customer second order date
second_order_net_demand_value	The customer second order demand value excluding taxes
second_order_gross_demand_value	The customer second order demand value including taxes
monetary_segment_of_second_order	The customers monetary segment of their second order.
days_to_second_order	The number of days elapsed between the customer first and second order
last_order_id	The customer most recent order id
last_order_date	the customer most recent ordered date
last_order_net_demand_value	The customer most recent order demand value excluding taxes
last_order_gross_demand_value	The customer most recent order demand value including taxes
monetary_segment_of_last_order	The customers monetary segment of their most recent order.
offline_campaign_that_customer_was_acquired_from	The Offline campaign that the customer was first seen in. Normally some sort of catalogue campaign/physical mailing
online_campaign_that_customer_was_acquired_from	The Online campaign the customer was acquired was, typically either a Facebook or Google Ad Campaign
online_source_that_customer_was_acquired_from	The UA source the customer was first seen in.
online_medium_that_customer_was_acquired_from	The UA medium the customer was first seen in.
online_channel_that_customer_was_acquired_from	The UA channel the customer was first seen in.
offline_source_that_customer_was_acquired_from	The offline source the customer was first seen in. e.g Direct Mail.
lifetime_order_count	The total number of orders placed by the customer
active_order_count	The total number of orders during the defined active period. Typically this is 12 months
gender	The gender of the customer
date_of_birth	The date of birth of the customer
age_in_years	The age in years of the customer, based of their date of birth
age_band	The age band of the customer.
staff_group	The staff group of the customer
loyalty_group	The loyalty group of the customer
reseller_group	the reseller group of the customer
billing_address_1	The customers billing address line 1
billing_address_2	The customers billing address line 2
billing_address_3	The customers billing address line 3
billing_address_4	The customers billing address line 4
billing_address_5	The customers billing address line 5
billing_address_6	The customers billing address line 6
billing_postcode	The customers billing postcode
billing_country	The customers billing country
billing_country_code	The customers billing ISO Country code
delivery_address_1	The customers delivery address line 1
delivery_address_2	The customers delivery address line 2
delivery_address_3	The customers delivery address line 3
delivery_address_4	The customers delivery address line 4
delivery_address_5	The customers delivery address line 5
delivery_address_6	The customers delivery address line 6
delivery_postcode	The customers delivery postcode
delivery_country	The customers delivery country
delivery_country_code	The customers delivery ISO country Code
customer_first_order_was_promotion	T or F Did the customer first order contain a promotion
customer_first_order_was_markdown	T or F Did the customer first order contain an item with markdown applied

The above fields can be requested from any of the endpoints by simply adding them to the Query request.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"21345270","collectionId":"b7c8120a-504a-492e-95b1-565343da0fe6","publishedId":"VUjTkP4S","public":true,"customColor":{"top-bar":"70C0BA","right-sidebar":"303030","highlight":"DE316A"},"publishDate":"2022-08-16T11:18:21.000Z"},"item":[{"name":"Datitude GraphQL","item":[{"name":"Customer","item":[{"name":"GetCustomerById","event":[{"listen":"test","script":{"id":"2ea462ec-03c3-4c01-a429-4097a4a48616","exec":["pm.test(\"Status code is 200\", function () {\r"," pm.response.to.have.status(200);\r","});\r","\r","pm.test(\"Checks email has expected value\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomerById.email).to.eql(\"stephen.dean@datitude.co.uk\");\r","});\r","\r","pm.test(\"Checks customer_id has expected value\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomerById.customer_id).to.eql(\"stephen.dean@datitude.co.uk\");\r","});\r","\r","pm.test(\"Checks first_name has expected value\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomerById.first_name).to.not.be.eql(\"\");\r","});\r","\r","pm.test(\"Checks billing_address_1 is populated\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomerById.billing_address_1).to.be.not.null\r","});"],"type":"text/javascript"}}],"id":"5bf96bd0-4897-456b-a032-61ef19a0ee9e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"graphql","graphql":{"query":"query GetCustomerById($customerId: String!) {\r\n getCustomerById(id: $customerId) {\r\n customer_id\r\n email\r\n title\r\n first_name\r\n billing_address_1\r\n }\r\n}","variables":"{\r\n \"customerId\": \"stephen.dean@datitude.co.uk\"\r\n}"}},"url":"dataapi.datitude.co.uk","description":"

This method allows for the searching of a customer using a customer_id

This method allows for the searching of a customer using a customer's email address.

This method allows for the searching of customer using a customer first name & last name

This method allows for the searching of a customer using a the customer's first line of address and postcode

This method allows you to return all customer creation on or after the supplied date.

\n","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":true,"source":{"_postman_id":"b7c8120a-504a-492e-95b1-565343da0fe6","id":"b7c8120a-504a-492e-95b1-565343da0fe6","name":"Datitude Data API","type":"collection"}},"urlObject":{"host":["dataapi","datitude","co","uk"],"query":[],"variable":[]}},"response":[{"id":"bf5de6ea-8520-49fc-b643-75890a5568d8","name":"GetCustomersSinceCreationDate","originalRequest":{"method":"POST","header":[],"body":{"mode":"graphql"},"url":"{{graphEndpoint}}"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"147154"},{"key":"ETag","value":"W/\"23ed2-DDyU6T5+r6tevWIXdLLqe7XxFiA\""},{"key":"Date","value":"Tue, 16 Aug 2022 11:08:57 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n \"data\": {\n \"getCustomersSinceCreationDate\": [\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"T\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"T\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"T\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"T\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"T\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"27 GLOVERS ROAD\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 7LA\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n },\n {\n \"customer_id\": \"156430\",\n \"email\": \"stephen.dean@datitude.co.uk\",\n \"title\": \"MR\",\n \"first_name\": \"Stephen\",\n \"last_name\": \"Dean\",\n \"home_telephone\": \"01494426435\",\n \"work_telephone\": \"02030035000\",\n \"mobile_telephone\": \"07714418134\",\n \"contact_address_1\": \"\",\n \"contact_address_2\": \"\",\n \"contact_address_3\": \"\",\n \"contact_address_4\": \"\",\n \"contact_address_5\": \"\",\n \"contact_address_6\": \"\",\n \"contact_postcode\": \"\",\n \"contact_country\": \"\",\n \"contact_country_code\": \"GB\",\n \"mailing_address_1\": \"27 GLOVERS ROAD\",\n \"mailing_address_2\": \"\",\n \"mailing_address_3\": \"\",\n \"mailing_address_4\": \"REIGATE\",\n \"mailing_address_5\": \"SURREY\",\n \"mailing_address_6\": \"\",\n \"mailing_postcode\": \"RH2 7LA\",\n \"mailing_postcode_no_white_space\": \"RH27LA\",\n \"mailing_country\": \"UNITED KINGDOM\",\n \"mailing_country_code\": \"GB\",\n \"mailing_paf_code\": \"PAF Matched\",\n \"mailing_suppression\": \"Not suppressed\",\n \"dedupe_key_line_1_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_line_2_postcode_country\": \"RH2 7LAGB\",\n \"dedupe_key_line_1_2_postcode_country\": \"27 GLOVERS ROADRH2 7LAGB\",\n \"dedupe_key_lastname_line_1_2_postcode_country\": \"SMITH27 GLOVERS ROADRH2 7LAGB\",\n \"email_subscriber\": \"T\",\n \"catalogue_subscriber\": \"T\",\n \"third_party_subscriber\": \"T\",\n \"sms_subscriber\": null,\n \"browser_subscriber\": null,\n \"frequency_segment\": \"Multibuyer (11+)\",\n \"recency_segment\": \"Active < 6 Months\",\n \"monetary_segment\": \"HOV (>=£150)\",\n \"active_frequency_segment\": \"07 - 10 Orders\",\n \"active_recency_segment\": \"active_recency_segment = 3 - 6 Months\",\n \"active_monetary_segment\": \"HOV (>=£150)\",\n \"nursery_segment\": \"Is Not Nursery or Is Prospect\",\n \"segmentation_cell\": \"04. Active VIP\",\n \"creation_date\": \"2021-01-01T00:00:00.000Z\",\n \"first_order_id\": \"255663\",\n \"first_order_date\": \"2016-12-06T00:00:00.000Z\",\n \"first_order_net_demand_value\": \"230.00\",\n \"first_order_gross_demand_value\": \"276.00\",\n \"monetary_segment_of_first_order\": \"HOV (>=£150)\",\n \"second_order_id\": \"264467\",\n \"second_order_date\": \"2016-12-24T00:00:00.000Z\",\n \"second_order_net_demand_value\": \"60.79\",\n \"second_order_gross_demand_value\": \"72.95\",\n \"monetary_segment_of_second_order\": \"LOV (< £150)\",\n \"days_to_second_order\": \"18\",\n \"last_order_id\": \"772457\",\n \"last_order_date\": \"2021-09-23T23:00:00.000Z\",\n \"last_order_net_demand_value\": \"57.50\",\n \"last_order_gross_demand_value\": \"69\",\n \"monetary_segment_of_last_order\": \"LOV (< £150)\",\n \"offline_campaign_that_customer_was_acquired_from\": \"Not set\",\n \"online_campaign_that_customer_was_acquired_from\": \"(not_set)\",\n \"online_source_that_customer_was_acquired_from\": \"google\",\n \"online_medium_that_customer_was_acquired_from\": \"cpc\",\n \"online_channel_that_customer_was_acquired_from\": \"\",\n \"offline_source_that_customer_was_acquired_from\": \"Not set\",\n \"lifetime_order_count\": 18,\n \"active_order_count\": \"7\",\n \"gender\": \"Male\",\n \"date_of_birth\": null,\n \"age_in_years\": null,\n \"age_band\": null,\n \"staff_group\": null,\n \"loyalty_group\": null,\n \"reseller_group\": null,\n \"billing_address_1\": \"27 GLOVERS ROAD\",\n \"billing_address_2\": \"\",\n \"billing_address_3\": \"\",\n \"billing_address_4\": \"REIGATE\",\n \"billing_address_5\": \"SURREY\",\n \"billing_address_6\": \"\",\n \"billing_postcode\": \"RH2 7LA\",\n \"billing_country\": \"United Kingdom\",\n \"billing_country_code\": \"GB\",\n \"delivery_address_1\": \"64 HIGH STREET\",\n \"delivery_address_2\": \"\",\n \"delivery_address_3\": \"\",\n \"delivery_address_4\": \"REIGATE\",\n \"delivery_address_5\": \"SURREY\",\n \"delivery_address_6\": \"\",\n \"delivery_postcode\": \"RH2 9AP\",\n \"delivery_country\": \"United Kingdom\",\n \"delivery_country_code\": \"GB\",\n \"customer_first_order_was_promotion\": \"F\",\n \"customer_first_order_was_markdown\": \"F\"\n }\n ]\n }\n}"}],"_postman_id":"449c24aa-cb3a-48f0-9033-83eb281ddf91"},{"name":"GetCustomersByCountryCode","event":[{"listen":"test","script":{"id":"15243381-d387-44e6-8d63-788f81e93666","exec":["pm.test(\"Status code is 200\", function () {\r"," pm.response.to.have.status(200);\r","});\r","\r","pm.test(\"Checks email has expected value\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomersByCountryCode[0].email).to.not.be.null;\r","});\r","\r","pm.test(\"Repsonse has 5 or more customers\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomersByCountryCode).length.to.be.gte(5)\r","});\r","\r","pm.test(\"Checks contact_country is populated\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getCustomersByCountryCode[0].contact_country).to.be.not.eq(\"\")\r","});"],"type":"text/javascript"}}],"id":"4fa48cbe-1e2f-4690-b839-5408b19e3a68","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"graphql","graphql":{"query":"query GetCustomersByCountryCode($countryCode: String!) {\r\n getCustomersByCountryCode(country_code: $countryCode) {\r\n customer_id,\r\n email,\r\n billing_address_1,\r\n billing_country,\r\n contact_country\r\n }\r\n}","variables":"{\r\n \"countryCode\": \"MC\"\r\n}"}},"url":"dataapi.datitude.co.uk","description":"

This method allows for the searching of customers using a country code

The response from this method will be large in nature due to the wide search criteria

This method allows for the creation of a customer account.

The fields in the below example are required in order to create a customer.

This method allows the updating of customer information.

In order to update a customer we require at least the customer email.

This method allows for the searching of a customer using a partial email address

This method allows for the searching of a customer's transactions by using their email address

This method allows you to return all transactions where the supplied date is greater or equal to one of the following fields:

ordered_date_time
demand_date_time
cancelled_date_time
shipped_date_time
sold_date_time
returned_date_time
refunded_date_time

This method allows you to return all transactions where the supplied date is greater or equal to one of the following fields:

ordered_date_time
demand_date_time
cancelled_date_time
shipped_date_time
sold_date_time
returned_date_time
refunded_date_time

The Transactions examples provided here make use of 2 schemas. The Transaction schema and a Line Item Schema.

These schemas allow you to return either the Order level values known as \"Transactions\" or line level values which is known as \"Line Item\".

\n","_postman_id":"02efa3ba-aacb-459a-a081-cbd6a8ef1230","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":true,"source":{"_postman_id":"b7c8120a-504a-492e-95b1-565343da0fe6","id":"b7c8120a-504a-492e-95b1-565343da0fe6","name":"Datitude Data API","type":"collection"}}},{"name":"Promotions","item":[],"id":"abdbe068-1a54-4ccb-a2e4-898c9cc803ef","_postman_id":"abdbe068-1a54-4ccb-a2e4-898c9cc803ef","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":true,"source":{"_postman_id":"b7c8120a-504a-492e-95b1-565343da0fe6","id":"b7c8120a-504a-492e-95b1-565343da0fe6","name":"Datitude Data API","type":"collection"}}},{"name":"Consents","item":[{"name":"GetConsents","event":[{"listen":"test","script":{"id":"24140e4f-1ed4-4e7c-b21a-6c00b5fd3e69","exec":["pm.test(\"Status code is 200\", function () {\r"," pm.response.to.have.status(200);\r","});\r","\r","pm.test(\"Checlk the number of possible consents\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getConsents).length.gte(5);\r","});\r","\r","pm.test(\"Checks for the email consent\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getConsents[0].name).to.eql(\"Email\");\r","});\r","\r","pm.test(\"Checks for the catalogue consent\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getConsents[1].name).to.eql(\"Catalogue\");\r","});\r","\r","pm.test(\"Checks for the thire party consent\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getConsents[2].name).to.eql(\"Third Parties\");\r","});\r","\r","pm.test(\"Checks for the SMS consent\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getConsents[3].name).to.eql(\"SMS\");\r","});\r","\r","pm.test(\"Checks for the broswer notifications consent\", function () {\r"," var jsonData = pm.response.json();\r"," pm.expect(jsonData.data.getConsents[4].name).to.eql(\"Broswer Notifications\");\r","});\r",""],"type":"text/javascript"}}],"id":"3045a41d-5c3c-4c6e-8188-b0a4e28ee718","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"graphql","graphql":{"query":"query GetConsents {\r\n getConsents {\r\n consent_id\r\n name\r\n description\r\n value\r\n }\r\n}","variables":""}},"url":"dataapi.datitude.co.uk","description":"

This method allows for the searching of a customer using a customer_id

These are all the possible operation of the Datitude Graph API

\n","_postman_id":"0c4ac82a-56b0-4e4b-8363-49bf4a532b4e","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]},"isInherited":true,"source":{"_postman_id":"b7c8120a-504a-492e-95b1-565343da0fe6","id":"b7c8120a-504a-492e-95b1-565343da0fe6","name":"Datitude Data API","type":"collection"}}}],"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":""},{"key":"password","value":""}]}},"event":[{"listen":"prerequest","script":{"type":"text/javascript","exec":[""],"id":"f61c1eed-b521-4d8d-90fc-d77be0554f84"}},{"listen":"test","script":{"type":"text/javascript","exec":[""],"id":"de4271de-43bf-491b-adeb-ccf89c5b318b"}}]}