Migrate your data from a solution that is not natively supported

This connector will allow you to re-import your aggregated data history for certain types of reports.

Connector name: RealTime Analytics - Import

Data re-import is based on aggregated data according to the defined import profile. It uses generic formats and is not tied to any specific platform. Therefore, the data source can come from any solution.

When sending values ​​for a data type, the following processing is performed: if you send a single value over a period of more than one day, the value is distributed equally over the number of days, and the remainder is added to the first day of the period.

When you send data over a given period, the following process is applied:
  • For the line in question, if the data does not exist, the value provided in the file is injected.
  • For the line in question, if data already exists, the new value sent cancels and replaces the existing one (example: if you had 15 page views and you send 17 page views, then the number 17 will be displayed in the interface).


How do I set up data re-import?

In order to set up data re-import, you must:
  • Please have your data in CSV format (accented characters will be automatically removed)
  • have a JSON file defining the data format and import type

Once the connector is created, you will have access to API endpoints that allow you to specify the types of data you can import. To ensure optimal compatibility between solutions, accented characters are removed during data re-import.


Site-level data

The following metrics:
  • Time spent: duration - it must be provided in seconds
  • visits: visit
  • daily unique visitors: dvisitor
  • sales: scartvalid
  • revenue: scartvalidamount
  • lead: estimatevalid
  • lead revenue: estimatevalidamount
  • shopping cart: scart
Example of an import format:
{
  "skipHeader" : true,
  "kind" : "website",
  "dimensions" : [{
     "idx" : 0,
     "target": "website_name"
  }],
  "metrics" : [{
     "idx" : 1,
     "target" : "visit"
   }, {
     "idx" : 4,
     "target" : "duration"
   }, {
     "idx" : 7,
     "target" : "dvisitor"
   }],
   "period" : {
     "from" : "01/03/2023",
     "to" : "31/03/2023",
     "scale" : "D"
   }
}

CSV file containing the data to be imported:
Nom,Visites,Actions,Nombre maximum d'actions en une visite,Temps total passé par les visiteurs (en secondes),Rebonds,Visites avec conversions,Visiteurs uniques (résumé quotidien),Utilisateurs (résumé quotidien)
MonSite,439216,818178,300,39214621,317335,0,403838,0

Call URL to import this data:
curl -F "meta-data=@website.json" -F "file-name=@website.csv" https://$URL_API/ea/v2/$TOKEN_API_EPC/epc/$SITE/analyticsimport/website.json



Page level data

The following metrics:
  • page views : hit
  • time spent : duration - must be provided in seconds
  • visits : visit
  • incoming visits : visitin
  • exit visits : visitout
  • bouce visits : visitone

Example of an import format:
  "skipHeader" : true,
  "kind" : "pagetree",
  "dimensions" : [{
     "idx" : 0,
     "target": "pageinfo_name"
  }],
  "metrics" : [{
     "idx" : 2,
     "target" : "hit"
   }, {
     "idx" : 3,
     "target" : "duration"
   }, {
     "idx" : 22,
     "target" : "visitin"
   }, {
     "idx" : 25,
     "target" : "visitone"
   }, {
     "idx" : 26,
     "target" : "visitout"
   }],
   "period" : {
     "from" : "01/03/2023",
     "to" : "31/03/2023",
     "scale" : "D"
   }
}

CSV file containing the data to be imported:
Nom,Vues de page uniques,Vues de page,Temps total passé par les visiteurs (en secondes),nb_hits_with_time_network,min_time_network,max_time_network,nb_hits_with_time_server,min_time_server,max_time_server,nb_hits_with_time_transfer,min_time_transfer,max_time_transfer,nb_hits_with_time_dom_processing,min_time_dom_processing,max_time_dom_processing,nb_hits_with_time_dom_completion,min_time_dom_completion,max_time_dom_completion,nb_hits_with_time_on_load,min_time_on_load,max_time_on_load,Entrées,Actions après être entré ici,Temps total passé par les visiteurs (en secondes) après être entré ici,Rebonds,Sorties,Visiteurs uniques (résumé quotidien),Entrées uniques (résumé quotidien),Sorties uniques (résumé quotidien),Temps moyen de connexion,Moy. heure du serveur,Moy. temps de transfert,Temps moyen de traitement du DOM,Temps moyen de génération du DOM,Moy. au temps de chargement,Temps de chargement moyen,Temps moyen sur la page,Taux de rebond,Taux de sortie,Méta-données: segment,Cliqué dans les résultats de recherche
Homepage,100651,119493,4343012,116206,0,1289.613,116217,0,1460.591,116220,0,604.561,116143,0.757,9743.714,388,1.014,54.823,353,0.085,1.236,76674,123083,4355771,57586,79539,87678,67301,69116,0.135,0.21,0.064,1.093,0.263,0.012,1.777,36,75 %,79 %,pageTitle==tata,
Bienvenu-sur-notre-sitre,78120,101083,3898685,100632,0,5608.867,100622,0,882.9,100642,0,481.358,100517,0.184,11014.492,3367,0.175,694.053,3227,0.036,3.626,68162,167686,7805427,36363,50701,72280,61857,47658,0.221,0.206,0.078,1.233,0.538,0.013,2.289,39,53 %,65 %,pageTitle==test,

