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
  • Quick start guide
  • Available endpoints
  • Supported dimensions and metrics
  • How data cubes work

Was this helpful?

Export as PDF
  1. Querying your data

Activities analytics queries

The activity analytics endpoint has been designed as a cube to query user activities.

PreviousUser activitiesNextAPI Quickstart

Last updated 1 year ago

Was this helpful?

This API gives you programmatic access to user activities as a data cube. You get metrics with dimensions, filters, and within date ranges leveraging the part of our multi-model database.

With the activities analytics API, you can create reports to answer questions like:

  • Number of active users. The metric is users and it has no dimensions or filter.

  • Number of active users per channel per day. The metric is users, grouped by channel_id and date_yyyymmdd dimensions, without filters.

  • Number of sessions per day for users who had an activity of type AD_VIEW on campaign 666. The metric is sessions, grouped by the date_yyyymmdd dimension with filter clauses activity_type = AD_VIEW and origin_campaign_id = 666

  • Days with more than 200k transactions on a specific channel. The metric is number_of_transactions, grouped ty the date_yyyymmdd dimension with filter clauses on channel_id = 666. Then a filter is applied on the calculated metric to only keep days with more than 200k transactions.

  • Maximum recommended 5 queries per second.

  • Response time around 1 second.

  • Results date range for the 4 latest months.

Quick start guide

Available endpoints

Supported dimensions and metrics

How data cubes work

It can also be used to build custom dashboards. For more information, see .

Calling the API to get your first metrics is easy with your favorite tool that you already use to query other mediarithmics endpoints. See the guide to get started.

returns a customized report of your activities analytics data.

See for the complete list of supported dimensions and metrics.

This endpoint is a mediarithmics . You can find documentation on how data cubes work and which data cubes are available in the specific documentation section.

Dashboards
API Quickstart
Dimensions en metrics
Data cube
Activity analytics
user_activities_analytics