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
  • Dimensions
  • General dimensions
  • Event dimensions
  • Device dimensions
  • Origin dimensions
  • Location dimensions
  • Metrics

Was this helpful?

Export as PDF
  1. Querying your data
  2. Activities analytics queries

Dimensions and metrics

The dimensions and metrics allowed in the activities analytics API.

Dimensions

The following dimensions can be requested in reports

General dimensions

Name
Title
Description

type

Activity type

date_time

Date + time

The combined value of date and time of the activity in timestamp format

channel_id

Channel ID

The ID of the channel on which the activity was registered

session_duration

Session duration

Duration of the session in seconds

segment_id

Segment ID

IDs of the segments in which the user was when doing the activity. Note : querying this dimension can throw an error if date ranges of the query are too big.

date_yyyymmdd

Date

Date in the YYYYMMDD format

date_yyyymmddhh

Date + Hour

Date in the YYYYMMDDHH format

date_yyyy_mm_dd

Date

Date in the YYYY_MM_DD format

date_yyyy_mm_dd_hh_mm

Date + Hour + minutes

Date in the YYYY_MM_DD_HH_mm format

has_conversion

Has conversion

goal_id

Goal ID

IDs of the goals triggered during the activity

has_bounced

Has bounced

Boolean. If the user only visited one page during the activity.

transaction_amount

Transaction amount

Amount spent by the user during the activity.

number_of_user_events

Number of events

All events (custom and predefined) are counted in this total, except : $conversion $ad_click $ad_view $email_view $email_click $email_sent $email_delivered $email_soft_bounce $email_hard_bounce $email_unsubscribe $email_complaint $set_user_profile_properties $set_user_consent $content_correction $quit_while_running $cleaned_referrer

number_of_ad_views

Number of $ad_view events

number_of_ad_clicks

Number of $ad_click events

number_of_email_views

Number of $email_view events

number_of_email_clicks

Number of $email_click events

number_of_confirmed_transactions

Number of $transaction_confirmed events

Event dimensions

You can query dimensions specific to the events that happened during each activity.

event_type

Event type. Only $transaction_confirmed $item_view $list_item_view $basket_view events are stored at the moment

brand

Brands of items related to the events

category1

Category 1 of items related to the events

category2

Category 2 of items related to the events

category3

Category 3 of items related to the events

category4

Category 4 of items related to the events

Device dimensions

Informations about the device used during each activity.

device_form_factor

Type of device : PERSONAL_COMPUTER SMART_TV GAME_CONSOLE SMARTPHONE TABLET WEARABLE_COMPUTER OTHE

device_os_family

OS of the device : WINDOWS MAC_OS LINUX ANDROID IOS OTHER

device_os_versions

Version of the OS, for example Windows 8 ios10

device_browser_family

Browser used during the activity : CHROME IE FIREFOX OPERA STOCK_ANDROID BOT EMAIL_CLIENT MICROSO_EDGE OTHER

device_browser_version

Browser's version. For example 10.3.4, 2.2

device_brand

Device brand. For example Acer Free

device_model

Device model. For example 10 plus 4K Ultraslim

device_agent_type

Agent type : MOBILE_APP WEB_BROWSER

Origin dimensions

  • origin_campaign_name / origin_campaign_technical_name / origin_campaign_id

  • origin_sub_campaign_technical_name / origin_sub_campaign_id

  • origin_message_id / origin_message_technical_name

  • origin_keywords

  • origin_creative_name / origin_creative_technical_name / origin_creative_id

  • origin_engagement_content_id

  • origin_social_network

  • origin_referral_path

Location dimensions

  • location_source

  • location_country

  • location_region

  • location_iso_region

  • location_city

  • location_iso_city

  • location_latitude

  • location_longitude

Metrics

The following metrics can be displayed in reports.

Name
Title
Description

users

Active users

The number of distinct active users

sessions

Activities / Sessions

The number of activities / sessions

conversion_rate

Conversion rate

Calculated with (Number of activities with conversions / Total number of activities)

avg_number_of_sessions_per_user_point

Average number of sessions per user point

Calculated from the number of sessions and the number of user points.

Note : this metric cannot be used with other metrics

avg_revenue_per_user_point

Average revenue per user point

Revenue divided by the number of distinct user points

Note : this metric cannot be used with other metrics

avg_number_of_transactions_per_user_poit

Average number of transactions per user point

Number of transactions devided by the number of distinct user points

Note : this metric cannot be used with other metrics

avg_session_duration

Average session duration

Calculated by doing an average of the session_duration dimension.

revenue

Revenue

Sum of transaction_amount dimension

avg_transaction_amount

Average transaction amount per activity

Sum of transaction_amount dimension divided by the number of transactions.

Note : this metric cannot be used with other metrics

avg_number_of_user_events

Average number of user events per activity

Sum of number_of_user_events dimension divided by the number of activities.

number_of_user_events

Total number of user events

Sum of number_of_user_events dimension

PreviousAPI QuickstartNextUse cases

Last updated 1 year ago

Was this helpful?

See for a list of all activity types.

Boolean. If a $conversion event happened during the activity. For more information, see .

Total number of the user triggered during the activity.

Total number of named $ad_view during the activity.

Total number of named $ad_click during the activity.

Total number of named $email_view during the activity.

Total number of named $email_click during the activity.

Total number of named $transaction_confirmed during the activity

Only specific predefined events are registered at the moment. See to integrate your events in these dimensions.

The following dimensions are populated by the :

The following dimensions are populated by the :

Event transformations
Activity origin
Activity location
User activity object
Predefined event names
User events
User events
User events
User events
User events
User events