Call URL to import this data:
curl -F "meta-data=@pagetree.json" -F "file-name=@pagetree.csv" https://$URL_API/ea/v2/$TOKEN_API_EPC/epc/$SITE/analyticsimport/pagetree.json

The URL of the page can be provided in the additionnal dimension: pageinfo_url.
Example of an import format:
{
  "skipHeader" : true,
  "kind" : "pagetree",
  "dimensions" : [{
     "idx" : 0,
     "target": "pageinfo_name"
  }, {
     "idx" : 1,
     "target" : "pageinfo_url"
  }],
  "metrics" : [{
     "idx" : 2,
     "target" : "hit"
   }, {
     "idx" : 3,
     "target" : "duration"
   }, {
     "idx" : 22,
     "target" : "visitin"
   }, {
     "idx" : 25,
     "target" : "visitone"
   }, {
     "idx" : 26,
     "target" : "visitout"
   }],
   "period" : {
     "from" : "01/03/2023",
     "to" : "31/03/2023",
     "scale" : "D"
   }
}



SEO - Search Engines

The following metrics:
  • time spent: duration - it must be provided in seconds
  • visits: visit
  • daily unique visitors: dvisitor
  • sales: scartvalid
  • sales revenue: scartvalidamount
  • lead : estimatevalid
  • lead revenue: estimatevalidamount
  • shopping carts: scart

