{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MDD SECONDAIRE","PROFILES","ORDERS","ORDER LINES","ABANDONED CARTS","ABANDONED CART LINES","liste valeur"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MDD SECONDAIRE","index":0,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":true,"merged":[[15,1,15,8],[26,1,26,8],[38,1,38,8],[50,1,50,8],[59,1,59,8]]}
[]
["DESCRIPTION DU MODÈLE DE DONNÉES SECONDAIRE"]
[]
[null,null,"Colonne à l'usage du client uniquement"]
[null,null,"Colonne à l'usage d'ACTITO uniquement"]
[]
[null,"Attention : chaque fichier doit être zippé individuellement en format .zip ou .gzip"]
[null,"LISTE DES TABLES"]
[null,null,"Nom technique de la table","Nom de la table dans l'interface ","Type de table","Si FTP : fichier obligatoire / optionnel","Si FTP : nom de fichier"]
[null,1,"Secondaire","Secondaire","Profils","Obligatoire","<YYYYMMDD>_<CLIENT>_SECONDAIRE.csv"]
[null,2]
[]
["TABLE DE PROFILS"]
["Toutes les personnes devant recevoir une communication marketing sont à importer dans la table de profil"]
[]
[null,"CONTACTS"]
[]
[null,null,"Nom technique / libellé de colonne dans le fichier","Provenance (colonne à l'usage du client / partenaire)","Type","Contraintes","Lien table de référence / Champ standard ACTITO","Nom du champ dans ACTITO","Description"]
[null,1,"idContact",null,"INTEGER","Unique et obligatoire",null,"Contact ID","Identifiant unique et obligatoire du profil dans ACTITO"]
[null,2,"email",null,"emailAddress",null,"emailAddress","Adresse email"]
[null,3]
[null,4]
[]
["TABLES DE DONNÉES LIÉES"]
["Relations 1-1 ou 1-N entre Profil et la table"]
[]
[null,"XXX"]
[]
[null,null,"Nom technique / libellé de colonne dans le fichier","Provenance (colonne à l'usage du client / partenaire)","Type","Contraintes","Lien table de référence / Champ standard ACTITO","Nom du champ dans ACTITO","Description"]
[null,1,"idUniqueXXX",null,"INTEGER","Unique et obligatoire",null,"ID XX","Identifiant unique et obligatoire dans la table"]
[null,2,"idContact",null,"INTEGER","Obligatoire",null,"Contact ID","Identifiant du profil, lien avec la table de profils"]
[null,3]
[null,4]
[]
["TABLES DES INTERACTIONS"]
["Relations 1-1 ou 1-N entre Profil et la table"]
["Un champ obligatoire au format date et heure doit être à minima présent dans cette table"]
[]
[null,"XXX"]
[]
[null,null,"Nom technique / libellé de colonne dans le fichier","Provenance (colonne à l'usage du client / partenaire)","Type","Contraintes","Lien table de référence / Champ standard ACTITO","Nom du champ dans ACTITO","Description"]
[null,1,"idUniqueXXX",null,"INTEGER","Unique et obligatoire",null,"ID XX","Identifiant unique et obligatoire dans la table"]
[null,2,"idContact",null,"INTEGER","Obligatoire",null,"Contact ID","Identifiant du profil, lien avec la table de profils"]
[null,3]
[null,4]
[]
["TABLES DE RÉFÉRENCE"]
["Relations N-1 entre une table de profils et/ou de données liées et/ou des interactions et la table de référence"]
["Maximum 10000 lignes"]
[]
[null,"XXX"]
[]
[null,null,"Nom technique / libellé de colonne dans le fichier","Provenance (colonne à l'usage du client / partenaire)","Type","Contraintes","Lien table de référence / Champ standard ACTITO","Nom du champ dans ACTITO","Description"]
[null,1,"idUniqueXXX",null,"INTEGER","Unique et obligatoire",null,"ID XX","Identifiant unique et obligatoire dans la table"]
[null,2]
[]
[]
["FICHIERS TECHNIQUES"]
[]
[null,"Suppression de profils"]
[]
[null,null,"Nom technique / libellé de colonne dans le fichier","Provenance (colonne à l'usage du client / partenaire)","Type","Contraintes","Lien table de référence / Champ standard ACTITO","Nom du champ dans ACTITO","Description"]
[null,1,"idContact",null,"INTEGER","Obligatoire",null,"ID Contact"]

{"sheet":"PROFILES","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,0,18,4],[21,0,21,4]]}
["#","Technical name on Actito table","CMS concept","CMS Field","Rules apply during the injection"]
[1,"accountId","customers","id"," -"]
[2,"firstName","customers","first_name"," -"]
[3,"lastName","customers","last_name"," -"]
[4,"emailAddress","customers","email"," -"]
[5,"sex","-","-","Not synchronized"]
[6,"birthDate","-","-","Not synchronized"]
[7,"addressCompany","customers","default_address.company","-"]
[8,"VATNumber","-","-","Not synchronized"]
[9,"addressStreet","customers","default_address.address1\ndefault_address.address2","\nThe two fields are concatenated"]
[10,"addressLocality","customers","default_address.city","-"]
[11,"addressCountry","customers","default_address.country","-"]
[12,"addressRegion","customers","default_address.province","-"]
[13,"addressPostalCode","customers","default_address.zip","-"]
[14,"mobilePhoneNumber","addresses","phone","-"]
[15,"customerGroup","customers","tags"," -"]
[16,"source","-","-","Constant 'SHOPIFY'"]
[17,"motherLanguage","storeConfigs","locale","Not synchronized"]
["Subscription"]
[1,"Newsletter","customers","email_marketing_consent.state"," -"]
[18,"Alerte","Alerte","BOOLEAN"," - true/false"]
["Segmentation"]
[1,"Clients Churn risks","-","-","compute on Actito with a predefined rule"]
[2,"Potential purchasers","-","-","compute on Actito with a predefined rule"]
[3,"New buyers","-","-","compute on Actito with a predefined rule"]
[4,"VIP customer","-","-","compute on Actito with a predefined rule"]
[5,"Unengaged","-","-","compute on Actito with a predefined rule"]
[6,"New subscribers","-","-","compute on Actito with a predefined rule"]
[7,"Engaged 3 months","-","-","compute on Actito with a predefined rule"]
[8,"Unengaged 1 year","-","-","compute on Actito with a predefined rule"]

{"sheet":"ORDERS","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["#","Technical name on Actito table","CMS concept","CMS Field","Rules apply during the injection"]
[1,"orderId","orders","id","-"]
[2,"reference","orders","token","-"]
[3,"currency","orders","currency","-"]
[4,"date","orders","created_at","-"]
[5,"total","orders","total_price\ntotal_tax\ntaxes_included","Start from total_price and add total_tax if taxes_included isn't set. \nA null result is avoided by using a constant 0."]
[6,"totalExclTax","orders","total_price\ntotal_tax\ntaxes_included","Start from total_price and subtract total_tax if taxes_included is set. \nA null result is avoided by using a constant 0."]
[7,"totalInclTax","orders","total_price\ntotal_tax\ntaxes_included","Start from total_price and add total_tax if taxes_included isn't set. \nA null result is avoided by using a constant 0."]
[8,"shipping","orders","\nshipping_lines[ALL].discounted_price\ntotal_shipping_price_set.presentment_money.amount","If there are shipping_lines, theirs discounted_price are sumed. \nOtherwise we use the total_shipping_price_set.presentment_money.amount"]
[9,"shippingOption","orders","shipping_lines[ALL].source","If there are shipping_lines, concatenate theirs source"]
[10,"paymentMethod","orders","processing_method","-"]
[11,"couponCode","orders","discount_codes[ALL].code","If there are discount_codes, concatenate theirs code"]
[12,"status","orders","fulfillment_status","-"]
[13,"shopId","orders","location_id","-"]
[14,"shopName","orders","landing_site"]
[15,"emailAddress","orders","email","-"]
[16,"accountId","orders","customer.id","-"]

{"sheet":"ORDER LINES","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["#","Technical name on Actito table","CMS concept","CMS Field","Rules apply during the injection"]
[1,"orderId","orders","id"]
[2,"orderDetailId","orders","line_items[X].id\nline_items[X].key","\nThe id of the line_items is get and if none the key is used"]
[3,"orderReference","orders","token"]
[4,"sku","orders","line_items[X].sku"]
[5,"description","products","body_html","The product based on line_items[X].product_id is fetched then sanitize his body_html"]
[6,"name","orders","line_items[X].name\nline_items[X].title","\nThe name of the line_items is get and if none the title is used"]
[7,"quantity","orders","line_items[X].quantity"]
[8,"unitPrice","orders","line_items[X].price"]
[9,"unitPriceExclTax","orders","line_items[X].price"]
[10,"unitPriceInclTax","orders","line_items[X].price"]
[11,"productUrl","products\nvariants\nshop","\nimages[FIRST_VARIANT].src","The product based on line_items[X].product_id is fetched\nthen variant based on line_items[X].variant_id is fetched \n\nValue is derived from 'http://{SHOP_DOMAIN}/products/{PRODUCT_HANDLE}?variant={VARIANT_ID}"]
[12,"pictureUrl","products","product.handle\nvariant.id\nshop.domain","The product based on line_items[X].product_id is fetched\n\nThen an image with a related line_items[X].variant_id and is searched. If none, the first image available is used"]
[13,"shopId","orders","\nlocation_id"]
[14,"shopName","\norders\nstoreViews","landing_site"]
[15,"emailAddress","orders","email","-"]
[16,"accountId","orders","customer.id","-"]

{"sheet":"ABANDONED CARTS","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["#","Technical name on Actito table","CMS concept","CMS Field","Rules apply during the injection"]
[1,"abandonedCartId","checkouts","id"]
[2,"reference","checkouts","token","-"]
[3,"currency","checkouts","currency"]
[4,"total","checkouts","\ntotal_price","-"]
[5,"totalExclTax","checkouts","total_price\ntotal_tax\ntaxes_included","Start from total_price and subtract total_tax if taxes_included is set. \nA null result is avoided by using a constant 0."]
[6,"totalInclTax","checkouts","total_price\ntotal_tax\ntaxes_included","Start from total_price and add total_tax if taxes_included isn't set. \nA null result is avoided by using a constant 0."]
[7,"status","-","-","Constant 'OPEN'"]
[8,"abandonedSinceMoment","checkouts","\ncreated_at","-"]
[9,"shopId","-","-","Not synchronized"]
[10,"shopName","-","-","Not synchronized"]
[11,"emailAddress","checkouts","email","-"]
[12,"accountId","checkouts","customer.id","-"]

{"sheet":"ABANDONED CART LINES","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["#","Technical name on Actito table","CMS concept","CMS Field","Rules apply during the injection"]
[1,"abandonedCartId","checkouts","id","-"]
[2,"abandonedCartDetailId","checkouts","line_items[X].id\nline_items[X].key","The id of the line_items is get and if none the key is used"]
[3,"abandonedCartReference","checkouts","token","-"]
[4,"sku","checkouts","line_items[X].sku","-"]
[5,"description","checkouts","body_html","The product based on line_items[X].product_id is fetched then sanitize his body_html"]
[6,"name","checkouts","line_items[X].name\nline_items[X].title","The name of the line_items is get and if none the title is used"]
[7,"quantity","checkouts","line_items[X].quantity","-"]
[8,"unitPrice","checkouts","line_items[X].price","-"]
[9,"unitPriceExclTax","checkouts","line_items[X].price","-"]
[10,"unitPriceInclTax","checkouts","line_items[X].price","-"]
[11,"productUrl","products\nvariants\nshop","product.handle\nvariant.id\nshop.domain","The product based on line_items[X].product_id is fetched\nthen variant based on line_items[X].variant_id is fetched \n\nValue is derived from 'http://{SHOP_DOMAIN}/products/{PRODUCT_HANDLE}?variant={VARIANT_ID}"]
[12,"pictureUrl","\nproducts","images[FIRST_VARIANT].src","The product based on line_items[X].product_id is fetched\n\nThen an image with a related line_items[X].variant_id and is searched. If none, the first image available is used"]
[13,"shopId","-","-","Not synchronized"]
[14,"shopName","-","-","Not synchronized"]
[15,"emailAddress","checkouts","email","-"]
[16,"accountId","checkouts","customer.id","-"]

{"sheet":"liste valeur","index":6,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["STRING",null,null,"firstName"]
["INTEGER",null,null,"lastName"]
["BOOLEAN (True / False)",null,null,"birthDate"]
["DATE (yyyy-mm-dd)",null,null,"sex"]
["TIMESTAMP (yyyy-mm-dd hh:mm:ss)",null,null,"motherLanguage"]
["NUMERIC (xx.xx)",null,null,"emailAddress"]
["birthdate",null,null,"addressStreet"]
["emailAddress",null,null,"addressNulber"]
["gsmNumber",null,null,"addressBox"]
["codeLangue",null,null,"addressPostalCode"]
["sex",null,null,"addressLocality"]
["telephoneNumber",null,null,"addressCountry"]
["civilité (M., Mlle, Mme)",null,null,"gsmNumber"]
["codePays",null,null,"telephoneNumber"]
[null,null,null,"civilState"]
[null,null,null,"nbChildren"]
[null,null,null,"profession"]
[null,null,null,"marketingConsent"]
[null,null,null,"-"]
[null,null,null,"abonnement email"]
[null,null,null,"abonnement sms"]
[null,null,null,"abonnement postal"]