Developer
User guidesDeveloper websiteHelp centerLog in
  • Welcome!
  • Organisations structure
    • Datamart
    • Users and roles
  • User points
    • User identifiers
      • Networks IDs
        • Device-based Network IDs
          • Custom Device ID integration
          • ID5
          • First ID
        • User-based Network IDs
          • Custom User ID integration
          • UTIQ martechpass
      • Accounts
      • Emails
      • Device identifiers
    • User activities and events
    • Compartments
    • User profiles
    • User segments
    • Hyper point & Quarantine
  • Data model
    • Defining your schema
    • Computed fields
      • Concepts
      • Setup
      • Development
      • Examples
  • Data ingestion
    • Real time user tracking
      • Website tracking
      • Mobile apps tracking
      • Ads exposure tracking
      • AMP tracking
      • Conversions tracking
      • Email views and clicks
      • Tracking API
      • Event rules
      • Activity analyzers
    • Bulk processing
      • Imports
        • User activities import
        • User profiles import
        • User choices import
        • Segments import
      • Deletions
        • User identifiers deletion
        • Device points deletion
        • User points deletion
      • User identifiers association
      • Integration batch
    • Activities analytics
    • Data warehouse
      • Preliminary setup
        • BigQuery
      • Create data warehouse
  • Querying your data
    • OTQL queries
    • OTQL examples
    • GraphQL queries
    • UserPoint API
    • User activities
    • Activities analytics queries
      • API Quickstart
      • Dimensions and metrics
      • Use cases
    • Funnel API
  • Alerting
    • Alert configurations
  • Data visualisation
    • Quickstart
    • Dashboards
    • Sections and cards
    • Charts
    • Datasets and data sources
      • Using a data file data source
    • Transformations
    • Filters
    • Cookbook
    • Reference
  • Advanced usages
    • Audience segmentation
      • Audience features
      • Segment builders
      • Audience segment metrics
      • Audience segment feed
        • Building new feeds
        • Monitoring a feed
        • Curated Audiences (SDA)
      • Edge segments
      • Cohort-based Lookalike
    • Contextual targeting
      • Setup
      • Activation
        • Google Ad Manager
        • Xandr (through prebid.js)
      • API documentation
    • Exporting your data
      • Query Exports
      • Datamart replication
    • Data privacy compliance
      • User choices
      • Cleaning rules
      • Exercise of user rights
      • Cookies
    • Campaigns
    • Automations
      • Email routers
      • Email renderers
      • Opt-in provider
      • Custom action plugins
      • Usage limits for automations
    • Plugins
      • Concepts
      • Creation & Deployment
      • Coding your plugin
      • Manage existing plugins
      • Layouts
      • Presets
      • Monitoring
      • Throttling
      • Batching (for external feeds)
    • Platform monitoring
      • Resources usage
        • Dimensions and metrics
      • Collection volumes
        • Dimensions and metrics
      • Events ingestion monitoring
        • Dimensions and metrics
    • Data Clean Room
      • Bunker
      • Clean room
  • Resources
    • Tutorial: Data Ingestion
      • Your first events
        • Add the mediarithmics tag
          • Getting the tag
          • Adding the tag
        • Send events using the tag
          • Adding event properties
          • Finding the UserEvent type in your schema
          • Matching your schema
          • Standard events
      • Your first bulk imports
        • API basics
          • Authentication
          • Your first API call
        • Send documents using the API
          • Requirements
          • Sending documents
    • Using our API
      • Authentication
    • Tools & libraries
      • mics CLI
      • JS Tag
      • Plugin SDK
    • Data cubes
      • Creating a report
      • Reference
Powered by GitBook
On this page
  • Technical concept
  • Definitions
  • Computed Field
  • Computed Field Function
  • Notions
  • Lifecycle
  • Technical flow

Was this helpful?

Export as PDF
  1. Data model
  2. Computed fields

Concepts

PreviousComputed fieldsNextSetup

Last updated 1 month ago

Was this helpful?

Technical concept

Computed fields are defined in the schema at the UserPoint level.

The plugin behind it performs computations on a regular basis of a function's result, based on the user activities and profile updates.

Definitions

Computed Field

A computed field is an instance of a Datamart function applied within a specific context. To use it, it must be declared in your schema.

Computed Field Function

A Computed Field Function is a of type COMPUTED_FIELD_FUNCTION, which can be created via the API following the standard or through the computing console interface.

Notions

A computed field is defined by these elements:

  1. State: The data stored to build the result. It is the history. Each new activity updates the State.

    → the state is closely related to the Lookback Window - i.e. the historical depth of events to be analyzed.

  2. Logic: The logic can be very simple (like a formula, a sum, a count…) or more complex (like a logical operation).

  3. Result: The data calculated and stored. It contains the score(s) to be used.

    The result can be either a single variable or an object, depending on the complexity of the computation. It is computed from the State

Other interesting concepts to take into consideration:

  • Input Data: Either new userActivities, either userProfile update, either both.

  • Period Update: The regularity of updates (every x days - by default x=1).

Lifecycle

  1. INITIAL – The instance is created with this status.

  2. INITIAL_LOADING – Once declared in the schema and successfully validated, an initial loading job is triggered.

  3. ACTIVE – The computed field becomes active if the job is completed successfully.

Technical flow

To better understand how a computed field works, here are the technical steps and the relation with the methods:

  1. Initialization: The computed field is declared in the schema.

  2. State Updates: Triggered by new user activities or profile updates.

  3. Result Calculation: The result is computed based on the current state.

  4. Storage: The result is stored for querying.

plugin
process
Computed field lifecycle
Drawing