Data Enrichment and Inlining

FunnelConnect provides extensive data enrichment and inlining capabilities across most of its APIs. Any data collected and imported, including event and profile data can be returned and inlined. Additionally, our iPaaS solution provides a wide range of API based data integration capabilities, for example with data cloud, data service, and client internal data warehouse services.

Fetching data from external systems via API requires very low latencies. Configurable timeout and circuit breaker solutions ensure the FunnelConnect service operates end-to-end even if external systems are not as expected.

FunnelConnect can use any of the available identifiers from its ID profile as lookup ID with these systems.

Data Enrichment

All pipelines can be enabled for IP address and user-agent derived data enrichment. We use IP2Location DB23 and Udger.

This data enrichment can be enabled by default or based on specific consent.

IP2Location data sample as inlined into events data stream:

JSON

  "geo": {
      "cc": "ES",
      "loc": {
        "lon": -0.37756800651550293,
        "lat": 39.469482421875
      },
      "mobileBrand": "Orange",
      "mnc": "03/09",
      "reg": "Valenciana, Comunidad",
      "city": "Valencia",
      "latency": 1,
      "isp": "Orange Espagne SA",
      "domainName": "orange.es",
      "mcc": "214",
      "usageType": "MOB"
    }

Udger data sample as inlined into events data stream:

JSON

    "ua": {
      "bType": "MB",
      "os": "Android",
      "latency": 1,
      "hdr": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36",
      "bFamily": "Chrome Mobile",
      "dName": "SP",
      "bVer": "133.0.0.0"
    }

Data Inlining

Data inlining means the following:

Returning data for a specific user and / or device in JSON response.
Passing data for a specific user and / or device to an external system API via asynchronous call.

Data inlining can be enabled for the Info Ident Track API and Proxy service.

Example JSON response:

JSON

{
  "umid": "86def240-beff-420d-ae87-ea76b8a84e1b",
  "state": 1,
  "identifiers": [
    {
      "name": "mt1",
      "value": "mt1-67h2p9VVPK2RWwuK7UJVSg"
    },
    {
      "name": "mt2",
      "value": "mt2-L8NMTaL2Ee2DSrWyuwgESA"
    },
    {
      "name": "email_sha256",
      "value": "a684079545719bb06100288b8ad5c97b0d2223935beb42eda37abedd4b074aca"
    },
    {
      "name": "email-aes",
      "value": "JRCHSIm4J_uDd8RXxrBI4A=="
    }
  ],
  "permissions": {
    "CS-OM": true,
    "CS-OPT": true,
    "CS-NBA": true
  },
  "permissionsLastModification": {
    "CS-OM": "2024-06-19T16:17:41.607Z",
    "CS-OPT": "2024-06-19T16:17:41.607Z",
    "CS-NBA": "2024-06-19T16:17:41.607Z"
  },
  "notificationHistory": [
    {
      "name": "MAIN_CS",
      "version": 1,
      "permissions": [
        "CS-OM",
        "CS-OPT",
        "CS-NBA"
      ],
      "date": "2024-06-19T16:17:41.607Z"
    }
  ],
  "notificationStatus": {
    "CS-NBA": true,
    "CS-OM": true,
    "CS-OPT": true,
    "CS-UTIQ": false
  },
  "attributes": {
    "browserFamily": "Chrome",
    "browserType": "BR",
    "browserVersion": "132.0.0.0",
    "cc": "DE",
    "city": "Frankfurt am Main",
    "deviceName": "PC",
    "domainName": "amazon.com",
    "isp": "A100 ROW GmbH",
    "latitude": "50.11088",
    "longitude": "8.681996",
    "mcc": "",
    "mnc": "",
    "mobileBrand": "",
    "osFamily": "Windows",
    "region": "Hessen",
    "nba1": "nba1",
    "nba2": "nba2",
    "usageType": "DCH",
    "attribute1": "value1",
    "attribute2": "value2"
  }
}