Ce document explicite le modèle de donnée disponible lorsqu'un connecteur de type Business Intelligence est mis en place.
Le format décrit ci-dessous est notre modèle standard d'envoi de donnée à toutes les solutions BI capable d'intégrer notre data sous sa forme la plus granulaire.
Ce modèle est en constante évolution et de nouvelles données viendront s'ajouter à cette liste sans jamais modifier les clés existantes et leur structure.
La clé de la structure contient le type d'appel envoyé selon une liste de valeurs figée:
Tous les clicks sur des liens trackés eulerian (clic, dynclick etc..)
Toutes les impressions trackées eulerian (view, dynview etc..)
Trafic site-centric. Toute page autre qu'un order / estimate / scart
Comme hit mais indique en plus qu'il s'agit de la première page d'une nouvelle visite
Page de confirmation de commande
Page de confirmation de devis
Domaine du référant de la première page vue
Domaine référant ad-centric
Profil de l'utilisateur (looker/shopper/buyer/etc)
UID (identifiant unique de l'utilisateur)
User agent de l'utilisateur
Liste des audiences et de leurs segments respectifs
hit,visit,order,scart,estimate
hit,visit,order,scart,estimate
hit,visit,order,scart,estimate
[{'ref':'45835','price':'0',quantity:1},{...}]
hit,visit,order,scart,estimate
hit,visit,order,scart,estimate
hit,visit,order,scart,estimate
Liste ded paramètres personnalisés
hit,visit,order,scart,estimate
[{'k':'v'},{'age':'25-30'}]
Nom du paramètre personnalisé
hit,visit,order,scart,estimate
Valeur du paramètre personnalisé
hit,visit,order,scart,estimate
lié au paramètre 'type' de la conversion
{
"devicetype": "Tablet",
"wskey": "client-fr",
"type": "click",
"epoch": "1476762585",
"eulerianid": "6742614185137654637",
"euleriandeviceid": "98724774666436377383",
"uid": "41771080",
"useragent": "Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Mobile/13G36",
"geo": "FRA8",
"ip": "78.118.234.156",
"profile": "Shopper",
"channel_c": "ml",
"channel_t": "c",
"channel_publisher": "client-fr",
"channel_ope": "NL-FR-CLIENTS-PREMIUM-161018",
"channel_seng": "",
"channel_sengkw": "",
"channel_rfdom": "",
"channel_rfdomuri": "",
"channel_loctxt": "",
"channel_creatxt": "",
"channel_slkw": "",
"channel_sikey": "category",
"channel_sival": "premium",
"channel_slcamp": "",
"channel_sladgroup": "",
"fullurl": "http://eulerian.client.fr/dynclick/client-fr/?eml-publisher=client-fr&eml-name=NL-FR-CLIENTS-PREMIUM-161018&eseg-name=category&eseg-item=premium&uid=41771080&eurl=http%3A%2F%2Fwww.client.fr%2Fofferpremium",
"cluster": {
"Actif newsletter": "Actif -30 jours",
"Premium": "Client Premium +1 an"
}
}
{
"devicetype": "Desktop",
"wskey": "client-fr",
"type": "view",
"epoch": "1476741805",
"eulerianid": "2764143871266801030",
"euleriandeviceid": "2764143871266801030",
"uid": "",
"useragent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36",
"geo": "FR",
"ip": "80.236.101.164",
"profile": "",
"channel_c": "ad",
"channel_t": "v",
"channel_publisher": "tradelab",
"channel_ope": "TLAB_PROSPECTING_PROFILING",
"channel_seng": "",
"channel_sengkw": "",
"channel_rfdom": "",
"channel_rfdomuri": "",
"channel_loctxt": "tradelab-domain_name",
"channel_creatxt": "Generic",
"channel_slkw": "",
"channel_sikey": "",
"channel_sival": "",
"channel_slcamp": "",
"channel_sladgroup": "",
"fullurl": "https://eulerian.client.fr/dynview/photobox-fr/pix.gif?ead-publisher=tradelab&ead-name=TLAB_PROSPECTING_PROFILING&ead-location=domain_name&ead-creative=Generic&ead-creativetype=1x1&ea-rnd=205363586"
,"cluster":{
"A-B_Retargeting":"Cible A",
"prospects":"nouveau prospect"
}
}
{
"devicetype": "SmartPhone",
"type": "hit",
"epoch": "1476741661",
"eulerianid": "13494950543979816964",
"euleriandeviceid": "2537865102402279348",
"uid": "5360955",
"useragent": "Mozilla/5.0 (iPhone; CPU iPhone OS 7_1_2 like Mac OS X) AppleWebKit/537.51.2 (KHTML, like Gecko) Version/7.0 Mobile/11D257 Safari/9537.53",
"geo": "FR",
"ip": "80.12.55.41",
"profile": "visitor",
"fullurl": "https://eulerian.client.com/col1/-/1678601783?urlp=%2FHome&pagegroup=Home&age=25-30&size=M&prdr2=669130&prdr0=1246310&prdr1=1363092&ss=320x480&sd=32&fra=0&url=https%3A%2F%2Fwww.oscaro.com%2F",
"path": "/Home",
"pagegroup": "Home",
"channel_c": "br",
"channel_publisher": "",
"channel_ope": "BRANDING",
"channel_seng": "Google",
"channel_sengkw": "client-notprovided",
"channel_rfdom": "",
"channel_rfdomuri": "",
"channel_loctxt": "",
"channel_creatxt": "",
"channel_slkw": "",
"channel_sikey": "",
"channel_sival": "",
"channel_slcamp": "",
"channel_sladgroup": "",
"currency": "EUR",
"product": [{
"ref": "1246310",
"price": "",
"quantity": "1"
}, {
"ref": "1363092",
"price": "",
"quantity": "1"
}, {
"ref": "669130",
"price": "",
"quantity": "1"
}],
"customp": [{
"k": "email",
"v": ""
}, {
"k": "age",
"v": "25-30"
}, {
"k": "size",
"v": "M"
}, {
"k": "segment",
"v": ""
}],
"cluster": {
"A-B_Retargeting": "B",
"prospects": " nouveau prospect"
}
}
{
"devicetype": "Desktop",
"type": "order",
"epoch": "1476755706",
"eulerianid": "12116298850026246700",
"euleriandeviceid": "3664146731612841153",
"uid": "6263105",
"useragent": "Mozilla/5.0 (Windows NT 6.0; rv:49.0) Gecko/20100101 Firefox/49.0",
"geo": "FR",
"ip": "90.18.238.84",
"profile": "registered",
"fullurl": "https://eulerian.client.com/col1/-/475487784?amount=320.74&frais_de_port=4.99&urlp=%2FStep5%2FConfirmTransaction&payment=CB&profile=registered&ref=33788526&eemail=aff37b68b83d0c1refref5a77aa477efe&uid=6263105&pagegroup=confirmation&prdr0=177292&prda0=36.63&prdq0=2&prdr1=1856824&prda1=141.36&prdq1=1&prdr2=3857469&prda2=8.21&prdq2=2&ss=1280x800&sd=24&fra=0&fl=23.0%20r0&url=https%3A%2F%2Feulerian.client.com%2FStep5%2FConfirmTransaction",
"path": "/Step5/ConfirmTransaction",
"pagegroup": "",
"channel_c": "ad",
"channel_publisher": "leboncoin",
"channel_ope": "cpm-display",
"channel_seng": "",
"channel_sengkw": "",
"channel_rfdom": "www.leboncoin.fr",
"channel_rfdomuri": "",
"channel_loctxt": "leboncoin-vignette-produit",
"channel_creatxt": "vignette-generique",
"channel_slkw": "",
"channel_sikey": "",
"channel_sival": "",
"channel_slcamp": "",
"channel_sladgroup": "",
"currency": "EUR",
"product": [{
"ref": "177292",
"price": "36.63",
"quantity": "2"
}, {
"ref": "1856824",
"price": "141.36",
"quantity": "1"
}, {
"ref": "3857469",
"price": "8.21",
"quantity": "2"
}],
"ref": "33788526",
"amount": "320.74",
"ordertype": "Marketplace",
"orderpayment": "CB",
"customp": [{
"k": "age",
"v": "18-25"
}, {
"k": "size",
"v": "M"
}, {
"k": "segment",
"v": "Nouveau client"
}],
"cluster": {
"clients-actifs": "Nouveau client -1 mois",
"Test_Retargeting": "B",
}
}