Example of an import format:
{
 "skipHeader" : true,
 "kind" : "searchengine",
 "dimensions" : [{
 "idx" : 0,
 "target": "searchengine_name"
 }],
 "metrics" : [{
 "idx" : 1,
 "target" : "visit"
 }, {
 "idx" : 4,
 "target" : "duration"
 }, {
 "idx" : 7,
 "target" : "dvisitor"
 }],
 "period" : {
 "from" : "01/03/2023",
 "to" : "31/03/2023",
 "scale" : "D"
 }


CSV file containing the data to be imported:
 Nom,Visites,Actions,Nombre maximum d'actions en une visite,Temps total passé par les visiteurs (en secondes),Rebonds,Visites avec conversions,Visiteurs uniques (résumé quotidien),Utilisateurs (résumé quotidien),Méta-données: segment,Méta-données: url,Méta-données: logo
Google,385590,684329,300,33213892,287085,0,358242,0,referrerType==search;referrerName==Google,http://google.com,plugins/Morpheus/icons/dist/searchEngines/google.com.png
URL for importing this data:
Bing,12835,31047,128,1671124,8290,0,12060,0,referrerType==search;referrerName==Bing,http://bing.com,plugins/Morpheus/icons/dist/searchEngines/bing.com.png
Call URL to import this data:
 Data at the level of tributary (referring) sites
curl -F "meta-data=@searchengine.json" -F "file-name=@searchengine.csv" https://$URL_API/ea/v2/$TOKEN_API_EPC/epc/$SITE/analyticsimport/searchengine.json


Referrers

The following metrics:
  • time spent: duration - it must be provided in seconds
  • visits: visit
  • daily unique visitors: dvisitor
  • sales: scartvalid
  • sales revenue: scartvalidamount
  • lead : estimatevalid
  • lead revenue: estimatevalidamount
  • shopping carts: scart

Example of an import format
{
  "skipHeader" : true,
  "kind" : "refererdomain",
  "dimensions" : [{
     "idx" : 0,
     "target": "refererdomain_name"
  }],
  "metrics" : [{
     "idx" : 1,
     "target" : "visit"
   }, {
     "idx" : 4,
     "target" : "duration"
   }, {
     "idx" : 7,
     "target" : "dvisitor"
   }],
   "period" : {
     "from" : "01/03/2023",
     "to" : "31/03/2023",
     "scale" : "D"
   }
}

CSV file containing the data to be imported:
Nom,Visites,Actions,Nombre maximum d'actions en une visite,Temps total passé par les visiteurs (en secondes),Rebonds,Visites avec conversions,Visiteurs uniques (résumé quotidien),Utilisateurs (résumé quotidien),Méta-données: segment
www.francetvinfo.fr,394,1765,71,38473,276,0,382,0,referrerName==www.francetvinfo.fr
www.oneplanetsummit.fr,376,758,13,61846,203,0,353,0,referrerName==www.oneplanetsummit.fr
fr.wikipedia.org,371,1397,53,69163,213,0,365,0,referrerName==fr.wikipedia.org

Call URL to import this data:
curl -F "meta-data=@refererdomain.json" -F "file-name=@refererdomain.csv" https://$URL_API/ea/v2/$TOKEN_API_EPC/epc/$SITE/analyticsimport/refererdomain.json



Paid acquisition sources


The following metrics:
  • time spent: duration - it must be provided in seconds
  • visits: visit
  • daily unique visitors: dvisitor
  • sales: scartvalid
  • sales revenue: scartvalidamount
  • lead : estimatevalid
  • lead revenue: estimatevalidamount
  • shopping carts: scart


Allowed values for media_key :
  • MAILING : emailing
  • ADVERTISING : display
  • AFFILIATION : affiliation
  • SPONSOREDLINK : SEA
  • PARTNER : partners
  • TRUSTEDFEED : comparison engine
  • OFFLINE : offline / broadcast / TV
  • GENERIC : generic

Example of an import format:
{
  "skipHeader" : true,
  "kind" : "opedata",
  "dimensions" : [{
     "idx" : 0,
     "target": "media_key"
  }, {
     "idx" : 1,
     "target" : "publisher_name"
  }, {
     "idx" : 2,
     "target" : "ope_name"
  }],
  "metrics" : [{
     "idx" : 3,
     "target" : "visit"
   }, {
     "idx" : 4,
     "target" : "duration"
   }, {
     "idx" : 5,
     "target" : "dvisitor"
   }],
   "period" : {
     "from" : "01/03/2023",
     "to" : "31/03/2023",
     "scale" : "D"
   }
}

CSV file containing the data to be imported:
Levier,Support,Campagne,Visites,Temps passé (en secondes),Visiteurs uniques (résumé quotidien)
ADVERTISING,Google,Google-Display,9654,665332,58
AFFILIATION,AWin,awin,548,98,6

Call URL to import this data:
curl -F "meta-data=@media.json" -F "file-name=@media.csv" https://$URL_API/ea/v2/$TOKEN_API_EPC/epc/$SITE/analyticsimport/opedata.json



Geographical data

The following metrics:
  • time spent: duration - it must be provided in seconds
  • visits: visit
  • daily unique visitors: dvisitor
  • sales: scartvalid
  • sales revenue: scartvalidamount
  • lead : estimatevalid
  • lead revenue: estimatevalidamount
  • shopping carts: scart

Example of an import format:
{
 "skipHeader" : true,
 "kind" : "geoloccountry",
 "dimensions" : [{
 "idx" : 9,
 "target": "geoloccountry_isocode"
 }],
 "metrics" : [{
 "idx" : 1,
 "target" : "visit"
 }, {
 "idx" : 4,
 "target" : "duration"
 }, {
 "idx" : 7,
 "target" : "dvisitor"
 }],
 "period" : {
 "from" : "01/03/2023",
 "to" : "31/03/2023",
 "scale" : "D"
 }
CSV file containing the data to be imported:
}

CSV file containing the data to be imported:
 Nom,Visites,Actions,Nombre maximum d'actions en une visite,Temps total passé par les visiteurs (en secondes),Rebonds,Visites avec conversions,Visiteurs uniques (résumé quotidien),Utilisateurs (résumé quotidien),Méta-données: code,Méta-données: logo,Méta-données: segment,Méta-données: logoHeight
France,439216,818178,300,39214621,317335,0,403838,0,fr,plugins/Morpheus/icons/dist/flags/fr.png,countryCode==fr,16
URL for importing this data:
États-Unis,22276,35735,115,3022018,17095,0,21092,0,us,plugins/Morpheus/icons/dist/flags/us.png,countryCode==us,16

Call URL to import this data:
curl -F "meta-data=@geoloccountry.json" -F "file-name=@geoloccountry.csv" https://$URL_API/ea/v2/$TOKEN_API_EPC/epc/$SITE/analyticsimport/geoloccountry.json