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 13 days 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